def get_boards_data(user_id):
data = dict()
data["statuses"] = connection_manager.execute_select('''
SELECT * FROM statuses ORDER BY statuses.id;
''')
data["boards"] = connection_manager.execute_select(
'''
SELECT boards.id, boards.title
FROM boards
WHERE deleted = FALSE AND user_id = %(user_id)s
ORDER BY boards.id;
''', {'user_id': user_id})
data["cards"] = connection_manager.execute_select(
'''
SELECT cards.id, cards.board_id, cards.status_id, cards.title, cards."order"
FROM cards
WHERE deleted = FALSE AND user_id = %(user_id)s
ORDER BY cards."order";
''', {'user_id': user_id})
return data
def get_user_by_name(username):
return connection_manager.execute_select(
'SELECT id FROM users WHERE username = %(username)s;',
{'username': username})
def get_activated(username):
return connection_manager.execute_select(
'''
SELECT activated FROM users WHERE username=%(username)s;
''', {'username': username})
def get_email_ids_by_email(email):
return connection_manager.execute_select(
'SELECT id FROM users WHERE email = %(email)s;', {'email': email})