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'))
