def rname(username): ret = 0 sql = '''select username from users; ''' # print sql usernames = select_all_result(sql) # print usernames for x in range(len(usernames)): if "".join(tuple(usernames[x])) == username['username']: ret = 1 if ret == 1: return False else: return True
def get_user(name): sql = '''SELECT * FROM users WHERE username = '******';''' % name return select_all_result(sql)
def get_users(): sql = '''SELECT * FROM users ''' return select_all_result(sql)
def get_user(name): sql = '''SELECT id,username,password,email FROM users WHERE username = '******';''' % name return select_all_result(sql)
def get_users(): sql = '''SELECT id,username,password,email FROM users ''' return select_all_result(sql)
def get_user_id(uid): sql = '''SELECT * FROM users WHERE id = '%d';''' % uid return select_all_result(sql)