Why use something like $almanc.sun.alt, at best it is confusing and at
worst it will break SQLite or MySQL/MariaDB. Why not use something like
solar_altitude. For your wee_database error far better to post the exact
command entered and the exact response received rather than "it doesn't
work".
Not sure exactly what you are getting at with your second question, I hope
you did not literally use ,...., in the schema_extended line. If you mean
do you include any previously added fields then yes you do, schema_extended
needs to comprise all of the fields in your schema, whether original, added
earlier or added now.
Gary
On Friday, 15 November 2019 16:09:34 UTC+10, Xant wrote:
>
>
> (addendum)
>
> Not sure if incorrect format or syntax to Database, but extend database
> with '$almanac.sun.alt' and '$almanac.moon.alt' generate errors upon
> "wee_database --rebuild-daily"
>
> schema_extended = schemas.wview.schema + [('maxSolarRad', 'REAL'),....,
> ('$almanac.sun.alt', 'REAL'), ('$almanac.moon.alt', 'REAL')]
>
>
> Also, upon adding new extensions to Database, on the "schema_extended
> =..." you keep the previously added, or delete previously added extensions?
>
--
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/b8c2ded4-0647-4bda-b6d3-f868d5c3bb4f%40googlegroups.com.