Sorry again, but I am unable to reproduce this. It works fine on my test setup.
Do all variables exhibit this? For example, $hour.outTemp.has_data? On Mon, Apr 12, 2021 at 1:28 PM [email protected] <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/654fcbf1-6e30-471e-9e95-430802ab84d2n%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/CAPq0zECCKKbopBmC%2BLPLUKfF9hqZAUx_b4V%3DCVO1%2BzRKr8VTuA%40mail.gmail.com.
