3 TABLE="CREATE TABLE IF NOT EXISTS data (key TEXT, value BLOB, source TEXT, time REAL, sequence REAL);"
7 echo $TABLE > generated.db.sql
8 echo "BEGIN IMMEDIATE TRANSACTION;" >> generated.db.sql
10 for (( i=0; i<120; i++ ))
12 T=$(echo 1385571956 + $i)
13 for (( n=1; n<1000; n++ ))
15 MS=$(echo $n \* 0.001 | bc)
16 TIME=$(echo $T + $MS | bc)
17 echo "insert into data values('VehicleSpeed',$(( ( RANDOM % 300 ) + 1 )),'test', $TIME, -1);" >> generated.db.sql
21 echo "END TRANSACTION;" >> generated.db.sql
23 sqlite3 generated.db < generated.db.sql