def __get_table_list(self): self.table['record'] = [] self.table['result'] = [] manager = MySQLManager(setting.configure) data_set = manager.query('show tables;') for table in data_set: if Convert.date_match(setting.date['start_time'], setting.date['end_time'], table[0]): if Convert.re_match_record_table.match(table[0]): self.table['record'].append(table[0]) if Convert.re_match_result_table.match(table[0]): self.table['result'].append(table[0])
class Task(Thread): def __init__(self, pool, configure=None, sql=None, func=None, kwargs=None): Thread.__init__(self) self.db = MySQLManager(configure) self.pool = pool self.sql = sql self.function = func self.kwargs = kwargs def run(self): cursor = self.db.get_cursor() cursor.execute(self.sql) if self.function is not None: self.function(cursor, self.db, **self.kwargs) if self.db is not None: self.db.close()
def __init__(self, pool, configure=None, sql=None, func=None, kwargs=None): Thread.__init__(self) self.db = MySQLManager(configure) self.pool = pool self.sql = sql self.function = func self.kwargs = kwargs