the commands with semi-colons. send me (with sudo also and with suo su ) metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb SQLite version 3.34.1 2021-01-20 14:10:07 Enter ".help" for usage hints. sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), usUnits, rain FROM archive WHERE dateTime > 1686881600 AND dateTime <= 1686981600; Error: unable to open database "/var/weewx/weewx.sdb": unable to open database file metfm@metfm:~$
without semi-colons database open metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb [sudo] password for metfm: SQLite version 3.34.1 2021-01-20 14:10:07 Enter ".help" for usage hints. sqlite> select datetime, datetime(dateTime, 'unixepoch','localtime'), rain from archive where dateTime > 1686881600 and dateTime <= 1686981600 ...> update archive set rain=12.6 where dateTime = 1686975900 ...> .quit ...> metfm@metfm:~$ sudo wee_database --rebuild-daily --from=2023-06-17 --to=2023-06-17 [sudo] password for metfm: Using configuration file /etc/weewx/weewx.conf Using database binding 'wx_binding', which is bound to database 'archive_sqlite' Daily summary for 2023-06-17 will be rebuilt. Proceed (y/n)? y Rebuilding daily summaries in database 'weewx.sdb' ... Processed 276 records to rebuild 1 daily summary in 0.12 seconds Rebuild of daily summaries in database 'weewx.sdb' complete metfm@metfm:~$ sudo /etc/init.d/weewx start Starting weewx (via systemctl): weewx.service. metfm@metfm:~$ but after restarting weewx no change in database. no 12.6 plus mm who i needs Στις Τρίτη 20 Ιουνίου 2023 στις 2:10:28 μ.μ. UTC+3, ο χρήστης gjr80 έγραψε: > At a guess I would say your sqlite3 commands were never executed due to > missing semi-colons at the end of each sqlite3 command line. Your commands > are basically fine, but you need to be careful with the datetime/dateTime > case > in the commands. No need for commits as your are not processing multiple > commands as a transaction. When editing the database you do need to be > mindful of your database units and make sure you use the same units in your > update queries. If using sqlite command line the easiest thing to do is to > look at the usUnits field. 1=US customary=inches, 16=Metric=cm, > 17=MetricWX=mm. Whether you use sqlite3 or a gui tool like sqlitebrowser > does not really matter, just check that your data was changed after you > make the change and if using a gui be very careful to not leave any fields > with null strings(though this is usually associate with deleting data > rather than updating it). FWIW if using sqlite3 I would use this sequence > of commands: > > $ sqlite3 /home/weewx/archive/weewx.sdb > sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), > usUnits, rain FROM archive WHERE dateTime > 1686881600 AND dateTime <= > 1686981600; > sqlite> UPDATE archive SET rain=12.6 WHERE dateTime = 1686975900; > sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), > usUnits, rain FROM archive WHERE dateTime=1686975900; > sqlite> .q > $ sudo wee_database --rebuild-daily --date=2023-06-17 > > In terms of the Seasons skin your updated data may causes changes to rain > plots (all except the 'today' plot), the June 2023 and 2023 NOAA format > reports and the statistics widget/page. All should come good in time (max > 24 hours) provided you update your data sometime this month, but if you > want to speed things up delete all your rain plots on your WeeWX machine. > If you update your data in say July you will need to delete the June 2023 > and 2023 NOAA format reports and all subsequent NOAA format reports to > force regeneration. > > Can't speak for any other skins. > > Gary > On Tuesday, 20 June 2023 at 07:04:56 UTC+1 [email protected] wrote: > > here is me commands in terminal . trying to plus 12.1 missing mm in 17 > july total rainfall > > metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb > [sudo] password for metfm: > SQLite version 3.34.1 2021-01-20 14:10:07 > Enter ".help" for usage hints. > sqlite> select datetime, datetime(dateTime, 'unixepoch','localtime'), rain > from archive where dateTime > 1686881600 and dateTime <= 1686981600 > ...> update archive set rain=12.6 where dateTime = 1686975900 > ...> .quit > ...> > metfm@metfm:~$ sudo wee_database --rebuild-daily --from=2023-06-17 > --to=2023-06-17 > [sudo] password for metfm: > Using configuration file /etc/weewx/weewx.conf > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > Daily summary for 2023-06-17 will be rebuilt. > Proceed (y/n)? y > Rebuilding daily summaries in database 'weewx.sdb' ... > Processed 276 records to rebuild 1 daily summary in 0.12 seconds > Rebuild of daily summaries in database 'weewx.sdb' complete > metfm@metfm:~$ sudo /etc/init.d/weewx start > Starting weewx (via systemctl): weewx.service. > metfm@metfm:~$ > > something missing? something im doing wrong? the exetra mm never shows in > weewx restarting and updating. > > > > Στις Σάββατο 17 Ιουνίου 2023 στις 12:11:40 μ.μ. UTC+3, ο χρήστης Stefanos > Kalaitzis έγραψε: > > First find the range of time(epoch) that you want to add the rain > Enter to weeex.sdb > > sudo sqlite3 /home/weewx/archive/weewx.sdb > > Then check what values your station recorded > > select datetime, datetime(dateTime, 'unixepoch','localtime'), rain from > archive where dateTime > 1686881600 and dateTime <= 1686981600; > > Then correct the time you want > For example > > update archive set rain=1.0 where dateTime = 1686975900; > > Then exit the db > > .quit > > Stop weewx > > After all corrections rebuild the data base for that day > > > sudo /home/weewx/bin/wee_database --rebuild-daily --from=2023-06-17 > --to=2023-06-17 > > Start weewx > > Thats what i am doing when i have to add some missing mm in my db > > > > Στις Σάβ, 17 Ιουν 2023, 11:42 ο χρήστης Δημήτρης Βήχος < > [email protected]> έγραψε: > > i want like to add some mm to my daily rainfall beacuse after power loss , > my console (fine offset) have 10mm above the weewx after the power on > again. > i had loss 10mm in my daily rain. > > thank you! > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/ded9f101-9d2a-4aea-9d2b-a65f4c8a9ea6n%40googlegroups.com.
