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
