class AnimeStudio(db.Model):
animeseries_id = db.Column(db.Integer,
db.ForeignKey('animeseries.id'),
primary_key=True)
studio_id = db.Column(db.Integer,
db.ForeignKey('studio.id'),
primary_key=True)
class AnimeProducer(db.Model):
animeseries_id = db.Column(db.Integer,
db.ForeignKey('animeseries.id'),
primary_key=True)
producer_id = db.Column(db.Integer,
db.ForeignKey('producer.id'),
primary_key=True)
class AnimeMedia(db.Model):
animeseries_id = db.Column(db.Integer,
db.ForeignKey('animeseries.id'),
primary_key=True)
media_id = db.Column(db.Integer,
db.ForeignKey('media.id'),
primary_key=True)
class AnimeGenre(db.Model):
animeseries_id = db.Column(db.Integer,
db.ForeignKey('animeseries.id'),
primary_key=True)
genre_id = db.Column(db.Integer,
db.ForeignKey('genre.id'),
primary_key=True)
class MCQQuestion(db.Model):
id = db.Column(db.Integer, primary_key=True)
question = db.Column(db.Text, nullable=False)
mark = db.Column(db.Integer, nullable=False)
difficulty = db.Column(db.Integer, nullable=False)
imp = db.Column(db.Boolean, default=False)
option1 = db.Column(db.Text, nullable=False)
option2 = db.Column(db.Text, nullable=False)
option3 = db.Column(db.Text, nullable=False)
option4 = db.Column(db.Text, nullable=False)
course_id = db.Column(db.Integer,
db.ForeignKey("course.id"),
nullable=False)
def __repr__(self):
return (
f"MCQQuestion({self.question}, {self.mark}, {self.difficulty}, {self.imp},"
f" {self.option1}, {self.option2}, {self.option3}, {self.option4})"
)
def to_dict(self):
return dict(
id=self.id,
question=self.question,
mark=self.mark,
difficulty=self.difficulty,
imp=self.imp,
option1=self.option1,
option2=self.option2,
option3=self.option3,
option4=self.option4,
)
class EquipmentTypeModel(db.Model, BaseModel):
# The name of the table at the data base.
__tablename__ = TableNames.S_EQUIPMENT_TYPE
# The table columns.
type_id = db.Column(db.String(50), primary_key=True)
description = db.Column(db.String(500), nullable=True)
equipments = db.relationship(RelationShip.EQUIPMENT,
backref="info",
cascade="save-update, merge, delete",
lazy=True)
def __repr__(self):
return "EquipmentTagsModel(type_id={})".format(self.type_id)
def to_dict(self):
"""
Convert EquipmentTagsModel into a dictionary, this way we can convert it to a JSON response.
:return: A clean dictionary form of this model.
"""
# convert columns to dict
dict_representation = super().to_dict()
# add additional values for the dictionary.
dict_representation["equipments"] = [
eq.to_dict() for eq in self.equipments
]
return dict_representation
class RolesRightsModel(db.Model, BaseModel):
# The name of the table at the data base.
__tablename__ = TableNames.T_ROLES_RIGHTS
# The table columns.
role_id = db.Column(db.String(50), db.ForeignKey(TableNames.S_ROLES + ".role_id"), primary_key=True)
right_id = db.Column(db.String(50), db.ForeignKey(TableNames.S_RIGHTS + ".right_id"), primary_key=True)
def __repr__(self):
return "RolesRights(role_id={}, right_id={})".format(self.role_id, self.right_id)
# Queries for this model.
@classmethod
def get_rights_by_role(cls, role_id: str):
"""
Get the a list of right ids for this role.
:param role_id: The role id.
:return: A list of right ids for this role.
"""
roles_rights: List[RolesRightsModel] = cls.find_by(role_id=role_id, get_first=False)
if roles_rights:
return [rr.right_id for rr in roles_rights]
return None
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default="default.svg")
password = db.Column(db.String(60), nullable=False)
courses = db.relationship("Course", backref="teacher", lazy=True)
def get_reset_token(self, expires_sec=86400):
s = Serializer(current_app.config["SECRET_KEY"], expires_sec)
return s.dumps({"user_id": self.id}).decode("utf-8")
@staticmethod
def verify_reset_token(token):
s = Serializer(current_app.config["SECRET_KEY"])
try:
user_id = s.loads(token)["user_id"]
except:
return None
return User.query.get(user_id)
def __repr__(self):
return f"User({self.username}, {self.email}, {self.image_file})"
def to_dict(self):
return dict(
id=self.id,
username=self.username,
email=self.email,
image_file=self.image_file,
)
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
ques = db.Column(db.String(150), nullable=False)
answers = db.relationship('Ans', backref=db.backref('question'), lazy=True)
def __repr__(self):
return f"post('{self.ques}')"
class Course(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), nullable=False)
price = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"course( '{self.name}', '{self.price}' )"
class AssistanceType(db.Model):
__tablename__ = 'assistance_type'
aid = db.Column(db.Integer, primary_key=True)
assistanceName = db.Column(db.String(30),unique=True, nullable=False)
def __init__(self, **kwargs):
super(AssistanceType, self).__init__(**kwargs)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
def __repr__(self):
return f"User('{self.username}')"
class Business(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
coordinates = db.Column(db.String(100), nullable=True)
categories = db.Column(db.String(100), nullable=True)
def __repr__(self):
return f"Business('{self.name}')"
class Ban_list(db.Model):
ban_id = db.Column(db.Integer, nullable=False, primary_key=True)
user_id = db.Column(db.Integer)
time = db.Column(db.Text)
def __repr__(self):
return f"Ban_list('{self.ban_id }', '{self.user_id}','{self.time}')"
class GPMobile(db.Model):
__tablename__ = 'gp_mobile'
mobilePhone = db.Column(db.String(8), primary_key=True)
postalCode = db.Column(db.String(10), unique=False, nullable=False)
def __init__(self, **kwargs):
super(GPMobile, self).__init__(**kwargs)
class FileTransferredModel(db.Model, BaseModel):
# The name of the table at the data base.
__tablename__ = TableNames.T_TRANSFERRED_FILES
# The table columns.
id = db.Column(db.String(50), primary_key=True)
status_id = db.Column(
db.String(50), db.ForeignKey(TableNames.S_TRANSFERRED_STATUS + ".id"))
transferred_by = db.Column(db.String(50), unique=False, nullable=False)
transferred_at = db.Column(db.DateTime,
default=datetime.utcnow,
nullable=False)
def __repr__(self):
return "FileTransferredModel(id={}, status_id={}, transferred_by={}, transferred_at={})"\
.format(self.id, self.status_id, self.transferred_by, self.transferred_at)
def save(self):
if current_user:
self.transferred_by = current_user.username
else:
self.transferred_by = "Unknown"
super().save()
def update(self, status_id: str, transferred_at: datetime):
self.status_id = status_id
self.transferred_at = transferred_at
self.save()
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20),
unique=False,
nullable=False,
default='default.jpg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
def __repr__(self):
return "User('{}', '{}', '{}')".format(self.username, self.email,
self.image_file)
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String, nullable=False, unique=True)
password = db.Column(db.String, nullable=False)
@classmethod
def lookup(cls, email):
return cls.query.filter_by(email=email).one_or_none()
@classmethod
def identify(cls, id):
return cls.query.get(id)
@property
def identity(self):
return self.id
def check_password(self, password):
return check_password_hash(self.password, password)
def __repr__(self):
return f'User<email={self.email}>'
class Email(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(120), nullable=False)
def __repr__(self):
return f"User('{self.email}')"
class Status(db.Model):
__tablename__= 'status'
statusID = db.Column(db.Integer, primary_key=True)
statusName = db.Column(db.String(20), nullable=False)
def __init__(self, **kwargs):
super(Status, self).__init__(**kwargs)
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(100), unique=True)
image = db.Column(db.Text(), default='index.png')
password = db.Column(db.String(100))
name = db.Column(db.String(1000))
posts = db.relationship('Post', backref='user', lazy=True)
class Doc(db.Model):
id = db.Column(db.Integer, primary_key=True)
doc_id = db.Column(db.Integer, nullable=False)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Doc('{self.doc_id}', '{self.date_posted}', '{self.user_id}')"
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text(), nullable=False)
email = db.Column(db.Text(), nullable=False)
password = db.Column(db.Text(), nullable=False)
def __repr__(self):
return '{}'.format(self.name)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
def __repr__(self):
return "User: {}, {}".format(self.username, self.email)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
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)
class Todo(db.Model):
id = db.Column(db.Integer, primary_key=True)
content = db.Column(db.String(200), nullable=False)
completed = db.Column(db.Boolean, default=False)
date_created = db.Column(db.DateTime, default=datetime.utcnow)
def __repr__(self):
return f"Todo(id={self.id}, content='{self.content}')"
class Post(db.Model):
_id = db.Column(db.Integer, primary_key=True)
datePosted = db.Column(db.DateTime, default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
userId = db.Column(db.Integer, db.ForeignKey("user._id"), nullable=False)
def __repr__(self):
return f"Post ('{self.title}, {self.datePosted} , {self.content}')"
class User(db.Model,UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
entry = db.relationship('graphData',backref='user', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.entry}')"
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
question = db.Column(db.Text, nullable=False)
mark = db.Column(db.Integer, nullable=False)
difficulty = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"Question({self.question}, {self.mark}, {self.difficulty})"
class Visitor(db.Model):
__tablename__ = 'visitor'
name = db.Column(db.String(25))
contact = db.Column(db.String(11))
place_from = db.Column(db.String(20))
timesheet = db.relationship('Timesheet_Visitor', backref='timelog')
activities = db.relationship('Activity', backref='activity')
