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'