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