def test_filter_date_type_day(self):
'''测试日类型日期变量逻辑'''
qiqiao.Application(self.driver).clickLeftMenu("字段条件")
time.sleep(0.3)
qiqiao.Application(self.driver).clickLeftMenu("日类型日期")
qiqiao.Application(self.driver).clickButtonInForm("编辑", 2)
now_time = datetime.datetime.now()
qiqiao.Date(self.driver).delete('变量本周')
qiqiao.Date(self.driver).normal('变量本周', now_time.strftime('%Y-%m-%d'))
offset = datetime.timedelta(days=-7)
re_date = (now_time + offset).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('变量上周')
qiqiao.Date(self.driver).normal('变量上周', re_date)
qiqiao.Date(self.driver).delete('变量本月')
qiqiao.Date(self.driver).normal('变量本月', now_time.strftime('%Y-%m-%d'))
month = datetime.timedelta(days=-30)
re_month = (now_time + month).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('变量上月')
qiqiao.Date(self.driver).normal('变量上月', re_month)
qiqiao.Date(self.driver).delete('变量今年')
qiqiao.Date(self.driver).normal('变量今年', now_time.strftime('%Y-%m-%d'))
year = datetime.timedelta(days=-365)
re_year = (now_time + year).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('变量去年')
qiqiao.Date(self.driver).normal('变量去年', re_year)
qiqiao.Application(self.driver).clickSubmit()
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("全局筛选条件")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='日类型日期'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('日类型日期应该显示数据', html)
self.assertNotIn('日类型日期不应该显示数据', html)
def test_required(self):
'''测试必填'''
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickSubmit()
error_loc = Operation().readXml('msg', 'requiredmsg')
msg = qiqiao.Application(self.driver).getText(error_loc)
self.assertEqual("不能为空", msg)
def test_filter_date_type_year(self):
'''测试年类型日期筛选外键数据'''
qiqiao.Application(self.driver).clickLeftMenu("字段条件")
time.sleep(0.3)
qiqiao.Application(self.driver).clickLeftMenu("年类型日期")
qiqiao.Application(self.driver).clickButtonInForm("编辑", 2)
now_time = datetime.datetime.now()
ago = datetime.timedelta(days=-365)
past = (now_time + ago).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('过去一年')
qiqiao.Date(self.driver).normal('过去一年', past)
future_year = (now_time +
datetime.timedelta(days=+365)).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('未来一年')
qiqiao.Date(self.driver).normal('未来一年', future_year)
qiqiao.Application(self.driver).clickSubmit()
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("全局筛选条件")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='年类型日期'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('年类型日期应用显示数据', html)
self.assertNotIn('年类型日期不应该显示数据', html)
def test_filter_date_type_equel_param(self):
'''测试日期逻辑等于变量筛选外键数据'''
qiqiao.Application(self.driver).clickLeftMenu("字段条件")
time.sleep(0.3)
qiqiao.Application(self.driver).clickLeftMenu("日期等于变量")
qiqiao.Application(self.driver).clickButtonInForm("编辑", 2)
now_time = datetime.datetime.now()
qiqiao.Date(self.driver).delete('等于今天')
qiqiao.Date(self.driver).normal('等于今天', now_time.strftime('%Y-%m-%d'))
yesteday = (now_time +
datetime.timedelta(days=-1)).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('等于昨天')
qiqiao.Date(self.driver).normal('等于昨天', yesteday)
tomorrow = (now_time +
datetime.timedelta(days=+1)).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('等于明天')
qiqiao.Date(self.driver).normal('等于明天', tomorrow)
before_yesteday = (now_time +
datetime.timedelta(days=-2)).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('等于前天')
qiqiao.Date(self.driver).normal('等于前天', before_yesteday)
after_tomorrow = (now_time +
datetime.timedelta(days=+2)).strftime('%Y-%m-%d')
qiqiao.Date(self.driver).delete('等于后天')
qiqiao.Date(self.driver).normal('等于后天', after_tomorrow)
qiqiao.Application(self.driver).clickSubmit()
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("全局筛选条件")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='日期等于变量'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('日期等于变量应该显示数据', html)
self.assertNotIn('日期等于变量不应该显示数据', html)
def test_limit_customer(self):
'''测试限制范围用户自定义'''
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml("departmentradio","normal").format(name="自定义"))
time.sleep(1)
html = self.driver.page_source
self.assertIn("系统运维部",html)
self.assertNotIn("技术委员会",html)
def test_show_feild(self):
'''测试外键附加显示字段'''
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('青青子衿悠悠我心', html)
def test_form_only_check(self):
'''测试表单唯一校验'''
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.SingleLineText(self.driver).normal("单行文本", "测试数据")
qiqiao.Application(self.driver).clickSubmit()
msg = qiqiao.Application(self.driver).getText(Operation().readXml(
'msg', 'prompt'))
self.assertEqual(msg, "单行文本必须唯一！！！")
def test_search_by_multiline_text(self):
'''通过多行文本筛选页面数据'''
qiqiao.MultilineText(self.driver).search("多行文本", "哈哈哈")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_search_by_score(self):
'''通过评分字段筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.Score(self.driver).search("评分", 5)
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_search_by_multiple_choice(self):
'''通过多项选择筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.MultipleChoices(self.driver).search("多项选择", "奥迪")
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_search_by_number(self):
'''通过数字筛选页面数据'''
qiqiao.Number(self.driver).search("数字", 15)
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_filter_date_time(self):
'''测试日期时间范围变量筛选外键数据'''
qiqiao.Application(self.driver).clickLeftMenu("字段条件")
time.sleep(0.3)
qiqiao.Application(self.driver).clickLeftMenu("范围变量")
qiqiao.Application(self.driver).clickButtonInForm("编辑", 2)
now_time = datetime.datetime.now()
qiqiao.DateTime(self.driver).delete('今天')
qiqiao.DateTime(self.driver).normal(
'今天', now_time.strftime('%Y-%m-%d %H:%M'))
yesteday = (now_time +
datetime.timedelta(days=-1)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('昨天')
qiqiao.DateTime(self.driver).normal('昨天', yesteday)
tomorrow = (now_time +
datetime.timedelta(days=+1)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('明天')
qiqiao.DateTime(self.driver).normal('明天', tomorrow)
before_yesteday = (
now_time + datetime.timedelta(days=-2)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('前天')
qiqiao.DateTime(self.driver).normal('前天', before_yesteday)
after_tomorrow = (
now_time + datetime.timedelta(days=+2)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('后天')
qiqiao.DateTime(self.driver).normal('后天', after_tomorrow)
qiqiao.DateTime(self.driver).delete('本周')
qiqiao.DateTime(self.driver).normal(
'本周', now_time.strftime('%Y-%m-%d %H:%M'))
past_week = (now_time +
datetime.timedelta(days=-7)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('上周')
qiqiao.DateTime(self.driver).normal('上周', past_week)
qiqiao.DateTime(self.driver).delete('本月')
qiqiao.DateTime(self.driver).normal(
'本月', now_time.strftime('%Y-%m-%d %H:%M'))
past_month = (now_time +
datetime.timedelta(days=-31)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('上月')
qiqiao.DateTime(self.driver).normal('上月', past_month)
qiqiao.DateTime(self.driver).normal(
'今年', now_time.strftime('%Y-%m-%d %H:%M'))
past_year = (now_time +
datetime.timedelta(days=-365)).strftime('%Y-%m-%d %H:%M')
qiqiao.DateTime(self.driver).delete('去年')
qiqiao.DateTime(self.driver).normal('去年', past_year)
qiqiao.Application(self.driver).clickSubmit()
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("全局筛选条件")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='范围变量'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('范围变量应该显示数据', html)
self.assertNotIn('范围变量不应该显示数据', html)
datetime.timedelta()
def test_search_by_editdate(self):
'''通过修改日期筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.Date(self.driver).search("修改时间", "2020-09-13", "2020-09-14")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("0", title)
def test_search_by_department(self):
'''通过部门选择筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.DepartmentRedio(self.driver).search("部门单选", "产",
"创新技术中心->产品研发二部")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_search_by_address(self):
'''通过地址选择筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.AddressSelection(self.driver).search("地址选择器", "河南省", "郑州市",
"中原区")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_search_by_datetime(self):
'''通过日期时间筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.DateTime(self.driver).search(
"日期时间", "2020-09-15 00:00 至 2020-09-16 00:00")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_date_limit_more(self):
'''测试日期限制逻辑大于'''
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Date(self.driver).required("必填_提示", '2019-09-20')
qiqiao.Tab(self.driver).clickTab("大于920")
qiqiao.Date(self.driver).normal("大于920", "2019-09-10")
qiqiao.Application(self.driver).clickSubmit()
msg = qiqiao.Application(self.driver).getText(Operation().readXml(
'msg', 'prompt'))
self.assertEqual(msg, '大于920')
def test_search_by_single_choice(self):
'''通过单项选择筛选页面数'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.SingleChoice(self.driver).search("单项下拉", "东京")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_search_by_creaperson(self):
'''通过创建人筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.PersonnelSelection(self.driver).search("创建人", "刁惠云")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("0", title)
def test_search_by_time(self):
'''通过时间筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.Time(self.driver).search("时间", "11:30", "12:00")
time.sleep(10)
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("1", title)
def test_filter_date(self):
'''测试日期筛选外键数据'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("全局筛选条件")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='日期'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('日期应该显示的数据', html)
self.assertNotIn('日期不应该显示的数据', html)
def test_filter_singletext(self):
'''测试单行文本筛选外键数据'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("全局筛选条件")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='单行文本'))
time.sleep(0.5)
html = self.driver.page_source
self.assertIn('筛选单行文本数据', html)
self.assertNotIn('筛选单行文本被过滤数据', html)
def test_combination_search(self):
'''测试组合筛选页面数据'''
qiqiao.Application(self.driver).clickExpand()
qiqiao.Date(self.driver).search("修改时间", "2020-10-26", "2020-10-27")
qiqiao.PersonnelSelection(self.driver).search("创建人", "刁惠云")
qiqiao.DepartmentRedio(self.driver).search("部门单选", "产",
"创新技术中心->产品研发二部")
qiqiao.Application(self.driver).clickSearchBtn()
time.sleep(1)
title = qiqiao.Application(self.driver).getText(Operation().readXml(
'application', 'totaldata'))
self.assertIn("0", title)
def test_linked_singletext(self):
'''测试联动筛选单行文本'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("单行文本联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.SingleLineText(self.driver).normal('等于道一', '道一')
qiqiao.SingleLineText(self.driver).normal('不等于道一', '哈哈哈')
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('筛选单行文本数据', html)
self.assertNotIn('筛选单行文本被过滤数据', html)
def test_linked_personal_selecter(self):
'''测试联动筛选人员单选'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("人员单选联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.PersonnelSelection(self.driver).normal('等于', '刁惠云')
qiqiao.PersonnelSelection(self.driver).normal('不等于', '吴健伦')
qiqiao.PersonnelSelection(self.driver).normal('等于任意一个', '罗琳月')
qiqiao.PersonnelSelection(self.driver).normal('不等于任意一个', '王浩')
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('人员单选应该显示的数据', html)
self.assertNotIn('人员单选不应该显示的数据', html)
def test_linked_multiplechoices(self):
'''测试联动筛选多项选择'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("多项选择联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.MultipleChoices(self.driver).dropDownNormal('等于', '北京')
qiqiao.MultipleChoices(self.driver).dropDownNormal('不等于', '北京', '上海')
qiqiao.MultipleChoices(self.driver).dropDownNormal('包含', '北京', '上海')
qiqiao.MultipleChoices(self.driver).dropDownNormal('不包含', '北京')
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('多项选择应该显示的数据', html)
self.assertNotIn('多项选择不应该显示的数据', html)
def test_linked_singlechoice(self):
'''测试联动筛选单项选择'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("单项选择联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.SingleChoice(self.driver).dropDownNormal('等于中国', '中国')
qiqiao.SingleChoice(self.driver).dropDownNormal('不等于中国', '日本')
qiqiao.SingleChoice(self.driver).dropDownNormal('等于任意一个', '美国')
qiqiao.SingleChoice(self.driver).dropDownNormal('不等于任意一个', '美国')
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('单项选择应该显示的数据', html)
self.assertNotIn('单项选择不应该显示的数据', html)
def test_linked_number(self):
'''测试联动筛选数字'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("数字联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.Number(self.driver).normal('等于5', 5)
qiqiao.Number(self.driver).normal('不等于5', 8)
qiqiao.Number(self.driver).normal('大于5', 9)
qiqiao.Number(self.driver).normal('小于5', 4)
qiqiao.Number(self.driver).normal('大于等于5', 5)
qiqiao.Number(self.driver).normal('小于等于5', 5)
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('数字应该显示的数据', html)
self.assertNotIn('数字不应该显示的数据', html)
def test_linked_department(self):
'''测试部门外键联动'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
time.sleep(1)
qiqiao.Application(self.driver).clickLeftMenu("部门选择联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
time.sleep(1)
qiqiao.DepartmentRedio(self.driver).normal('等于', '创新技术中心')
qiqiao.DepartmentRedio(self.driver).normal('不等于', '员工成功部')
qiqiao.MultipleDepartments(self.driver).normal('等于任意一个', '事业二部', '董办')
qiqiao.MultipleDepartments(self.driver).normal('不等于任意一个', '创新技术中心',
'事业二部')
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('部门单选应该显示的数据', html)
self.assertNotIn('部门单选不应该显示的数据', html)
def test_linked_personals(self):
'''测试联动筛选人员多选'''
qiqiao.Application(self.driver).clickLeftMenu("外键选择")
qiqiao.Application(self.driver).clickLeftMenu("人员多选联动")
qiqiao.Application(self.driver).clickButtonInTitle("添加")
qiqiao.MultiplePersonnel(self.driver).normal('等于', '刁惠云', '罗琳月')
time.sleep(1)
qiqiao.MultiplePersonnel(self.driver).normal('不等于', '孙铋舰', '孙财和')
time.sleep(1)
qiqiao.MultiplePersonnel(self.driver).normal('包含', '孙奥博', '孙保民')
time.sleep(1)
qiqiao.MultiplePersonnel(self.driver).normal('不包含', '李四', '孙岑')
qiqiao.Application(self.driver).clickElement(Operation().readXml(
'foreignkeyselection', 'normal').format(name='外键选择'))
time.sleep(1)
html = self.driver.page_source
self.assertIn('人员多选应该显示的数据', html)
self.assertNotIn('人员多选不应该显示的数据', html)
