def searchOnebyId(self, searchId): grade = Grade('',self.user_id,'','','') database = sql.DataBase() result = database.selectOne('users_grades', grade.getKeys(), 'quiz_id='+str(searchId)+' AND user_id='+str(self.user_id)) if result == None: result = [] return result
def searchOnebyId(self, searchId): quiz = Quiz('', self.user_id, '', '', '', '', '') database = sql.DataBase() result = database.selectOne( 'quizzes', quiz.quizKeys(), 'id=' + str(searchId) + ' AND user_id=' + str(self.user_id)) if result == None: result = [] return result
def searchOnebyName(self, searchStr): quiz = Quiz('', self.user_id, '', '', '', '', '') database = sql.DataBase() result = database.selectOne( 'quizzes', quiz.quizKeys(), 'name LIKE "%' + searchStr + '%" ORDER BY user_id=' + str(self.user_id) + ' DESC') if result == None: result = [] return result
def update(self): database = sql.DataBase() quizId = self.id if type(self.data) == list: self.data = json.dumps(self.data) data = self.__dict__ data.pop('id') updateStr = ', '.join([ '{0}=\'{1}\''.format(key, value) for (key, value) in data.items() ]) self.id = database.update('quizzes', updateStr, 'id=' + str(quizId)) return True
def login(self): database = sql.DataBase() self.password = self.encryptPass(self.password) result = database.selectOne( 'users', 'id,name,email,password', 'email="' + self.email + '" AND password="******"') try: if result[2] == self.email: self.id = result[0] self.name = result[1] return True except: return False
def searchAll(self): grade = Grade('',self.user_id,'','','') database = sql.DataBase() result = database.select('users_grades', grade.getKeys(), 'user_id='+str(self.user_id)) if result == None: grades = [] else: grades = [] for item in result: grade = Grade(item[0], item[1], item[2], item[3], item[4]) grades.append(grade) return grades
def searchAll(self): quiz = Quiz('', self.user_id, '', '', '', '', '') database = sql.DataBase() result = database.select('quizzes', quiz.quizKeys(), 'user_id=' + str(self.user_id)) if result == None: quizzes = [] else: quizzes = [] for item in result: quiz = Quiz(item[0], item[1], item[2], item[3], item[4], item[5], item[6]) quizzes.append(quiz) return quizzes
def register(self): database = sql.DataBase() self.password = self.encryptPass(self.password) self.id = database.insert('users', self.__dict__) return True
def getUserName(self): database = sql.DataBase() result = database.selectOne('users', 'name', 'id=' + str(self.user_id)) return result[0]
def updateQuestions(self): database = sql.DataBase() database.update('quizzes', 'data=\'' + json.dumps(self.data) + '\'', 'id=' + str(self.id)) return True
def register(self): database = sql.DataBase() self.id = database.insert('quizzes', self.__dict__) return True