def test_demo_001(self): """新用户注册""" logger.info('*===============用例{}\{}开始执行===============*'.format( __name__, sys._getframe().f_code.co_name)) sql = "delete from user_info where phone='18637607203';" sql1 = "delete from category_tree where media_name = 'gaozuxin'" flag = mysql.update(sql) flag2 = mysql.update(sql1) self.assertEqual(1, flag, msg="用户删除失败") self.assertEqual(1, flag2, msg="用户删除失败") one_browser_window() self.loginpage.open_regist() self.loginpage.regist('gaozuxin', 'gzx123456', '18637607203', '9274', 'A1b8S') self.loginpage.take_screenshot() islogin = self.indexpage.get_loginuser() try: self.assertEqual('gaozuxin', islogin, msg="注册并登录失败") except: data = {"subject": '[自动创建]新用户注册并登录异常', "description": ''} link_redmine(self.redmine_user, self.redmine_pwd, data) self.assertEqual('gaozuxin', islogin, msg="注册并登录失败") self.indexpage.click_exit_userbtn() logger.info('*===============用例{}\{}执行结束===============*'.format( __name__, sys._getframe().f_code.co_name))
def my_assert(self, type_assert, method_assert, value_real, value_except, subject_redmine, des_redmine): if type_assert == 'assertTrue': try: method_assert(value_real == value_except, msg=des_redmine) except Exception as des_redmine: data = { "subject": '[自动创建]' + subject_redmine, "description": des_redmine } link_redmine(self.redmine_user, self.redmine_pwd, data) method_assert(value_real == value_except, msg=des_redmine)
def test_demo_003(self): """用户登录、配置规则、添加任务""" logger.info('*===============用例{}\{}开始执行===============*'.format( __name__, sys._getframe().f_code.co_name)) one_browser_window() sql1 = "delete from task_rule where uid = 163 and rule_name like '新建规则_%页';" sql2 = "delete from task_info where uid = 163 and task_name like '新建任务_非异步';" flag1 = mysql.update(sql1) flag2 = mysql.update(sql2) self.assertEqual(1, flag1, msg="规则删除失败") self.assertEqual(1, flag2, msg="任务删除失败") self.loginpage.open_login() self.loginpage.login('18201112814', 'gzx123456', 'A1b8S') self.loginpage.take_screenshot() # self.loginpage.find_element(Ruleherf_loc).click() self.rulepage.open() self.rulepage.add_rule() time.sleep(1) handles = driver.window_handles # 获取所有打开窗口的句柄 driver.switch_to.window(handles[1]) rulename1 = '新建规则_列表页' select_category1 = 'category1' rule_type1 = 'type1' pageurl1 = 'http://in.nen.com.cn/ssjj/index.shtml' url_pattern1 = 'http://in.nen.com.cn*' rulemark1 = 'test_list' extract_method1 = 'method1' self.addrule.click_enter_piontconf(rulename1, select_category1, rule_type1, pageurl1, url_pattern1, rulemark1, extract_method1) time.sleep(1) self.loginpage.find_element( '//*[@id="layui-layer4"]/div[3]/a[1]').click() time.sleep(1) handles = driver.window_handles driver.switch_to.window(handles[-1]) self.extensionpage.add_dongbeinews_listrule() self.addrule.click_savecnewrulebtn() self.addrule.take_screenshot() time.sleep(5) rulename2 = '新建规则_正文页' select_category2 = 'category1' rule_type2 = 'type2' pageurl2 = 'http://in.nen.com.cn/system/2018/03/23/020430991.shtml' url_pattern2 = 'http://in.nen.com.cn*' rulemark2 = 'test_text' extract_method2 = 'method1' self.addrule.click_enter_piontconf(rulename2, select_category2, rule_type2, pageurl2, url_pattern2, rulemark2, extract_method2) time.sleep(1) self.loginpage.find_element( '//*[@id="layui-layer4"]/div[3]/a[1]').click() time.sleep(2) handles = driver.window_handles driver.switch_to.window(handles[-1]) self.extensionpage.add_dongbeinews_textrule() self.addrule.click_saverulebtn() self.addrule.take_screenshot() driver.switch_to.window(handles[0]) # self.loginpage.find_element(Taskherf_loc).click( self.taskpage.open() self.taskpage.add_task() time.sleep(2) handles = driver.window_handles driver.switch_to.window(handles[-1]) taskname = '新建任务_非异步' taskcategory = 'category1' tasktype = '调度任务' cron = '*/1 * * * *' timebreak_loc = '30' isagent = '否' self.addtask.collect_init(taskname, taskcategory, tasktype, cron, timebreak_loc, isagent) urllist_lis = 'http://in.nen.com.cn/ssjj/index.shtml' select_extractrule_list = "新建规则_列表页" check1_list = 'url' check2_list = '当选中字段已经存在时跳过' turnpagec_list = '0' opentimeout_list = '5秒' waittime_list = '不等待' sampleurl_text = 'http://in.nen.com.cn/system/2018/03/23/020430991.shtml' selcet_extractrule_text = "新建规则_正文页" turnpagec_text = '0' opentimeout_text = '5秒' waittime_text = '不等待' self.addtask.new_regular_collection( urllist_lis, select_extractrule_list, check1_list, check2_list, turnpagec_list, opentimeout_list, waittime_list, sampleurl_text, selcet_extractrule_text, turnpagec_text, opentimeout_text, waittime_text) self.addtask.click_savecnfbtn() self.addtask.click_confirmbtn() self.addrule.take_screenshot() time.sleep(2) self.addtask.click_effectivenowbtn() self.loginpage.take_screenshot() driver.switch_to.window(handles[0]) sql3 = "select task_id from task_info where uid = 163 and task_name = '新建任务_非异步';" task_id1 = mysql.select_one(sql3) time.sleep(100) # self.loginpage.find_element(Dataherf_loc).click() self.datapage.open() task_id2 = self.datapage.get_first_taskid() self.loginpage.take_screenshot() try: self.assertEqual(str(task_id1[0]), str(task_id2), msg="任务id获取异常") except: data = {"subject": '[自动创建]新建非异步常规任务id获取异常', "description": ''} link_redmine(self.redmine_user, self.redmine_pwd, data) self.assertEqual(str(task_id1[0]), str(task_id2), msg="任务id获取异常") self.datapage.click_see_details() tasks = self.datapage.get_first_tasks() logger.info("任务抓取条数{}".format(tasks)) try: self.assertEqual('30', str(tasks), msg="任务数据抓取异常") except: data = {"subject": '[自动创建]非异步常规任务数据抓取异常', "description": ''} link_redmine(self.redmine_user, self.redmine_pwd, data) self.assertEqual('30', str(tasks), msg="任务数据抓取异常") logger.info('*===============用例{}\{}执行结束===============*'.format( __name__, sys._getframe().f_code.co_name))
def test005_task(self): """微博采集_微博号采集""" logger.info('*===============用例{}\{}开始执行===============*'.format( __name__, sys._getframe().f_code.co_name)) one_browser_window() sql1 = "delete from task_info where uid = 163 and task_name = '微博采集_微博号_大数据';" flag1 = mysql.update(sql1) self.assertEqual(1, flag1, msg="微博采集微博号任务删除失败") self.loginpage.open_login() self.loginpage.login('18201112814', 'gzx123456', 'A1b8S') self.loginpage.take_screenshot() self.loginpage.find_element(Taskherf_loc).click() self.taskpage.add_task() time.sleep(2) handles = driver.window_handles driver.switch_to.window(handles[-1]) taskname = '微博采集_微博号_大数据' taskcategory = 'category2' tasktype = '调度任务' cron = '*/1 * * * *' timebreak_loc = '30' isagent = '否' self.addtask.collect_init(taskname, taskcategory, tasktype, cron, timebreak_loc, isagent) wbkeyword = '大数据' self.addtask.new_weibo_collection(wbkeyword) time.sleep(2) self.addtask.click_savecnfbtn1() self.addtask.click_confirmbtn() self.addrule.take_screenshot() time.sleep(5) self.addtask.click_effectivenowbtn1() self.loginpage.take_screenshot() driver.switch_to.window(handles[0]) sql3 = "select task_id from task_info where uid = 163 and task_name = '微博采集_微博号_大数据';" task_id1 = mysql.select_one(sql3) time.sleep(120) self.loginpage.find_element(Dataherf_loc).click() task_id2 = self.datapage.get_first_taskid() self.loginpage.take_screenshot() try: self.assertEqual(str(task_id1[0]), str(task_id2), msg="微博采集任务id获取异常") except: data = {"subject": '[自动创建]新建微博微博号采集任务id获取异常', "description": ''} link_redmine(self.redmine_user, self.redmine_pwd, data) self.assertEqual(str(task_id1[0]), str(task_id2), msg="微博采集任务id获取异常") self.datapage.click_see_details() tasks = self.datapage.get_first_tasks() logger.info("任务抓取条数{}".format(tasks)) try: self.assertNotEqual('0', str(tasks), msg="微博采集任务数据抓取异常") except: data = {"subject": '[自动创建]微博微博号采集任务数据抓取异常', "description": ''} link_redmine(self.redmine_user, self.redmine_pwd, data) self.assertNotEqual('0', str(tasks), msg="微博采集任务数据抓取异常") logger.info('*===============用例{}\{}执行结束===============*'.format( __name__, sys._getframe().f_code.co_name))