def get(self): cursor.execute("SELECT * FROM badges") results = cursor.fetchall() return jsonify(results)
def get(self): cursor.execute( "SELECT q.* , c.title as category, jsonb_agg(t) as tags , username FROM questions q LEFT JOIN question_tags qt ON q.id = qt.question_id LEFT JOIN tags t ON qt.tag_id = t.id LEFT JOIN categories c ON q.category_id = c.id LEFT JOIN users u ON q.user_id = u.id GROUP BY q.id, c.title, username" ) question_list = cursor.fetchall() return jsonify(question_list)
def get(self, id): cursor.execute( "SELECT q.*, username, c.title FROM questions q JOIN users u ON q.user_id = u.id JOIN categories c ON q.category_id = c.id WHERE q.id = %s", (id, )) question_list = cursor.fetchall() return jsonify(question_list)
def get(self, id): cursor.execute("SELECT * FROM pages WHERE id = %s", (id, )) results = cursor.fetchall() return jsonify(results)