数据驱动

创建CSV文件，放入Data文件夹下

导入CSV

# !/usr/bin/env python
# -*- coding:utf-8 -*-

import csv
from utils.pathUtils import filePath


def reasCsvList():
    '''列表方式读取CSV文件'''
    lists = []
    with open(filePath(fileName='data.csv'), encoding='utf-8') as f:
        reader = csv.reader(f)
        # 不读取第一行内容
        next(reader)
        for item in reader:
            lists.append(item)
    return lists


# print(reasCsvList()[0][2])


def reasCsvLDict():
    '''字典方式读取CSV文件'''
    lists1 = []
    with open(filePath(fileName='data.csv'), encoding='utf-8') as f:
        reader = csv.DictReader(f)
        for item in reader:
            lists1.append(dict(item))
    return lists1

# print(reasCsvLDict()[1]['\ufeffusername'])

# !/usr/bin/env python
# -*- coding:utf-8 -*-

import unittest
from page.sina import Sina
from page.Init import InitSian
from utils.csvUtils import reasCsvList


class SinaTest(InitSian, Sina):
    def test_sina_login_001(self):
        '''登陆验证：用户名密码空'''
        self.login(username=reasCsvList()[0][0], password=reasCsvList()[0][1])
        self.assertEqual(self.getDivText, reasCsvList()[0][2])

    def test_sina_login_002(self):
        '''登陆验证：用户名不规范'''
        self.login(username=reasCsvList()[1][0], password=reasCsvList()[1][1])
        self.assertEqual(self.getDivText, reasCsvList()[0][2])

    def test_sina_login_003(self):
        '''登陆验证：用户名密码错误'''
        self.login(username=reasCsvList()[2][0], password=reasCsvList()[2][1])
        self.assertEqual(self.getDivText, reasCsvList()[0][2])

    def test_sina_login_004(self):
        '''登录判断是否登录'''
        self.login(username=reasCsvList()[3][0], password=reasCsvList()[3][1])
        self.assertEqual(self.getNick, reasCsvList()[0][2])


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

# !/usr/bin/env python
# -*- coding:utf-8 -*-

import unittest
from page.sina import Sina
from page.Init import InitSian
from utils.csvUtils import reasCsvLDict

class SinaTest(InitSian, Sina):
    def test_sina_login_001(self):
        '''登陆验证：用户名密码空'''
        self.login(username=reasCsvLDict()[0]['\ufeffusername'], password=reasCsvLDict()[0]['password'])
        self.assertEqual(self.getDivText, reasCsvLDict()[0]['期望结果'])

    def test_sina_login_002(self):
        '''登陆验证：用户名不规范'''
        self.login(username=reasCsvLDict()[1]['\ufeffusername'], password=reasCsvLDict()[1]['password'])
        self.assertEqual(self.getDivText, reasCsvLDict()[1]['期望结果'])

    def test_sina_login_003(self):
        '''登陆验证：用户名密码错误'''
        self.login(username=reasCsvLDict()[2]['\ufeffusername'], password=reasCsvLDict()[2]['password'])
        self.assertEqual(self.getDivText, reasCsvLDict()[2]['期望结果'])

''' 
def test_sina_login_004(self):
    # 登录判断是否登录
    self.login(
        username=reasCsvLDict()[3]['\ufeffusername'],
        password=reasCsvLDict()[3]['password']
    )
    self.assertEqual(self.getNick, reasCsvLDict()[3]['期望结果'])
'''


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

# !/usr/bin/env python
# -*- coding:utf-8 -*-

import unittest
from page.sina import Sina
from page.Init import InitSian
from utils.excelUtils import readExcel


class SinaTest(InitSian, Sina):
    def test_sina_login_001(self):
        '''登陆验证：用户名密码空'''
        self.login(username=readExcel()[0][0], password=readExcel()[0][1])
        self.assertEqual(self.getDivText, readExcel()[0][2])

'''
def test_sina_login_002(self):
    # 登陆验证：用户名不规范
    self.login(username=readExcel()[1][0], password=readExcel()[1][1])
    self.assertEqual(self.getDivText, readExcel()[1][2])

def test_sina_login_003(self):
    # 登陆验证：用户名密码错误
    self.login(username=readExcel()[2][0], password=readExcel()[2][1])
    self.assertEqual(self.getDivText, readExcel()[2][2])
def test_sina_login_004(self):
    # 登录判断是否登录
    self.login(
        username=reasCsvLDict()[3]['\ufeffusername'],
        password=reasCsvLDict()[3]['password']
    )
    self.assertEqual(self.getNick, reasCsvLDict()[3]['期望结果'])
'''

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