flask增删改查

一对多创表

class User(db.Model):
    uid=db.Column(db.Integer,primary_key=True,autoincrement=True,comment='用户ID')
    mobile=db.Column(db.String(11),comment='手机号')
    password=db.Column(db.String(125),comment='密码')
    username=db.Column(db.String(156),comment='用户名')
    add=db.relationship('Address',backref='address')


#----------------------------------------------------------------------------#
class Address(db.Model):
    aid = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='用户ID')
    add=db.Column(db.String(256),comment='地址')
    add_new=db.Column(db.String(256),comment='详细地址')
    name=db.Column(db.String(256),comment='名字')
    mobile=db.Column(db.String(11),comment='电话')
    add_id=db.Column(db.Integer,db.ForeignKey('user.uid'))

多对多创表

user_channel=db.Table(
    'user_channel',
    db.Column('user_id'