X-Git-Url: https://git.jacobcasper.com/?p=mercuryms.git;a=blobdiff_plain;f=send.sh;h=a1af21f4e55c4f8ec8631c9e4ee28994ec8656ee;hp=e38559cfe29393d315ad6191f04a5c3c99958bfe;hb=58c787a47ddfcd526efed27ec54230154d7b7640;hpb=c9716b9597ab2274dc8f4448fd8d50a548d79ef5

diff --git a/send.sh b/send.sh
index e38559c..a1af21f 100755
--- a/send.sh
+++ b/send.sh
@@ -1,2 +1,7 @@
 #!/bin/bash
-sqlite3 mercuryms.sqlite "$(awk '/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)
+)"