class District(Base):
__tablename__ = 'district'
__table_args__ = {'comment': '?????'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
city_code = Column(VARCHAR(4), index=True, comment='????')
city_name = Column(NVARCHAR(64), comment='????')
county_code = Column(VARCHAR(2), comment='????')
county_name = Column(NVARCHAR(64), comment='????')
town_code = Column(VARCHAR(3), comment='????')
town_name = Column(NVARCHAR(64), comment='????')
village_code = Column(VARCHAR(3), comment='???')
village_name = Column(NVARCHAR(64), comment='???')
group_code = Column(VARCHAR(2), comment='???')
group_name = Column(NVARCHAR(64), comment='???')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
bz = Column(NVARCHAR(255), comment='??')
full_code = Column(VARCHAR(14), index=True, comment='????')
class Department(Base):
__tablename__ = 'department'
__table_args__ = {'comment': '???'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
name = Column(NVARCHAR(64), comment='????')
simple_name = Column(NVARCHAR(64), comment='????')
dept_code = Column(VARCHAR(64), comment='????')
address = Column(NVARCHAR(64), comment='??')
telephone = Column(VARCHAR(32), comment='??')
fax = Column(VARCHAR(32), comment='??')
pid = Column(VARCHAR(36), index=True, comment='????ID')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
bz = Column(NVARCHAR(255), comment='??')
isinformal = Column(NUMBER(3, 0, False),
server_default=text("0 "),
comment='????????')
class IfBscFundinfo(Base):
__tablename__ = 'if_bsc_fundinfo'
l_fund_id = Column(NUMBER(10, 0, False), primary_key=True)
vc_fund_code = Column(VARCHAR(16), nullable=False)
vc_fund_name = Column(VARCHAR(64))
l_default_asset = Column(NUMBER(8, 0, False))
l_default_combi = Column(NUMBER(12, 0, False))
c_fund_type = Column(CHAR(1))
c_fund_status = Column(CHAR(1))
l_bank_id = Column(NUMBER(10, 0, False))
vc_bank_account = Column(VARCHAR(30))
vc_shclearing_account = Column(VARCHAR(30))
l_main_fund_id = Column(NUMBER(4, 0, False))
vc_mkt_fund_code = Column(VARCHAR(16))
c_fund_type2 = Column(CHAR(4))
vc_fund_tag = Column(VARCHAR(8))
iscurrmngpdt = Column(VARCHAR(32))
vc_sequare_code = Column(VARCHAR(128))
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
d_updatetime = Column(DateTime)
def __str__(self):
return 'l_fund_id'
class IfBscWmp(Base):
__tablename__ = 'if_bsc_wmp'
vc_scode = Column(VARCHAR(20), primary_key=True)
l_market = Column(VARCHAR(50))
vc_wmp_code = Column(VARCHAR(16))
l_wmp_type = Column(VARCHAR(50))
l_wmp_category = Column(VARCHAR(50))
l_wmp_investment = Column(VARCHAR(50))
vc_company_code = Column(VARCHAR(16))
l_collect_bdate = Column(NUMBER(8, 0, False))
l_collect_edate = Column(NUMBER(8, 0, False))
l_payment_date = Column(VARCHAR(50))
l_begin_date = Column(VARCHAR(50))
l_end_date = Column(VARCHAR(50))
l_interestpay_type = Column(VARCHAR(50))
c_day_type = Column(CHAR(1))
en_face_value = Column(VARCHAR(50))
l_currency = Column(VARCHAR(50))
en_issue_scale = Column(VARCHAR(50))
l_interest_type = Column(VARCHAR(50))
en_expect_yield = Column(VARCHAR(50))
c_advance_flag = Column(CHAR(1))
vc_data_source = Column(VARCHAR(32))
d_updatetime = Column(DateTime)
vc_md_business_model = Column(VARCHAR(1024))
vc_remark = Column(VARCHAR(64))
c_evaluation_type = Column(CHAR(1))
vc_risk_type = Column(VARCHAR(32))
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
def __str__(self):
return 'vc_scode'
class ActorBorrowerConfig(Base):
__tablename__ = 'sl$actor_borrower_config'
__table_args__ = {u'schema': 'SLPROD'}
table_tag = 'sl$'
aid = Column(NUMBER(38), primary_key=True)
config_id = Column(NUMBER(38))
loan_app_id = Column(NUMBER(38))
class TBscStockinfo(Base):
__tablename__ = 't_bsc_stockinfo'
l_date = Column(NUMBER(8, 0, False), primary_key=True, nullable=False)
vc_inter_code = Column(VARCHAR(8), primary_key=True, nullable=False)
l_market = Column(VARCHAR(50))
vc_report_code = Column(VARCHAR(20))
vc_stock_name = Column(VARCHAR(100))
c_stock_type = Column(VARCHAR(2))
c_asset_type = Column(CHAR(1))
vc_asset_relative_code = Column(VARCHAR(8))
vc_currency = Column(VARCHAR(3))
vc_mixed_type = Column(VARCHAR(100))
vc_international_code = Column(VARCHAR(32))
vc_busin_classes = Column(VARCHAR(512))
c_default_price = Column(CHAR(1))
en_reference_price = Column(VARCHAR(50))
l_publish_date = Column(NUMBER(8, 0, False))
l_turnover_date = Column(NUMBER(8, 0, False))
l_total_lock_day = Column(VARCHAR(50))
l_left_lock_days = Column(VARCHAR(50))
d_updatetime = Column(DateTime, server_default=text("""\
sysdate
"""))
vc_assign_code = Column(VARCHAR(20))
vc_md5 = Column(VARCHAR(32))
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
def __str__(self):
return str(self.l_date) + str(self.vc_inter_code) + '$*' + str(
self.vc_md5)
class Leader(Base):
__tablename__ = 'leader'
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
user_id = Column(VARCHAR(36), comment='??ID')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
class UsersGroup(Base):
__tablename__ = 'users_group'
__table_args__ = {'comment': '??'}
id = Column(VARCHAR(36), primary_key=True, comment='??')
name = Column(NVARCHAR(64), comment='????')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
class TBscBondpoolview(Base):
__tablename__ = 't_bsc_bondpoolviews'
vc_scode = Column(VARCHAR(20), primary_key=True, nullable=False)
vc_name = Column(VARCHAR(100))
l_market = Column(VARCHAR(50), primary_key=True, nullable=False)
vc_code = Column(VARCHAR(16), nullable=False)
l_date = Column(NUMBER(8, 0, False), primary_key=True, nullable=False)
vc_companyname = Column(VARCHAR(64))
l_guarant_kind = Column(VARCHAR(50))
vc_poolname = Column(VARCHAR(20))
vc_innercompany_rank = Column(VARCHAR(20))
vc_companycredit_rank = Column(VARCHAR(20))
vc_innerbond_rank = Column(VARCHAR(200))
vc_bondcredit_rank = Column(VARCHAR(20))
vc_rankwatch = Column(VARCHAR(20))
l_credit_anticipate = Column(VARCHAR(50))
vc_companylongratename = Column(VARCHAR(64))
vc_industryname_tk = Column(VARCHAR(64))
vc_company_type = Column(VARCHAR(128))
vc_bond_type = Column(VARCHAR(64))
c_is_vrcode = Column(CHAR(1))
c_is_compliance = Column(CHAR(1))
c_is_highrisk = Column(CHAR(1))
vc_focustype = Column(VARCHAR(20))
d_updatetime = Column(DateTime)
vc_bond_highrisk = Column(VARCHAR(10))
vc_bb_bond_highrisk = Column(VARCHAR(10))
vc_md5 = Column(VARCHAR(32))
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
def __str__(self):
return str(self.l_market) + str(self.l_date) + str(
self.vc_scode) + '$*' + str(self.vc_md5)
class IfBscPfNav(Base):
__tablename__ = 'if_bsc_pf_nav'
vc_pf_code = Column(VARCHAR(20), primary_key=True, nullable=False)
l_enddate = Column(VARCHAR(50), primary_key=True, nullable=False)
en_unitnav = Column(VARCHAR(50))
en_unitaccnav = Column(VARCHAR(50))
en_repairunitnav = Column(VARCHAR(50))
en_navgrtd = Column(VARCHAR(50))
en_navgrl1w = Column(VARCHAR(50))
en_navgrt1w = Column(VARCHAR(50))
en_navgrl1m = Column(VARCHAR(50))
en_navgrt1m = Column(VARCHAR(50))
en_navgrl3m = Column(VARCHAR(50))
en_navgrtq = Column(VARCHAR(50))
en_navgrl6m = Column(VARCHAR(50))
en_navgrts = Column(VARCHAR(50))
en_navgrl1y = Column(VARCHAR(50))
en_navgrt1y = Column(VARCHAR(50))
en_navgrlist = Column(VARCHAR(50))
l_isvalid = Column(NUMBER(1, 0, False))
d_updatetime = Column(DateTime)
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
def __str__(self):
return 'vc_pf_code' + '$*' + 'l_enddate'
class ThirdParty(Base):
__tablename__ = 'third_party'
id = Column(VARCHAR(36), primary_key=True)
third_party_name = Column(VARCHAR(255))
index_code = Column(NUMBER(asdecimal=False))
create_worker = Column(VARCHAR(36))
create_time = Column(DateTime)
latest_modify_worker = Column(VARCHAR(255))
latest_modify_time = Column(DateTime)
isvalid = Column(NUMBER(asdecimal=False))
bz1 = Column(NVARCHAR(255))
bz2 = Column(NVARCHAR(255))
bz3 = Column(NVARCHAR(255))
bz4 = Column(NVARCHAR(255))
bz = Column(NVARCHAR(255))
class TBscNontradingday(Base):
__tablename__ = 't_bsc_nontradingdays'
l_publish_date = Column(VARCHAR(50), primary_key=True, nullable=False)
vc_scode = Column(VARCHAR(20), primary_key=True, nullable=False)
vc_bond_code = Column(VARCHAR(16), nullable=False)
l_market = Column(VARCHAR(50), nullable=False)
vc_nontrading_reason = Column(VARCHAR(3), primary_key=True, nullable=False)
vc_nontrading_term = Column(VARCHAR(3))
is_section = Column(CHAR(1))
l_nontrading_begin = Column(VARCHAR(50), primary_key=True, nullable=False)
l_nontrading_end = Column(VARCHAR(50))
l_retrading_day = Column(VARCHAR(50))
d_updatetime = Column(DateTime, nullable=False)
vc_data_source = Column(VARCHAR(32), nullable=False)
d_src_updatetime = Column(DateTime, nullable=False)
l_source_id = Column(NUMBER(18, 0, False), nullable=False)
vc_md5 = Column(VARCHAR(32))
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
def __str__(self):
return str(self.l_nontrading_begin) + str(self.vc_scode) + str(
self.l_publish_date) + str(self.vc_nontrading_reason) + '$*' + str(
self.vc_md5)
class KeyValue(Base):
__tablename__ = 'key_value'
__table_args__ = {'comment': 'key-value???'}
id = Column(VARCHAR(50), primary_key=True, comment='??ID')
key = Column(NVARCHAR(64), comment='?')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
value = Column(Text, comment='?')
class GlobalObject(Base):
__tablename__ = 'global_object'
id = Column(NUMBER(9, 0, False), primary_key=True)
domain = Column(VARCHAR(255), nullable=False)
name = Column(VARCHAR(255), nullable=False)
data_source = Column(VARCHAR(255))
field_name = Column(VARCHAR(255))
class UserRelPosition(Base):
__tablename__ = 'user_rel_position'
__table_args__ = {'comment': '???????'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
user_id = Column(VARCHAR(36), comment='??ID')
position_id = Column(VARCHAR(36), comment='??ID')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
class DeptRelBranche(Base):
__tablename__ = 'dept_rel_branche'
__table_args__ = {'comment': '??????????'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
department_id = Column(VARCHAR(36), comment='??ID')
branche_id = Column(VARCHAR(36), comment='????ID')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
class VdiPrtUnderlyingAsset(Base):
__tablename__ = 'vdi_prt_underlying_asset'
key_prt_underlying_asset = Column(NUMBER(asdecimal=False),
primary_key=True)
una_ass_kind = Column(VARCHAR(30))
una_ass_code = Column(VARCHAR(30))
una_underlying_ass_kind = Column(VARCHAR(30))
una_underlying_ass_code = Column(VARCHAR(30))
una_start_date = Column(DateTime)
una_end_date = Column(DateTime)
una_share_par = Column(NUMBER(22, 7, True))
una_principal = Column(NUMBER(20, 5, True))
una_src_rec_key = Column(NUMBER(asdecimal=False))
una_rec_time = Column(DateTime)
def __str__(self):
return 'key_prt_underlying_asset'
class SyncLog(Base):
__tablename__ = 'sync_log'
__table_args__ = {'comment': '?????????'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
change_id = Column(VARCHAR(36), comment='????ID')
i_ok = Column(NUMBER(asdecimal=False), comment='?????? 1?? 0??')
errorinfo = Column(NVARCHAR(500), comment='????')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
class SyncService(Base):
__tablename__ = 'sync_service'
__table_args__ = {'comment': '??????'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
website_name = Column(NVARCHAR(64), comment='????')
service_url = Column(VARCHAR(256), comment='????')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
i_enable = Column(NUMBER(asdecimal=False), comment='???? 1?????? 0??')
class LoginPageHtml(Base):
__tablename__ = 'login_page_html'
__table_args__ = {'comment': '???HTML'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
web_html = Column(Text, comment='WEB?HTML')
app_html = Column(Text, comment='APP?HTML')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????\x13')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
login_page_id = Column(VARCHAR(36), index=True, comment='???Id')
class BorrowerConfig(Base):
__tablename__ = 'sl$borrower_config'
__table_args__ = {u'schema': 'SLPROD'}
table_tag = 'sl$'
id = Column(NUMBER(38), primary_key=True)
name = Column(VARCHAR2(150))
content = Column(CLOB)
access_group = Column(VARCHAR2(1024))
class PdfDoc(Base):
__tablename__ = 'pdf_doc'
__table_args__ = {'schema': 'decanatuser'}
pk = Column(NUMBER(asdecimal=False), primary_key=True)
fk_pdf_doc_type = Column(NUMBER(asdecimal=False),
nullable=False, index=True)
name = Column(VARCHAR(512), nullable=False)
body = Column(LargeBinary)
publish_date = Column(DateTime, nullable=False)
fk_decanat_user = Column(NUMBER(asdecimal=False), index=True)
hash = Column(VARCHAR(64), index=True, comment='хэш идентификатора')
fk_mime_type = Column(NUMBER(asdecimal=False), index=True, server_default=text("""\
1
"""), comment='тит документа')
minio_id = Column(VARCHAR(1024))
minio_cnt = Column(NUMBER(asdecimal=False), server_default=text("""\
0
"""))
def mapping_df_types(df):
dtypedict = {}
for i, j in zip(df.columns, df.dtypes):
if "object" in str(j):
dtypedict.update({i: VARCHAR(256)})
if "float" in str(j):
dtypedict.update({i: NUMBER(19, 8)})
if "int" in str(j):
dtypedict.update({i: VARCHAR(19)})
return dtypedict
class Position(Base):
__tablename__ = 'position'
__table_args__ = {'comment': '???'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
name = Column(NVARCHAR(64), comment='??')
p_department_id = Column(VARCHAR(36), comment='????ID')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
code = Column(NVARCHAR(64), comment='??')
type = Column(NUMBER(asdecimal=False), comment='???? 0 ???? 10?????')
class Role(Base):
__tablename__ = 'role'
__table_args__ = {'comment': '???'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
name = Column(NVARCHAR(64), comment='???')
classify = Column(NVARCHAR(64), comment='????')
i_default = Column(NUMBER(asdecimal=False), comment='?????? 0?? 1??')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz = Column(NVARCHAR(255), comment='??')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
class IfBusNonissuelockperiod(Base):
__tablename__ = 'if_bus_nonissuelockperiod'
l_fund_id = Column(NUMBER(10, 0, False), primary_key=True, nullable=False)
vc_report_code = Column(VARCHAR(16), primary_key=True, nullable=False)
vc_report_name = Column(VARCHAR(32))
l_begin_date = Column(NUMBER(8, 0, False), nullable=False)
l_end_date = Column(NUMBER(8, 0, False), nullable=False)
vc_type = Column(VARCHAR(32))
en_amount = Column(VARCHAR(50))
en_unitcost = Column(VARCHAR(50))
l_lockdays = Column(VARCHAR(50))
l_combi_id = Column(NUMBER(12, 0, False), primary_key=True, nullable=False)
l_date = Column(NUMBER(8, 0, False))
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
d_updatetime = Column(DateTime)
def __str__(self):
return 'vc_report_code' + '$*' + 'l_combi_id' + '$*' + 'l_fund_id'
class GroupBelongtoUser(Base):
__tablename__ = 'group_belongto_user'
__table_args__ = {'comment': '???????'}
id = Column(VARCHAR(36), primary_key=True, comment='??ID')
belongto_user_id = Column(VARCHAR(36), comment='????ID')
group_id = Column(VARCHAR(36), comment='??ID')
index_code = Column(NUMBER(asdecimal=False), comment='????')
create_worker = Column(VARCHAR(36), comment='???')
create_time = Column(DateTime, comment='????')
latest_modify_worker = Column(VARCHAR(36), comment='?????')
latest_modify_time = Column(DateTime, comment='??????')
isvalid = Column(NUMBER(asdecimal=False), comment='????')
bz1 = Column(NVARCHAR(255), comment='??1')
bz2 = Column(NVARCHAR(255), comment='??2')
bz3 = Column(NVARCHAR(255), comment='??3')
bz4 = Column(NVARCHAR(255), comment='??4')
i_creator = Column(NUMBER(asdecimal=False), comment='??????1?? 0???')
group_authority = Column(NUMBER(asdecimal=False),
comment='?????1???? 0????')
def factory_table_transaction(self, f_keys):
check = self._check_existing_table_in_metadata(
self.generate_table_name())
if check:
self.metadata.clear()
table_model = {
'__tablename__':
self.generate_table_name(),
'oid':
Column(NUMBER(),
Sequence(self.generate_sequence_name()),
primary_key=True),
'entity_oid':
Column(NUMBER(), primary_key=True)
}
for f_key in f_keys:
table_model.update({f_key + '_id_tr': Column(NUMBER())})
new_class = type(self.generate_class_name(), (self.Base, ),
table_model)
return new_class
class VGp3DepoActorinfo(Base):
__tablename__ = 'v_gp3_depo_actorinfo'
key_depo_actorinfo = Column(NUMBER(asdecimal=False), primary_key=True)
id_ass_code = Column(VARCHAR(30))
ass_sht_name = Column(VARCHAR(40))
id_act_code = Column(VARCHAR(8))
act_legal_country = Column(VARCHAR(13))
rec_time = Column(DateTime)
def __str__(self):
return 'key_depo_actorinfo'
class IfBusShenhqV5(Base):
__tablename__ = 'if_bus_shenhq_v5'
vc_securityid = Column(VARCHAR(8), primary_key=True, nullable=False)
vc_securityidsource = Column(VARCHAR(8))
vc_symbol = Column(VARCHAR(40))
vc_englishname = Column(VARCHAR(40))
en_securitytype = Column(NUMBER(8, 0, False))
en_prevclosepx = Column(VARCHAR(50))
en_openprice = Column(VARCHAR(50))
en_closepx = Column(VARCHAR(50))
en_numtrades = Column(NUMBER(20, 0, False))
en_totalvolumetrade = Column(VARCHAR(50))
en_totalvaluetrade = Column(VARCHAR(50))
d_updatetime = Column(DateTime, server_default=text("sysdate"))
l_date = Column(VARCHAR(50), primary_key=True, nullable=False)
vc_source = Column(VARCHAR(20))
vc_update_operater = Column(VARCHAR(20))
def __str__(self):
return 'l_date' + '$*' + 'vc_securityid'
