[GTALUG] capturing the output of any program and inserting in db

[Myles Braithwaite]

Jamon Camisso wrote:
> What if $MESSAGE == 'foo); DELETE FROM log;'

Fixed:

#!/bin/bash
CLEAN_MESSAGE="${MESSAGE//\;/}"
sqlite3 log.db "INSERT INTO log (message) VALUES ('$CLEAN_MESSAGE');"