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]