Esempio n. 1
0
    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()
Esempio n. 2
0
    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)
Esempio n. 3
0
 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']
Esempio n. 4
0
 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