如何使用文件進(jìn)行數(shù)據(jù)驅(qū)動？

1、使用yaml
2、使用json
3、使用csv

• test_data.yaml

- selenium
- python
- DDT

• test_data_interface.yaml
  可用于接口json格式數(shù)據(jù)

- {"name":"linda","age":18}
- {"name":"sophoe","age":88}

• test_data.json

{"name":"linda","age": 18}

• test_data1.json
  可用于接口json格式數(shù)據(jù)

{
  "data": {
    "name": "linda",
    "age": 18
  },
  "data2": {
    "name": "jenkins",
    "age": 88
  }
}

代碼

from ddt import ddt,file_data
import unittest

'''
實(shí)現(xiàn)DDT的步驟：
1、在測試類上使用@ddt裝飾符
2、在測試方法上使用@file_data裝飾符
3、@file_data
4、將傳入的列表解析（折包）使用@unpack

'''

@ddt
class TestDdtFile(unittest.TestCase):
    @unittest.skip
    @file_data('test_data.yml')
    def test_yaml(self, value):
        print(value)

    # json----dict  --**
    @unittest.skip
    @file_data('test_data_interface.yaml')
    def test_yaml_interface(self, **value):
        print(value)
        print(type(value))


    @file_data('test_data.json')
    def test_json(self, value):
        print(value)

    @unittest.skip
    @file_data('test_data1.json')
    def test_json_com(self, **value):
        print(value)

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

• test_data.csv

Username,Password
admin,123456.
linda,123456.

代碼

import csv
import unittest
from ddt import ddt,data

def get_csv_data(file_name):
    rows=[]
    with open("test_data.csv",'r') as f:
        reader = csv.reader(f)
# 跳過第 一行
        next(reader,None)
        for row in reader:
            rows.append(row)
        return rows

@ddt
class TestDdtCsv(unittest.TestCase):
    @data(*get_csv_data("test_data.csv"))
    def test_get_data(self,value):
        username = value[0]
        password = value[1]
        print('登陸的用戶名：%s'% username, '密碼是%s' % password)

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

實(shí)踐 :對用戶名和密碼進(jìn)行數(shù)據(jù)驅(qū)動，完成不同用戶登陸的自動化

# 建立csv文件--excel表建立完成導(dǎo)出成csv格式 ，utf-8  ,記事本另存為csv
# 讀取csv每一個數(shù)據(jù)
# 在通過ddt方式 實(shí)現(xiàn)數(shù)據(jù)驅(qū)動


import csv
import unittest
from ddt import ddt,data
from selenium import webdriver
from selenium.webdriver.common.by import By
import time

def get_csvdata(file_name):
    rows=[]
    with open(file_name,'r') as f:
        reader1 = csv.reader(f)
        # 跳過第一行
        next(reader1, None)
        for row in reader1:
            rows.append(row)
        print(rows)
        return rows



@ddt
class TestDdtCsv(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        path = '/Users/lindafang/PycharmProjects/selenium3forpython2020/driver/chromedriver'
        cls.driver = webdriver.Chrome(executable_path=path)

        cls.driver.maximize_window()
        cls.driver.get("http://172.16.166.129:81/zentao/user-login.html")

    @classmethod
    def tearDownClass(cls):
        # pass
        cls.driver.close()
        cls.driver.quit()

    @data(*get_csvdata("test_data.csv"))
    def test_csv_getdata(self,value):
        username=value[0]
        password=value[1]
        print("用戶名是%s" % username,"密碼是%s" % password)
        self.driver.find_element_by_id("account").send_keys(username)
        self.driver.find_element(By.NAME, 'password').send_keys(password)
        self.driver.find_element_by_id("submit").click()
        time.sleep(3)
        self.driver.find_element_by_class_name("dropdown-toggle").click()
        self.driver.find_element_by_link_text("退出").click()


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