diff options
author | Cédric Bonhomme <cedric@cedricbonhomme.org> | 2017-05-23 15:37:50 +0200 |
---|---|---|
committer | Cédric Bonhomme <cedric@cedricbonhomme.org> | 2017-05-23 15:37:50 +0200 |
commit | a756a3e9da58df6247e3437be4c13da25dab1aa0 (patch) | |
tree | 60281271606a5cc6b718d65d998c2d97b3fa4c50 /src/web/models/tag.py | |
parent | Added UTF-8 version of the logo. (diff) | |
parent | Update tags of bookmarks. (diff) | |
download | newspipe-a756a3e9da58df6247e3437be4c13da25dab1aa0.tar.gz newspipe-a756a3e9da58df6247e3437be4c13da25dab1aa0.tar.bz2 newspipe-a756a3e9da58df6247e3437be4c13da25dab1aa0.zip |
Fixed conflicts.
Diffstat (limited to 'src/web/models/tag.py')
-rw-r--r-- | src/web/models/tag.py | 31 |
1 files changed, 23 insertions, 8 deletions
diff --git a/src/web/models/tag.py b/src/web/models/tag.py index 8d7fe4d4..ab901cda 100644 --- a/src/web/models/tag.py +++ b/src/web/models/tag.py @@ -1,22 +1,37 @@ #! /usr/bin/env python # -*- coding: utf-8 -*- -from sqlalchemy import Column, ForeignKey, Integer, String -from sqlalchemy.orm import relationship - from bootstrap import db -class Tag(db.Model): - text = Column(String, primary_key=True, unique=False) +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 = Column(Integer, ForeignKey('article.id', ondelete='CASCADE'), + article_id = db.Column(db.Integer, db.ForeignKey('article.id', ondelete='CASCADE'), primary_key=True) # relationships - article = relationship('Article', back_populates='tag_objs', - foreign_keys=[article_id]) + article = db.relationship('Article', back_populates='tag_objs', + foreign_keys=[article_id]) def __init__(self, text): self.text = text + + +class BookmarkTag(db.Model): + id = db.Column(db.Integer, primary_key=True) + text = db.Column(db.String, unique=False) + + # foreign keys + user_id = db.Column(db.Integer, db.ForeignKey('user.id')) + bookmark_id = db.Column(db.Integer, db.ForeignKey('bookmark.id', ondelete='CASCADE')) + + # relationships + bookmark = db.relationship('Bookmark', back_populates='tags', + cascade="all,delete", foreign_keys=[bookmark_id]) + + # def __init__(self, text, user_id): + # self.text = text + # self.user_id = user_id |