1 files changed, 72 insertions, 0 deletions
diff --git a/newspipe/models/bookmark.py b/newspipe/models/bookmark.py
new file mode 100644
index 00000000..c3bc2dea
--- /dev/null
+++ b/newspipe/models/bookmark.py
@@ -0,0 +1,72 @@
+#! /usr/bin/env python
+# -*- coding: utf-8 -*-
+
+# Newspipe - A Web based news aggregator.
+# Copyright (C) 2010-2020 Cédric Bonhomme - https://www.cedricbonhomme.org
+#
+# For more information: https://git.sr.ht/~cedric/newspipe
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+__author__ = "Cedric Bonhomme"
+__version__ = "$Revision: 0.1 $"
+__date__ = "$Date: 2016/12/07 $"
+__revision__ = "$Date: 2016/12/07 $"
+__copyright__ = "Copyright (c) Cedric Bonhomme"
+__license__ = "GPLv3"
+
+from newspipe.bootstrap import db
+from datetime import datetime
+from sqlalchemy import desc
+from sqlalchemy.orm import validates
+from sqlalchemy.ext.associationproxy import association_proxy
+
+from newspipe.models.tag import BookmarkTag
+from newspipe.models.right_mixin import RightMixin
+
+
+class Bookmark(db.Model, RightMixin):
+    """
+    Represent a bookmark.
+    """
+
+    id = db.Column(db.Integer(), primary_key=True)
+    href = db.Column(db.String(), default="")
+    title = db.Column(db.String(), default="")
+    description = db.Column(db.String(), default="")
+    shared = db.Column(db.Boolean(), default=False)
+    to_read = db.Column(db.Boolean(), default=False)
+    time = db.Column(db.DateTime(), default=datetime.utcnow)
+    user_id = db.Column(db.Integer(), db.ForeignKey("user.id"))
+
+    # relationships
+    tags = db.relationship(
+        BookmarkTag,
+        backref="of_bookmark",
+        lazy="dynamic",
+        cascade="all,delete-orphan",
+        order_by=desc(BookmarkTag.text),
+    )
+    tags_proxy = association_proxy("tags", "text")
+
+    @validates("description")
+    def validates_title(self, key, value):
+        return str(value).strip()
+
+    @validates("extended")
+    def validates_description(self, key, value):
+        return str(value).strip()
+
+    def __repr__(self):
+        return "<Bookmark %r>" % (self.href)