def __init__(self):
dbDir = "ProgramDataFiles\\foodDB.db"
if os.path.isfile(dbDir):
self.conn = sqlite3.connect(dbDir)
else:
self.conn = sqlite3.connect(dbDir.replace('\\', '/'))
self.c = self.conn.cursor()
foodItemsFile = "ProgramDataFiles\\foodItemsJSON.txt"
foodItemsJSON = FileUtilitiy.readLinesToJSON(foodItemsFile)
self.c.execute("select name from sqlite_master where type='table'")
# print self.c.fetchall()
self.dbName = "foodItems"
sqlStr = "DROP TABLE " + self.dbName
self.c.execute(sqlStr)
sqlStr = "CREATE TABLE " + self.dbName + " "
sqlStr += "(id, name, hasPoultry, hasGluten, calories, buyFrom, mealType, hasFish)"
self.c.execute(sqlStr)
for food in foodItemsJSON:
sqlStr = "INSERT INTO " + self.dbName + " VALUES "
sqlStr += "('" + str(food['id']) + "', '" + str(food['name']) + "', '" + str(food['hasPoultry'])
sqlStr += "', '" + str(food['hasGluten']) + "', '" + str(food['calories'])
sqlStr += "', '" + str(food['buyFrom']) + "', '" + str(food['mealType'])
sqlStr += "', '" + str(food['hasFish']) + "')"
self.c.execute(sqlStr)
self.conn.commit()
def updateUserFSMVariables(self):
fileName = "ProgramDataFiles\\" + str(self.userNumber) + "_" + self.userName + "\\" + str(self.userNumber) + "_" + self.userName +"_Vars.txt"
jsonVars = FileUtilitiy.readLinesToJSON(fileName)
jsonVars = jsonVars[-1]
print jsonVars
jsonVars['exerciseSets'] = self.exerciseSets
jsonRow = json.dumps(jsonVars)
print jsonRow
FileUtilitiy.writeTextLine(fileName, jsonRow)
def getUserFSMVariables(self):
fileName = "ProgramDataFiles\\" + str(self.userNumber) + "_" + self.userName + "\\" + str(self.userNumber) + "_" + self.userName +"_Vars.txt"
print fileName
jsonVars = FileUtilitiy.readLinesToJSON(fileName)
jsonVars = jsonVars[-1]
print jsonVars
self.weatherIsNice = jsonVars['weatherIsNice']
self.canEatPoultry = jsonVars['canEatPoultry']
self.canEatGluten = jsonVars['canEatGluten']
self.canEatFish = jsonVars['canEatFish']
self.exerciseSets = jsonVars['exerciseSets']
self.exerciseSuggested = jsonVars['exerciseSuggested']
self.meal1Suggested = jsonVars['meal1Suggested']
self.meal2Suggested = jsonVars['meal2Suggested']
self.meal3Suggested = jsonVars['meal3Suggested']
def getUserFSMVars(self):
fileName = "ProgramDataFiles\\" + str(self.userNumber) + "_" + self.userName + "\\" + str(self.userNumber) + "_" + self.userName +"_Vars.txt"
if FileUtilitiy.checkFileExists(fileName):
jsonVars = FileUtilitiy.readLinesToJSON(fileName)
jsonVars = jsonVars[-1]
print "Loaded old VARS"
print jsonVars
print
self.canEatPoultry = jsonVars['canEatPoultry']
self.canEatGluten = jsonVars['canEatGluten']
self.canEatFish = jsonVars['canEatFish']
self.hasTalkedJapan = jsonVars['hasTalkedJapan']
self.hasTalkedParis = jsonVars['hasTalkedParis']
self.exerciseSets = jsonVars['exerciseSets']
else:
# keep own files
print "Didn't need to grab VARS"
pass
