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'), ])