整形 Integer
uid = db.Column(db.Integer, primary_key=True, autoincrement=True, comment="用户ID")
vip_time = db.Column(db.Integer, nullable=False, default=0, comment="会员有效期")
status = db.Column(db.Integer, nullable=False, default=0, comment="订单状态 0 待支付 1已支付 2 已取消")
字符串 String
username = db.Column(db.String(32), nullable=False, unique=True, default="", comment="用户名")
时间 DateTime
birthday = db.Column(db.DateTime, default='')
birthday = db.Column(db.DateTime, default=datetime.now)
login_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
布尔 Boolean
status = db.Column(db.Boolean, nullable=False, default=True, comment="是否可用")
大浮点 DECIMAL
rice = db.Column(db.DECIMAL(12, 2), nullable=False, default=0, comment="价格")
大文本 Text
intro = db.Column(db.Text, nullable=False, default="", comment="图书简介")
一对多
一方(CategoryModel)
book = db.relationship("BookModel", backref="cate")
多方(BookModel)
category_id = db.Column(db.Integer, db.ForeignKey("category_model.cid"))
# backref的值是给"多方"用来查询"一方"的
一对多关系的查询:
从一查多:
cate_info = CategoryModel.query.get(1) <对象>
book_all = cate_info.book 不需要.all()
从多查一:
book_info = BookModel.query.get(2) <对象>
cate_one = book_info.cate