I would not recommend accessing the database directly. Use the SLE tools instead.
Or, just wait. Eventually, Issue #182 will get resolved. -tk On Tue, Nov 15, 2016 at 8:36 AM, Pier Francesco Costa <[email protected] > wrote: > > > Il giorno martedì 15 novembre 2016 17:11:46 UTC+1, Andrew Milner ha > scritto: >> >> Sounds as though you just want an sql select script rather than a >> report! Reports are intended to summarise the detail, not provide it. How >> often do you want the json file creating - or do you want it created every >> archive interval? Does the json file have to provide just a list >> of outTemp values or does it also contain date, time as well as outTemp? >> >> >> >> On Tuesday, 15 November 2016 18:01:25 UTC+2, Pier Francesco Costa wrote: >> >>> Hi, >>> I am coming back with some question about how to generate a report with >>> cheetah. >>> >>> I'd like to generate a Json file containing every outTemp value over the >>> last 24 hours. >>> >>> I have already read the documentation and wrote a report that generate a >>> Json. >>> I get the outTemp.avg using the .hours iterator. >>> >>> The problem I have is that I'd like to iterate not every hour but every >>> single archive record, because I am using an archive interval of 5 minutes. >>> >>> How could I do that? >>> >> > Hi, > maybe you're right, I though that I could use the report generator > because I am not so skilled with python and database access. > Also the database is stored in US units and I want to use metric ones, so > I would either need to convert units on the fly or changing unit system > inside the database. > The Json file should also have a list of times, one for each values. > > So after Tom answer I think I have two option... creating a SLE or writing > a python script that runs as a chron job directly accessing the database, > am I right? > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
