Re: [weewx-user] Weewx 5.1 - Observation over 2 days

2025-03-27 Thread Dr Henk Harms
Ill be on the road for the next 2.5 weeks not having much access to internet, when I am back in the office I will fix that up for you. On Tue, 25 Mar 2025 at 22:52, Mike B. wrote: > Dr Henk Harms - Firstly thank you for taking timeout and putting together > the solution above. I think its pretty

Re: [weewx-user] Weewx 5.1 - Observation over 2 days

2025-03-25 Thread Mike B.
Dr Henk Harms - Firstly thank you for taking timeout and putting together the solution above. I think its pretty close. When trying to add the record using: *with self.engine.db_binder.get_manager(self.output_binding) as dbm_output: dbm_output.addRecord(recor

Re: [weewx-user] Weewx 5.1 - Observation over 2 days

2025-03-24 Thread Dr Henk Harms
Just new here... do not know karen k, or about her repo yet... where is her repo is it on github? Yes AU is metric, I assume if you set the it in conf it will do what it does... On Mon, 24 Mar 2025 at 16:08, 'michael.k...@gmx.at' via weewx-user < weewx-user@googlegroups.com> wrote: > Didn't Kare

Re: [weewx-user] Weewx 5.1 - Observation over 2 days

2025-03-23 Thread Dr Henk Harms
I ran that query or similar on my mariadb... took forever. Would it not be simpler to have an table called archive_day_bom_minmax and have a weewx service write to that table at 9am each day? On Thu, 20 Mar 2025 at 18:31, Mike B. wrote: > Hi All, > > I am trying to capture a new observation: "H

Re: [weewx-user] Weewx 5.1 - Observation over 2 days

2025-03-23 Thread 'michael.k...@gmx.at' via weewx-user
Didn't Karen K have something of this sort in her repo? The above will only work with metric db, will it? Dr Henk Harms schrieb am Montag, 24. März 2025 um 06:56:39 UTC+1: > > So been "messing with it" > To create a table. > > CREATE TABLE archive_bom_minmax ( > dateTime INTEGER NOT NULL P

Re: [weewx-user] Weewx 5.1 - Observation over 2 days

2025-03-23 Thread Dr Henk Harms
So been "messing with it" To create a table. CREATE TABLE archive_bom_minmax ( dateTime INTEGER NOT NULL PRIMARY KEY, usUnits INTEGER NOT NULL, `interval` INTEGER NOT NULL, min_temp DOUBLE, min_temp_time INTEGER, max_temp DOUBLE, max_temp_time INTEGER ); Then add this