def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_MT_DCE_POSITION_PZ'
self.db.set_metadata(self.table_name, [
PyDB.DateField('datadate', is_key=True),
PyDB.StringField('pinzhongid', is_key=True),
PyDB.StringField('datatype', is_key=True),
PyDB.IntField('rank', is_key=True),
PyDB.StringField('account'),
PyDB.IntField('vol'),
PyDB.IntField('chg'),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_310_Team'
self.db.set_metadata(self.table_name, [
PyDB.IntField("leagueid", is_key=True),
PyDB.IntField("teamid", is_key=True),
PyDB.StringField("teamnames"),
PyDB.StringField("teamnamec"),
PyDB.StringField("teamnameeng"),
PyDB.IntField("unknowid"),
PyDB.DateField("update_dt"),
PyDB.StringField("source"),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_310_COMPETITION'
self.db.set_metadata(self.table_name, [
PyDB.IntField("gameId", is_key=True),
PyDB.StringField("competitiongroups"),
PyDB.StringField("competitiongroupc"),
PyDB.StringField("competitiongroupe"),
PyDB.IntField("continentsid"),
PyDB.StringField("leaguegroups"),
PyDB.StringField("leaguegroupc"),
PyDB.StringField("leaguegroupe"),
PyDB.IntField("leaguegroupid"),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_TRADE_CALENDAR'
self.db.set_metadata(self.table_name, [
PyDB.StringField('tradingcalendar', is_key=True),
PyDB.DateField('tradingday', is_key=True),
PyDB.IntField('flag'),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_310_LEAGUE1'
self.db.set_metadata(self.table_name, [
PyDB.IntField("leagueid", is_key=True),
PyDB.StringField("leaguenames"),
PyDB.StringField("leaguenamec"),
PyDB.StringField("leaguenameeng"),
PyDB.StringField("season"),
PyDB.IntField("sumround"),
PyDB.IntField("currentround"),
PyDB.StringField("leagua"),
PyDB.StringField("leaguaeng"),
PyDB.StringField("leaguedesc"),
PyDB.DateField("update_dt"),
PyDB.StringField("source"),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_PUOK_STEEL'
self.db.set_metadata(self.table_name, [
PyDB.DateField("datadate"),
PyDB.IntField("pageid", is_key=True),
PyDB.StringField("data_type"),
PyDB.StringField("news_contents"),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 't_bm_pages'
self.db.set_metadata(self.table_name, [
PyDB.StringField("url_hash", is_key=True),
PyDB.StringField("url", is_key=True),
PyDB.IntField('status'),
PyDB.DatetimeField("create_time"),
PyDB.DatetimeField('update_time'),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'T_SPORTTERY_LOSEMATCHID'
self.db.set_metadata(self.table_name, [
PyDB.IntField("matchid"),
PyDB.StringField("spidername"),
PyDB.StringField("tablename"),
PyDB.StringField("url", is_key=True),
PyDB.StringField("losereason"),
])
def __init__(self, db_url):
self.db = self.build_connection(db_url)
self.table_name = 'etl_log.Etl_Log_Stg'
self.db.set_metadata(self.table_name, [
PyDB.StringField("source_name", is_key=True),
PyDB.StringField("target_table", is_key=True),
PyDB.DatetimeField("start_dt"),
PyDB.DatetimeField('end_dt'),
PyDB.IntField('data_row'),
PyDB.StringField('is_successful'),
PyDB.StringField('log_desc'),
PyDB.DatetimeField('datetime_stamp'),
])