from flask import Flask, render_template, flash, redirect
from flask_sqlalchemy import SQLAlchemy
from flask_wtf import FlaskForm
from wtforms.ext.sqlalchemy.orm import model_form # m

app = Flask(__name__)
db = SQLAlchemy(app) # m
app.secret_key="ra9ialoH3peNisai5sie8phei2gier7E"

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) # m

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

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

        db.session.commit()

@app.route("/new", methods=["GET", "POST"])
def lomake():
        form = CommentForm()
        if form.validate_on_submit(): # m
                comment = Comment() # m
                form.populate_obj(comment) # m
                db.session.add(comment) # m
                db.session.commit()
                flash("Added")
                return redirect("/")

        return render_template("new.html", form=form)

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

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