外键
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
def __init__(self, name):
self.name = name
class Article(db.Model):
__tablename__ = 'articles'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(50), nullable=False)
content = db.Column(db.Text, nullable=False)
author_id = db.Column(db.Integer, db.ForeignKey('users.id'))
author = db.relationship('User', backref=db.backref('articles'))
def __init__(self, title, content):
self.title = title
self.content = content
多对多
Article_tag = db.Table(
'article_tag',
db.Column('article_id', db.Integer, db.ForeignKey('articles.id'), primary_key=True),
db.Column('tag_id', db.Integer, db.ForeignKey('tags.id'), primary_key=True)
)
class Article(db.Model):
__tablename__ = 'articles'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(20), nullable=False)
content = db.Column(db.Text, nullable=False)
tags = db.relationship(
'Tag',
secondary=Article_tag,
backref=db.backref('tags', lazy='dynamic'),
lazy='dynamic'
)
def __init__(self, title, content):
self.title = title
self.content = content
class Tag(db.Model):
__tablename__ = 'tags'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(20), nullable=False)
articles = db.relationship(
'Article',
secondary=Article_tag,
backref=db.backref('articles', lazy='dynamic'),
lazy='dynamic'
)
def __init__(self, name):
self.name = name