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)
