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