X-Git-Url: https://git.jacobcasper.com/?p=mercuryms.git;a=blobdiff_plain;f=send.sh;h=a1af21f4e55c4f8ec8631c9e4ee28994ec8656ee;hp=b2e0e731e6ad2a5ec060f34cc28510339abd3caf;hb=58c787a47ddfcd526efed27ec54230154d7b7640;hpb=7576a45852d74d69aeb36c06e6896b223c7fb61c diff --git a/send.sh b/send.sh index b2e0e73..a1af21f 100755 --- a/send.sh +++ b/send.sh @@ -1,2 +1,7 @@ #!/bin/bash -sqlite3 mercuryms.sqlite "$(awk 'BEGIN {print "PRAGMA FOREIGN_KEYS = ON;"} /received/ {print "INSERT INTO SENT_MEDIA (MEDIA_ID) VALUES("$1");";}' <(sqlite3 mercuryms.sqlite "SELECT ID, PHONE_NUMBER, URI FROM MEDIA WHERE ID NOT IN (SELECT MEDIA_ID FROM SENT_MEDIA)" | timeout $TIMEOUT_SECONDS netcat $HOST $PORT))" +sqlite3 mercuryms.sqlite " +$(awk 'BEGIN {print "PRAGMA FOREIGN_KEYS = ON;"} \ + /received/ {print "INSERT INTO SENT_MEDIA (MEDIA_ID) VALUES ("$1");";}' \ + <(sqlite3 mercuryms.sqlite "SELECT ID, PHONE_NUMBER, URI FROM MEDIA WHERE ID NOT IN (SELECT MEDIA_ID FROM SENT_MEDIA)" \ + | timeout $TIMEOUT_SECONDS netcat $HOST $PORT) +)"