Thanks for your fix. It's now activated within my environment (I did restart weewx afterwards). Tomorrow I'll report back...
Tom Keffer schrieb am Freitag, 17. November 2023 um 14:43:37 UTC+1: > I don't know why this is working for Karen, but not Michael. > > In any case, try this version of xtypes.py. It explicitly tests whether a > daily summary is available when calculating wind vectors. > > -tk > > On Thu, Nov 16, 2023 at 10:54 PM 'Michael Waldor' via weewx-user < > weewx...@googlegroups.com> wrote: > >> I have to admit that I do not understand the details howto setup sqlite >> databases within weewx - I've tried to follow the recipe for DWD forecasts >> as given within https://github.com/roe-dl/weewx-DWD , and I did retain >> all database settings as given by standard delivery weewx.conf (I do a >> manual diff with my private copy of weewx.conf each time when I update >> weewx to a new release). >> >> Here the full part w.r.t. sqlite from my weewx.conf (comments dropped) >> [DataBindings] >> [[wx_binding]] >> database = archive_sqlite >> table_name = archive >> manager = weewx.manager.DaySummaryManager >> schema = schemas.wview_extended.schema >> >> [[dwd_binding]] >> database = dwd_sqlite >> table_name = forecast >> manager = weewx.manager.Manager >> schema = schemas.dwd.schema >> >> [Databases] >> [[archive_sqlite]] >> database_name = weewx.sdb >> database_type = SQLite >> >> [[dwd_sqlite]] >> database_name = dwd-forecast-K2714.sdb >> database_type = SQLite >> >> And the forecast schema /usr/share/weewx/schemas/dwd.py contains >> schema = [('dateTime','INTEGER NOT NULL PRIMARY KEY'), >> ('usUnits','INTEGER NOT NULL'), >> ('interval','INTEGER NOT NULL')] >> >> The sqlite DB itself is stored at /var/lib/weewx/dwd-forecast-K2714.sdb >> side by side with weewx.sdb >> echo .schema | sqlite3 /var/lib/weewx/dwd-forecast-K2714.sdb returns >> >> CREATE TABLE forecast (dateTime INTEGER NOT NULL PRIMARY KEY,usUnits >> INTEGER NOT >> NULL,interval INTEGER NOT NULL,hour INTEGER,outTemp REAL,dewpoint >> REAL,outHumid >> ity REAL,windchill REAL,heatindex REAL,windDir REAL,windSpeed >> REAL,windGust REAL >> ,pop REAL,cloudcover REAL,barometer REAL,rain REAL,rainDur >> REAL,sunshineDur REAL >> ,visibility REAL,ww INTEGER); >> >> >> Tom Keffer schrieb am Donnerstag, 16. November 2023 um 23:52:17 UTC+1: >> >>> First weewx.conf: >>>> [[dwd_binding]] >>>> database = dwd_sqlite >>>> table_name = forecast >>>> manager = weewx.manager.Manager >>>> schema = schemas.dwd.schema >>>> >>> >>> You are using the database manager weewx.manager.Manager for the >>> "forecast" table. That manager will not include daily summaries, which is >>> why you are getting the error that the daily summary table >>> forecast_day_wind is missing. Is this intentional? >>> >>> Nevertheless, it should be possible to calculate the wind vectors >>> without the daily summaries. It would be frightfully slow, but it would >>> work. >>> >>> Two questions: >>> >>> 1. What does the schema schemas.dwd.schema look like? >>> 2. What is the actual schema used in the database used by forecast? You >>> didn't give enough information for me to determine the path to the actual >>> database, so you'll have to do that. >>> >>> echo .schema | sqlite3 path-to-the-forecast-database >>> >>> -tk >>> >>> -- >> 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+...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/7c1b30f5-638f-4d17-96e9-3a60e0559b03n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/7c1b30f5-638f-4d17-96e9-3a60e0559b03n%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/f1babadb-e2d7-4310-aa87-fde4f6c5c729n%40googlegroups.com.
