from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///./Article2.db'
db = SQLAlchemy(app)
article_tag = db.Table('article_tag',
db.Column('article_id',db.Integer,db.ForeignKey('article.id'),primary_key=True),
db.Column('tag_id',db.Integer,db.ForeignKey('tag.id'),primary_key=True)
)
class Article(db.Model):
__tablename__ = 'article'
id = db.Column(db.Integer,primary_key = True,autoincrement= True)
title = db.Column(db.String(100),nullable = False)
#让Article和Tag产生关联
#因为Article和Tag表中间还有一个article_tag表,所以添加secondary
#假如拿到了一个标签Tag,怎么拿到标签下的所有文章呢.反向引用Article这时用backref
tags = db.relationship('Tag',secondary= article_tag,backref = db.backref('articles'))
class Tag(db.Model):
__tablename__ = 'tag'
id = db.Column(db.Integer,primary_key = True,autoincrement= True)
name = db.Column(db.String(100),nullable = True)
db.create_all()
#tag和article_tag共同组成主键
@app.route('/')
def function():
article1 = Article(title = 'aaa')
article2 = Article(title = 'bbb')
tag1 = Tag(name = '111')
tag2 = Tag(name = '222')
#实现多对多关系,一个article有两个标签
# article1.tags.append(tag1)
# article1.tags.append(tag2)
# article2.tags.append(tag1)
# article2.tags.append(tag2)
db.session.add(article1)
db.session.add(article2)
db.session.add(tag1)
db.session.add(tag2)
db.session.commit()
article1 = Article.query.filter(Article.title == 'aaa').first()
tags = article1.tags
for tag in tags:
print(tag.name)
return 'index'
if __name__ == '__main__':
app.run()
Flask-sqlalchemy多对多关系
最新推荐文章于 2023-05-04 17:12:17 发布