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