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)