在 Flask 中获取特定的帖子类别

Question

如果我的类别 == 学术（SelectField 选择），我必须得到职位。但它不起作用（不显示帖子）。如何为此获取发布数据或表单数据？

我试过了

@categories.route("/category/academic")

def academic():

    page = request.args.get('page', 1, type=int)

    posts = Post.query.order_by(

        Post.date_posted.desc()).filter(

        Post.category == "Academic").paginate(page=page, per_page=5)

    return render_template('academic.html', posts=posts)

和

@categories.route("/category/academic")

def academic():

    form = PostForm()

    page = request.args.get('page', 1, type=int)

    post = Post(title=form.title.data,

                content=form.content.data,

                category=form.category.data)

    posts = Post.query.order_by(

        Post.date_posted.desc()).order_by(

        post.category == "Academic").paginate(page=page, per_page=5)

    return render_template('academic.html', posts=posts)

和

@categories.route("/category/academic")

def academic():

    page = request.args.get('page', 1, type=int)

    posts = Post.query.order_by(

        Post.date_posted.desc()).filter(

        **PostForm**.category == "Academic").paginate(page=page, per_page=5)

    return render_template('academic.html', posts=posts)

后分类

class Post(db.Model):

    id = db.Column(db.Integer, primary_key=True)

    title = db.Column(db.String(100), nullable=False)

    date_posted = db.Column(db.DateTime, nullable=False,

                            default=datetime.utcnow)

    content = db.Column(db.Text, nullable=False)

    category = db.Column(db.String(50))

    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

PostForm.category

class PostForm(FlaskForm):

    title = StringField('Title', validators=[DataRequired()])

    content = TextAreaField('Content', validators=[DataRequired()])

    category = SelectField('Category', validators=[DataRequired()], choices=[(

        'Academic', 'Academic'), ('Art', 'Art')])

    submit = SubmitField('Post')

不起作用，因为帖子未显示。