class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(120), nullable=True)
last_name = db.Column(db.String(120), nullable=True)
nickname = db.Column(db.String(120), nullable=True)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='default.jpg')
password = db.Column(db.String(60), nullable=False)
create_date = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
last_update = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow,
onupdate=datetime.utcnow)
posts = db.relationship('Post', backref='Author', lazy=True)
role = db.Column(db.Integer, nullable=True)
projects = db.relationship('Projectheader', backref='Creator', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
roles = {0: 'Admin', 1: 'Contributor', 2: 'Member'}
def is_contributor(self):
return self.role in (0, 1)
def is_admin(self):
return self.role == 0
class Tags(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), nullable=False)
slug = db.Column(db.String(64), unique=True)
def __init__(self, *args, **kwargs):
super(Tags, self).__init__(*args, **kwargs)
self.slug = slugify(self.name)
def __repr__(self):
return f"Tags(name='{self.name}')"
def __str__(self):
return f"{self.name}"
class userPageView(db.Model):
id = db.Column(db.Integer, primary_key=True)
session_id = db.Column(db.String, nullable=False)
from_page = db.Column(db.String, nullable=False)
to_page = db.Column(db.String, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
user_agent = db.Column(db.String, nullable=True)
timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
def __repr__(self):
return f"userPageView(session_id:'{self.session_id}', user_id:{self.user_id}, from_page:'{self.from_page}', to_page:'{self.to_page}', date/time:'{self.timestamp}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
last_update = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow,
onupdate=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
summary = db.Column(db.Text, nullable=True, default='')
slug = db.Column(db.String(255), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
active_state = db.Column(db.String, nullable=True)
post_type = db.Column(db.String, nullable=True)
tags = db.relationship('Tags',
secondary=post_tags,
backref=db.backref('Posts', lazy='dynamic'))
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}, slug='{self.slug}')"
class Projectheader(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
description = db.Column(db.Text, nullable=False)
date_created = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
date_last_update = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow,
onupdate=datetime.utcnow)
start_date = db.Column(db.DateTime, nullable=False)
end_date = db.Column(db.DateTime, nullable=True)
active_state = db.Column(db.String, nullable=True)
details = db.relationship('Projectdetails',
backref='project',
lazy=True,
cascade="all,delete")
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Projectheader(title='{self.title}', description='{self.description}', active_state={self.active_state})"
class Projectdetails(db.Model):
id = db.Column(db.Integer, primary_key=True)
project_id = db.Column(db.Integer,
db.ForeignKey('projectheader.id'),
nullable=False)
attr = db.Column(db.String(25), nullable=False)
value = db.Column(db.Text, nullable=False)
displayOrder = db.Column(db.Integer, nullable=False)
date_created = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
date_last_update = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow,
onupdate=datetime.utcnow)
def __repr__(self):
return f"Projectdetails(project_id='{self.project_id}', attr={self.attr}, value='{self.value}', displayOrder:{self.displayOrder}, last updated:'{self.date_last_update}')"
projects = db.relationship('Projectheader', backref='Creator', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
roles = {0: 'Admin', 1: 'Contributor', 2: 'Member'}
def is_contributor(self):
return self.role in (0, 1)
def is_admin(self):
return self.role == 0
post_tags = db.Table(
'entry_tags', db.Column('tag_id', db.Integer, db.ForeignKey('tags.id')),
db.Column('post_id', db.Integer, db.ForeignKey('post.id')))
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
last_update = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow,
onupdate=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
summary = db.Column(db.Text, nullable=True, default='')