Advertisement
Guest User

Untitled

a guest
Apr 8th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. import random
  2. from flask import Flask, request, session, redirect, url_for, render_template, flash
  3. from flask.ext.sqlalchemy import SQLAlchemy
  4. from werkzeug.routing import RequestRedirect
  5.  
  6. app = Flask(__name__)
  7. app.config["DEBUG"] = True
  8.  
  9. SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://{username}:{password}@{hostname}/{databasename}".format(
  10. username="majaokholm",
  11. password="oppåFarshat@68",
  12. hostname="majaokholm.mysql.pythonanywhere-services.com",
  13. databasename="majaokholm$majaokholm",
  14. )
  15. app.config["SQLALCHEMY_DATABASE_URI"] = SQLALCHEMY_DATABASE_URI
  16. app.config["SQLALCHEMY_POOL_RECYCLE"] = 299
  17.  
  18. db = SQLAlchemy(app)
  19.  
  20. class Comment(db.Model):
  21.  
  22. __tablename__ = "comments"
  23.  
  24. id = db.Column(db.Integer, primary_key=True)
  25. content = db.Column(db.String(4096))
  26.  
  27. @app.route("/")
  28. def index():
  29. return render_template("index_page.html")
  30.  
  31. @app.route('/post', methods=["GET", "POST"])
  32. def post():
  33. if request.method == "GET":
  34. return render_template("post_page.html", comments=Comment.query.all())
  35. comment = Comment(content=request.form["contents"])
  36. db.session.add(comment)
  37. db.session.commit()
  38. return redirect(url_for('post'))
  39.  
  40. <form action="." method="POST">
  41. <textarea class="form-control" name="contents" placeholder="Enter a
  42. comment"></textarea>
  43. <input type="submit" value="Post comment">
  44. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement