def check_email(email, username):
emailsername = database.select(USERINFO, what='username', where="email=$email", vars={'email': email})
if len(emailsername) == 0:
return False
elif username != emailsername[0].username:
return False
return True
def check_user_info(username, password):
userpassword = database.select(USERINFO,
what='password',
where='username=$username',
vars={'username': username})[0].password
if userpassword == password:
return True
return False
def update_password(username):
database.update(USERINFO, where='username=$username', password='******' % random.randint(1000, 10000),
vars={'username': username})
return database.select(USERINFO, what='password', where="username=$username", vars={'username': username})[
0].password
def check_user_is_duplicate(username):
usernames = database.select(USERINFO, what='username', where="username=$username", vars={'username': username})
if len(usernames) != 0:
return False
return True
def get_todolist_with_limit(limit, offset):
todolist = database.select(DATABASE, what='id,title,finished', order='finished,id DESC', limit=limit, offset=offset)
return todolist
def get_todolist():
todolist = database.select(DATABASE, what='id,title,finished', order='finished,id DESC', limit=10, offset=0)
return todolist
def get_by_id(id):
value = database.select(DATABASE, what='id,title', where='id=$id', vars={'id': id})
if not value:
return False
return value[0]
