def pushData(): #threading.Timer(300,pushData).start() print("Push Data Started") i = final_data() if i[5] == '': i[5] = 0 if i[6] == '': i[6] = 0 if i[4] == '': i[4] = 0 efficiency = 0 if float(i[6]) > 0.5: efficiency = (float(i[3]) * 20 * 60) / (367 * float(i[6])) data1 = data(temperature=i[1], humidity=i[2], flow=i[3], voltage=i[4], current=i[5], power=i[6], efficiency=efficiency, Time=i[0]) print(i[0]) db.session.add(data1) db.session.commit() print("commited")
def pushData(): threading.Timer(5, pushData).start() t = get_data( "http://139.59.42.21:8080/~/in-cse/in-name/Team9_Pumps_performance_monitoring/pr_4_esp32_1/oe/oe_1_temperature/la" )[1] print(float(t)) data1 = data(temperature=t, humidity=25, flow=7, power=56, current=21, efficiency=1) db.session.add(data1) db.session.commit() print("commited")
import csv from datetime import datetime from basics import data, db with open('data.csv') as file: readCSV = csv.reader(file, delimiter=',') for i in readCSV: efficiency = 0 if float(i[6]) > 0.5: efficiency = (float(i[3]) * 20 * 60) / (367 * float(i[6])) data1 = data(temperature=i[1], humidity=i[2], flow=i[3], voltage=i[4], current=i[5], power=i[6], efficiency=efficiency, Time=datetime.strptime(i[0], '%Y-%m-%d %H:%M:%S')) db.session.add(data1)
if oe_temp6[i] == "" or oe_temp6[i] == "NULL-Value": i = i + 1 continue final_reading.append(loli) i = i + 1 return final_reading final = lolzzmax() # 0 is date time for i in final: efficiency = 0 if float(i[6]) >0.5: efficiency = (float(i[3])*20*60)/(367*float(i[6])) data1 = data(temperature = i[1], humidity = i[2], flow = i[3], voltage = i[4], current = i[5], power=i[6], efficiency = efficiency, Time = i[0]) db.session.add(data1) db.session.commit() # except: # print("justin bieber chutiya hai!")
if oe_temp6[i] == "" or oe_temp6[i] == "NULL-Value": i = i + 1 continue final_reading.append(loli) i = i + 1 return final_reading final = lolzzmax() # 0 is date time for i in final: print((float(i[3]) * 20 * 60) / (367 * float(i[6]))) data1 = data(temperature=float(i[1]), humidity=float(i[2]), flow=float(i[3]), voltage=float(i[4]), current=float(i[5]), power=float(i[6]), efficiency=(float(i[3]) * 20 * 60) / (367 * float(i[6])), Time=i[0]) db.session.add(data1) db.session.commit() #Q*h*sg/(hp*3960) #Q = flow #H = 10 #sg = 1 #hp = 5