2 sqlite3 mercuryms.sqlite
"
3 $(awk 'BEGIN {print "PRAGMA FOREIGN_KEYS
= ON
;"} \
4 /received/ {print "INSERT INTO SENT_MEDIA
(MEDIA_ID
) VALUES
("$1");";}' \
5 <(sqlite3 mercuryms.sqlite "SELECT ID
, PHONE_NUMBER
, URI FROM MEDIA WHERE ID NOT IN
(SELECT MEDIA_ID FROM SENT_MEDIA
)" \
6 | timeout $TIMEOUT_SECONDS netcat $HOST $PORT)