简单数据库驱动实现 - 编程语言

数据文件

分别为要访问的网址，输入框的定位表达式，搜索按钮的定位表达式，搜索关键字，断言关键字

https://www.bing.com||//input[@id=”sb_form_q”]||sb_form_go||”测试开发”||”测试开发"
https://www.sogou.com||//input[@id=”query”]||stb||”测试开发”||”测试开发"

测试脚本:

方式1:脚本方式
#encoding=utf-8
from selenium import webdriver
import time
with open("e://data.txt",encoding="gbk") as fp:
    datas = fp.readlines()
driver = webdriver.Firefox(executable_path = "d:\\geckodriver")   
for data in datas:
    data = data.strip().split("||")
    driver.get(data[0])
    searchBox = driver.find_element_by_xpath(data[1])
    searchBox.send_keys(data[3])
    searchButton = driver.find_element_by_id(data[2])
    searchButton.click()
    time.sleep(5)
    assert data[4] in driver.page_source

driver.quit()

方式2:封装函数

#encoding=utf-8
from selenium import webdriver
import time,os
driver = webdriver.Firefox(executable_path = "d:\\geckodriver")
def get_data(file_path):
    if os.path.exists(file_path):
        with open(file_path,encoding="gbk") as fp:
            test_datas = fp.readlines()
        return test_datas
    else:
        print("文件不存在!")

#定义实际的测试步骤:打开浏览器 输入 关键字 进行搜索
def test_step(url,searchBox_xpath,searchButton_id,searchWord,assertWord):
    global driver
    driver.get(url)
    searchBox = driver.find_element_by_xpath(searchBox_xpath)
    searchButton = driver.find_element_by_id(searchButton_id)
    searchBox.send_keys(searchWord)
    searchButton.click()
    time.sleep(5)
    assert assertWord in driver.page_source

#主函数，获取测试数据，执行测试步骤
def main(file_path):
    global driver
    test_datas = get_data(file_path)
    for data in test_datas:
        if data.strip() != "":
            data = data.split("||")
            url = data[0].strip()
            print(url)
            searchBox_xpath = data[1].strip()

            searchButton_id = data[2].strip()
            searchWord = data[3].strip()
            assertWord = data[4].strip()

            test_step(url,searchBox_xpath,searchButton_id,searchWord,assertWord)
    driver.quit()

if __name__ == "__main__":

    main("e:\\data.txt")