from Retrieve import retrieve
import time
import thread
TV = retrieve.retrieve('SpotHome2',"TV",1,0,10000)
Coffee = retrieve.retrieve('SpotHome2',"Coffee",1,0,10000)
LampLiving = retrieve.retrieve('SpotHome2',"LampLiving",1,0,10000)
LampBed = retrieve.retrieve('SpotHome2',"LampBed",1,0,10000)
User200 = retrieve.retrieve('SpotHome2',"200_Consumption",1,0,10000)
User201 = retrieve.retrieve('SpotHome2',"201_Consumption",1,0,10000)
User200Occu = retrieve.retrieve('SpotHome2',"200_Occupancy",1,0,10000)
User201Occu = retrieve.retrieve('SpotHome2',"201_Occupancy",1,0,10000)
User200RSSI = retrieve.retrieve('SpotHome2',"200_RSSI",1,0,10000)
User201RSSI = retrieve.retrieve('SpotHome2',"201_RSSI",1,0,10000)
TV = TV.split()
Coffee = Coffee.split()
LampLiving = LampLiving.split()
LampBed = LampBed.split()
User200 = User200.split()
User201 = User201.split()
User200Occu = User200Occu.split()
User201Occu = User201Occu.split()
User200RSSI = User200RSSI.split()
User201RSSI = User201RSSI.split()
from Retrieve import retrieve
import time
import thread
TimeStamp = retrieve.retrieve('SpotHome2', "TimeStamp", 1, 0, 10000)
TV = retrieve.retrieve('SpotHome2', "TV", 1, 0, 10000)
Coffee = retrieve.retrieve('SpotHome2', "Coffee", 1, 0, 10000)
LampLiving = retrieve.retrieve('SpotHome2', "LampLiving", 1, 0, 10000)
LampBed = retrieve.retrieve('SpotHome2', "LampBed", 1, 0, 10000)
User200 = retrieve.retrieve('SpotHome2', "200_Consumption", 1, 0, 10000)
User201 = retrieve.retrieve('SpotHome2', "201_Consumption", 1, 0, 10000)
User200Occu = retrieve.retrieve('SpotHome2', "200_Occupancy", 1, 0, 10000)
User201Occu = retrieve.retrieve('SpotHome2', "201_Occupancy", 1, 0, 10000)
User200RSSI = retrieve.retrieve('SpotHome2', "200_RSSI", 1, 0, 10000)
User201RSSI = retrieve.retrieve('SpotHome2', "201_RSSI", 1, 0, 10000)
TimeStamp = TimeStamp.split()
TV = TV.split()
Coffee = Coffee.split()
LampLiving = LampLiving.split()
LampBed = LampBed.split()
User200 = User200.split()
User201 = User201.split()
User200Occu = User200Occu.split()
User201Occu = User201Occu.split()
User200RSSI = User200RSSI.split()
User201RSSI = User201RSSI.split()
from Retrieve import retrieve
import time
# input values are (table_name, fields, condition, data_from, data_to)
# return values are csv data
#14E00401000042B1CE : Laura
#14E004010000429DF7 : Akhi
#14E0040100004288B9 : Younghun
#14E004010000429DA9 : Zainul
#condition = "TID=\"14E004010000429DA9\""
#condition = "TID=\"14E0040100004288B9\""
#condition = "TID=\"14E004010000429DF7\""
condition = "TID=\"14E00401000042B1CE\""
file = open('laura.dat', 'w+')
data = retrieve.retrieve('RFID', "TimeStamp,UID", condition, 0, 10000)
file.write(data)
file.close()
#file = open('DataForm.txt','w+')
#for i in data.split(','):#
# try:
# print time.localtime(i)
# except:
# pass
#time = time.time()
#condition = "AID=\"%s\""%(4) # AND "TimeStamp=%d""%(time)
#condition = "AID=4"
#condition = "TimeStamp>1181771990"
#print condition
import time
# input values are (table_name, fields, condition, data_from, data_to)
# return values are csv data
#14E00401000042B1CE : Laura
#14E004010000429DF7 : Akhi
#14E0040100004288B9 : Younghun
#14E004010000429DA9 : Zainul
#condition = "TID=\"14E004010000429DA9\""
#condition = "TID=\"14E0040100004288B9\""
#condition = "TID=\"14E004010000429DF7\""
condition = "TID=\"14E00401000042B1CE\""
file = open('laura.dat','w+')
data = retrieve.retrieve('RFID',"TimeStamp,UID",condition,0,10000)
file.write(data)
file.close()
#file = open('DataForm.txt','w+')
#for i in data.split(','):#
# try:
# print time.localtime(i)
# except:
# pass
#time = time.time()
#condition = "AID=\"%s\""%(4) # AND "TimeStamp=%d""%(time)
#condition = "AID=4"
#condition = "TimeStamp>1181771990"
from Retrieve import retrieve
import time
import thread
Condition = "PosDescription=\"LivingRoom\" and ID = 201"
#TimeStamp = retrieve.retrieve('HomeTokens',"TimeStamp",Condition,0,10000)
#PosDescription = retrieve.retrieve('HomeTokens',"PosDescription",Condition,0,10000)
LivBaseToken = retrieve.retrieve('HomeTokens',"BaseToken",Condition,0,10000).split('\n')
LivCaliToken = retrieve.retrieve('HomeTokens',"CaliToken",Condition,0,10000).split('\n')
LivHysToken = retrieve.retrieve('HomeTokens',"HysToken",Condition,0,10000).split('\n')
LivRSSI = retrieve.retrieve('HomeTokens',"RSSI",Condition,0,10000).split('\n')
Condition = "PosDescription=\"WorkSpace3\""
WorkBaseToken = retrieve.retrieve('HomeTokens',"BaseToken",Condition,0,10000).split('\n')
WorkCaliToken = retrieve.retrieve('HomeTokens',"CaliToken",Condition,0,10000).split('\n')
WorkHysToken = retrieve.retrieve('HomeTokens',"HysToken",Condition,0,10000).split('\n')
WorkRSSI = retrieve.retrieve('HomeTokens',"RSSI",Condition,0,10000).split('\n')
Condition = "PosDescription=\"Kitchen1\""
Kit1BaseToken = retrieve.retrieve('HomeTokens',"BaseToken",Condition,0,10000).split('\n')
Kit1CaliToken = retrieve.retrieve('HomeTokens',"CaliToken",Condition,0,10000).split('\n')
Kit1HysToken = retrieve.retrieve('HomeTokens',"HysToken",Condition,0,10000).split('\n')
Kit1RSSI = retrieve.retrieve('HomeTokens',"RSSI",Condition,0,10000).split('\n')
Condition = "PosDescription=\"Kitchen2\""
Kit2BaseToken = retrieve.retrieve('HomeTokens',"BaseToken",Condition,0,10000).split('\n')
Kit2CaliToken = retrieve.retrieve('HomeTokens',"CaliToken",Condition,0,10000).split('\n')
Kit2HysToken = retrieve.retrieve('HomeTokens',"HysToken",Condition,0,10000).split('\n')
Kit2RSSI = retrieve.retrieve('HomeTokens',"RSSI",Condition,0,10000).split('\n')
