Commit | Line | Data |
---|---|---|
1 | #!/bin/bash | |
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) | |
7 | )" |