class User(db.Model, UserMixin): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True) email = db.Column(db.String(200), unique=True) bookmarks = db.relationship('Bookmark', backref='user', lazy='dynamic') password_hash = db.Column(db.String) @property def password(self): raise AttributeError('Password: write-only field') @password.setter def password(self, password): self.password_hash = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password_hash, password) @staticmethod def get_by_username(username): return User.query.filter_by(username=username).first() def __repr__(self): return "<User %r>" % self.username
class Bookmark(db.Model): __tablename__ = 'bookmark' 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]) @tags.setter def tags(self, string): if string: self._tags = [Tag.get_or_create(name) for name in string.split(',')] else: self._tags = [] def __repr__(self): return "<Bookmark '{}' : '{}'> ".format(self.description, self.url)
class Book(db.Model): id: int = db.Column(db.Integer, primary_key=True) name: str = db.Column(db.String(255)) def __init__(self, name): self.name = name def __repr__(self): return '<Product %d>' % self.id
class User(db.Model): id: int = db.Column(db.Integer, primary_key=True) email: str = db.Column(db.String(255)) password: str = db.Column(db.String(255)) def __init__(self, email, password): self.email = email self.password = password def __repr__(self): return '<User %d>' % self.id
class Tag(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(25), nullable=False, unique=True, index=True) @staticmethod def get_or_create(name): try: return Tag.query.filter_by(name=name).one() except: return Tag(name=name) @staticmethod def all(): return Tag.query.all() def __repr__(self): return self.name
from datetime import datetime from sqlalchemy import desc from bookmark import db from flask_login import UserMixin from werkzeug.security import check_password_hash, generate_password_hash 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): __tablename__ = 'bookmark' 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):