Why is grep only returning one line?

Question 1

#!/bin/bash

while true; do
    trap break SIGINT
    ping -w 5 10.0.0.1 | { trap '' SIGQUIT
        ts '%Y-%m-%d %H:%M:%S |' |
        grep -E 'PING|packets|rtt' | { read grep_out
            echo $grep_out
            # echo "INSERT INTO test VALUES($grep_out);EXIT;" |
            # mysql --user=user --password=pass
        }
     }
done

expected output:

2015-11-07 05:42:35 | PING 10.0.0.1 (10.0.0.1) 56(84) bytes of data.
2015-11-07 05:42:40 | 5 packets transmitted, 5 received, 0% packet loss, time 4005ms
2015-11-07 05:42:40 | rtt min/avg/max/mdev = 16.385/133.707/471.837/174.004 ms
2015-11-07 05:42:40 | PING 10.0.0.1 (10.0.0.1) 56(84) bytes of data.

настоящий output:

2015-11-07 05:42:35 | PING 10.0.0.1 (10.0.0.1) 56(84) bytes of data.
2015-11-07 05:42:40 | PING 10.0.0.1 (10.0.0.1) 56(84) bytes of data.

Question 2

grep возвращает несколько строк очень хорошо:

$ while true; do
 trap break SIGINT
 ping -w 5 localhost | { trap '' SIGQUIT
 ts '%Y-%m-%d %H:%M:%S |' |
 grep -E 'PING|packets|rtt'
 }
done
2015-11-07 17:28:50 | PING localhost (127.0.0.1) 56(84) bytes of data.
2015-11-07 17:28:55 | 6 packets transmitted, 6 received, 0% packet loss, time 4998ms
2015-11-07 17:28:55 | rtt min/avg/max/mdev = 0.027/0.035/0.042/0.005 ms
2015-11-07 17:28:55 | PING localhost (127.0.0.1) 56(84) bytes of data.
2015-11-07 17:29:00 | 6 packets transmitted, 6 received, 0% packet loss, time 4999ms
2015-11-07 17:29:00 | rtt min/avg/max/mdev = 0.024/0.040/0.052/0.009 ms
2015-11-07 17:29:00 | PING localhost (127.0.0.1) 56(84) bytes of data.

проблемой является ненужное read foo; echo foo, Вы делаете:

grep -E 'PING|packets|rtt' | { read grep_out
    echo $grep_out
}

Это будет только для чтения одна строка grep вывод.

, Так как просто необходимо вставить отрывок вначале и конец:

while true; do
    trap break SIGINT
    ping -w 5 10.0.0.1 | { trap '' SIGQUIT
        ts '%Y-%m-%d %H:%M:%S |' | {
            echo 'INSERT INTO test VALUES('
            grep -E 'PING|packets|rtt'
            echo ');EXIT;'
        } |
        mysql --user=user --password=pass
     }
done

Пример:

$ while true; do
    trap break SIGINT
    ping -w 5 localhost | { trap '' SIGQUIT
        ts '%Y-%m-%d %H:%M:%S |' | {
            echo -n 'INSERT INTO test VALUES('
            grep -E 'PING|packets|rtt'
            echo -n ');EXIT;'
        } |
        cat
     }
done
INSERT INTO test VALUES(2015-11-07 17:48:02 | PING localhost (127.0.0.1) 56(84) bytes of data.
2015-11-07 17:48:07 | 6 packets transmitted, 6 received, 0% packet loss, time 4996ms
2015-11-07 17:48:07 | rtt min/avg/max/mdev = 0.029/0.037/0.046/0.008 ms
);EXIT;
INSERT INTO test VALUES(^C%

Заботятся с заключением в кавычки и другими проблемами Внедрения SQL.

muru · Accepted Answer · 30 September 2019 в 05:34