Hi, I tried to get $hour.outTemp.avg, and just got N/A
but $day.pm2_5.avg does work and give me the average over the last 24h. So it seems my setup is only messing up the "hourly" summary. Any idea where I should look to try figure this one out? Regards, On Monday, April 12, 2021 at 11:52:53 PM UTC+2 [email protected] wrote: > 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/f8d1f8bc-d2f3-4e3c-9c65-4ef4873f39b6n%40googlegroups.com.
