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')