def getCaseIds(self, args):
logger.info(inspect.stack()[0][3])
sql = TestCaseSQLMapper().getSQL(inspect.stack()[0][3])
logger.info(sql)
logger.info(args)
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def editApplication(self, args):
logger.info(inspect.stack()[0][3])
sql = ApplicationSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
logger.info(sql)
logger.info(args)
return daoOperate.write()
def addEnvironmentItem(self, args):
#实例化
logger.info(inspect.stack()[0][3])
sql = EnvironmentSQLMapper().getSQL(inspect.stack()[0][3])
logger.error(sql)
logger.error(args)
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def getInterfaceInfosByProject(self, args):
#实例化
logger.info(inspect.stack()[0][3])
sql = InterfaceSQLMapper().getSQL(inspect.stack()[0][3])
# logger.error(sql)
# logger.error(args)
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def addTestCaseContent(
self,
args,
):
logger.info(inspect.stack()[0][3])
sql = TestCaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def updateTestInstance(self, args):
logger.info(inspect.stack()[0][3])
sql = TestInstanceSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def setWebApiDiff(self, args):
logger.info(inspect.stack()[0][3])
sql = WebApiSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def getWebApiForVersion(self, args):
#实例化
logger.info(inspect.stack()[0][3])
sql = WebApiSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def editGroup(self, args):
logger.info(inspect.stack()[0][3])
sql = GroupSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def getWaitingTaskInfos(self, args):
#实例化
logger.info(inspect.stack()[0][3])
sql = TaskMetaqInfoSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def getTableGroupRelationList(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def SynchronizeDatabase(self, args):
# todo 没有sql
daoOperate = DbBaseHelper()
return daoOperate.read()
def getTableComment(self, args, **kwargs):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read(**kwargs)
def getSynchronizeColumn(self, args, **kwargs):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read(**kwargs)
def isInitSynchronize(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def addTableGroupRelation(self, args, is_execute_many=False):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args, is_execute_many)
return daoOperate.write()
def deleteTableGroupRelation(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def getSearchByColumnRemark(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def addTaskInfo(self, args):
#实例化
logger.info(inspect.stack()[0][3])
sql = TaskMetaqInfoSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def deleteColumnLink(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def updateTaskStatus(self, args):
logger.info(inspect.stack()[0][3])
sql = TaskMetaqInfoSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def getDatabasePwdById(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def getGroupInfoByParentGroupId(self, args):
logger.info(inspect.stack()[0][3])
sql = GroupSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def getColumnListByColName(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def getWebApiInfosForCase(self, args):
logger.info(inspect.stack()[0][3])
sql = WebApiSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def getViewLinksByGroup(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def getTestInstanceInfoById(self, args):
logger.info(inspect.stack()[0][3])
sql = TestInstanceSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.read()
def editDatabase(self, args):
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
def __execTaskCaseJob(caseId,userId=None,envConfig=False,requestObject=None,init=False, \
instanceId=None,caseName=None):
if not envConfig:
caseInfo = TestCaseDaoInterface().getCaseInfosById(
{"caseId", caseId})
if caseInfo.getSuccess() and len(caseInfo.getMessage()) > 0:
envId = caseInfo.getMessage()[0].get("envid")
envResult = EnvironmentDaoInterface().getEnvironmentInfoById(
{"envId": envId})
if envResult.getSuccess() and len(envResult.getMessage()) <= 0:
logger.error(
"Test envId [{0}]:No env config".format(envId))
return
envConfig = envResult[0]
else:
return
if init:
saveSession = False
elif requestObject is not None:
saveSession = False
else:
saveSession = True
exec_start_flag = time.time()
exec_start = datetime.datetime.now()
contentResult = CaseContentDaoInterface().getContentInfosByCaseId(
caseId)
Presult = {}
statusFlag = True
if contentResult.getSuccess() and len(contentResult.getMessage()) > 0:
for content in sorted(contentResult.getMessage(),
key=attrgetter('step')):
#TODO "DATARESULT" + STEP
response = None
#request api
if content.get("type") == 0:
if envConfig.get("datatemplate").endswith("/"):
url = envConfig.get("datatemplate")[:-1] + content.get(
"url")
else:
url = envConfig.get("datatemplate") + content.get(
"url")
params = TaskCenterService.__rendeTemplate(
content.get("request_params"),
envConfig.get("datatemplate"), Presult)
requestUtil = RequestBase(url=url,
method=content.get("method"),
format=content.get("format"),
params=params,
object=requestObject,
userId=userId,
saveSession=saveSession)
response, obj = requestUtil.route()
try:
response = json.loads(response)
except Exception as e:
logger.warn(
"return result is not json:{0} Exception:{1}".
format(response, e))
#request sql
elif content.get("type") == 1:
dbConfig = {}
dbConfig.setdefault("db", envConfig.get("dbname"))
dbConfig.setdefault("host", envConfig.get("dbhostname"))
dbConfig.setdefault("user", envConfig.get("dbusername"))
dbConfig.setdefault("passwd", envConfig.get("dbpasswd"))
dbConfig.setdefault("port", envConfig.get("dbport"))
dbUtil = DbBaseHelper()
response = dbUtil.execReadOnlySQL(
dbConfig,
TaskCenterService.__rendeTemplate(
content.get("sqlcontent"),
envConfig.get("datatemplate"), Presult, False))
Presult.setdefault("DATAREAULT" + str(content.get("step")),
response)
#assert
assertResult = AssertDaoInterface().getAssertInfosByContentId(
content.get("id"))
if assertResult.getSuccess():
for assertInfo in assertResult:
result = TaskCenterService.__execAssertJob(
eval("Presult." + assertInfo.get("actual")),
assertInfo.get("expect"),
assertInfo.get("assert_type"))
if not result.getSuccess():
statusFlag = False
break
if saveSession:
exec_end_flag = time.time()
exec_end = datetime.datetime.now()
if statusFlag:
status = "Success"
else:
status = "Failed"
#caseResult
caseResultInfo = {}
caseResultInfo.setdefault("instanceid", instanceId)
caseResultInfo.setdefault("caseid", caseId)
caseResultInfo.setdefault("casename", caseName)
caseResultInfo.setdefault("runtime",
exec_end_flag - exec_start_flag)
caseResultInfo.setdefault("exec_start", exec_start)
caseResultInfo.setdefault("exec_end", exec_end)
caseResultInfo.setdefault("status", status)
caseResultInfo.setdefault("messaga", response)
caseResultInfo.setdefault("remarks", None)
CaseResultDaoInterface().addCaseResult(caseResultInfo)
dataResult = DataResult()
dataResult.setSuccess(statusFlag)
if init:
dataResult.setMessage(obj)
else:
dataResult.setMessage(status)
return dataResult
def editDatabasePwdById(self, args):
logger.info(inspect.stack()[0][3])
sql = DatabaseSQLMapper().getSQL(inspect.stack()[0][3])
daoOperate = DbBaseHelper(sql, args)
return daoOperate.write()
