class HomeSubData(Base): # 表名 __tablename__ = 'home_sub_data' id = Column(INT(), primary_key=True) img = Column(VARCHAR(255)) url = Column(VARCHAR(255)) title = Column(VARCHAR(255)) des = Column(VARCHAR(255)) name = Column(VARCHAR(255)) time = Column(VARCHAR(255)) """通过外键约束建立关系,耦合性大,数据删除需删除从表后才能删除主表 home_sub_id = Column(INT(), ForeignKey('home_sub.id'))""" home_sub_id = Column(INT(), ForeignKey('home_sub.id', ondelete='CASCADE')) # 不通过外键约束建立一对多关系 # home_sub_id = Column(INT()) def __init__(self, img, url, title, des, name, time): self.img = img self.url = url self.title = title self.des = des self.name = name self.time = time
class BookSimple(Base): __tablename__ = 'book_simple' id = Column(INT(), primary_key=True) img = Column(VARCHAR(255)) book_id = Column(VARCHAR(255)) title = Column(VARCHAR(255)) author = Column(VARCHAR(255)) score = Column(VARCHAR(255)) information_title = Column(VARCHAR(255)) source = Column(VARCHAR(255)) information_des = Column(VARCHAR(255)) book_category_id = Column( INT(), ForeignKey('book_category.id', ondelete='CASCADE')) def __init__(self, img, book_id, title, author, score, information_title, source, information_des): self.img = img self.book_id = book_id self.title = title self.author = author self.score = score self.information_title = information_title self.source = source self.information_des = information_des
class cvEducationExp(Base): __tablename__ = 'T_CV_EDUCATION_EXPERIENCE' ID = Column(INT(11), primary_key=True, autoincrement=True) ResumeID = Column(VARCHAR(15)) School = Column(VARCHAR(400)) EndYear = Column(INT(4)) EndMonth = Column(INT(2))
class HomeSub(Base): # 表名 __tablename__ = 'home_sub' id = Column(INT(), primary_key=True) title = Column(VARCHAR(255)) type = Column(VARCHAR(255)) """通过外键约束建立关系,耦合性大,数据删除需删除从表后才能删除主表 home_sub_data_array = relationship('HomeSubData', backref='home_sub') home_id = Column(INT(), ForeignKey('home.id'))""" home_sub_data_array = relationship('HomeSubData', backref='home_sub', cascade='all, delete-orphan', passive_deletes=True) home_id = Column(INT(), ForeignKey('home.id', ondelete='CASCADE')) # 不通过外键约束建立一对多关系 # home_sub_data_array = relationship('HomeSubData', primaryjoin=foreign(HomeSubData.home_sub_id) == remote(id), # backref='home_sub') # home_id = Column(INT()) def __init__(self, title, tp): self.title = title self.type = tp self.home_sub_data_array = []
class BR_Diagnosis_copy1(Base): # 表的名字: __tablename__ = 'BR_Diagnosis_copy1' # 表的结构: BR_DiagnosisID = Column(INT(), primary_key=True) BR_EncounterID = Column(INT(), ForeignKey('BR_Encounter.BR_EncounterID')) BR_EncounterNewID = Column(INT())
class BR_Death(Base): # 表的名字: __tablename__ = 'BR_Death' # 表的结构: BR_DeathID = Column(INT(), primary_key=True) BR_EncounterID = Column(INT(), ForeignKey('BR_Encounter.BR_EncounterID')) BR_EncounterNewID = Column(INT())
class BR_Comorbidity(Base): # 表的名字: __tablename__ = 'BR_Comorbidity' # 表的结构: BR_ComorbidityID = Column(INT(), primary_key=True) BR_EncounterID = Column(INT(), ForeignKey('BR_Encounter.BR_EncounterID')) BR_EncounterNewID = Column(INT())
class BR_MedicalImaging_Diag(Base): # 表的名字: __tablename__ = 'BR_MedicalImaging_Diag' # 表的结构: BR_MedicalImaging_DiagID = Column(INT(), primary_key=True) BR_MedicalImagingID = Column( INT(), ForeignKey('BR_MedicalImaging.BR_MedicalImagingID')) BR_MedicalImaging_Diag_No = Column(INT())
class Position(Base): #定义一个类,继承Base __tablename__ = 'Position' ID = Column(INT(), primary_key=True) PositionName = Column(String(50)) Description = Column(String(100)) Weight = Column(INT()) def __init__(self, PositionName, Description, Weight): self.Description = Description self.PositionName = PositionName self.Weight = Weight
class Player(Base): __tablename__ = 'player' player_id = Column(INT(), primary_key=True) team_id = Column(INT()) player_name = Column(VARCHAR(255)) height = Column(FLOAT()) def __init__(self, player_id, team_id, player_name, height): self.player_id = player_id self.team_id = team_id self.player_name = player_name self.height = height
class dc_pluginsituation(Base): # 表的名字: __tablename__ = 'dc_pluginsituation' # 表的结构: dc_pluginsituation_id = Column(INT(), primary_key=True) dc_agent_id = Column(INT(), ForeignKey('dc_agent.dc_agent_id')) dc_pluginsituation_name = Column(String(200)) dc_pluginsituation_isupdate = Column(String(40))
class BR_Demographics(Base): # 表的名字: __tablename__ = 'BR_Demographics' # 表的结构: BR_Demographics_ID = Column(INT(), primary_key=True) BR_EncounterID = Column(INT(), ForeignKey('BR_Encounter.BR_EncounterID')) BR_Demographics_BirthDate = Column(Date) BR_EncounterNewID = Column(INT())
class cvWorkExp(Base): __tablename__ = 'T_CV_WORK_EXPERIENCE' ID = Column(INT(11), primary_key=True, autoincrement=True) ResumeID = Column(VARCHAR(15)) Company = Column(VARCHAR(250)) DutyPerformance = Column(TEXT()) CompanyIndustry = Column(VARCHAR(50)) CompanyIntrdouce = Column(VARCHAR(2000)) JobName = Column(VARCHAR(100)) StartYear = Column(INT(4)) StartMonth = Column(INT(2)) EndYear = Column(INT(4)) EndMonth = Column(INT(2))
class BR_MedicalImaging(Base): # 表的名字: __tablename__ = 'BR_MedicalImaging' # 表的结构: BR_MedicalImagingID = Column(INT(), primary_key=True) BR_EncounterID = Column(INT(), ForeignKey('BR_Encounter.BR_EncounterID')) BR_MedicalImaging_ImageAge = Column(INT()) BR_MedicalImaging_ImageDate = Column(Date) BR_EncounterNewID = Column(INT())
class BR_Pathology(Base): # 表的名字: __tablename__ = 'BR_Pathology' # 表的结构: BR_PathologyID = Column(INT(), primary_key=True) BR_EncounterID = Column(INT(), ForeignKey('BR_Encounter.BR_EncounterID')) BR_PathologyID_PAAge = Column(INT()) BR_PathologyID_PADate = Column(Date) BR_EncounterNewID = Column(INT())
class dc_pluginsituation_service(Base): # 表的名字: __tablename__ = 'dc_pluginsituation_service' # 表的结构: dc_pluginsituation_service_id = Column(INT(), primary_key=True) dc_pluginsituation_service_name = Column(String(100)) dc_pluginsituation_service_status = Column(String(40)) dc_pluginsituation_id = Column(INT(),ForeignKey('dc_pluginsituation.dc_pluginsituation_id')) dc_pluginsituation_service_Operate = Column(String(40))
class BookSubLabel(Base): __tablename__ = 'book_sub_label' id = Column(INT(), primary_key=True) name = Column(VARCHAR(255)) book_main_label_id = Column( INT(), ForeignKey('book_main_label.id', ondelete='CASCADE')) book_des_array = relationship('BookDes', backref='book_sub_label', cascade='all, delete-orphan', passive_deletes=True) def __init__(self, name: str): self.name = name self.book_des_array = []
class DBEmployee(BaseModel): __tablename__ = 'employees' first_name = Column(VARCHAR(50)) last_name = Column(VARCHAR(50)) user_id = Column(INT())
class Update(Base): """ Update class that represents a device update """ __tablename__ = 'firmware' id: int = Column(INT(), primary_key=True, autoincrement=True) codename: str = Column(VARCHAR(30), nullable=False) version: str = Column(VARCHAR(20), nullable=False) android: str = Column(VARCHAR(5), nullable=False) branch: str = Column(VARCHAR(15), nullable=False) size: str = Column(BIGINT(), nullable=True) md5: str = Column(CHAR(32), unique=True, nullable=True) filename: str = Column(TEXT(), unique=True, nullable=True) github_link: str = Column(TEXT(), nullable=False) osdn_link: str = Column(TEXT(), nullable=True) date: str = Column(DATE(), nullable=True) inserted_on: str = Column(TIMESTAMP(), default=current_timestamp()) def __repr__(self): return f"<Update(codename={self.codename}, version={self.version}, branch={self.branch})>" def __str__(self): return str( {k: v for k, v in self.__dict__.items() if not k.startswith("_")})
class Update(Base): """ Update class that represents a device update """ __tablename__ = 'updates' id: int = Column(INT(), primary_key=True, autoincrement=True) codename: str = Column(VARCHAR(30), nullable=False) version: str = Column(VARCHAR(20), nullable=False) android: str = Column(VARCHAR(5), nullable=False) branch: str = Column(VARCHAR(15), nullable=False) type: str = Column(VARCHAR(11), nullable=False) method: str = Column(VARCHAR(8), nullable=False) size: str = Column(BIGINT(), nullable=True) md5: str = Column(CHAR(32), unique=True, nullable=True) filename: str = Column(TEXT(), unique=True, nullable=True) link: str = Column(TEXT(), nullable=False) changelog: str = Column(TEXT(), nullable=True, default='Bug fixes and system optimizations.') date: str = Column(DATE(), nullable=True) inserted_on: str = Column(TIMESTAMP(), default=current_timestamp()) def __repr__(self): return f"<Update(codename={self.codename}, version={self.version}, branch={self.branch}, method={self.method})>" def __str__(self): return str({k: v for k, v in self.__dict__.items() if not k.startswith("_")})
class dc_configsituation(Base): # 表的名字: __tablename__ = 'dc_configsituation' # 表的结构: dc_configsituation_id = Column(INT(), primary_key=True) dc_pluginsituation_id = Column(INT(), ForeignKey('dc_pluginsituation.dc_pluginsituation_id')) dc_configsituation_configname = Column(String(100)) dc_configsituation_content = Column(String(999999)) dc_configsituation_isupdate = Column(String(40)) dc_configsituation_isManualEdit = Column(String(40))
class BookDes(Base): __tablename__ = 'book_des' id = Column(INT(), primary_key=True) img = Column(VARCHAR(255)) book_id = Column(VARCHAR(255)) title = Column(VARCHAR(255)) author = Column(VARCHAR(255)) score = Column(VARCHAR(255)) press = Column(VARCHAR(255)) producers = Column(VARCHAR(255)) sub_title = Column(VARCHAR(255)) origin_name = Column(VARCHAR(255)) translator = Column(VARCHAR(255)) publish_time = Column(VARCHAR(255)) page = Column(VARCHAR(255)) price = Column(VARCHAR(255)) comment_num = Column(VARCHAR(255)) star = Column(VARCHAR(255)) content_des = Column(TEXT()) author_des = Column(TEXT()) tags = Column(VARCHAR(255)) book_sub_label_id = Column( INT(), ForeignKey('book_sub_label.id', ondelete='CASCADE')) def __init__(self, img, book_id, title, author, score, press, producers, sub_title, origin_name, translator, publish_time, page, price, comment_num, star, content_des, author_des, tags): self.img = img self.book_id = book_id self.title = title self.author = author self.score = score self.press = press self.producers = producers self.sub_title = sub_title self.origin_name = origin_name self.translator = translator self.publish_time = publish_time self.page = page self.price = price self.comment_num = comment_num self.star = star self.content_des = content_des self.author_des = author_des self.tags = tags self.book_sub_label_id = []
class floor(ColumnElement): """ Implement floor() function as a custom function to allow use in sqlite for testing. """ type = INT() def __init__(self, clauses): self.clauses = clauses
class BR_Encounter(Base): # 表的名字: __tablename__ = 'BR_Encounter' # 表的结构: BR_EncounterID = Column(INT(), primary_key=True) EncounterIDEncrypt = Column(String(500))
class BR_Information(Base): # 表的名字: __tablename__ = 'BR_Information' # 表的结构: BR_Information_ID = Column(INT(), primary_key=True) BR_Information_PatientNo = Column(String(4000))
class User(Base): # 表的名字: __tablename__ = "user" # 表的结构: id = Column(INT(), primary_key=True) user_name = Column(String(), ) mobile = Column(String(), ) password = Column(String(), )
class TeNoSt(Base): __tablename__ = 'test' id = Column(INT(), primary_key=True, autoincrement=True) value = Column(String(32), nullable=False, default='') def update(self, info_dict): for key in info_dict: setattr(self, key, info_dict[key])
class dc_agent(Base): # 表的名字: __tablename__ = 'dc_agent' # 表的结构: dc_agent_id = Column(INT(), primary_key=True) dc_agent_address = Column(String(200)) dc_agent_operate = Column(String(200))
class dc_plugin(Base): # 表的名字: __tablename__ = 'dc_plugin' # 表的结构: dc_plugin_id = Column(INT(), primary_key=True) dc_plugin_name = Column(String(200)) dc_plugin_location = Column(String(4000))
class medicalImaging(Base): # 表的名字: __tablename__ = 'testTable' # 表的结构: test_id = Column(INT(), primary_key=True) test_name = Column(String(400)) # 上传图片拼接的html test_allImage = Column(String(99999))