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

[Dave Cramer]

Dave Cramer

On 29 October 2014 13:18, Jamon Camisso <jamon.camisso at utoronto.ca> wrote:

> On 2014-10-29 12:13 PM, Myles Braithwaite wrote:
> > Dave Cramer wrote:
> >> Is there anything out there that is written simply ? By this I mean I
> >> don't want to have to install a framework or a jvm or any large
> >> dependencies. Ideally this would be written in bash or the like.
> >
> > You could use the sqlite. Running something like:
> >
> > #!/bin/sh
> > sqlite3 log.db 'INSERT INFO log (message) VALUES ($MESSAGE);'
> >
> > in a table setup like this:
> >
> > CREATE TABLE log (
> >       id INTEGER PRIMARY KEY,
> >       timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
> >       message TEXT
> > );
>
> What if $MESSAGE == 'foo); DELETE FROM log;'
>
> Just saying.. :p
>

good point, this is an internal tool, so probably not a real issue.

>
>
> ---
> GTALUG Talk Mailing List - talk at gtalug.org
> http://gtalug.org/mailman/listinfo/talk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/talk/attachments/20141029/49426e29/attachment.html>