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})