1. Stop weewx. 2. Install the tool sqlite3, if it has not been installed already:
*sudo apt install sqlite3* 3. Calculate the starting and ending dates in unix epoch time. These are the dates that you want to zero out. The tool https://www.epochconverter.com/ is useful for this. 14 June 2021 0000 = *1623654000* 1 August 2021 0000 = *1627801200* 4. Find your sqlite database file. If you did a package install, it will be in /var/lib/weewx/weewx.sdb. If you did a setup.py install, it will be in /home/weewx/archive/weewx.sdb. I'm assuming the former. 5. Make a backup of the database file: *sudo cp /var/lib/weewx/weewx.sdb /var/lib/weewx/weewx.sdb.backup* 6. Use the tool sqlite3 to see what's in the database. This select statement will show the epoch time, date, and rain for the period 14 June until 1 August. Make sure you include the semicolon at the end. It will print out a lot of rows. Look them over. *sudo sqlite3 /var/lib/weewx/weewx.sdb* sqlite> *select datetime, datetime(dateTime, 'unixepoch','localtime'), rain from archive where dateTime > 1623654000 and dateTime <= 1627801200;* 7. If it meets your expectations, zero out the rain fields for that period: sqlite> *update archive set rain=0.0 where dateTime > 1623654000 and dateTime <= 1627801200;* sqlite> *.quit* 8. Rebuild the daily summaries for the affected period. *sudo wee_database --rebuild-daily --from=2021-06-14 --to=2021-08-01* 9. Restart weewx. On Thu, Aug 5, 2021 at 9:23 PM Big Hiller <[email protected]> wrote: > > Phew! Good thing you asked, it says "database = archive_sqlite" > > I did say I am a n00b ;) > On Thursday, August 5, 2021 at 5:44:27 PM UTC-7 [email protected] wrote: > >> We need to know (for sure) what database you are using. Look in your >> weewx.conf file, for the section that looks like: >> >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_sqlite >> >> We need the line for the option "database". It will say "archive_mysql" >> if you are using MySQL, "archive_sqlite" otherwise. >> >> -tk >> >> On Thu, Aug 5, 2021 at 5:37 PM Big Hiller <[email protected]> wrote: >> >>> 1. Pacific (PST) >>> 2. MySQL, I believe. >>> >>> On Thursday, August 5, 2021 at 5:17:49 PM UTC-7 [email protected] wrote: >>> >>>> 1. What time zone are you in? >>>> 2. What database are you using? >>>> >>>> On Thu, Aug 5, 2021 at 4:42 PM Big Hiller <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> I'm no good at SQL or pretty much anything in Linux other than getting >>>>> my WeeWX instance running. >>>>> >>>>> It's been running great for almost a year now and I have a little >>>>> issue I was hoping to get a little help on. >>>>> >>>>> My wife has been putting the sprinkler into a new place and I hadn't >>>>> noticed until a little while back but when she waters the lawn it's been >>>>> going into the rain sensor and has been getting measured as rain fall. >>>>> Clearly this is not good and luckily we have had no rain at all here in >>>>> Vancouver for the last few months so I feel it's safe to simple null out >>>>> any data for that sensor in the specific range. >>>>> >>>>> That leads me to the question: >>>>> *How (which command) would I delete all the rainfall data from June >>>>> 14, 2021 to August 1, 2021?* >>>>> >>>>> Probably really simple for some of you :) >>>>> >>>>> Thanks in advance! >>>>> >>>>> -- >>>>> 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/764c76c8-9162-497e-ad08-01cbb8d65f7an%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/weewx-user/764c76c8-9162-497e-ad08-01cbb8d65f7an%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/816feb5b-9c27-4dc9-9e07-b14e0fa220c7n%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/816feb5b-9c27-4dc9-9e07-b14e0fa220c7n%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/762f209a-cdcf-4d0e-9912-f451c5db205an%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/762f209a-cdcf-4d0e-9912-f451c5db205an%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/CAPq0zEBi-AXmaRQ1-Xnd9SWX8LF4Ma7R1%3DV2QmMvfmMh7CzSeg%40mail.gmail.com.
