Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import random
- from flask import Flask, request, session, redirect, url_for, render_template, flash
- from flask.ext.sqlalchemy import SQLAlchemy
- from werkzeug.routing import RequestRedirect
- app = Flask(__name__)
- app.config["DEBUG"] = True
- SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://{username}:{password}@{hostname}/{databasename}".format(
- username="majaokholm",
- password="oppåFarshat@68",
- hostname="majaokholm.mysql.pythonanywhere-services.com",
- databasename="majaokholm$majaokholm",
- )
- app.config["SQLALCHEMY_DATABASE_URI"] = SQLALCHEMY_DATABASE_URI
- app.config["SQLALCHEMY_POOL_RECYCLE"] = 299
- db = SQLAlchemy(app)
- class Comment(db.Model):
- __tablename__ = "comments"
- id = db.Column(db.Integer, primary_key=True)
- content = db.Column(db.String(4096))
- @app.route("/")
- def index():
- return render_template("index_page.html")
- @app.route('/post', methods=["GET", "POST"])
- def post():
- if request.method == "GET":
- return render_template("post_page.html", comments=Comment.query.all())
- comment = Comment(content=request.form["contents"])
- db.session.add(comment)
- db.session.commit()
- return redirect(url_for('post'))
- <form action="." method="POST">
- <textarea class="form-control" name="contents" placeholder="Enter a
- comment"></textarea>
- <input type="submit" value="Post comment">
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement