On Tuesday, July 2, 2019 at 4:38:04 PM UTC-7, gjr80 wrote:
>
> 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. 
>
>
>
That is a good guess.   It's also kinda undocumented previously, perhaps.

More details.

I was using the purpleair extension which works fine.   I wanted to add the 
AQI calculation to that extension, so I did so, saving that in a 'new' 
element in the database.  I added the field to the archive table manually 
via a sqlite3 command, and similarly created the archive_day_aqi2_5 table 
manually via sqlite3 (as I could find no weewx option for doing so, the 
existing docs talk about extending the primary db, but do not mention the 
same thing on a secondary db).

I then started weewx and my (modified) extension and it worked fine, 
populating the (new) field in the archive records as time moved forward, 
and weewx started populating the (new) archive_day_aqi2_5 table from that 
point forward.

The problem was catching the old months of archive records up with 
calculated AQI data, and catching up the resulting day summaries for that 
field.

Cooking up a python script to do sqlite 'update' on the aqi_2_5 element in 
the (modified) archive schema was straightforward.   At that point I had an 
updated set of archive records, but no matching day summaries for the new 
element in the records.

So.... when I ran --rebuild-daily with no options, it is true that the 
current day was correct, as weewx had generated the summary record for the 
'current' day.   

Forcing the 'old' days to regenerate the summary tables is where I got hung 
up.  I was not aware that there's a time check in there for the most-recent 
data, nor that wee_database silently returns without any user feedback.  
That's the confusion factor I ran into.

FWIW - my aqi page from the modified purpleair extension is at 
https://www.skahan.net/weewx/purpleair.html and it all looks good.

I also sent a PR to Ken Baker in case he wants to add AQI to his 
extension.  If anybody else wants a copy, email me.

Thanks.

-- 
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/0a8037db-0245-470f-8b81-d78630f19712%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to