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/CAPq0zECFJBxz-0Vqiu7-oUEk-skQj54eXgObO9sc4%3Do%3Dsqjxqw%40mail.gmail.com.
