thks for yr help, i follow yr guide to cleanup database :

pi@raspberrypi:~ $ echo "SELECT * FROM archive WHERE (rain < 0);" | sqlite3 
/var/tmp/backup.sdb
1523516100|1|5|29.405696969085|29.0870376875|29.0870376875|67.3666666666667|48.416|37.0|80.0|0.937794853313016|21.6687231304882|2.46063603713324|22.5|0.0|-15.3|42.5342303732686|48.416|48.416|||0.0||49.82|||||||||75.75||||||||||||||||1.0|1.0|1.0|
1523623500|1|5|29.6939319716336|29.3823375625|29.3823375625|70.4042857142857|65.12|41.7142857142857|57.5|2.13441535039209|55.6672765639842|3.13171859271503||0.0|-0.08|49.7270271335126|65.12|65.12|||0.0|67.928|||||||||72.2|||||||||||||||||0.0|0.0|0.0|
then
pi@raspberrypi:~ $ echo "UPDATE archive SET windSpeed=NULL WHERE (rain < 
0);" | sqlite3 /var/tmp/backup.sdb
pi@raspberrypi:~ $ echo "SELECT * FROM archive WHERE (rain < 0);" | sqlite3 
/var/tmp/backup.sdb
1523516100|1|5|29.405696969085|29.0870376875|29.0870376875|67.3666666666667|48.416|37.0|80.0||21.6687231304882|2.46063603713324|22.5|0.0|-15.3|42.5342303732686|48.416|48.416|||0.0||49.82|||||||||75.75||||||||||||||||1.0|1.0|1.0|
1523623500|1|5|29.6939319716336|29.3823375625|29.3823375625|70.4042857142857|65.12|41.7142857142857|57.5||55.6672765639842|3.13171859271503||0.0|-0.08|49.7270271335126|65.12|65.12|||0.0|67.928|||||||||72.2|||||||||||||||||0.0|0.0|0.0|

but got this :

pi@raspberrypi:~ $ wee_database weewx.conf --drop-daily
-bash: wee_database: command not found

>
>

-- 
You received this message because you are subscribed to the Google Groups 
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to