def get_questions_answers(user_id): args = {'questioner_id': user_id} query = "SELECT * FROM questions q LEFT JOIN answers a ON a.question_id = q.id WHERE q.questioner_id = %(questioner_id)s" res = connection.select_query(query, args) return res
def check_user(email): args = {'email':email} query = "SELECT id FROM users WHERE email = %(email)s" res = connection.select_query(query, args) return res if res else None
def get_user_id(username): """Convenience method to look up the id for a username.""" args = {'name' : username} query = "SELECT id FROM users WHERE name = %(name)s" rv = connection.select_query(query, args) return rv if rv else None
def get_user(username): args = {'name' : username} query = "SELECT * FROM users WHERE name = %(name)s" user = connection.select_query(query, args) return user if user else None