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