def getsubmition_jenkinsjobs(testsubmitionid, jenkinsserverid): if jenkinsserverid: jenkinsserver = DAL_DictValue.getdatavaluebyid(jenkinsserverid) servername = jenkinsserver.DicDataName jsonjobs = JenkinsService.getjenkinsjobs(servername) else: jenkinsservers = DAL_DictValue.getdatavaluebytype("JenkinsServer") servername = jenkinsservers[0].DicDataName jsonjobs = JenkinsService.getjenkinsjobs(servername) result = list() for job in jsonjobs['jobs']: temp = dict() temp["text"] = job['name'] temp["memberid"] = job['url'] if testsubmitionid != 0: testsubmition = DAL_TestSubmition.gettestsubmition( testsubmitionid) if testsubmition.TPSJenkinsJobName == job['url']: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def getjenkinsjobs(serverid): servername = "" if serverid: jenkinsserver = DAL_DictValue.getdatavaluebyid(serverid) servername = jenkinsserver.DicDataName jsonjobs = JenkinsService.getjenkinsjobs(servername) else: jenkinsservers = DAL_DictValue.getdatavaluebytype("JenkinsServer") servername = jenkinsservers[0].DicDataName jsonjobs = JenkinsService.getjenkinsjobs(servername) return [(job['url'], job['name']) for job in jsonjobs['jobs']]
def get_scminfo(productnameid, user_dicdataname, password_dicdataname, coderoot_dicdataname): scm_user = str( DAL_DictValue.getdatavaluebydataname("SCMInfo", user_dicdataname).DicDataDesc) scm_password = str( DAL_DictValue.getdatavaluebydataname( "SCMInfo", password_dicdataname).DicDataDesc) scm_desc = str(DAL_TestProject.get_testproject(productnameid).TPKEY) scm_coderoot = str( DAL_DictValue.getdatavaluebydataname( "SCMInfo", coderoot_dicdataname).DicDataDesc) scm_info = SCMInfo(scm_user, scm_password, scm_coderoot + CommonHelper.get_slash() + scm_desc) return scm_info
def getplatform(self): platform = "--" platformobject = DAL_DictValue.getdatavaluebyid( self.testsubmition.TPSPlatform) if platformobject: platform = platformobject.DicDataName return platform
def getstatus(self): status = "--" statusobject = DAL_DictValue.getdatavaluebyid( self.testsubmition.TPSStatus) if statusobject: status = statusobject.DicDataName return status
def getproducttype(self): producttype = "--" producttypeobject = DAL_DictValue.getdatavaluebyid( self.testsubmition.TPSProductType) if producttypeobject: producttype = producttypeobject.DicDataName return producttype
def getqaemaillist(producttypeid, outputemaillist): qagroup = DAL_DictValue.getdatavaluebyid(producttypeid).DicDataDesc emaillist = outputemaillist for user in UserService.getusersbygroup(qagroup): if user.email in emaillist: pass else: emaillist.append(user.email) return emaillist
def get_browsers(self): browsers = "--" if self.autoagent.AAgentBrowser != "": browsers = "" browsers_list = eval(self.autoagent.AAgentBrowser) print(browsers_list) for browserid in browsers_list: browsers = browsers + DAL_DictValue.get_dataname_by_datavalue( "AutoTaskRuntime", browserid).DicDataName + " " # browsers=browsers[0,len(browsers)] return browsers
def getdefaultemailreciverlist(producttypeid,outputemaillist): qagroup = DAL_DictValue.getdatavaluebyid(producttypeid).DicDataDesc emaillist = outputemaillist if qagroup!="DevTest": emailconfig = TestJobService.getemaliconfig() emailstring = emailconfig['defautrecivers'] for email in emailstring.split(','): if email in emaillist: pass else: emaillist.append(email) return emaillist
def trigerjenkinsjob(submitionid): try: testSubmition = DAL_TestSubmition.gettestsubmition(submitionid) jenkinsserver = DAL_DictValue.getdatavaluebyid( testSubmition.TPSJenkinsServer).DicDataName joburl = testSubmition.TPSJenkinsJobName.replace( "http://" + jenkinsserver, '') joburl = joburl.replace("job", 'mpttrigger') urllist = joburl.split('/') newurl = "/" + urllist[1] + "/" + urllist[ 2] + "/build?mptjob=" + urllist[3] + "&mptid=" + str( submitionid) + "&" + testSubmition.TPSBuildParameters JenkinsService.trigerbuild(jenkinsserver, str(newurl).strip()) except Exception as ex: pass
def get_autotask_types(autotaskid): tasktypes = DAL_DictValue.getdatavaluebytype("AutoTaskType") result=list() for tasktype in tasktypes: temp=dict() temp["text"]=tasktype.DicDataName temp["memberid"]=tasktype.DicDataValue if autotaskid!=0: autotask=DAL_AutomationTask.get_automation_task(autotaskid) if tasktype.DicDataValue==autotask.TaskTpye: temp["selected"]=1 else: temp["selected"]=0 else: temp["selected"]=0 result.append(temp) return str(result).replace("u'","'")
def get_testjob_jobtypes(testjobid): avaliblejobtypes = DAL_DictValue.getdatavaluebytype("JobType") result=list() for dicdata in avaliblejobtypes: temp=dict() temp["text"]=dicdata.DicDataName temp["memberid"]=dicdata.id if testjobid!=0: testsubmition=DAL_TestJob.gettestjob(testjobid) if testsubmition.TJJobType==dicdata.id: temp["selected"]=1 else: temp["selected"]=0 else: temp["selected"]=0 result.append(temp) return str(result).replace("u'","'")
def get_testjob_status(testjobid): allstatus = DAL_DictValue.getdatavaluebytype("JobStatus").filter(DicDataDesc=1) result=list() for status in allstatus: temp=dict() temp["text"]=status.DicDataName temp["memberid"]=status.id if testjobid!=0: testjob=DAL_TestJob.gettestjob(testjobid) if status.id==testjob.TJStatus: temp["selected"]=1 else: temp["selected"]=0 else: temp["selected"]=0 result.append(temp) return str(result).replace("u'","'")
def get_autoagent_os(autoagentid): all_os = DAL_DictValue.getdatavaluebytype("AgentOSType") result = list() if autoagentid != 0: autoagent = DAL_AutoAgent.get_autoagent(autoagentid) for os in all_os: temp = dict() temp["text"] = os.DicDataName temp["memberid"] = os.DicDataValue if autoagentid != 0: if os.DicDataValue == autoagent.AOS: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_testsubmition_projecttype(testsubmitionid): avalibleprojecttypes = DAL_DictValue.getdatavaluebytype("ProjectType") result = list() for dicdata in avalibleprojecttypes: temp = dict() temp["text"] = dicdata.DicDataName temp["memberid"] = dicdata.id if testsubmitionid != 0: testsubmition = DAL_TestSubmition.gettestsubmition( testsubmitionid) if testsubmition.TPSProductType == dicdata.id: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_autotestconfig_types(autotestconfigid): tasktypes = DAL_DictValue.getdatavaluebytype("AutoTaskType") result = list() for tasktype in tasktypes: temp = dict() temp["text"] = tasktype.DicDataName temp["memberid"] = tasktype.DicDataValue if autotestconfigid != 0: autotestconfig = DAL_AutoTestConfig.get_autotest_config( autotestconfigid) if tasktype.DicDataValue == autotestconfig.TCFTaskTpye: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_testsubmition_platforms(testsubmitionid): allplatforms = DAL_DictValue.getdatavaluebytype("TestPlatform") result = list() for dicdata in allplatforms: temp = dict() temp["text"] = dicdata.DicDataName temp["memberid"] = dicdata.id if testsubmitionid != 0: testsubmition = DAL_TestSubmition.gettestsubmition( testsubmitionid) if testsubmition.TPSPlatform == dicdata.id: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_autorunresult_browsers(autorunresultid): all_browsers=DAL_DictValue.getdatavaluebytype("AutoTaskRuntime").filter(DicDataDesc='WEB') result=list() if autorunresultid!=0: autorunresult=DAL_AutoRunResult.get_autorunresult(autorunresultid) for browser in all_browsers: temp=dict() temp["text"]=browser.DicDataName temp["memberid"]=browser.DicDataValue if autorunresultid!=0: if browser.DicDataValue in eval(autorunresult.AAgentBrowser): temp["selected"]=1 else: temp["selected"]=0 else: temp["selected"]=0 result.append(temp) return str(result).replace("u'","'")
def get_autotestconfig_driver(autotestconfigid): alldrivers = DAL_DictValue.getdatavaluebytype("AutoAgentExecDriver") result = list() for driver in alldrivers: temp = dict() temp["text"] = driver.DicDataName temp["memberid"] = driver.id if autotestconfigid != 0: autotestconfig = DAL_AutoTestConfig.get_autotest_config( autotestconfigid) if driver.DicDataValue == autotestconfig.TCFExecuteDriver: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def getsubmition_jenkinsserver(testsubmitionid): alljenkinsservers = DAL_DictValue.getdatavaluebytype("JenkinsServer") result = list() for dicdata in alljenkinsservers: temp = dict() temp["text"] = dicdata.DicDataName temp["memberid"] = dicdata.id if testsubmitionid != 0: testsubmition = DAL_TestSubmition.gettestsubmition( testsubmitionid) if testsubmition.TPSJenkinsServer == dicdata.id: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_autotestconfig_testingenv(autotestconfigid): all_testenvs = DAL_DictValue.getdatavaluebytype("TestEnv") result = list() for env in all_testenvs: temp = dict() temp["text"] = env.DicDataName temp["memberid"] = env.id if autotestconfigid != 0: autotestconfig = DAL_AutoTestConfig.get_autotest_config( autotestconfigid) if autotestconfig.TCFTestingEnv and env.DicDataValue == int( autotestconfig.TCFTestingEnv): temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_autotestconfig_browsers(autotestconfigid): all_browsers = DAL_DictValue.getdatavaluebytype( "AutoTaskRuntime").filter(DicDataDesc='WEB') result = list() if autotestconfigid != 0: autotestconfig = DAL_AutoTestConfig.get_autotest_config( autotestconfigid) for browser in all_browsers: temp = dict() temp["text"] = browser.DicDataName temp["memberid"] = browser.DicDataValue if autotestconfigid != 0 and autotestconfig.TCFBrowser: if browser.DicDataValue in eval(autotestconfig.TCFBrowser): temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_autotestconfig_os(autotestconfigid): all_os = DAL_DictValue.getdatavaluebytype("AutoTaskRuntime").filter( DicDataDesc='APP') result = list() if autotestconfigid != 0: autotestconfig = DAL_AutoTestConfig.get_autotest_config( autotestconfigid) for os in all_os: temp = dict() temp["text"] = os.DicDataName temp["memberid"] = os.DicDataValue print(temp) if autotestconfigid != 0: if os.DicDataValue == autotestconfig.TCFOS: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def get_autotestconfig_osversion(autotestconfigid, osid): osname = DAL_DictValue.get_dataname_by_datavalue( "AutoTaskRuntime", osid).DicDataName if osname == "Android": mobiledevice = DAL_AutoMobileDevice.get_device_byos("android") else: mobiledevice = DAL_AutoMobileDevice.get_device_byos("ios") result = list() for device in mobiledevice: temp = dict() temp["text"] = device.MDOSVersion temp["value"] = device.MDOSVersion if autotestconfigid != 0: autotestconfig = DAL_AutoTestConfig.get_autotest_config( autotestconfigid) if device.MDOSVersion == autotestconfig.TCFOSVersion: temp["selected"] = 1 else: temp["selected"] = 0 else: temp["selected"] = 0 result.append(temp) return str(result).replace("u'", "'")
def getdicvaluebyid(id): dicdata = DAL_DictValue.getdatavaluebyid(id) if dicdata: return dicdata.DicDataName else: return "--"
def get_status(self): return DAL_DictValue.get_dataname_by_datavalue( "AutoAgentStatus", self.autoagent.AStatus).DicDataName
def get_os(self): agent_os = "--" if self.autoagent.AOS != 0: agent_os = DAL_DictValue.get_dataname_by_datavalue( "AgentOSType", self.autoagent.AOS).DicDataName return agent_os
def get_job_types(): avalibleprojecttypes = DAL_DictValue.getdatavaluebytype("JobType") return [(project.id, project.DicDataName) for project in avalibleprojecttypes]
def get_jobs_status(): allstatus = DAL_DictValue.getdatavaluebytype("JobStatus").filter(DicDataDesc=1) # allstatus=[(48,'暂停'),(50,'未来任务'),(51,'排队中')] return [(status.id, status.DicDataName) for status in allstatus]
def getemaliconfig(): result = {} allconfigs = DAL_DictValue.getdatavaluebytype("EmailConfig") for config in allconfigs: result[config.DicDataDesc] = config.DicDataName return result