Re: [weewx-user] Re: 24 hour rain total in mysql database

2019-01-05 Thread bdf0506
Wow, thanks Thomas. I will use this as a guide to try out and test this. On Friday, January 4, 2019 at 8:38:11 PM UTC-5, Thomas Keffer wrote: > > If you want it precalculated in the database, you could write a WeeWX > service to do this. It would look something like this (NOT TESTED): > > *File

Re: [weewx-user] Re: 24 hour rain total in mysql database

2019-01-04 Thread Thomas Keffer
If you want it precalculated in the database, you could write a WeeWX service to do this. It would look something like this (NOT TESTED): *File user/total_rain.py* import weewx import weewx.units from weewx.engine import StdService class Total24(StdService): """Service that calculates the

[weewx-user] Re: 24 hour rain total in mysql database

2019-01-04 Thread bdf0506
So, I want to easily be able to query the database, and see at any given time what the 24 hour rain total is. When I go to Dec 15 at 2:00pm, I want to know how much was accumulated between 12/14 2:00pm-12/15 2:00pm. Yes, I can do a complex mysql query to get this information, but I really don't

[weewx-user] Re: 24 hour rain total in mysql database

2019-01-03 Thread vince
On Thursday, January 3, 2019 at 1:17:29 PM UTC-8, gjr80 wrote: > > I am hard pressed to understand why you might want the rainfall from > 11:25 17 September 2017 until 11:25 18 September 2017, or say 11:45 17 > September 2017 to 11:45 18 September 2017. Would not the existing daily > midnight

[weewx-user] Re: 24 hour rain total in mysql database

2019-01-03 Thread gjr80
Hi, I am a little bit lost in terms of understanding what it is you want to do. Do you want a field in the weeWX archive that contains the rainfall in the last 24 hours;for example today's 09:30 archive record would contain the rainfall from 09:30 yesterday to 09:30 today, today's 09:35 record

[weewx-user] Re: 24 hour rain total in mysql database

2019-01-02 Thread bdf0506
Yea, I figured I could do this with a mysql query, but was hoping to get it into the database structure so I can run simple queries based on the numbers already being calculated as a field, as this is an important number to see for me in the db itself. If I alter the table and add syntax to

[weewx-user] Re: 24 hour rain total in mysql database

2019-01-01 Thread mwall
On Monday, December 31, 2018 at 12:50:45 PM UTC-5, bdf0506 wrote: > > I am looking to add information into my archive database that will show > rainfall over the last 24 hours. > > Today, I have the influxdb extension, and when I look in the influxdb, I > see a measurement for "rain24_in". I