def set_upsert_data(): print("开始执行set_upsert_data") ms = MYSQL(MySQL_CONFIG1["HOST"], MySQL_CONFIG1["USER"], MySQL_CONFIG1["PASSWORD"], MySQL_CONFIG1["DB"]) try: sql = "INSERT INTO `test_flow`.`training`(`ts`, `code`, `total`, `forward_total`, `reverse_total`, `sum_flow`, `sum_inst`, `inst_num`, `max_inst`, `max_inst_ts`, `min_inst`, `min_inst_ts`) VALUES ( CURRENT_TIMESTAMP, 'code1', 310001, 50, 5, 48, 2222, 42, 55, '2020-05-01 00:09:00', 23, '2020-01-01 00:09:00')" ms.ExecuNoQuery(sql.encode('utf-8')) sql = "UPDATE `test_flow`.`training` set ts=CURRENT_TIMESTAMP " ms.ExecuNoQuery(sql.encode('utf-8')) except Exception: return
class CleanData(object): def __init__(self): self.ms = MYSQL(MySQL_CONFIG["HOST"], MySQL_CONFIG["USER"], MySQL_CONFIG["PASSWORD"], MySQL_CONFIG["DB"]) def clean_datasource_test_data(self): dss_sql = "delete from merce_dss where creator = 'admin' and name not like '%测试用%' " # print(dss_sql) try: self.ms.ExecuNoQuery(dss_sql) except TypeError as e: print('66666') def clean_dataset_test_data(self): dt_sql = "delete from merce_dataset where creator = 'admin' and name not like '%测试用%' and name like 'API_datasets%' " try: self.ms.ExecuNoQuery(dt_sql) except TypeError as e: print('66666')
def delete_autotest_datas(): print("------开始删除测试数据-------") ms = MYSQL(MySQL_CONFIG["HOST"], MySQL_CONFIG["USER"], MySQL_CONFIG["PASSWORD"], MySQL_CONFIG["DB"]) try: flow_sql = "delete from merce_flow where name like 'test%' or name like 'gjb%' or name like 'auto_api_test_%'" dataset_sql = "delete from merce_dataset where name like 'test%' or name like 'merce%' or name like 'sink%' or name like 'gjb_test_%' " schema_sql = "delete from merce_schema where name like 'test%' or name like 'apitest%' or name like 'gtest%'" tenant_sql = "delete from merce_tenant where name like 'api_tenants%' order by create_time desc limit 1" print("删除flow表测试数据 ", flow_sql) ms.ExecuNoQuery(flow_sql.encode('utf-8')) print("删除dataset表测试数据 ", dataset_sql) ms.ExecuNoQuery(dataset_sql.encode('utf-8')) print("删除schema表测试数据 ", schema_sql) ms.ExecuNoQuery(schema_sql.encode('utf-8')) print("删除tenant表测试数据 ", tenant_sql) ms.ExecuNoQuery(tenant_sql.encode('utf-8')) except: return #delete_autotest_datas()