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.
