website/app/models.py

"""
All models for module
"""

from datetime import datetime
# from sqlalchemy.ext.hybrid import hybrid_method, hybrid_property
from flask_login import UserMixin
from app import db, argon2


class Base():
    """Base class for models"""
    id = db.Column(db.Integer, primary_key=True)

    def __repr__(self):
        return "<%s(%s)>" % (type(self).__name__, self.id)


class User(Base, db.Model, UserMixin):
    """Model for User"""

    name = db.Column(db.String, unique=True, nullable=False)
    email = db.Column(db.String(255), unique=True)
    _password = db.Column("password", db.String(255))
    registration_at = db.Column(db.DateTime, default=datetime.utcnow)

    @property
    def password(self):
        """Return the password"""
        return self._password

    @password.setter
    def password(self, password):
        """Hash password"""
        self._password = argon2.generate_password_hash(password)

    def check_password(self, password):
        """Check if password is correct"""
        return argon2.check_password_hash(self.password, password)


class Page(Base, db.Model):
    """Model for Page"""

    title = db.Column(db.String, nullable=False)
    datetime = db.Column(db.DateTime, default=datetime.utcnow)
    source = db.Column(db.String)

    user_id = db.Column(
        db.Integer,
        db.ForeignKey("sp_users.id")
    )
    user = db.relationship(
        "User",
        backref=db.backref("players", lazy="dynamic")
    )