def day_data_to_file(workdir,day=None):
''' generate one day wattage text file '''
# get datetime limits
dt00 = datetime(2010,1,1,0,0,0)
if day==None:
lts = last_entry_timestamp()
dt00 = datetime(lts.year,lts.month,lts.day,0,0,0)
else:
dt00 = datetime(day.year,day.month,day.day,0,0,0)
dt24 = dt00 + timedelta(1,0,0)
# get data from to
data = get_raw_data(return_data(begin=dt00,end=dt24))
calculate_wattage(data)
if type(data)==list:
fname = '{}{:04}{:02}{:02}_day_data.txt'.format(workdir,dt00.year,dt00.month,dt00.day)
f = open(fname,'w')
f.write('# time; p[kw]\n')
for e in data[1:]:
f.write('{:02}:{:02}; {:0.3f}\n'.format(e[0].hour,e[0].minute,e[2]))
f.close()
return fname
return None
def all_data_to_day_files(workdir):
''' generate day wattage files from all data in db '''
fts = first_entry_timestamp()
lts = last_entry_timestamp()
dt00 = datetime(fts.year,fts.month,fts.day,0,0,0)
ret = []
while dt00<=lts:
day = date(dt00.year,dt00.month,dt00.day)
r = day_data_to_file(workdir,day)
if r!=None:
print('{}'.format(r))
ret.append(r)
dt00 += timedelta(1,0,0)
return ret