Thanks, I will try to use the SLE tools. I have read the documentation for the implmementation of the seven_day tag, so I can make a new tag like "24_hour". As an example, where is the .hours implementation, so i can make a .records tag that iterate over each record?
Il giorno martedì 15 novembre 2016 17:40:02 UTC+1, Tom Keffer ha scritto: > > 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] > <javascript:>> 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] <javascript:>. >> 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.
