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/CAPq0zEBq%2BzmFnW8zRg-1V%3DzP%2BwdyC0B4P87ZLF14CYREoWZLZw%40mail.gmail.com.
