/
sqlite-notes.txt
executable file
·34 lines (23 loc) · 992 Bytes
/
sqlite-notes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Notes on building for SQLite3
Dependencies:
- sqlite3
- libsqlite3-dev
- libbluetooth-dev
- libcurl4-openssl-dev
sudo apt-get install sqlite3 libsqlite3-dev libbluetooth-dev libcurl4-openssl-dev
Build command:
make sqlite
CONFIGURATION NOTES
MySqlDatabase - full path to SQLite Database file
MySqlUser, MySqlPwd - must have (dummy) values or DB stuff won't work. Not used for SQLite db though.
DEV NOTES
smatool.c line 60: MySqlDatabase variable increased len from 20 to 80
Some useful Command Line commands:
The following will repost old values from 5am on 20 January 2012
starttime="2012-01-20 05:00:00"
endtime="2012-01-20 19:30:00"
./smatool --debug -from "$starttime" -to "$endtime" -repost 2>&1 > ./temp-log.txt
or
./smatool -from "$starttime" -to "$endtime" -repost 2>&1 | logger -t smatool -p local5.info
or
starttime="2012-02-21 05:00:00";endtime="2012-02-21 20:30:00";./smatool -from "$starttime" -to "$endtime" -repost 2>&1 | logger -t smatool -p local5.info