Timed job to tell listener to upload images to NextCloud

[mercuryms.git] / send.sh

diff --git a/send.sh b/send.sh
new file mode 100755 (executable)
index 0000000..e38559c
--- /dev/null
+++ b/send.sh
@@ -0,0 +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))"