DB "canary" added - with fail/restart when connection dropped

[weathermon.git] / bin / dump-yesterday

diff --git a/bin/dump-yesterday b/bin/dump-yesterday
index 457792f9313498e90b2b2b240cfbe4ab52e93cba..c9e1eaf5727c875d83c4a05f7ffbac37f8e6a835 100755 (executable)
--- a/bin/dump-yesterday
+++ b/bin/dump-yesterday
@@ -4,10 +4,14 @@ yesterday=`echo "print(os.date(\"%Y-%m-%d\",os.time()-24*60*60))" | /usr/bin/lua
 
 logdb=`uci get weathermon.process.logdb`
 
-dumpdir=`uci get weathermon.process.archive_dir`/`echo "print(os.date(\"%Y/%m/%d\",os.time()-22*60*60))" | /usr/bin/lua`
+if [ -f "$logdb" ]; then
 
-mkdir -p $dumpdir
+  dumpdir=`uci get weathermon.process.archive_dir`/`echo "print(os.date(\"%Y/%m/%d\",os.time()-22*60*60))" | /usr/bin/lua`
 
-/usr/bin/weather-filter $logdb dump-compacted $yesterday $dumpdir
+  mkdir -p $dumpdir
 
-sqlite3 $logdb "delete from log where time_stamp<date('now','-1 day')"
+  /usr/bin/weather-filter $logdb dump-compacted $yesterday $dumpdir
+
+  sqlite3 $logdb "delete from log where time_stamp<date('now','-2 day')"
+
+fi