From a1e559df7df7628ed8e6574d49144533d9faa791 Mon Sep 17 00:00:00 2001 From: Jacob Casper Date: Sun, 5 Apr 2020 04:21:27 -0500 Subject: [PATCH] Enable foreign keys on sent media insert --- send.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/send.sh b/send.sh index e38559c..b2e0e73 100755 --- a/send.sh +++ b/send.sh @@ -1,2 +1,2 @@ #!/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))" -- 2.20.1