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()
