SQLite command from bash

Question

I need to record temperatures to a SQLite-DB on a linux system (using bash)

My problem is that I get the temperature readings in an individual file. How can I get that reading into the SQLite command

 sqlite3 mydb "INSERT INTO readings (TStamp, reading) VALUES (datetime(), 'xxx');"

The file contains just one line with the value "45.7" and should replace the xxx. Using fix data the SQL command works pretty well.

You might be interested in the .import CLI command: sqlite.org/cli.html — glenn jackman
– glenn jackman, Commented Feb 21, 2016 at 19:42

nsilent22 · Accepted Answer · 2016-02-21 21:25:33Z

1

You can simply echo commands to the sqlite3, just like this:

temp=`cat file_with_temperature_value`
echo "INSERT INTO readings (TStamp, reading) VALUES (datetime(), '$temp');" | sqlite3 mydb

or do it like in your example:

temp=`cat file_with_temperature_value`
sqlite3 mydb "INSERT INTO readings (TStamp, reading) VALUES (datetime(), '$temp');"

answered Feb 21, 2016 at 21:25

nsilent22

2,88314 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1