def get_user_from_uid(uid):
fields = [
'id', 'username', 'phone', 'role', 'cn_name', 'position', 'password',
'email'
]
sql = '''SELECT %s FROM users WHERE id = '%s';''' % (','.join(fields), uid)
print sql
values = select_result(sql)
return dict(zip(fields, values))
def get_role_from_username(username):
sql = '''SELECT role FROM users WHERE username = '******';''' % username
return select_result(sql)
def get_passwd_from_username(username):
sql = '''SELECT password FROM users WHERE username = '******';''' % username
return select_result(sql)
def get_role_from_username(username):
sql = '''SELECT role, cn_name FROM users WHERE username = '******';''' % username
app.logger.debug(select_result(sql))
return select_result(sql)
def get_uid_from_username(username):
sql = '''SELECT id FROM users WHERE username = '******';''' % username
uid = select_result(sql)
if uid:
return uid[0], True
return None, False
def validate_uid_exists(uid):
sql = '''SELECT * FROM users WHERE id = '%s';''' % uid
num = select_result(sql)
if not num:
return None, False
return 'username:%s already exists.' % uid, True
def validate_user_exists(username):
sql = '''SELECT * FROM users WHERE username = '******';''' % username
num = select_result(sql)
if not num:
return None, False
return 'username:%s already exists.' % username, True
def get_users_count():
sql = '''SELECT count(*) FROM users; '''
return select_result(sql)
def get_assets_count():
sql = '''SELECT count(*) FROM assets; '''
return select_result(sql)