class Comment(db.Model):
__tablename__ = 'comments'
id = db.Column(UUID(), primary_key=True)
user_id = db.Column(UUID(), db.ForeignKey('users.id'), index=True)
content_id = db.Column(UUID(), db.ForeignKey('contents.id'), index=True)
body = db.Column(db.Text())
created = db.Column(db.DateTime)
class User(db.Model):
__tablename__ = 'users'
id = db.Column(UUID(), primary_key=True)
avatar = db.Column(db.String(256))
username = db.Column(db.String(64), unique=True, index=True)
email = db.Column(db.String(64), unique=True, index=True)
password_hash = db.Column(db.String(128))
role = db.Column(db.String(16))
registered = db.Column(db.DateTime)
active = db.Column(db.Boolean)
is_anonymous = False
def __init__(self, avatar, username, email, role):
self.id = uuid.uuid4().urn
self.avatar = avatar
self.username = username
self.email = email
self.role = role
self.datetime = datetime.datetime.utcnow()
self.active = True
def __repr__(self):
return '<User {}>'.format(self.username)
def is_authenticated(self):
return True
def is_active(self):
return self.active
def get_id(self):
return self.id
def get_urole(self):
return self.role
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
class ContentType(db.Model):
__tablename__ = 'content_types'
id = db.Column(UUID(), primary_key=True)
name = db.Column(db.String(64))
uri = db.Column(db.String(64))
class Setting(db.Model):
__tablename__ = 'settings'
id = db.Column(db.Integer, primary_key=True)
key = db.Column(db.String(32))
value = db.Column(db.String(256))
class Tag(db.Model):
__tablename__ = 'tags'
id = db.Column(UUID(), primary_key=True)
name = db.Column(db.String(64))
class ContentRelated(db.Model):
__tablename__ = 'content_related'
id = db.Column(UUID(), primary_key=True)
content_id = db.Column(UUID(), db.ForeignKey('contents.id'), index=True)
to_content_id = db.Column(UUID(), db.ForeignKey('contents.id'))
class Content(db.Model):
__tablename__ = 'contents'
id = db.Column(UUID(), primary_key=True)
uri = db.Column(db.String(64), unique=True, index=True)
content_type_id = db.Column(UUID(),
db.ForeignKey('content_types.id'),
index=True)
rubric_id = db.Column(UUID(), db.ForeignKey('rubrics.id'), index=True)
user_id = db.Column(UUID(), db.ForeignKey('users.id'), index=True)
title_seo = db.Column(db.String(64))
description_seo = db.Column(db.String(160))
preview = db.Column(db.String(128))
alt = db.Column(db.String(64))
content_image = db.Column(db.String(128))
language_seo = db.Column(db.String(2))
title = db.Column(db.String(128))
description = db.Column(db.Text())
body = db.Column(db.Text())
rating = db.Column(db.Integer(), default=0)
seen = db.Column(db.Integer(), default=0)
comment_count = db.Column(db.Integer(), default=0)
created = db.Column(db.DateTime())
updated = db.Column(db.DateTime())
status = db.Column(db.SmallInteger())
class Rubric(db.Model):
__tablename__ = 'rubrics'
id = db.Column(UUID(), primary_key=True)
name = db.Column(db.String(64))
uri = db.Column(db.String(64))