[mercuryms.git] / send.sh

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