自动化脚本-模块化、参数化脚本(模板)

用例主脚本

#coding=utf-8
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import Select
from selenium.common.exceptions import NoSuchElementException
import unittest, time
from time import sleep


import sys
sys.path.append("../public")
 #导入登录文件
#from public import login

class MH_QJSS_002(unittest.TestCase):
    def setUp(self):
        self.driver = webdriver.Chrome()
        print("start")


    def test_MH_QJSS_002(self):
        u"""进入全局搜索页面，放大镜图标不可点击"""
        driver = self.driver
        driver.implicitly_wait(10)
        driver.get("http://172.22.43.116:1514/#/adminlogin")

        sys.path.append("../public")
        #调用登录模块
        from public.LOGIN import login
        login(self)

        from public.QUANJU import quanju
        #调用进入全局搜索页面模块
        quanju(self)

        driver.find_element_by_xpath("//*[@id='root']/span/div/div/div[2]/div[1]/div/div[2]/div[1]/div/i[1]").click()
        Clipboard = driver.find_element_by_xpath("//*[@id='root']/span/div/div/div[1]/div/div/div[3]/i[2]").get_attribute("class")

        ##通过断言，判断用例是否通过，此处运用是否出现相应值进行判定
        self.assertEqual('anticon anticon-search iconFindMargin disabled',Clipboard,msg='失败')
        print("用例通过")

    def tearDown(self):
        self.driver.quit()
        print("stop")

if __name__ == "__main__":
    	unittest.main()

主脚本调用的模块（login）

#coding=utf-8
from time import sleep
import sys
import os
curPath = os.path.abspath(os.path.dirname(__file__))
rootPath = os.path.split(curPath)[0]
sys.path.append(rootPath)

def login(self):
    import xlrd
    workbook = xlrd.open_workbook('C:\\Users\\admin\\Desktop\\QJSS\\auto_test\\Parameterization\\user.xls')
    #table = workbook.sheet_names()[0]     #此处直接获取第一个表格的名称
    #test=workbook.sheet_by_name(table)  #通过名称获取工作表的内容
    test = workbook.sheets()[0]  #直接获取第一个表格的内容
    username = str(int(test.cell_value(7,7)))
    password = str(int(test.cell_value(7,8)))

    driver = self.driver
    driver.implicitly_wait(10)
    driver.maximize_window()#将浏览器最大化显示
    driver.find_element_by_xpath("//*[@id='userName']").clear()
    driver.find_element_by_xpath("//*[@id='password']").clear()
    driver.find_element_by_xpath("//*[@id='userName']").send_keys(username)#此处调用xlrd模块参数化
    driver.find_element_by_xpath("//*[@id='password']").send_keys(password)#此处调用xlrd模块参数化

    driver.find_element_by_xpath("//*[@id='root']/span/div/div/div[1]/div/form/div[3]/div/div/span/button").click()

    try:
        driver.find_element_by_xpath('/html/body/div[2]/div/div[2]/div/div[1]/div[3]/div/button').click()
        print('登录有日程消息提醒')
    except:
        print('登录不存在日程提醒')

if __name__ == "__main__":
    unittest.main()