def test_number_types( self, metadata, connection, ): specs = [(Numeric(5, 2), NUMBER(5, 2)), (NUMBER, NUMBER())] self._run_test(metadata, connection, specs, ["precision", "scale"])
class TBscIbmminfo(Base): __tablename__ = 't_bsc_ibmminfo' vc_company_code = Column(VARCHAR(8), primary_key=True) l_declare_date = Column(NUMBER(8, 0, False), nullable=False) l_begin_date = Column(NUMBER(8, 0, False), nullable=False) l_end_date = Column(NUMBER(8, 0, False)) vc_ibmm_no = Column(VARCHAR(20), nullable=False) vc_ibmm_name = Column(VARCHAR(200), nullable=False) vc_ibmm_sname = Column(VARCHAR(100)) vc_ibmm_type = Column(VARCHAR(50)) c_status = Column(CHAR(1)) 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) c_del = Column(CHAR(1)) vc_md5 = Column(VARCHAR(32)) vc_source = Column(VARCHAR(20)) vc_update_operater = Column(VARCHAR(20)) l_delete = Column(NUMBER(scale=0, asdecimal=False), server_default=text("0")) def __str__(self): return str(self.vc_company_code) + '$*' + str(self.vc_md5)
class MdBscSecuritycomp(Base): __tablename__ = 'md_bsc_securitycomp' l_publish_date = Column(NUMBER(scale=0, asdecimal=False), primary_key=True, nullable=False) vc_scode = Column(VARCHAR(20), primary_key=True, nullable=False) vc_stock_code = Column(VARCHAR(16), nullable=False) l_market = Column(NUMBER(scale=0, asdecimal=False), nullable=False) vc_relation_type = Column(VARCHAR(32), primary_key=True, nullable=False) vc_relation_code = Column(VARCHAR(20), primary_key=True, nullable=False) l_relation_market = Column(NUMBER(scale=0, asdecimal=False), primary_key=True, nullable=False) l_begin_date = Column(NUMBER(scale=0, asdecimal=False)) l_end_date = Column(NUMBER(scale=0, asdecimal=False)) c_enable = Column(CHAR(1), nullable=False) d_updatetime = Column(DateTime, nullable=False) def __str__(self): return str(self.l_publish_date) + str(self.vc_scode) + str( self.vc_relation_type) + str(self.vc_relation_code) + str( self.l_relation_market) + '$*' + str(self.vc_stock_code) + str( self.l_market) + str(self.l_begin_date) + str( self.l_end_date) + str(self.c_enable) + str( self.d_updatetime)
class TBscInvestmentAdvice(Base): __tablename__ = 't_bsc_investment_advice' vc_code = Column(VARCHAR(200)) vc_sname = Column(VARCHAR(200), primary_key=True) l_issue_date = Column(NUMBER(scale=0, asdecimal=False)) vc_issuer_name = Column(VARCHAR(200)) vc_guarantor = Column(VARCHAR(200)) en_issue_amount = Column(VARCHAR(200)) vc_duration = Column(VARCHAR(200)) vc_uwrtname = Column(VARCHAR(2000)) vc_creditrate = Column(VARCHAR(200)) vc_ratecomname = Column(VARCHAR(200)) vc_inner_creditrate = Column(VARCHAR(200)) vc_rate_operator = Column(VARCHAR(200)) vc_industry_name = Column(VARCHAR(200)) vc_interest_interval = Column(VARCHAR(4000)) vc_market_rate = Column(VARCHAR(200)) vc_star_level = Column(VARCHAR(200)) vc_advice_type = Column(VARCHAR(200)) vc_advice_rate = Column(VARCHAR(200)) vc_investment_advice = Column(VARCHAR(4000)) vc_referral = Column(VARCHAR(200)) vc_floor_price = Column(VARCHAR(200)) b_in_bondpool = Column(VARCHAR(200)) b_holiday = Column(VARCHAR(200)) vc_bond_type = Column(VARCHAR(200)) vc_market = Column(VARCHAR(200)) b_pledged = Column(VARCHAR(200)) d_bid_begintime = Column(VARCHAR(200)) d_bid_endtime = Column(VARCHAR(200)) vc_fundamental = Column(VARCHAR(4000)) vc_primary_rating = Column(VARCHAR(200), nullable=False) l_date = Column(NUMBER(20, 8, True))
class TLogDqc(Base): __tablename__ = 't_log_dqc' l_serial_no = Column(NUMBER(asdecimal=False), primary_key=True) vc_target_table = Column(VARCHAR(64)) c_module = Column(CHAR(1)) l_level = Column(NUMBER(scale=0, asdecimal=False)) l_kind = Column(NUMBER(scale=0, asdecimal=False)) vc_msg = Column(VARCHAR(4000)) c_deal_flag = Column(CHAR(1)) vc_query_sql = Column(VARCHAR(4000)) d_updatetime = Column(DateTime, server_default=text("sysDATE")) l_date = Column(NUMBER(8, 0, False)) vc_col_code = Column(VARCHAR(32)) l_dict_id = Column(NUMBER(scale=0, asdecimal=False)) vc_err_code = Column(VARCHAR(64)) vc_memo = Column(VARCHAR(1000)) vc_second_class_name = Column(VARCHAR(240)) vc_workflow_name = Column(VARCHAR(240)) vc_workflow_name_cn = Column(VARCHAR(240)) l_workflow_runid = Column(NUMBER(scale=0, asdecimal=False)) l_tabrule_id = Column(NUMBER(scale=0, asdecimal=False)) c_mail_flag = Column(CHAR(1)) l_task_id = Column(NUMBER(scale=0, asdecimal=False)) l_object_id = Column(NUMBER(scale=0, asdecimal=False))
def test_number_types(self): specs = [ ( Numeric(5, 2), NUMBER(5, 2), ), ( NUMBER, NUMBER(), ), ] self._run_test(specs, ['precision', 'scale'])
class IfBscSecurityst(Base): __tablename__ = 'if_bsc_securityst' vc_scode = Column(VARCHAR(20), primary_key=True, nullable=False) vc_stock_code = Column(VARCHAR(16), nullable=False) l_market = Column(NUMBER(scale=0, asdecimal=False), nullable=False) l_st_type = Column(NUMBER(scale=0, asdecimal=False), primary_key=True, nullable=False) l_st_date = Column(NUMBER(scale=0, asdecimal=False), primary_key=True, nullable=False) l_endst_date = Column(NUMBER(scale=0, asdecimal=False)) d_updatetime = Column(DateTime, nullable=False) vc_source = Column(VARCHAR(20)) vc_update_operater = Column(VARCHAR(20)) l_delete = Column(NUMBER(scale=0, asdecimal=False), server_default=text("0")) def __str__(self): return 'l_st_type'+'$*'+ 'vc_scode'+'$*'+ 'l_st_date'
class Tstockinfo(Base): __tablename__ = 'tstockinfo' 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(NUMBER(asdecimal=False)) 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(NUMBER(16, 8, True)) l_publish_date = Column(NUMBER(8, 0, False)) l_turnover_date = Column(NUMBER(8, 0, False)) l_total_lock_day = Column(NUMBER(scale=0, asdecimal=False)) l_left_lock_days = Column(NUMBER(scale=0, asdecimal=False)) vc_assign_code = Column(VARCHAR(20)) def __str__(self): return 'l_date' + '$*' + 'vc_inter_code'
class TBusShengb(Base): __tablename__ = 't_bus_shengb' gblb = Column(VARCHAR(8), primary_key=True) gbdm1 = Column(VARCHAR(16)) gbdm2 = Column(VARCHAR(32)) gbsl = Column(NUMBER(17, 2, True)) gbrq1 = Column(VARCHAR(8)) gbrq2 = Column(VARCHAR(8)) gbbl = Column(NUMBER(19, 13, True)) gbje1 = Column(NUMBER(18, 3, True)) gbje2 = Column(NUMBER(18, 3, True)) gbzd = Column(VARCHAR(100)) gbrq = Column(VARCHAR(8)) gbdm3 = Column(VARCHAR(32)) gbbz1 = Column(CHAR(1)) gbbz2 = Column(CHAR(1)) gbbzsm = Column(VARCHAR(100)) gbsl2 = Column(NUMBER(17, 2, True)) gbbl2 = Column(NUMBER(19, 13, True)) gbrq3 = Column(VARCHAR(8)) gbrq4 = Column(VARCHAR(8)) d_updatetime = Column(DateTime) def __str__(self): return str(self.gblb) + '$*' + str(self.vc_md5)
class TBusPledgedrepoPool(Base): __tablename__ = 't_bus_pledgedrepo_pool' l_date = Column(VARCHAR(40), primary_key=True, nullable=False) l_market = Column(VARCHAR(40), primary_key=True, nullable=False) vc_code = Column(VARCHAR(8), primary_key=True, nullable=False) vc_scode = Column(VARCHAR(16)) vc_name = Column(VARCHAR(100)) vc_type = Column(VARCHAR(14)) en_stand_code = Column(NUMBER(asdecimal=False)) vc_md5 = Column(VARCHAR(32)) def __str__(self): return str(self.l_market) + str(self.vc_code) + str( self.l_date) + '$*' + str(self.vc_md5)
class TMP_TM_CODEXD(db.Model): __tablename__ = "TMP_TM_CODEXD" __table_args__ = {'schema': DB_OWNER} Column('COMM_CODE', NVARCHAR(30), primary_key=True) Column('COMD_CODE', NVARCHAR(30), primary_key=True) Column('COMD_CDNM', NVARCHAR(200), nullable=False) Column('COMD_ENNM', NVARCHAR(100)) Column('CRTE_DATE', NVARCHAR(8), default="20170113") Column('REF1_FILD', NVARCHAR(100)) Column('REF2_FILD', NVARCHAR(100)) Column('REF3_FILD', NVARCHAR(100)) Column('REF4_FILD', NVARCHAR(100)) Column('SORT_ORDR', NUMBER(precision=5, scale=0, asdecimal=False)) Column('INST_USID', NVARCHAR(30), default="ADMIN") Column('INST_DATE', default=db.func.current_timestamp()) Column('UPDT_USID', NVARCHAR(30), default="ADMIN") Column('UPDT_DATE', default=db.func.current_timestamp(), onupdate=db.func.current_timestamp())
class IfBscNtsLiqDi(Base): __tablename__ = 'if_bsc_nts_liq_dis' l_date = Column(NUMBER(scale=0, asdecimal=False), primary_key=True) vc_scode = Column(VARCHAR(22)) vc_code = Column(VARCHAR(20)) l_market = Column(NUMBER(scale=0, asdecimal=False)) l_end_date = Column(NUMBER(scale=0, asdecimal=False)) l_publish_date = Column(NUMBER(scale=0, asdecimal=False)) vc_type_name = Column(VARCHAR(200)) vc_type_code = Column(VARCHAR(50)) l_ltshare_date = Column(NUMBER(scale=0, asdecimal=False)) en_risk = Column(NUMBER(asdecimal=False)) d_updatetime = Column(DateTime) vc_data_source = Column(VARCHAR(10))
class TMP_TM_CODEXH(db.Model): __tablename__ = "TMP_TM_CODEXH" __table_args__ = {'schema': DB_OWNER} Column('COMM_CODE', NVARCHAR(30), primary_key=True) Column('COMM_CDNM', NVARCHAR(100), nullable=False) Column('SYST_CODE', NVARCHAR(6)) Column('CDGB_CODE', NVARCHAR(6)) Column('COCD_LNTH', NUMBER(precision=5, scale=0, asdecimal=False)) Column('RE1F_DESC', NVARCHAR(100)) Column('RE1T_CODE', NVARCHAR(6)) Column('RE2F_DESC', NVARCHAR(100)) Column('RE2T_CODE', NVARCHAR(6)) Column('RE3F_DESC', NVARCHAR(100)) Column('RE3T_CODE', NVARCHAR(6)) Column('RE4F_DESC', NVARCHAR(100)) Column('RE4T_CODE', NVARCHAR(6)) Column('INST_USID', NVARCHAR(30), default="ADMIN") Column('INST_DATE', default=db.func.current_timestamp()) Column('UPDT_USID', NVARCHAR(30), default="ADMIN") Column('UPDT_DATE', default=db.func.current_timestamp(), onupdate=db.func.current_timestamp())
class TBscNtsLiqDi(Base): __tablename__ = 't_bsc_nts_liq_dis' l_date = Column(NUMBER(scale=0, asdecimal=False), primary_key=True) vc_scode = Column(VARCHAR(22)) vc_code = Column(VARCHAR(20)) l_market = Column(NUMBER(scale=0, asdecimal=False)) l_end_date = Column(NUMBER(scale=0, asdecimal=False)) l_publish_date = Column(NUMBER(scale=0, asdecimal=False)) vc_type_name = Column(VARCHAR(200)) vc_type_code = Column(VARCHAR(50)) l_ltshare_date = Column(NUMBER(scale=0, asdecimal=False)) en_risk = Column(NUMBER(asdecimal=False)) d_updatetime = Column(DateTime) vc_data_source = Column(VARCHAR(10)) def __str__(self): return str(self.l_date)+'$*'+str(self.vc_md5)
def test_number_types(self): specs = [(Numeric(5, 2), NUMBER(5, 2)), (NUMBER, NUMBER())] self._run_test(specs, ["precision", "scale"])