Tom I tried adding the column using the following command:
wee_database --add-column=lightning_frequency --type=TEXT It does add the column and populates the data but generates an error during the archival cycle. I guess it looking for integers and real type values. Aug 16 22:00:22 raspberrypi weewx[24285] ERROR weewx.manager: Replace failed for database weewx.sdb: table archive_day_lightning_frequency has 9 columns but 5 values were supplied Aug 16 22:00:22 raspberrypi weewx[24285] INFO weewx.manager: Added record 2021-08-16 22:00:00 EDT (1629165600) to database 'weewx.sdb' Aug 16 22:00:22 raspberrypi weewx[24285] ERROR weewx.manager: Replace failed for database weewx.sdb: table archive_day_lightning_frequency has 9 columns but 5 values were supplied Next I will try adding using the schema. Rich On Monday, August 16, 2021 at 6:55:55 PM UTC-4 [email protected] wrote: > Can't say that I've tried that, but I don't see why it wouldn't work. It's > certainly simpler. > > Let me know how it goes. > > On Mon, Aug 16, 2021 at 9:11 AM [email protected] <[email protected]> > wrote: > >> Thanks Tom. >> >> I have another question before proceeding. Do I need to physically >> update the schema to include column and type or could I just use the >> following command: >> >> wee_database --add-column=comments --type=TEXT >> >> Rich >> >> On Monday, August 16, 2021 at 8:29:16 AM UTC-4 [email protected] wrote: >> >>> Good question. Yes, it is possible to store text. >>> >>> 1. Assuming you're using sqlite, make sure you read their documentation >>> on data types: https://sqlite.org/datatype3.html >>> >>> 2. Create a new schema accordingly. For example, >>> >>> table = [('dateTime', 'INTEGER NOT NULL UNIQUE PRIMARY KEY'), >>> ('usUnits', 'INTEGER NOT NULL'), >>> ('interval', 'INTEGER NOT NULL'), >>> ('outTemp', 'REAL'), >>> ('comments', 'TEXT') >>> ] >>> >>> >>> day_summaries = [('outTemp', 'scalar'), ('comments', 'scalar')] >>> >>> schema = { >>> 'table': table, >>> 'day_summaries' : day_summaries >>> } >>> >>> >>> This is just an example. Your schema is likely to have many more types >>> than this. >>> >>> 3. See the directions in the Customizing Guide for how to specify that >>> your new schema be used. *Picking a starting schema >>> <http://www.weewx.com/docs/customizing.htm#Picking_a_starting_schema>*. >>> >>> 4. Read the developer's notes on Accumulators >>> <https://github.com/weewx/weewx/wiki/Accumulators>. In your weewx.conf >>> file, specify that your text type should be accumulated using the " >>> firstlast" accumulator. This will prevent it from trying to find the >>> average, etc, of a string. >>> >>> [Accumulator] >>> [[comments]] >>> accumulator = firstlast >>> >>> >>> That's it. If your new type appears in the archive record, then it will >>> be included in the database. >>> >>> Tags like >>> >>> <p>Details: $current.comments, last recorded at $day.comments.last</p> >>> >>> >>> should also work. >>> >>> >>> On Sun, Aug 15, 2021 at 8:43 PM [email protected] <[email protected]> >>> wrote: >>> >>>> In the Weewx DB, the column data types are primary Real or Integer but >>>> is it possible to store data as Text? >>>> >>>> -- >>>> 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/faf66dd7-7e4a-45fa-9737-6f0094024c88n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/faf66dd7-7e4a-45fa-9737-6f0094024c88n%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/c4c792b5-c214-446e-9e4b-6d76dbc14aabn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/c4c792b5-c214-446e-9e4b-6d76dbc14aabn%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/342b5f6f-c184-43cc-b214-b5e351dcd8f8n%40googlegroups.com.
