from datetime import datetime from sqlalchemy import desc from flask_login import UserMixin from werkzeug.security import check_password_hash, generate_password_hash from thermos import db tags = db.Table( "bookmark_tag", db.Column("tag_id", db.Integer, db.ForeignKey("tag.id")), db.Column("bookmark_id", db.Integer, db.ForeignKey("bookmark.id")), ) class Bookmark(db.Model): id = db.Column(db.Integer, primary_key=True) url = db.Column(db.Text, nullable=False) date = db.Column(db.DateTime, default=datetime.utcnow) description = db.Column(db.String(300)) user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) _tags = db.relationship( "Tag", secondary=tags, lazy="joined", backref=db.backref("bookmarks", lazy="dynamic"), ) @staticmethod def newest(num): return Bookmark.query.order_by(desc(Bookmark.date)).limit(num)
from datetime import datetime from flask_login import UserMixin from sqlalchemy import desc from werkzeug.security import generate_password_hash, check_password_hash from thermos import db tags = db.Table( 'bookmark_tag', db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')), db.Column('bookmark_id', db.Integer, db.ForeignKey('bookmark.id'))) class Bookmark(db.Model): id = db.Column(db.Integer, primary_key=True) url = db.Column(db.Text, nullable=False) date = db.Column(db.DateTime, default=datetime.utcnow) description = db.Column(db.String(300)) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) _tags = db.relationship('Tag', secondary=tags, lazy='joined', backref=db.backref('bookmarks', lazy='dynamic')) @staticmethod def newest(num): return Bookmark.query.order_by(desc(Bookmark.date)).limit(num) @property def tags(self): return ",".join([t.name for t in self._tags])
from datetime import datetime from sqlalchemy import desc from flask_login import UserMixin from werkzeug.security import generate_password_hash, check_password_hash from thermos import db tags = db.Table( 'bookmark_tag', db.Column('id_tad', db.Integer, db.ForeignKey('tag.id_tag'), nullable=False), db.Column('id_bookmark', db.Integer, db.ForeignKey('bookmark.id_bookmark'), nullable=False)) class Bookmark(db.Model): id_bookmark = db.Column(db.Integer, primary_key=True) nm_url = db.Column(db.Text, nullable=False) dt_bookmark = db.Column(db.DateTime, default=datetime.utcnow) nm_description = db.Column(db.String(300)) id_user = db.Column(db.Integer, db.ForeignKey('user.id_user'), nullable=False) _tags = db.relationship('Tag', secondary=tags, lazy='joined', backref=db.backref('bookmarks', lazy='dynamic'))