aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCédric Bonhomme <cedric@cedricbonhomme.org>2020-11-20 15:43:48 +0100
committerCédric Bonhomme <cedric@cedricbonhomme.org>2020-11-20 15:43:48 +0100
commita16099dfdd679398a90eefb3ed467974648b3b26 (patch)
tree170e0f98c023aa13f9dbe0f5ed4a095678c66714
parentadded missing import (diff)
downloadnewspipe-a16099dfdd679398a90eefb3ed467974648b3b26.tar.gz
newspipe-a16099dfdd679398a90eefb3ed467974648b3b26.tar.bz2
newspipe-a16099dfdd679398a90eefb3ed467974648b3b26.zip
updated indexes
-rw-r--r--newspipe/models/article.py18
-rw-r--r--newspipe/models/feed.py16
2 files changed, 24 insertions, 10 deletions
diff --git a/newspipe/models/article.py b/newspipe/models/article.py
index af190053..c26d2530 100644
--- a/newspipe/models/article.py
+++ b/newspipe/models/article.py
@@ -28,7 +28,7 @@ __license__ = "GPLv3"
from datetime import datetime
-from sqlalchemy import Index
+from sqlalchemy import Index, ForeignKeyConstraint
from sqlalchemy.ext.associationproxy import association_proxy
from newspipe.bootstrap import db
@@ -63,12 +63,18 @@ class Article(db.Model, RightMixin):
)
tags = association_proxy("tag_objs", "text")
- # indexes
__table_args__ = (
- Index('user_id'),
- Index('user_id', 'category_id'),
- Index('user_id', 'feed_id'),
- Index('ix_article_uid_fid_eid', user_id, feed_id, entry_id)
+ ForeignKeyConstraint([user_id], ['user.id'], ondelete='CASCADE'),
+ ForeignKeyConstraint([feed_id], ['feed.id'], ondelete='CASCADE'),
+ ForeignKeyConstraint([category_id], ['category.id'],
+ ondelete='CASCADE'),
+ Index('ix_article_eid_cid_uid', user_id, category_id, entry_id),
+ Index('ix_article_retrdate', retrieved_date),
+
+ Index('user_id'),
+ Index('user_id', 'category_id'),
+ Index('user_id', 'feed_id'),
+ Index('ix_article_uid_fid_eid', user_id, feed_id, entry_id)
)
# api whitelists
diff --git a/newspipe/models/feed.py b/newspipe/models/feed.py
index 4d067163..95c5f340 100644
--- a/newspipe/models/feed.py
+++ b/newspipe/models/feed.py
@@ -28,7 +28,7 @@ __license__ = "GPLv3"
from datetime import datetime
-from sqlalchemy import Index, desc
+from sqlalchemy import Index, desc, ForeignKeyConstraint
from sqlalchemy.orm import validates
from newspipe.bootstrap import db
@@ -72,9 +72,17 @@ class Feed(db.Model, RightMixin):
order_by=desc(Article.date),
)
- # index
- idx_feed_uid_cid = Index("user_id", "category_id")
- idx_feed_uid = Index("user_id")
+ __table_args__ = (
+ ForeignKeyConstraint([user_id], ['user.id'], ondelete='CASCADE'),
+ ForeignKeyConstraint([category_id], ['category.id'],
+ ondelete='CASCADE'),
+ ForeignKeyConstraint([icon_url], ['icon.url']),
+ Index('ix_feed_uid', user_id),
+ Index('ix_feed_uid_cid', user_id, category_id),
+ )
+
+ # idx_feed_uid_cid = Index("user_id", "category_id")
+ # idx_feed_uid = Index("user_id")
# api whitelists
@staticmethod
bgstack15