app.py

from flask import render_template, request, redirect
from constants import app, db



class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(300), nullable=False)
    text = db.Column(db.Text, nullable=False)


@app.route('/index')
@app.route('/')
def index():
    return render_template('index.html')

@app.route('/posts')
def posts():
    posts = Post.query.all()
    return render_template('/posts.html', posts=posts)


@app.route('/create', methods = ['POST', 'GET'])
def create():
    if request.method == 'POST':
        title = request.form['title']
        text = request.form['text']

        post = Post(title = title, text = text )
        try:
            db.session.add(post)
            db.session.commit()
            return redirect('/')
        except:
            return 'при добавлении статьи возникла ошибка'
    else:
        return render_template('create.html')


if __name__ == '__main__':
    app.run(debug=True)