On Tuesday, 2 July 2019 18:57:31 UTC-4, vince wrote: > On Tuesday, July 2, 2019 at 3:07:28 PM UTC-7, gjr80 wrote:If no date of any > type is specified the daily summaries will be rebuilt from the time of last > update through until the most recent archive record. > > > Uncertain what that means. Update of what ? The archive table ? The day > summary tables ?
—rebuild-daily only affects the daily summary tables, it has no effect on the archive. > For a normal functioning install these times will likely be the same and > hence nothing is rebuilt (there is no need) so wee_database returns to the > command prompt very quickly. > > > How'bout a me-hacked-brutally install ??? :-) Me-hacked-brutally or not, wee_database applies the same logic. I am guessing that since there was no advice that any days were rebuilt the timestamp of the last daily summary update matched that of the latest record in the archive. > On the other hand, the other extreme is if you drop the daily summaries > first, all daily summaries are rebuilt from first to last archive record. > Specific dates or date ranges are only rebuilt if a —date or —from and —to > are provided. The console output should reflect what was done. > > I didn't drop the tables, but I did try deleting all the records from the > archive_day_myfieldname table. > Deleting records from the daily summaries has no affect on wee_database, well other than giving the user an expectation that one thing will happen when in fact it will not. This is one of the reasons why handling the daily summaries is best done through wee_database rather than direct manipulation. > > With no options other than --binding and --rebuild-daily the console output > nothing after I hit 'y' to proceed. > > > When I added the --from and --to values and dates that covered the whole > range of archive table dates, it 'did' provide nice input and did the right > thing. > As I would expect. > Is there anything making you suspect the current day is being rebuilt other > than a quick return to the command prompt. A quick return does not > necessarily mean anything was rebuilt. > > Yes - I deleted all records from the archive_day_<fieldname> table and ran > wee_database --rebuild-daily --binding='mybindinghere' and it created one > record in the archive_day_<fieldname> table, just the day summary for today. > It didn't do the previous days that the archive table were for. > > So the behavior seemed to require specifying a date or date-range for it to > work (and display to the console) as expected. No, it just requires that you don’t separately manipulate the daily summary tables :) I have not seen anything that wee_database has done that is not expected behaviour. Gary -- 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/05548061-3c5d-4fa9-bfa5-68497d0f2856%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
