From 0fa1a1c363aaf934a9ce80ee8b255cf8b840901e Mon Sep 17 00:00:00 2001 From: Cédric Bonhomme Date: Fri, 21 Apr 2017 23:09:42 +0200 Subject: We will finally have a table for tags of articles and tags of bookmarks. --- src/web/models/tag.py | 18 ++++++++---------- 1 file changed, 8 insertions(+), 10 deletions(-) (limited to 'src/web/models/tag.py') diff --git a/src/web/models/tag.py b/src/web/models/tag.py index c23d15ea..70430fa6 100644 --- a/src/web/models/tag.py +++ b/src/web/models/tag.py @@ -6,6 +6,7 @@ from bootstrap import db class ArticleTag(db.Model): text = db.Column(db.String, primary_key=True, unique=False) + # user_id = db.Column(db.Integer(), db.ForeignKey('user.id')) # foreign keys article_id = db.Column(db.Integer, db.ForeignKey('article.id', ondelete='CASCADE'), @@ -13,26 +14,23 @@ class ArticleTag(db.Model): # relationships article = db.relationship('Article', back_populates='tag_objs', - foreign_keys=[article_id]) + foreign_keys=[article_id]) def __init__(self, text): self.text = text class BookmarkTag(db.Model): - __tablename__ = 'BookmarkTag' - #id = db.Column(db.Integer, primary_key=True) - text = db.Column(db.String, primary_key=True) + text = db.Column(db.String, primary_key=True, unique=False) + # user_id = db.Column(db.Integer(), db.ForeignKey('user.id')) # foreign keys - # bookmark_id = db.Column(db.Integer, db.ForeignKey('bookmark.id', ondelete='CASCADE'), - # primary_key=True) + bookmark_id = db.Column(db.Integer, db.ForeignKey('bookmark.id', ondelete='CASCADE'), + primary_key=True) # relationships - # bookmark = db.relationship('Bookmark', back_populates='tag_objs', - # single_parent=True, - # cascade="all, delete-orphan", - # foreign_keys=[bookmark_id]) + bookmark = db.relationship('Bookmark', back_populates='tag_objs', + foreign_keys=[bookmark_id]) def __init__(self, text): self.text = text -- cgit