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