See the section *Changing the unit system in an existing database <https://weewx.com/docs/latest/customizing.htm#Changing_the_unit_system>* in the Customization Guide.
On Wed, Jun 21, 2023 at 12:45 PM Δημήτρης Βήχος <[email protected]> wrote: > finaly i did it with sqlitebrowser easily! thank you! > is there way my data base appears values to mm and C for temp, instead to > inches and F ? > > Στις Τετάρτη 21 Ιουνίου 2023 στις 4:17:58 μ.μ. UTC+3, ο χρήστης Rainer > Lang έγραψε: > >> At the end of the day it doesn't matter where the weewx.sdb is located - >> as long as weewx and wee_database via weewx.conf and sqlite3 via the path >> in the command know/are told >> where it is located. >> >> You can still check with sqlitebrowser what your entry in your database >> for the respective EPOCH timestamp is (see my earlier mail) - and you can >> change it manually >> (provided you start it with sudo sqlitebrowser /var/lib/weewx/weewx.sdb >> [in your case]). >> That's the pragmatic approach. >> >> Of course you can still try to figure out why your SQL command doesn't >> seem to have been successful. >> >> On 21.06.2023 13:24, Δημήτρης Βήχος wrote: >> >> my database is on /var/lib/weewx/weewx.sdb >> >> metfm@metfm:~$ ls -ail /var/lib/weewx >> σύνολο 18692 >> 264962 drwxr-xr-x 1 root root 18 Ιουν 21 14:20 . >> 269 drwxr-xr-x 1 root root 592 Φεβ 26 18:30 .. >> 270727 -rwxrwxrwx 1 root root 19140608 Ιουν 21 14:20 weewx.sdb >> metfm@metfm:~$ >> >> Στις Τετάρτη 21 Ιουνίου 2023 στις 11:49:35 π.μ. UTC+3, ο χρήστης gjr80 >> έγραψε: >> >>> No. The default Debian based distro database is /var/lib/weewx/weewx.sdb. >>> The archive directory is only used (by default) for setup.py installs. >>> >>> OP. Have you confirmed the location (and name) of your WeeWX database? >>> What does the following command show: >>> >>> $ ls -ail /var/lib/weewx >>> >>> Gary >>> >>> On Wednesday, 21 June 2023 at 09:28:58 UTC+1 [email protected] >>> wrote: >>> >>>> It should be /var/lib/weewx/archive/weewx.sdb >>>> >>>> Can you give us a screenshot where the weewx.sdb is?? >>>> >>>> Στις Τετ, 21 Ιουν 2023, 11:03 ο χρήστης Δημήτρης Βήχος < >>>> [email protected]> έγραψε: >>>> >>>>> debian installed. also triyng with sudo sqlite3 >>>>> /var/lib/weewx/weewx.sdb same thing. >>>>> >>>>> Στις Τετάρτη 21 Ιουνίου 2023 στις 9:55:34 π.μ. UTC+3, ο χρήστης gjr80 >>>>> έγραψε: >>>>> >>>>>> Have you customised your WeeWX install? You appear to be using a >>>>>> package install so unless you have changed it your WeeWX database should >>>>>> be >>>>>> in /var/lib/weewx not /var/weewx. >>>>>> >>>>>> Gary >>>>>> >>>>>> On Wednesday, 21 June 2023 at 05:48:19 UTC+1 [email protected] >>>>>> wrote: >>>>>> >>>>>>> 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/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%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/f4d024d3-7dca-4a12-961f-1a3d85c05a07n%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/f4d024d3-7dca-4a12-961f-1a3d85c05a07n%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/c3acfded-0eb0-447b-a7b5-8685d47bd54an%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/c3acfded-0eb0-447b-a7b5-8685d47bd54an%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/CAPq0zEB7Zvhe3fZL10EvW1%2BLQbn0up38qUmHTQ9YMp0Uuv09mA%40mail.gmail.com.
