def generateUsersHistory():
### Comment out the two lines below if I don't want to clear the previous results
open("CSV1.csv", 'w').close()
open("CSV2.csv", 'w').close()
### Comment out the three lines below if I don't want to clear the previous results
header = [
'id_user', 'date', 'avr14', 'avr5', 'W-1', 'negative_med_change',
'positive_med_change', 'max_dusting', 'rain', 'wind', 'temperature',
'month36', 'W0', 'W0-avr14'
]
appendLineToFile(header, "CSV1.csv")
appendLineToFile(header, "CSV2.csv")
# wormup date
wormupDate = seasonsDates.wormupDate
# start of 1st CSV
winterStartDate2017 = seasonsDates.winterStartDate2017
# start of 2nd CSV
winterStartDate2018 = seasonsDates.winterStartDate
# finish date
winter2StartDate = seasonsDates.winter2StartDate
db = dbConnection()
allWeather, allWeatherValues = getAllWeather(db)
dustingPointsTable = getDustingPointsTable(db)
db = dbConnection()
cursor = db.cursor(buffered=True)
cursor.execute("SELECT id_user, type FROM users u")
users = [user for user in cursor]
cursor.close()
db.close()
# Was used to mask user aleready with data
# for i in range(1,seasonsDates.N+1):
# users.remove(i)
num_cores = multiprocessing.cpu_count()
Parallel(n_jobs=num_cores)(delayed(processInputUsers)(
userRow[0], userRow[1], wormupDate, winterStartDate2017,
winterStartDate2018, winter2StartDate, allWeather, allWeatherValues,
dustingPointsTable) for userRow in users)
from database import dbConnection db = dbConnection() # DROP weather table query = "DROP TABLE IF EXISTS weather;" print(query) cursor = db.cursor() cursor.execute(query) db.commit() cursor.close() # CREATE weather table query =\ "CREATE TABLE `weather` (\ `date` DATE NOT NULL,\ `temperature` FLOAT,\ `humidity` FLOAT,\ `wind` FLOAT,\ `rain` FLOAT,\ PRIMARY KEY (`date`)\ );" print(query) cursor = db.cursor() cursor.execute(query) db.commit() cursor.close() # INSERT values from file weatherFilePath = "./weather_history.txt"
def processInputUsers(idUser, type, wormupDate, winterStartDate2017,
winterStartDate2018, winter2StartDate, allWeather,
allWeatherValues, dustingPointsTable):
db = dbConnection()
today = wormupDate
thisUsersAllergiesNames = getThisUsersAllergiesNames(db, idUser)
last14AsthmaResultsAfterDailyMedicinesQueue = []
last14AsthmaResultsQueue = []
dosagesFrom5DaysBackQueue = []
dosagesIdsFrom5DaysBackQueue = []
dosageChangeQueue = []
dosageChangeLogQueue = []
dosageIncreaseCounter = 0
dosageDecreaseCounter = 0
# controlTestList = []
# medicineEventsList = []
# trendsList = []
# For each day in a time slot
while today < winter2StartDate:
# LOG
# print(str(last14AsthmaResultsAfterDailyMedicinesQueue) + " last14AsthmaResultsAfterDailyMedicinesQueue")
#print(str(dosagesFrom5DaysBackQueue) + " dosagesFrom5DaysBackQueue")
# print(str(dosagesIdsFrom5DaysBackQueue) + " dosagesIdsFrom5DaysBackQueue")
# print(str(dosageChangeQueue) + " dosageChangeQueue")
todayStr = today.strftime("%Y-%m-%d")
# LOG
# progress bar
# comment this for maximum speed
# v = int((today - wormupDate).days / 750 * 100)
# string = ""
# for _ in range(v): string += "#"
# for _ in range(100-v): string += " "
# print(str(idUser) + " [" + string + "]")
print(idUser)
if today == winterStartDate2017:
fileName = 'CSV1.csv'
elif today == winterStartDate2018:
fileName = 'CSV2.csv'
dailyDataLine = [
idUser, todayStr, "", "", "", "", "", "",
allWeatherValues[todayStr][0], allWeatherValues[todayStr][1],
allWeatherValues[todayStr][2], "", "", ""
]
# counting number of both types of changes in dosageChangeLogQueue
positiveChange = 0
negativeChange = 0
for change in dosageChangeLogQueue:
if change[:1] == "+":
positiveChange += 1
elif change == "0":
pass
else:
negativeChange += 1
dailyDataLine[5] = negativeChange
dailyDataLine[6] = positiveChange
# logTable = [idUser] # LOG
W = 25
numberOfFactorsUsedForRandomizationOfWMedicinesChange = 0
# DONE 1. Dusting
ifIsAnyDusting = False
maxTodaysDustingPoints = 0
season36Name, dailyDataLine[11] = getSeason36(today)
for allerieName in thisUsersAllergiesNames:
todaysDustingPoints = dustingPointsTable[allerieName][season36Name]
if todaysDustingPoints != 0:
ifIsAnyDusting = True
if maxTodaysDustingPoints < todaysDustingPoints:
maxTodaysDustingPoints = todaysDustingPoints
W -= maxTodaysDustingPoints
dailyDataLine[7] = maxTodaysDustingPoints
# logTable.append(maxTodaysDustingPoints) # LOG
# DONE 2. Rain
if ifIsAnyDusting and allWeather[todayStr][0]:
# logTable.append("R") # LOG
W += 1
else:
# logTable.append(" ") # LOG
pass
# DONE 3. Wind
if ifIsAnyDusting and allWeather[todayStr][1]:
# logTable.append("W") # LOG
numberOfFactorsUsedForRandomizationOfWMedicinesChange += 1
W -= 1
else:
# logTable.append(" ") # LOG
pass
# DONE 4. Temperature
if ifIsAnyDusting and allWeather[todayStr][2]:
# logTable.append("T") # LOG
numberOfFactorsUsedForRandomizationOfWMedicinesChange += 1
W -= 1
else:
# logTable.append(" ") # LOG
pass
# 5. Changes of medicine dosage
if dosageIncreaseCounter >= 2:
# replaceing "+N"s with "0" in queue, subtraction from counter 2 and change of W
for index in range(len(dosageChangeQueue)):
if dosageChangeQueue[index][:1] == "+":
dosageChangeQueue[index] = "0"
dosageIncreaseCounter -= 2
W -= 2
# logTable.append("W-2") # LOG
elif dosageDecreaseCounter >= 2:
# replaceing "-N"s with "0" in queue, adding to counter 2 and change of W
for index in range(len(dosageChangeQueue)):
if dosageChangeQueue[index][:1] == "-":
dosageChangeQueue[index] = "0"
dosageDecreaseCounter -= 2
W += 2
# logTable.append("W+2") # LOG
else:
# logTable.append("W+0") # LOG
pass
# DONE 6. Change of trend
arithmeticAverage = 0
lenList = len(last14AsthmaResultsAfterDailyMedicinesQueue)
if lenList >= 5:
# arithmeticAverage = countArithmeticAverage(last14AsthmaResultsAfterDailyMedicinesQueue)
arithmeticAverage = countArithmeticAverage(
last14AsthmaResultsQueue)
numberOfElementsGraterThanArithmeticAverage = 0
for index in range(lenList - 5, lenList):
if last14AsthmaResultsAfterDailyMedicinesQueue[
index] > arithmeticAverage:
numberOfElementsGraterThanArithmeticAverage += 1
if numberOfElementsGraterThanArithmeticAverage >= 3:
W += 2
# logTable.append("+")
else:
W -= 2
# logTable.append("-")
else:
# logTable.append("0")
pass
### I'm checking if the CHANGE OF MEDICINE DOSAGE ocures and changing it and i'm counting WMedicines (W')
# first it is randomized if user is taking medicines based on his type
if type == 0:
medicineTakeChance = 100
else:
medicineTakeChance = 90
if len(dosagesIdsFrom5DaysBackQueue) > 0:
lastDosageId = dosagesIdsFrom5DaysBackQueue[
len(dosagesIdsFrom5DaysBackQueue) - 1]
lastDosageValue = dosagesFrom5DaysBackQueue[
len(dosagesFrom5DaysBackQueue) - 1]
else:
lastDosageId = 1
lastDosageValue = "0"
if randrange(101) <= medicineTakeChance:
# he is taking medicines today
# INFO: not changing dosage between x and y
x = 25
y = 21
if W > x:
numberOfDosagesNeeded = -int((W - 25) / 2)
elif W < y:
numberOfDosagesNeeded = int((25 - W) / 2)
else:
numberOfDosagesNeeded = 0
numberOfDosagesToIncrease = numberOfDosagesNeeded - int(
lastDosageValue)
# LOG
# if numberOfDosagesToIncrease > 0 and lastDosageValue == "10":
# print("Nie można ZWIĘKSZYĆ dawki!")
# elif (numberOfDosagesToIncrease < 0 and lastDosageValue == "0"):
# print("Nie można ZMNIEJSZYĆ dawki!")
if numberOfDosagesToIncrease > 0 and lastDosageValue != "10":
# increase
maxIncreasePossible = 10 - int(lastDosageValue)
if maxIncreasePossible < numberOfDosagesToIncrease:
numberOfDosagesToIncrease = maxIncreasePossible
dosageChangeQueue.append("+" + str(numberOfDosagesToIncrease))
if len(dosageChangeQueue) > 5:
dosageChangeQueue.pop(0)
dosageChangeLogQueue.append("+" +
str(numberOfDosagesToIncrease))
if len(dosageChangeLogQueue) > 5:
dosageChangeLogQueue.pop(0)
dosageIncreaseCounter += 1
# medicineEventsList.append((idUser, 1, todayStr, lastDosageId+numberOfDosagesToIncrease,))
dosagesFrom5DaysBackQueue.append(
str(int(lastDosageValue) + numberOfDosagesToIncrease))
if len(dosagesFrom5DaysBackQueue) > 5:
dosagesFrom5DaysBackQueue.pop(0)
dosagesIdsFrom5DaysBackQueue.append(lastDosageId +
numberOfDosagesToIncrease)
if len(dosagesIdsFrom5DaysBackQueue) > 5:
dosagesIdsFrom5DaysBackQueue.pop(0)
WMedicines = W
if ifIsAnyDusting:
for _ in range(numberOfDosagesNeeded):
if numberOfFactorsUsedForRandomizationOfWMedicinesChange == 0:
# chance = 90
chance = 90
if numberOfFactorsUsedForRandomizationOfWMedicinesChange == 1:
# chance = 85
chance = 85
else:
# INFO: numberOfFactorsUsedForRandomizationOfWMedicinesChange == 2:
# chance = 55
chance = 55
if randrange(101) <= chance:
WMedicines += 2
else:
pass
elif numberOfDosagesToIncrease < 0 and lastDosageValue != "0":
# decrease
numberOfDosagesToDecrease = -numberOfDosagesToIncrease
maxDecreasePossible = 0 + int(lastDosageValue)
if maxDecreasePossible < numberOfDosagesToDecrease:
numberOfDosagesToDecrease = maxDecreasePossible
dosageChangeQueue.append("-" + str(numberOfDosagesToDecrease))
if len(dosageChangeQueue) > 5:
dosageChangeQueue.pop(0)
dosageChangeLogQueue.append("-" +
str(numberOfDosagesToDecrease))
if len(dosageChangeLogQueue) > 5:
dosageChangeLogQueue.pop(0)
dosageDecreaseCounter += 1
# medicineEventsList.append((idUser, 1, todayStr, lastDosageId-numberOfDosagesToDecrease,))
dosagesFrom5DaysBackQueue.append(
str(int(lastDosageValue) - numberOfDosagesToDecrease))
if len(dosagesFrom5DaysBackQueue) > 5:
dosagesFrom5DaysBackQueue.pop(0)
dosagesIdsFrom5DaysBackQueue.append(lastDosageId -
numberOfDosagesToDecrease)
if len(dosagesIdsFrom5DaysBackQueue) > 5:
dosagesIdsFrom5DaysBackQueue.pop(0)
WMedicines = W
if ifIsAnyDusting:
for _ in range(lastDosageId - numberOfDosagesToDecrease):
if numberOfFactorsUsedForRandomizationOfWMedicinesChange == 0:
# chance = 95
chance = 90
if numberOfFactorsUsedForRandomizationOfWMedicinesChange == 1:
# chance = 80
chance = 85
else:
# INFO: numberOfFactorsUsedForRandomizationOfWMedicinesChange == 2:
# chance = 60
chance = 55
if randrange(101) <= chance:
WMedicines += 2
else:
pass
else:
# don't change
# too low dose OR too high dose OR stable situation
dosageChangeQueue.append("0")
if len(dosageChangeQueue) > 5:
dosageChangeQueue.pop(0)
dosageChangeLogQueue.append("0")
if len(dosageChangeLogQueue) > 5:
dosageChangeLogQueue.pop(0)
# medicineEventsList.append((idUser, 1, todayStr, lastDosageId,))
dosagesFrom5DaysBackQueue.append(lastDosageValue)
if len(dosagesFrom5DaysBackQueue) > 5:
dosagesFrom5DaysBackQueue.pop(0)
dosagesIdsFrom5DaysBackQueue.append(lastDosageId)
if len(dosagesIdsFrom5DaysBackQueue) > 5:
dosagesIdsFrom5DaysBackQueue.pop(0)
WMedicines = W
if ifIsAnyDusting:
for _ in range(lastDosageId - 1):
if numberOfFactorsUsedForRandomizationOfWMedicinesChange == 0:
# chance = 95
chance = 90
if numberOfFactorsUsedForRandomizationOfWMedicinesChange == 1:
# chance = 80
chance = 85
else:
# INFO: numberOfFactorsUsedForRandomizationOfWMedicinesChange == 2:
# chance = 60
chance = 55
if randrange(101) <= chance:
WMedicines += 2
else:
pass
else:
# he is not taking medicines today
WMedicines = W
if lastDosageValue == "0":
dosageChangeQueue.append("0")
if len(dosageChangeQueue) > 5:
dosageChangeQueue.pop(0)
dosageChangeLogQueue.append("0")
if len(dosageChangeLogQueue) > 5:
dosageChangeLogQueue.pop(0)
else:
dosageChangeQueue.append("-" + str(lastDosageId - 1))
if len(dosageChangeQueue) > 5:
dosageChangeQueue.pop(0)
dosageChangeLogQueue.append("-" + str(lastDosageId - 1))
if len(dosageChangeLogQueue) > 5:
dosageChangeLogQueue.pop(0)
dosageDecreaseCounter += 1
dosagesFrom5DaysBackQueue.append("0")
if len(dosagesFrom5DaysBackQueue) > 5:
dosagesFrom5DaysBackQueue.pop(0)
dosagesIdsFrom5DaysBackQueue.append(1)
if len(dosagesIdsFrom5DaysBackQueue) > 5:
dosagesIdsFrom5DaysBackQueue.pop(0)
# LOG
# if len(dosagesFrom5DaysBackQueue) != 0:
# logTable.append(dosagesFrom5DaysBackQueue[len(dosagesFrom5DaysBackQueue)-1])
# Saving W and WMedicines to database
if W > 25:
W = 25
if W < 5:
W = 5
if WMedicines > 25:
WMedicines = 25
if WMedicines < 5:
WMedicines = 5
# controlTestList.append((idUser, todayStr, W, WMedicines,))
# adding avr W14
dailyDataLine[2] = countArithmeticAverage(last14AsthmaResultsQueue)
# adding avr W5
dailyDataLine[3] = countArithmeticAverage(
last14AsthmaResultsQueue[-5:])
# adding W-1
if len(last14AsthmaResultsQueue) > 0:
dailyDataLine[4] = last14AsthmaResultsQueue[-1]
else:
dailyDataLine[4] = 25
# adding W0
dailyDataLine[12] = W
# adding W to last14AsthmaResultsQueue
last14AsthmaResultsQueue.append(W)
if len(last14AsthmaResultsQueue) > 14:
last14AsthmaResultsQueue.pop(0)
# adding W0-avr W14
dailyDataLine[13] = dailyDataLine[2] - W
last14AsthmaResultsAfterDailyMedicinesQueue.append(WMedicines)
if len(last14AsthmaResultsAfterDailyMedicinesQueue) > 14:
last14AsthmaResultsAfterDailyMedicinesQueue.pop(0)
# LOG
# if W < 16:
# print("W poniżej 16!")
# if WMedicines < 16:
# print("WMedicines poniżej 16!")
'''
# Calculation of the trend
if arithmeticAverage == 0:
trend = "0"
else:
if WMedicines < arithmeticAverage - 1:
if WMedicines == 5:
trend = "0"
else:
trend = "-1"
elif WMedicines > arithmeticAverage + 1:
if WMedicines == 25:
trend = "0"
else:
trend = "+1"
else:
trend = "0"
# trendsList.append((idUser, todayStr, trend,))
# logTable.append(trend)
'''
if today >= winterStartDate2017:
appendLineToFile(dailyDataLine, fileName)
# print("U: %s Data: %s W:[%s,%s] Pylenie:%s Deszcz:%s Wiatr:%s Temp.:%s Zm. dawki: %s Zm.tend.: %s Dosage: %s Trend: %s" % (logTable[0], todayStr, W, WMedicines, logTable[1], logTable[2], logTable[3], logTable[4], logTable[5], logTable[6], logTable[7], logTable[8])) # LOG
today += timedelta(days=1)
# print("Saving history to database... " + str(idUser)) # LOG
# dbSave(controlTestList, medicineEventsList, trendsList)
db.close()
def __init__(self, debug=False):
self.debug = debug
self.clients = {}
self.db = dbConnection()
self.whiteboards = WhiteboardFiles()
import json
import traceback
from database import dbConnection
mysql = dbConnection()
def getAllUsers():
cur = mysql.cursor()
cur.execute("SELECT * FROM users")
rows = cur.fetchall()
cur.close()
return rows
def truncateTableNamed(tableName):
cursor = mysql.cursor()
cursor.execute("TRUNCATE " + tableName)
mysql.commit()
cursor.close()
def printTableNamed(db, tableName):
cursor = mysql.cursor()
cursor.execute("SELECT * FROM " + tableName)
rows = ""
for x in cursor:
rows += str(x) + "\n"
print(rows)
def __init__(self, debug = False):
self.debug = debug
self.clients = {}
self.db = dbConnection()
self.whiteboards = WhiteboardFiles()