def espSub():
temp = request.args.get('temp')
hum = request.args.get('humidity')
room = request.args.get('room')
sql = MySql()
sql.insertRecord(temp, hum, room)
return flask.jsonify(GenericResponse("okay", 201, "Created").__dict__)
class SummaryService:
def __init__(self):
self.sql = MySql()
self.read = Read()
def getSlaveSummary(self, room):
now = self.read.getTemp()
day = [
str(self.sql.avgTempToday(room)),
str(self.sql.avgHumidityToday(room))
]
nowTime = datetime.datetime.today() + datetime.timedelta(days=1)
weekTime = datetime.datetime.today() - datetime.timedelta(days=7)
week = [
str(
self.sql.avgTempBetween(room, weekTime.strftime('%Y-%m-%d'),
nowTime.strftime('%Y-%m-%d'))),
str(
self.sql.avgHumidityBetween(room,
weekTime.strftime('%Y-%m-%d'),
nowTime.strftime('%Y-%m-%d')))
]
summary = Summary(now, day, week)
return summary.__dict__
def getSummary(self, room):
latest = self.sql.latestReadingWithTime(room)
now = [latest[0], latest[1]]
day = [
str(self.sql.avgTempToday(room)),
str(self.sql.avgHumidityToday(room))
]
nowTime = datetime.datetime.today() + datetime.timedelta(days=1)
weekTime = datetime.datetime.today() - datetime.timedelta(days=7)
week = [
str(
self.sql.avgTempBetween(room, weekTime.strftime('%Y-%m-%d'),
nowTime.strftime('%Y-%m-%d'))),
str(
self.sql.avgHumidityBetween(room,
weekTime.strftime('%Y-%m-%d'),
nowTime.strftime('%Y-%m-%d')))
]
summary = Summary(now, day, week, room, latest[2])
return summary.__dict__
def getSummaries(self, rooms):
summaries = []
for room in rooms:
summaries.append(self.getSummary(room))
return summaries
def getSummaries(self):
summaries = []
for room in self.sql.getRooms():
summaries.append(self.getSummary(room))
return summaries
def __init__(self):
self.sql = MySql()
self.read = Read()
def _startTransfer():
sql = MySql()
recordCount = sql.transferRecords(request.get_json().get('host'))
return GenericResponse(
"Processed " + recordCount + " records from old host", 204,
"No Content").__dict__
from api.dht.MySql import MySql
sql = MySql()
def executeCustomSql(sql):
userInput = input("Enter SQl Statement: ")
sql.runQuery(userInput)
def avg(type):
userInput = input("Enter room/sensor name: ")
room = str(userInput)
userInput = input("Enter 0 to input date range: ")
if userInput == 0:
avgBetween(type, room)
else:
if type == "temp":
print("Avg. Temp = " + str(sql.avgTemp(room)))
else:
print("Avg. Humidity = " + str(sql.avgHumidity(room)))
def avgBetween(type, room):
userInput = input("Enter starting date: ")
start = str(userInput)
userInput = input("Enter ending date: ")
stop = str(userInput)
if type == "temp":
print("Avg. Temp = " + str(sql.avgTempBetween(room, start, stop)))
else:
def __init__(self):
self.sql = MySql()
self.read = Read()
self.daysInMonth = DAYS_IN_MONTH
class ChartService:
def __init__(self):
self.sql = MySql()
self.read = Read()
self.daysInMonth = DAYS_IN_MONTH
def getChart(self, intervalRequest):
if intervalRequest.type == "temp":
return Intervals(self._getTempAvgChart(intervalRequest)).__dict__
else:
return Intervals(self._getTempDiffChart(intervalRequest)).__dict__
return []
def _getMonthAvg(self, type, intervals, j, q, sdt, edt):
fullDays = False
rooms = self.sql.getRooms()
if int(edt[1]) == q and int(edt[0]) == j and int(sdt[0]) == j and int(
sdt[1]) == q:
sDay = int(sdt[2])
eDay = int(edt[2])
elif int(edt[1]) == q and int(edt[0]) == j:
sDay = 1
eDay = int(edt[2])
else:
sDay = 1
eDay = self.daysInMonth[q - 1]
if int(sdt[0]) != int(edt[0]) or int(sdt[1]) != int(
edt[1]) or (eDay - sDay) >= 3:
fullDays = True
if sDay == eDay:
if type == "avg":
self._getDayAvgApi(25, intervals, j, q, sDay, sdt, edt, rooms,
2)
else:
self._getDayDiff(intervals, j, q, sDay, sdt, edt, fullDays, 6)
else:
for i in range(sDay, eDay + 1):
if i == eDay:
if type == "avg":
self._getDayAvgApi(25, intervals, j, q, i, sdt, edt,
rooms, 6)
else:
self._getDayDiff(24, intervals, j, q, i, sdt, edt,
fullDays, 6)
else:
if type == "avg":
self._getDayAvgApi(23, intervals, j, q, i, sdt, edt,
rooms, 6)
else:
self._getDayDiff(23, intervals, j, q, i, sdt, edt,
fullDays, 6)
def _getTempAvgChart(self, intervalRequest):
intervals = []
sdt = intervalRequest.startDate.split("-")
edt = intervalRequest.endDate.split("-")
if int(sdt[0]) == int(edt[0]):
self._getAvgIntervals("avg", intervals, int(sdt[0]), sdt, edt)
else:
for j in range(int(sdt[0]), int(edt[0])):
self._getAvgIntervals("avg", intervals, j, sdt, edt)
return intervals
def _getTempDiffChart(self, intervalRequest):
intervals = []
sdt = intervalRequest.startDate.split("-")
edt = intervalRequest.endDate.split("-")
if intervalRequest.startDate == intervalRequest.endDate:
self._getOneDayDiff(intervals, sdt, edt)
else:
if int(sdt[0]) == int(edt[0]):
self._getAvgIntervals("diff", intervals, int(sdt[0]), sdt, edt)
else:
for j in range(int(sdt[0]), int(edt[0])):
self._getAvgIntervals("diff", intervals, j, sdt, edt)
return intervals
def _getDayAvgApi(self, endRange, intervals, year, month, day, sdt, edt,
rooms, interval):
startTime = (
datetime.datetime(year, month, day, 0, 0, 0, 0) +
datetime.timedelta(hours=-1)).strftime('%Y-%m-%d %H:%M:%S')
endTime = (
datetime.datetime(year, month, day, 0, 0, 0, 0) +
datetime.timedelta(hours=endRange)).strftime('%Y-%m-%d %H:%M:%S')
records = self.sql.getRecordsBetween(startTime, endTime)
records.sort(key=self._getDate)
cursor = 0
for k in range(0, endRange):
if k % interval == 0:
avgDate = (
datetime.datetime(year, month, day, 0, 0, 0, 0) +
datetime.timedelta(hours=k)).strftime('%Y-%m-%d %H:%M:%S')
sDate = (datetime.datetime(year, month, day, 0, 0, 0, 0) +
datetime.timedelta(hours=(k - 1))
).strftime('%Y-%m-%d %H:%M:%S')
eDate = (datetime.datetime(year, month, day, 0, 0, 0, 0) +
datetime.timedelta(hours=(k + 1))
).strftime('%Y-%m-%d %H:%M:%S')
intervals.append(
self._getInterval(records, cursor, sDate, eDate, avgDate,
"temp", rooms).__dict__)
def _getDayDiff(self, endRange, intervals, j, q, i, sdt, edt, fullDays,
interval):
if fullDays:
avgDate = (datetime.datetime(j, q, i, 0, 0, 0,
0)).strftime('%Y-%m-%d')
sDate = (
datetime.datetime(j, q, i, 0, 0, 0, 0) +
datetime.timedelta(hours=(0))).strftime('%Y-%m-%d %H:%M:%S')
eDate = (
datetime.datetime(j, q, i, 0, 0, 0, 0) +
datetime.timedelta(hours=(24))).strftime('%Y-%m-%d %H:%M:%S')
self._getTempDiffInterval(intervals, sDate, eDate, avgDate)
else:
for k in range(0, endRange):
if ((k % interval) == 0):
avgDate = (datetime.datetime(j, q, i, 0, 0, 0, 0) +
datetime.timedelta(hours=k)
).strftime('%Y-%m-%d %H:%M:%S')
sDate = (datetime.datetime(j, q, i, 0, 0, 0, 0) +
datetime.timedelta(hours=(k - interval))
).strftime('%Y-%m-%d %H:%M:%S')
eDate = (datetime.datetime(j, q, i, 0, 0, 0, 0) +
datetime.timedelta(hours=(k + interval))
).strftime('%Y-%m-%d %H:%M:%S')
self._getTempDiffInterval(intervals, sDate, eDate, avgDate)
def _getTempDiffInterval(self, intervals, sDate, eDate, avgDate):
office = self.sql.tempDiffBetween("office", sDate, eDate)
bedroom = self.sql.tempDiffBetween("bedroom", sDate, eDate)
freezer = self.sql.tempDiffBetween("freezer", sDate, eDate)
outside = self.sql.tempDiffBetween("outside", sDate, eDate)
interval = Interval(avgDate,
[str(office[0]), str(office[1])],
[str(bedroom[0]), str(bedroom[1])],
[str(freezer[0]), str(freezer[1])],
[str(outside[0]), str(outside[1])])
intervals.append(interval.__dict__)
def _getAvgIntervals(self, type, intervals, j, sdt, edt):
if int(edt[0]) == j and int(sdt[0]) == int(edt[0]):
sMonth = int(sdt[1])
eMonth = int(edt[1])
elif int(edt[0]) == j:
sMonth = 1
eMonth = int(edt[1])
elif int(sdt[0]) == j:
sMonth = int(sdt[1])
eMonth = 12
else:
sMonth = 1
eMonth = 12
if sMonth == eMonth:
self._getMonthAvg(type, intervals, j, sMonth, sdt, edt)
else:
for q in range(sMonth, eMonth + 1):
self._getMonthAvg(type, intervals, j, q, sdt, edt)
def _getOneDayDiff(self, intervals, sdt, edt):
for k in range(0, 25):
if ((k % 2) == 0):
avgDate = (
datetime.datetime(int(sdt[0]), int(sdt[1]), int(sdt[2]), 0,
0) +
datetime.timedelta(hours=k)).strftime('%Y-%m-%d %H:%M:%S')
sDate = (datetime.datetime(int(sdt[0]), int(sdt[1]), int(
sdt[2]), 0, 0) + datetime.timedelta(hours=(k - 1))
).strftime('%Y-%m-%d %H:%M:%S')
eDate = (datetime.datetime(int(sdt[0]), int(sdt[1]), int(
sdt[2]), 0, 0) + datetime.timedelta(hours=(k + 1))
).strftime('%Y-%m-%d %H:%M:%S')
office = self.sql.tempDiffBetween("office", sDate, eDate)
bedroom = self.sql.tempDiffBetween("bedroom", sDate, eDate)
freezer = self.sql.tempDiffBetween("freezer", sDate, eDate)
outside = self.sql.tempDiffBetween("outside", sDate, eDate)
interval = Interval(
avgDate, [str(office[0]), str(office[1])],
[str(bedroom[0]), str(bedroom[1])],
[str(freezer[0]), str(freezer[1])],
[str(outside[0]), str(outside[1])])
intervals.append(interval.__dict__)
def _getAvg(self, roomSums, room):
for sum in roomSums:
if sum.room == room:
if sum.count == 0:
return None
else:
return int(sum.sum / sum.count)
return None
def _getDate(self, reading):
return reading.date
def _addRoomReading(self, roomSums, reading, type):
sums = []
for tSum in roomSums:
sum = tSum.sum
count = tSum.count
if tSum.room == reading.room:
if type == "temp":
sum = tSum.sum + reading.temp
else:
sum = tSum.sum + reading.humidity
count = tSum.count + 1
sums.append(RoomSum(tSum.room, sum, count))
return sums
def _compareDate(self, subject, start, end):
if str(subject) >= str(start) and str(subject) <= str(end):
return True
else:
return False
def _getInterval(self, readings, cursor, startDate, endDate, intervalDate,
type, rooms):
roomSums = []
for room in rooms:
roomSums.append(RoomSum(room, 0, 0))
first = True
count = 0
for i in range(cursor, len(readings)):
count = count + 1
if self._compareDate(readings[i].date, startDate, endDate):
if first:
first = False
roomSums = self._addRoomReading(roomSums, readings[i], type)
else:
if first == False:
break
cursor = cursor + count
return Interval(intervalDate, self._getAvg(roomSums, "office"),
self._getAvg(roomSums, "bedroom"),
self._getAvg(roomSums, "freezer"),
self._getAvg(roomSums, "outside"))