Query phptimeseries for historic data?

johnbanks · 25 May 2021 01:15

How, in PYTHON, do I query a phptimeseries feed to get the data at an historic time?

For example - CUM generation at this midnight minus CUM generation at last midnight = today’s generation

johnbanks · 25 May 2021 22:20

I’ve now discovered Trystan Lea’s useful script phptimeseries.py

emoncms/usefulscripts/blob/master/enginereaders/phptimeseries.py

import struct, os

# Directory of phptimeseries feeds, see: settings.php
datadir = "/var/lib/phptimeseries/"
    
# Feed id to read: 
feedid = 1
    
#----------------------------------------------------
    
fh = open(datadir+"feed_"+str(feedid)+".MYD", 'rb')
bytesize = os.stat(datadir+"feed_"+str(feedid)+".MYD").st_size
npoints = int(bytesize/9.0)
    
for i in range(npoints):

    array = struct.unpack('<cIf',fh.read(9))
    
    time = array[1]
    value = array[2]

This file has been truncated. show original

So I can now try searching thru’ all the feed values to find the one closest to my desired time.