[REQUEST] Historical Data

[danmed]

I may work on this myself if i can figure out the python for it..

It would be great to have a simple graph that can display the history of the price comparisons for each day..

first steps :

• sqlite database or ability to write to external mysql / mariadb database
• each run writes the 2 values to a new row in the db
• fields : key, date/time, go price, agile price, current tariff, switch

Once this exists it should be trivial to add in some simple web interface to display the data..

[eelmafia]

Why not just write out to a csv file on disk and then use that to display your data? A db sounds overkill for something like this

[danmed]

Why not just write out to a csv file on disk and then use that to display your data? A db sounds overkill for something like this

even better idea..

[danmed]

i think something like this should work.... im struggling to figure out how to test it though. I think if i mount a bind volume to /app then i should be able to easily test the code.

import datetime
csv_datetime = datetime.datetime.now()

csv_potential_cost = total_potential_calculated / 100
csv_current_cost = total_curr_cost / 100
csv_current_tariff = current_tariff 

with open('history.csv', 'a') as f:
    f.write(csv_datetime.strftime("%x") + ',' + csv_current_cost + ',' + csv_potential_cost + ',' + csv_current_tariff + '/n')

[Johnr24]

who knew reddit would build it's own version of predbat (with extra steps)

[danmed]

looks like the new release has changed the code a lot.. i think ill leave this to someone who knows what they are doing