class User(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(50), nullable=False)
lastname = db.Column(db.String(50), nullable=False)
email = db.Column(EmailType, nullable=False, unique=True)
user_type = db.Column(db.Integer, nullable=False, default=2)
_salt = db.Column(db.String(255), nullable=False)
_password = db.Column(db.String(255), nullable=False)
def __str__(self):
return "User: <id={2}, name={0}, lastname={1}, email={3}>".format(self.name,
self.lastname, self.id, self.email)
def __repr__(self):
return "User: <id={2}, name={0}, lastname={1}, email={3}>".format(self.name,
self.lastname, self.id, self.email)
@property
def password(self):
return (self._salt, self._password)
@password.setter
def password(self, plain_password):
self._salt, self._password = Utils.hash_password(plain_password)
class Admin(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(50), nullable=False, unique=True)
_salt = db.Column(db.String(255), nullable=False)
_password = db.Column(db.String(255), nullable=False)
def __str__(self):
return "Admin: <id={1}, username={0}, password={2}, salt={3}>".format(
self.username, self.id, self._password, self._salt)
def __repr__(self):
return "Admin: <id={1}, username={0}, password={2}, salt={3}>".format(
self.username, self.id, self._password, self._salt)
@property
def password(self):
return (self._salt, self._password)
@password.setter
def password(self, plain_password):
self._salt, self._password = Utils.hash_password(plain_password)
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.String, primary_key=True)
name = db.Column(db.String(255), nullable=False)
profile_url = db.Column(db.String, nullable=False)
access_token = db.Column(db.String, nullable=False)
birthday = db.Column(db.Date, nullable=False)
posts = db.relationship('Post', backref='user_post', lazy='dynamic')
events = db.relationship('Event', backref='user_event', lazy='dynamic')
to_friends = association_proxy('to_relations', 'to_friend')
from_owners = association_proxy('from_relations', 'from_owner')
categories = relationship("Category",
secondary=user_categories,
lazy='subquery')
products = relationship("UserProduct",
back_populates="user",
lazy='subquery')
class AuthToken(db.Model):
id = db.Column(db.Integer, primary_key=True)
token = db.Column(db.String(128), unique=False, nullable=False)
expiration = db.Column(db.DateTime,
default=(datetime.now() + timedelta(minutes=15)))
user_id = db.Column(db.String, db.ForeignKey('user.id'))
class Category(db.Model):
__tablename__ = 'category'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False, unique=True)
user_products = db.relationship("UserProduct", back_populates="category")
class FriendRelationshipType(db.Model):
__tablename__ = 'friend_relationship_type'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False, unique=True)
class UserEmail(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(256), unique=True, nullable=False)
confirmed_at = db.Column(db.DateTime, default=datetime.now())
user_id = db.Column(db.String, db.ForeignKey('user.id'))
class UserProfile(db.Model):
id = db.Column(db.Integer, primary_key=True)
firstname = db.Column(db.String(64), unique=True)
lastname = db.Column(db.String(64), unique=True)
