I'm looking to add a field to the archive table for my purpleair.sdb file, and create the matching archive_day_whatever table and backfill it with data.
Does wee_database support operating on just one database ? It isn't clear from the docs and --help info whether I can specify just one database to operate on. The binding is: [[purpleair_binding]] manager = weewx.manager.DaySummaryManager schema = user.purpleair.schema table_name = archive database = purpleair_sqlite I can probably get mostly there via low-level sqlite3 commands ala: # create the table echo "CREATE TABLE archive_day_aqi (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);" | sqlite3 foo.sdb # alter the archive schema echo "alter table archive add column aqi INTEGER;" | sqlite3 foo.sdb But I'd still need to backfill the new archive_day_aqi table with its data. I have 12+ years of archive records in my normal weewx.sdb, so obviously I don't want to rebuild all the databases for all of known time. I'm just looking to build the archive_day_aqi table in the purpleair.sdb from the known data. Am I missing some switch combinations for wee_database perhaps ? -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/bc71ddf5-9086-4936-a6bb-0bdc1f75d286%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.