使用Flask实现帖子的建模

Flask实现的功能：

• post模型的建立
• post表单的建立

post模型的建立:

from app.extensions import db
from datetime import datetime


class Posts(db.Model):
    __tablename__ = 'posts'
    id = db.Column(db.Integer, primary_key=True)
    rid = db.Column(db.Integer, default=0)
    content = db.Column(db.Text)
    timestamp = db.Column(db.DateTime, default=datetime.utcnow)
    # 添加外键关联，'表名.字段'
    uid = db.Column(db.Integer, db.ForeignKey('users.id'))

__init__.py:
添加关联表collections

from app.extensions import db
from .user import User
from .posts import Posts


# 用户收藏帖子的中间关联表，不需手动维护
collections = db.Table('collections',
    db.Column('user_id', db.Integer, db.ForeignKey('users.id')),
    db.Column('posts_id', db.Integer, db.ForeignKey('posts.id'))
)

post表单的建立:

from flask_wtf