def like(post_id):
like_number_temp = session_db.query(Posts).filter(Posts.id == post_id).first().likes_number
session_db.query(Posts).filter_by(id = post_id).update({'likes_number' : like_number_temp+1})
session_db.commit()
return jsonify({
'likes_number' : session_db.query(Posts).filter(Posts.id == post_id).first().likes_number
})
def login():
if (request.method == 'GET'):
return render_template("login.html")
else:
if (session_db.query(Users).filter(Users.login == request.form['login'] and Users.password == sha256(request.form['password'])).first()):
session['logged_in'] = True
if (session_db.query(Users).filter(Users.login == request.form['login'] and Users.isadmin == True).first()):
return redirect('/page_admin')
else:
flash("You're not an admin, redirecting to the posts page")
return redirect("/")
else:
flash("Wrong login, check the credentials")
return redirect('/login')
def return_comment_list(post_id):
comment_list = list(
session_db.query(Comments).filter(Comments.post_id == post_id))
return comment_list
def return_particular_post(post_id):
return session_db.query(Posts).filter(Posts.id == post_id).first()
def return_post_list():
return session_db.query(Posts).order_by(Posts.id.desc())