def contains(user_id):
DB.exec_command(f'SELECT * FROM addresses WHERE UserId={user_id}',
False)
return cur.fetchone()
def get(user_id):
DB.exec_command(f'SELECT GroupName FROM groups WHERE UserId={user_id}', False)
return cur.fetchone()
def get_hint_shown(user_id):
DB.exec_command(f'SELECT HintShown FROM portal WHERE UserId={user_id}',
False)
return cur.fetchone()
def set_hint_shown(user_id):
DB.exec_command(
f'UPDATE portal SET HintShown=1 WHERE UserId={user_id}')
return cur.fetchone()
def get(user_id):
DB.exec_command(
f'SELECT Login, Password FROM portal WHERE UserId={user_id}',
False)
return cur.fetchone()