def pre_test(self): nameList = mysqlCon().searchMysql() self.log_info(self.casedata) self.assert_("已确定无%s的账号信息:", mysqlCon().existName(nameList, self.casedata)) self.log_info("已确定无%s的账号信息" % self.casedata) self.url = urlInfo()
def run_test(self): baseGo = modelFieldInfo() ModelFieldNew = baseGo.nameRandom() ModelFieldNameUpdate = baseGo.nameRandom() baseGo.creatID(ModelFieldNew) resMql = mysqlCon().comMysql( "SELECT field_id FROM custom_content_model_field ORDER BY field_id desc LIMIT 1" ) ModelFieldId = resMql[0][0] findNewRes = baseGo.FindID(ModelFieldId) self.assert_("创建ModelField是否成功", findNewRes["data"]["fieldName"] == ModelFieldNew) self.log_info("成功创建ModelField名称:%s,ModelFieldID:%s" % (ModelFieldNew, ModelFieldId)) baseGo.update(ModelFieldId, ModelFieldNameUpdate) findNewRes = baseGo.AccurateSearch(ModelFieldId) self.assert_( "修改程序是否成功", findNewRes["data"]["fieldName"] == ModelFieldNameUpdate) # 验证是否修改 self.log_info("成功执行修改程序,修改指定id的Name") baseGo.delete(ModelFieldId) mysqlCon().comMysql( "DELETE FROM custom_content_model_field WHERE field_id = %s" % ModelFieldId) resMql = mysqlCon().comMysql( "SELECT * FROM custom_content_model_field WHERE field_id = %s" % ModelFieldId) self.assert_("指定id是否已经被清理", (len(resMql) == 0))
def run_test(self): baseGo = SiteInfo() siteNew = baseGo.nameRandom() siteNameUpdate = baseGo.nameRandom() baseGo.creatID(siteNew) res = baseGo.FindID() siteId = res["data"]["list"][0]["appId"] findNewRes = baseGo.AccurateSearch(siteId) self.assert_("创建site是否成功", findNewRes["data"]["appTitle"] == siteNew) self.log_info("成功创建site名称:%s,siteId:%s" % (siteNew, siteId)) baseGo.update(siteId,siteNameUpdate) findNewRes = baseGo.AccurateSearch(siteId) self.assert_("修改程序是否成功", findNewRes["data"]["appTitle"] == siteNameUpdate) # 验证是否修改 self.log_info("成功执行修改程序,修改指定id的Name") enp = baseGo.delete(siteId) res = re.findall("cn.fy.common.exception.ResultException: (.+)", enp) self.assert_("删除功能权限是否开放", res[0] == '该操作危险,系统暂不开放') mysqlCon().comMysql("DELETE FROM site_app WHERE app_id = %s" % siteId) resMql = mysqlCon().comMysql("SELECT * FROM site_app WHERE app_id = %s" % siteId) self.log_info(resMql) self.assert_("指定id是否已经被清理", (len(resMql) == 0))
def run_test(self): baseGo = dictGroup() pageNew = baseGo.nameRandom() pageNameUpdate = baseGo.nameRandom() baseGo.creatID(pageNew) res = baseGo.FindID() self.log_info(res) pageId = res["data"]["list"][-1]["groupId"] findNewRes = baseGo.AccurateSearch(pageId) self.assert_("创建page是否成功", findNewRes["data"]["groupCode"] == pageNew) self.log_info("成功创建page名称:%s,modelID:%s" % (pageNew, pageId)) baseGo.update(pageId, pageNameUpdate) findNewRes = baseGo.AccurateSearch(pageId) self.assert_( "修改程序是否成功", findNewRes["data"]["groupCode"] == pageNameUpdate) # 验证是否修改 self.log_info("成功执行修改程序,修改指定id的Name") baseGo.delete(pageId) mysqlCon().comMysql( "DELETE FROM custom_dict_group WHERE group_id = %s" % pageId) resMql = mysqlCon().comMysql( "SELECT * FROM custom_dict_group WHERE group_id = %s" % pageId) print(resMql) self.assert_("指定id是否已经被清理", (len(resMql) == 0))
def run_test(self): baseGo = modelInfo() modelNew = baseGo.nameRandom() modelNameUpdate = baseGo.nameRandom() baseGo.creatID(modelNew) res = baseGo.FindID() modelId = res["data"]["list"][0]["modelId"] findNewRes = baseGo.AccurateSearch(modelId) self.assert_("创建model是否成功", findNewRes["data"]["modelName"] == modelNew) self.log_info("成功创建model名称:%s,modelID:%s" % (modelNew, modelId)) baseGo.update(modelId, modelNameUpdate) findNewRes = baseGo.AccurateSearch(modelId) self.assert_( "修改程序是否成功", findNewRes["data"]["modelName"] == modelNameUpdate) # 验证是否修改 self.log_info("成功执行修改程序,修改指定id的Name") # baseGo.delete(modelId) mysqlCon().comMysql( "DELETE FROM custom_content_model WHERE model_id = %s" % modelId) resMql = mysqlCon().comMysql( "SELECT * FROM custom_content_model WHERE model_id = %s" % modelId) self.assert_("指定id是否已经被清理", (len(resMql) == 0))
def run_test(self): baseGo = reviewInfo() #上传文件至网页端目录 enpPath = baseGo.upfilisBatch(settings.PROJECT_ROOT_DIR + r"\resources\FIles\pingLun.xlsx") #上传评论到网页 res = baseGo.importDo(enpPath) self.comparsion("批量创建评论", res["msg"] == "执行成功") #清理data数据,以test开头的评论 sql = 'DELETE FROM review_reviews WHERE content LIKE "test%"' mysqlCon().comMysql(sql) pass
def run_test(self): baseGo = self.baseGo modelNew = baseGo.nameRandom() modelNameUpdate = baseGo.nameRandom() baseGo.creatID(modelNew) res = baseGo.FindID() self.log_info(res) modelId = res["data"]["list"][0]["id"] findNewRes = baseGo.AccurateSearch(modelId) self.assert_("创建model是否成功", findNewRes["data"]["keywords"] == modelNew) self.log_info("成功创建model名称:%s,modelID:%s" % (modelNew, modelId)) baseGo.update(modelId, modelNameUpdate) findNewRes = baseGo.AccurateSearch(modelId) self.log_info("修改后的model:%s" % findNewRes) self.assert_( "修改程序是否成功", findNewRes["data"]["keywords"] == modelNameUpdate) # 验证是否修改 self.assert_("修改程序是否成功", findNewRes["data"]["isOpen"] == 1) #验证修改isOpen是否有效 self.log_info("成功执行修改程序,修改指定id的Name") #删除 baseGo.delete(modelId) # mysqlCon().comMysql("DELETE FROM custom_content_model WHERE model_id = %s" % modelId) #验证其数据库知否存在该数据 resMql = mysqlCon().comMysql( "SELECT * FROM ad_position WHERE id = %s" % modelId) self.assert_("指定id是否已经被清理", (len(resMql) == 0))
def post_test(self): # 删除该账号 urldel = self.url.urlBasefun() + "ms/sys/sys_manager/delete.do" payload = "[%s]" % self.managerId response = requests.request("POST", urldel, data=payload, headers=self.headers) self.log_info("删除功能response:%s" % response.text) #从数据库中验证是否已经删除 nameList = mysqlCon().searchMysql() self.log_info(r"查找数据库是否存在该账户:" + str(self.newName in nameList)) # print(self.newName,nameList) urlCheck = self.url.urlBasefun( ) + "ms/sys/sys_manager/info/%s.do" % self.managerId responseCheck = requests.request("POST", urlCheck, data=payload, headers=self.headers) responseCheck = json.loads(responseCheck.text) self.log_info("调用查找接口response:%s" % responseCheck) if (self.newName in nameList) == False and responseCheck['data'] == None: self.log_info("添加成功,数据库中已经不含有%s,删除功能已经实现" % self.newName) self.log_info("新增账号已清理") else: raise ("账号未被清理")
def run_test(self): baseGo = self.baseGo modelNew = baseGo.nameRandom() baseGo.creatID(modelNew) res = baseGo.FindID() self.log_info(res) modelId = res["data"]["list"][0]["id"] self.log_info("该信息的id:%s"%modelId) baseGo.delete(modelId) #删除 time.sleep(2) #验证其数据库知否存在该数据 resMql = mysqlCon().comMysql("SELECT del_flag FROM message where id = %s" % modelId) self.assert_( "指定id是否已经被清理,flag已更改为1",(resMql[0][0] == 1)) #清理数据库测试数据 mysqlCon().comMysql("delete FROM message where id = %s" % modelId)
def getModelId(self): ''' 获得数据库model_id最新添加的一个modelID :return:最新modelId ''' resMql = mysqlCon().comMysql("SELECT model_id FROM sys_model order by model_id DESC LIMIT 1") print(resMql) rootModelID = resMql[0][0] return rootModelID
def run_test(self): baseGo = roleModelInfo() dirName = baseGo.nameRandom() rootName = baseGo.nameRandom() buttonName = baseGo.nameRandom() dirButtonName = baseGo.nameRandom() dirButtonNameUpdate = baseGo.nameRandom() baseGo.creatModel(rootName, 1, 0) # 执行创建根目录菜单 rootModelID = baseGo.getModelId() findNewRes = baseGo.AccurateSearch(rootModelID) self.assert_("创建一级菜单栏是否成功",findNewRes["data"]["modelTitle"] == rootName) self.log_info("成功创建一级菜单栏名称:%s,modelID:%s" % (rootName, rootModelID)) baseGo.creatModel(dirName, 1, rootModelID) # 在根目录下创建二级目录菜单 dirModelID = baseGo.getModelId() findNewRes = baseGo.AccurateSearch(dirModelID) self.assert_("创建二级菜单栏名称是否成功",findNewRes["data"]["modelTitle"] == dirName) self.log_info("成功创建二级菜单栏名称:%s,modelID:%s" % (dirName, dirModelID)) baseGo.creatModel(buttonName, 2, rootModelID) # 执行创建二级目录按钮 buttonModelID = baseGo.getModelId() findNewRes = baseGo.AccurateSearch(buttonModelID) self.assert_( "创建二级按钮是否成功",findNewRes["data"]["modelTitle"] == buttonName) self.log_info("成功创建二级按钮名称:%s,modelID:%s" % (buttonName, buttonModelID)) baseGo.creatModel(dirButtonName, 2, dirModelID) # 执行创建二级目录菜单下创建按钮 dirModelID_twice = baseGo.getModelId() findNewRes = baseGo.AccurateSearch(dirModelID_twice) self.assert_( "创建二级菜单栏按钮是否成功",findNewRes["data"]["modelTitle"] == dirButtonName) self.log_info("成功创建二级菜单栏按钮名称:%s,modelID:%s" % (dirButtonName, dirModelID_twice)) baseGo.update(dirModelID_twice, dirModelID, dirButtonNameUpdate) findNewRes = baseGo.AccurateSearch(dirModelID_twice) self.assert_( "修改程序是否成功",findNewRes["data"]["modelTitle"] == dirButtonNameUpdate) # 验证是否修改 self.log_info("成功执行修改程序,修改指定id的Name") baseGo.delete(dirModelID_twice) resMql = mysqlCon().comMysql("SELECT model_id FROM sys_model where model_id = %s" % dirModelID_twice) self.assert_( "指定id是否已经被清理",(len(resMql) == 0)) self.log_info("成功删除指定id的记录") self.log_info("清理根目录数据") baseGo.delete(rootModelID)
def run_test(self): url = self.url.urlBasefun() + "ms/sys/sys_manager/save.do" self.log_info("创建新用户%s" % self.url.nameRandom()) self.newName = self.url.nameRandom() payload = { "createBy": 0, "createDate": "2019-08-01T01:25:03.800Z", "createDateStr": "string", "del": 0, "managerName": "%s" % self.newName, "managerNickname": "strog", "managerPassword": "******", "managerSalt": "string", "roleIdList": [self.casedata['roleID']], "updateBy": 0, "updateDate": "2019-08-01T01:25:03.800Z", "updateDateStr": "string" } self.headers = { 'Cookie': 'accountName = liubo;%s' % self.url.keepSession() } responseAdd = requests.request("POST", url, json=payload, headers=self.headers) self.log_info("新增接口返回response:%s" % responseAdd.text) nameList = mysqlCon().searchMysql() self.log_info(r"查找数据库是否存在该账户:" + str(self.newName in nameList)) if (self.newName in nameList) == True: self.log_info("添加成功,数据库中已经含有%s,添加功能已经实现" % self.newName) #索引获取manager_id urlList = self.url.urlBasefun() + "ms/sys/sys_manager/list.do" querystring = { "sortOrder": "asc", "pageSize": "10", "pageNumber": "1", "pageNo": "1" } responseList = requests.request("POST", urlList, headers=self.headers, params=querystring) responseList = json.loads(responseList.text) self.managerId = responseList['data']['list'][0]['managerId'] #获得最新的managerID self.log_info("新增账号的managerId:%s" % responseList['data']['list'][0]['managerId'])
def run_test(self): baseGo = self.baseGo modelNew = baseGo.nameRandom() baseGo.creatID(modelNew) res = baseGo.FindID() # self.log_info(res) modelId = res["data"]["list"][0]["id"] self.log_info("该信息的id:%s"%modelId) tel = res["data"]["list"][0]["tel"] self.log_info(baseGo.phone(tel)) self.comparsion("该手机号已经被加密","错误的手机号"==baseGo.phone(tel)) baseGo.delete(modelId) #删除 time.sleep(2) #验证其数据库知否存在该数据 resMql = mysqlCon().comMysql("SELECT * FROM message where id = %s" % modelId) self.comparsion( "指定id是否已经被清理",(len(resMql) == 0))
def run_test(self): baseGo = DictInfo() dictNew = baseGo.nameRandom() dictNameUpdate = baseGo.nameRandom() baseGo.creatID(dictNew) res = baseGo.FindID() dictId = res["data"]["list"][0]["dictId"] findNewRes = baseGo.AccurateSearch(dictId) self.assert_("创建dict是否成功", findNewRes["data"]["dictName"] == dictNew) self.log_info("成功创建dict名称:%s,modelID:%s" % (dictNew, dictId)) baseGo.update(dictId, dictNameUpdate) findNewRes = baseGo.AccurateSearch(dictId) self.assert_( "修改程序是否成功", findNewRes["data"]["dictName"] == dictNameUpdate) # 验证是否修改 self.log_info("成功执行修改程序,修改指定id的Name") baseGo.delete(dictId) resMql = mysqlCon().comMysql( "SELECT * FROM custom_dict WHERE dict_id = %s" % dictId) self.assert_("指定id是否已经被清理", (len(resMql) == 0))
def AccurateSearch(self, id): url = SiteInfo().urlBasefun() + "ms/sys/site_app/info/%s.do" % id headers = { 'Content-Type': "application/json", 'Cookie': "%s" % SiteInfo()._keepSession(), } response = requests.request("POST", url, headers=headers) response = json.loads(response.text) return response if __name__ == '__main__': baseGo = SiteInfo() siteId=33 # print(baseGo.delete("63")) mysqlCon().comMysql("DELETE FROM site_app WHERE app_id = 18") # baseGo.update(26,"test123") # enp = baseGo.delete(26) # res = re.findall("cn.fy.common.exception.ResultException: (.+)",enp) # print(res) # # import requests # name = '60' # url = "http://csf.91clt.com:8090/fycms/ms/sys/site_app/delete.do" # payload = "[\r\n %s\r\n]"%name # headers = { # 'Content-Type': "application/json", # 'Cookie': "%s"%SiteInfo()._keepSession(), # # } #
headers = { 'Content-Type': "application/json", 'Cookie': "%s" % reviewInfo()._keepSession(), } response = requests.request("GET", url, headers=headers, params=querystring) response = json.loads(response.text) return response if __name__ == '__main__': baseGo = reviewInfo() enpPath = baseGo.upfilisBatch(settings.PROJECT_ROOT_DIR+r"\resources\FIles\pingLun.xlsx") res = baseGo.importDo(enpPath) sql = 'DELETE FROM review_reviews WHERE content LIKE "test%"' enpMysql = mysqlCon().comMysql(sql) print(enpMysql) # print(baseGo.GetFiles() # for dir_path, dir_names, file_names in test_resources.walk("/"): # log_info("dir_path=%s" % dir_path)