selenium 数据驱动框架自动化从0到1–9

selenium 数据驱动框架自动化从0到1–9

等了很久了吧？感谢你从头坚持学到这里，上一篇我们配置了日志，这篇我们就正式写添加联系人的测试逻辑， 不啰嗦，直接上代码：

---

在test_scripts包下创建一个test_126email_contact_person文件，代码如下：

#encoding=utf-8

from util.open_browser import *
from util.excel_parse import *
from app_models.add_contact_person_action import AddContactPersonAction
from app_models.login_action import LoginAction
from util.get_log_obj import *
from config.var_config_path import *
import time
import traceback

excelObj = ExcelParse(test_data_file_path)
excelObj.load_workbook()



def test126MailAddContacts():
    lg = GetLog().log()
    lg.info('添加联系然测试开始')
    try:
        usersheet = excelObj.get_sheet_by_name(u'126账号')
        is_execute_user = excelObj.get_column(usersheet, lp_is_execute)
        data_book_column = excelObj.get_column(usersheet, lp_data_book)
        lg.info('开始执行登陆')
        for idex, i in enumerate(is_execute_user[1:]):
            if i.value == 'y':
                userRow = excelObj.get_row(usersheet, idex + 2)
                userName = userRow[lp_user_name - 1].value
                userPassword = userRow[lp_password - 1].value
                print(userName, userPassword)

                driver = OpenBrowser()
                LoginAction.login(driver, userName, userPassword)
                time.sleep(5)
                lg.info(&