def post(self):
body = request.get_json()
title = body["title"]
try:
cursor.execute("INSERT INTO categories (title) VALUES(%s)",
(title, ))
conn.commit()
return {"body": body}, 200
except:
conn.rollback()
print("already exists..")
abort(403, error_message='This already exists')
return last_id
def post(self):
body = request.get_json()
username = body["username"]
password = hash_password(body["password"])
email = body["email"]
cursor.execute(
"INSERT INTO users (username, user_password, email, user_point, badge_id) VALUES(%s, %s, %s, %s, %s)",
(username, password, email, 1000, 1))
conn.commit()
return {
"username": username,
"password": password,
"email": email
}, 200
def get(self, id):
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 WHERE q.id = %s GROUP BY q.id, c.title, username",
(id, ))
question = cursor.fetchone()
# result = {}
# result["id"] = question[0]
# result["user_id"] = question[1]
# result["category_id"] = question[2]
# result["question_title"] = question[3]
# result["question_content"] = question[4]
# result["is_solved"] = question[5]
# result["created_at"] = question[6]
# result["updated_at"] = question[7]
# result["category_name"] = question[8]
# result["username"] = question[9]
return jsonify(question)
def post(self):
body = request.get_json()
username = body["username"]
givenpassword = body["password"]
cursor.execute("SELECT * FROM users WHERE username = %s", (username, ))
user = cursor.fetchone()
user_obj = {
'id': user['id'],
'role': 'admin' if user['is_admin'] else 'normal'
}
authorized = check_password(user["user_password"], givenpassword)
print(user_obj)
if not authorized:
return {'error': 'Email or password invalid'}, 401
expires = datetime.timedelta(days=7)
access_token = create_access_token(identity=user_obj,
expires_delta=expires)
return {
'token': access_token,
'username': user["username"],
}, 200
def get(self):
cursor.execute("SELECT * FROM badges")
results = cursor.fetchall()
return jsonify(results)
def delete(self, id):
cursor.execute("DELETE FROM badges WHERE id = %s", (id, ))
return '', 204
def post(self):
body = request.get_json()
title = body["title"]
cursor.execute("INSERT INTO badges (title) VALUES(%s)", (title, ))
conn.commit()
return {"body": body}, 200
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):
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 * FROM pages WHERE id = %s", (id, ))
results = cursor.fetchall()
return jsonify(results)
