print '''You can now get trace information per house. You can also see the
trace of a particular appliance. However this is the point where you are
informed that "seeing" is actually a step that comes after pickling. Do you want to pickle a house? If not you will be asked shortly to pickle a type? Enter yes or no'''
boo = raw_input()
if str(boo) == 'yes':
#house = raw_input('Enter a home id\n')
#appliance = raw_input('Enter an appliance name (this is not actually necessary at\this point):')
#query = 'select * from {0}.{1} where dataid={2}'.format(schema_names[schema], month,house)
#df = p.get_dataframe(query).fillna(0)
# temp = p.clean_dataframe(df,schema,[])
# test = p.get_month_traces_per_dataid(schema,month,house)
print 'you now have a bunch of appliance traces, one trace for each appliance in a house'
print 'here is some information about the first trace '
elif str(boo) == 'no':
print 'ok what appliance do you want?'
app = str(raw_input())
print 'this step takes quite a while'
pecan.set_url(db_url)
dataids = pecan.get_dataids_with_real_values(schema, month, app)
type = pecan.generate_traces_for_appliance_by_dataids(
schema, month, app, dataids)
utils.pickle_object(type, '{}_{}'.format(app, month))
else:
print 'what was that?'
#house = raw_input('Enter a home id\n')
#appliance = raw_input('Enter an appliance name (this is not actually necessary at\this point):')
#query = 'select * from {0}.{1} where dataid={2}'.format(schema_names[schema], month,house)
#df = p.get_dataframe(query).fillna(0)
# temp = p.clean_dataframe(df,schema,[])
# test = p.get_month_traces_per_dataid(schema,month,house)
print 'you now have a bunch of appliance traces, one trace for each appliance in a house'
print 'here is some information about the first trace '
elif str(boo)=='no':
print 'ok what appliance do you want?'
app = str(raw_input())
print 'this step takes quite a while'
pecan.set_url(db_url)
dataids = pecan.get_dataids_with_real_values(schema,month,app)
type = pecan.generate_traces_for_appliance_by_dataids(schema, month,app,dataids)
utils.pickle_object(type, '{}_{}'.format(app,month))
else:
print 'what was that?'
trace = opdsa.generate_trace_by_dataid(homes, home)
print_permission = raw_input("Would you like to see it? Enter yes or no\n")
if print_permission == 'yes':
print trace
pickle_thing = trace
pickle_name = str(home)
elif reply == "set":
print "You can see any month in 2013, and any month up to July in 2014."
year = raw_input("Please enter 2014 or 2013\n")
month = raw_input("Please enter a number one through twelve\n")
print "Ok hold on"
app_set = opdsa.generate_set_by_year_month(homes, int(year), int(month))
pickle_thing = app_set
pickle_name = '{}_{}'.format(str(year), str(month))
else:
print "HEY! I said trace or set dum dum"
pickle_permission = raw_input(
"Would you like a pickle with that? Enter yes or no\n")
if pickle_permission == 'yes':
utils.pickle_object(pickle_thing, pickle_name)
else:
print "Okie Doke, thanks for coming!"
#print trace.resample('MS').series
trace = opdsa.generate_trace_by_dataid(homes,home)
print_permission = raw_input("Would you like to see it? Enter yes or no\n")
if print_permission=='yes':
print trace
pickle_thing=trace
pickle_name = str(home)
elif reply=="set":
print "You can see any month in 2013, and any month up to July in 2014."
year = raw_input("Please enter 2014 or 2013\n")
month = raw_input("Please enter a number one through twelve\n")
print "Ok hold on"
app_set = opdsa.generate_set_by_year_month(homes,int(year),int(month))
pickle_thing=app_set
pickle_name = '{}_{}'.format(str(year),str(month))
else:
print "HEY! I said trace or set dum dum"
pickle_permission = raw_input("Would you like a pickle with that? Enter yes or no\n")
if pickle_permission=='yes':
utils.pickle_object(pickle_thing,pickle_name)
else:
print "Okie Doke, thanks for coming!"
#print trace.resample('MS').series
