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
