class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    nickname = db.Column(db.String(100), index=True, unique=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password = db.Column(db.String(100), index=True, unique=True)
    role = db.Column(db.SmallInteger, default=ROLE_USER)
    posts = db.relationship('Entry', backref='author', lazy='dynamic')
    about_me = db.Column(db.String(140))
    last_seen = db.Column(db.DateTime)
    pwdhash = db.Column(db.String(100))

сlass Entry(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80))
    text = db.Column(db.Text)
    pub_date = db.Column(db.DateTime)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

@app.route('/user/<nickname>', methods=['GET', 'POST'])
@login_required
def user(nickname):
    title = 'Ваша страница'
    user = User.query.filter_by(nickname=nickname).first_or_404()
    if user == None:
        flash('Пользователь ' + nickname + ' не найден.')
        return redirect(url_for('index'))
    post = user.posts.order_by(Entry.pub_date.desc()).all()
    return render_template('user.html', title=title, user=user, post=post)

{% for post in posts %}
                <p>{{ entry.title }}</p>
                <pre>{{ entry.text }}</pre>
                <p>{{ entry.pub_date }}</p>
            {% endfor %}

<p>{{ entry.title }}</p>
<pre>{{ entry.text }}</pre>
<p>{{ entry.pub_date }}</p>

@app.route('/user/<nickname>', methods=['GET', 'POST'])
@login_required
def user(nickname):
    title = 'Ваша страница'
    user = User.query.filter_by(nickname=nickname).first_or_404()
    if user == None:
        flash('Пользователь ' + nickname + ' не найден.')
        return redirect(url_for('index'))
    posts = user.posts.order_by(Entry.pub_date.desc()).all()
    return render_template('user.html', title=title, user=user, posts=posts)



{% for post in posts %}
    <p>{{ post.title }}</p>
    <pre>{{ post.text }}</pre>
    <p>{{ post.pub_date }}</p>
{% endfor %}