from flask import Flask, render_template, flash, redirect
from flask_sqlalchemy import SQLAlchemy # sudo apt-get install flask_sqlaclhemy
from flask_wtf import FlaskForm
from wtforms.ext.sqlalchemy.orm import model_form

app = Flask(__name__)
db = SQLAlchemy(app)
app.secret_key="ra9ialohpherai5sie8phei2gier7E"

class Comment(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	text = db.Column(db.String, nullable=False)
	name = db.Column(db.String, nullable=False)

CommentForm = model_form(model=Comment, base_class=FlaskForm, db_session=db.session)

@app.before_first_request
def comments():
	db.create_all()

	comment = Comment(text="a comment", name="commenter")
	db.session.add(comment)

	comment = Comment(text="a comment2", name="commenter2")
	db.session.add(comment)

	comment = Comment(text="thing", name="Erkki Esimerkki")
	db.session.add(comment)

	db.session.commit()

@app.route("/new", methods=["GET", "POST"])
def lomake():
    form = CommentForm()
    return render_template("new.html", form=form)

@app.route("/")
def index():
	comments = Comment.query.all()
	return render_template("message.html", comments=comments)

@app.route("/msg")
def msgPage():
	flash("tst msg")
	return redirect("/")

if __name__ == "__main__":
	app.run()