Sure, Sorry for this.
So I am using the archive_mysql binding. It holds the archive database filled by my driver loop (which is SDR). I have an additional SDS011 service that fills in the pm2_5 and pm10 columns. This 2 columns have been added to the archive table. So despite the complicated conf, this is just one binding for my 'live data'.(Maybe I should clean this up.) On Monday, April 12, 2021 at 10:15:16 PM UTC+2 [email protected] wrote: > That's a lot of bindings and databases. Which one are you using for > your $hour.pm2_5.has_data query? In fact, maybe you should tell us the > exact tag you are using. > > -tk > > On Mon, Apr 12, 2021 at 1:07 PM [email protected] <[email protected]> > wrote: > >> Hi, >> >> Here are the requested sections : >> >> ############################################################################## >> >> # This section binds a data store to a database. >> >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_mysql >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.wxmanager.WXDaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview.schema >> [[wd_binding]] >> manager = weewx.manager.DaySummaryManager >> schema = user.wdschema.weewxwd_schema >> table_name = archive >> database = weewxwd_mysql >> [[forecast_binding]] >> database = forecast_mysql >> manager = weewx.manager.Manager >> schema = user.forecast.schema >> table_name = archive >> [[wdsupp_binding]] >> database = wd_supp_mysql >> table_name = supp >> manager = weewx.manager.Manager >> schema = user.wdschema.wdsupp_schema >> [[pm_binding]] >> database = archive_mysql >> table_name = archive >> manager = weewx.wxmanager.WXDaySummaryManager >> schema = user.sds011.schema >> >> >> ############################################################################## >> >> # This section defines various databases. >> [Databases] >> >> # A SQLite database is simply a single file >> [[archive_sqlite]] >> database_name = weewx.sdb >> database_type = SQLite >> >> # MySQL >> [[archive_mysql]] >> database_type = MySQL >> database_name = weewx >> host = >> user = >> password = >> [[weewxwd_mysql]] >> database_name = weewxwd >> database_type = MySQL >> host = >> user = >> password = >> [[weewxwd_sqlite]] >> database_name = weewxwd.sdb >> root = %(WEEWX_ROOT)s >> database_type = SQLite >> [[forecast_sqlite]] >> database_name = forecast.sdb >> database_type = SQLite >> [[forecast_mysql]] >> database_name = forecast >> database_type = MySQL >> host = >> user = >> password = >> [[wd_supp_sqlite]] >> database_type = SQLite >> database_name = wdsupp.sdb >> [[wd_supp_mysql]] >> database_name = weewxwd >> database_type = MySQL >> host = >> user = >> password = >> [[pm_sqlite]] >> database_name = pm.sdb >> database_type = SQLite >> >> >> ############################################################################## >> >> # This section defines defaults for the different types of databases. >> >> [DatabaseTypes] >> >> # Defaults for SQLite databases >> [[SQLite]] >> driver = weedb.sqlite >> # Directory in which the database files are located >> SQLITE_ROOT = %(WEEWX_ROOT)s/archive >> >> # Defaults for MySQL databases >> [[MySQL]] >> driver = weedb.mysql >> # The host where the database is located >> host = localhost >> # The user name for logging in to the host >> user = >> # The password for the user name (quotes guard against parsing >> errors) >> password = >> >> >> ############################################################################## >> >> While reviewing this, I noticed the manager line in the PM_Binding. Could >> this be the issue? >> >> >> >> On Monday, April 12, 2021 at 5:10:19 PM UTC+2 [email protected] wrote: >> >>> Sorry, I don't have an explanation. >>> >>> Can we see the [DataBindings], [Databases], and [DatabaseTypes] sections >>> of weewx.conf? You can obfuscate any passwords. >>> >>> On Sat, Apr 10, 2021 at 7:58 AM [email protected] <[email protected]> >>> wrote: >>> >>>> I checked, (I adjusted the query a bit since I am on mysql), but it >>>> confirmed there are 31 rows in the last 1 hour. >>>> >>>> I ran : >>>> select >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html> >>>> count >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_count> >>>> (*),avg >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_avg> >>>> (pm2_5),max >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_max> >>>> (pm2_5) from archive where dateTime >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html> >>>> >=(select >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html> >>>> max >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_max> >>>> (dateTime >>>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html> >>>> )-3600 from archive); >>>> >>>> and got : >>>> count(*) avg(pm2_5) max(pm2_5) >>>> >>>> 31 1.0897849462365594 1.2 >>>> >>>> >>>> >>>> >>>> >>>> On Saturday, April 10, 2021 at 4:49:26 PM UTC+2 [email protected] wrote: >>>> >>>>> Well, you can check what's in the database for the last hour. Adjust >>>>> the path to the database as necessary. >>>>> >>>>> *sqlite3 /var/lib/weewx/weewx.sdb* >>>>> sqlite> *select datetime(dateTime,'unixepoch','localtime'),pm2_5 from >>>>> archive where dateTime>=(select max(dateTime)-3600 from archive);* >>>>> >>>>> >>>>> >>>>> On Sat, Apr 10, 2021 at 5:50 AM [email protected] <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I am trying to improve my station sking with a proper AQI >>>>>> computation/display. however when using $hour.pm2_5.has_data it is >>>>>> always >>>>>> false. >>>>>> >>>>>> Data is stored in the pm2_5 column of weewx archive database. Gauges >>>>>> show the current values, and history plot show prior data. >>>>>> >>>>>> Is there a setting I need to add somewhere so that hourly average can >>>>>> be computed on this column as well? >>>>>> >>>>>> Regards, >>>>>> >>>>>> -- >>>>>> 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/6110a7ae-2012-47b9-9ffe-0cc7c8c67837n%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/weewx-user/6110a7ae-2012-47b9-9ffe-0cc7c8c67837n%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/28c7fca2-6552-4c19-9c51-8db602b9a416n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/28c7fca2-6552-4c19-9c51-8db602b9a416n%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/d3533f18-e001-48a4-b73a-aeab9b844644n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/d3533f18-e001-48a4-b73a-aeab9b844644n%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/654fcbf1-6e30-471e-9e95-430802ab84d2n%40googlegroups.com.
