flask数据库查询之反向引用

反向引用

模型字段名

class Brand(BaseModel,db.Model):
    __tablename__ = 'brand'
    # id=db.Column(db.Integer,primary_key=True)
    brand_name=db.Column(db.String(20))
    brand_style=db.Column(db.String(30))
    brand_style_detail=db.Column(db.String(50))
    cars=db.relationship('Car',backref='brand')
    def __repr__(self):
        return self.brand_name

class Car(BaseModel,db.Model):
    __tablename__='sc_cars'
    # id=db.Column(db.Integer,primary_key=True)
    user_id=db.Column(db.Integer,db.ForeignKey('sc_users.id'))
    brand_id=db.Column(db.Integer,db.ForeignKey('brand.id'))
    price= db.Column(db.Integer,default=0,nullable=False)
    car_age=db.Column(db.Integer) #age of the car
    car_style=db.Column(db.String(10))#style of the car
    car_gearbox=db.Column(db.Integer,defau