Python Utility.get_excel_GUI_tuple примеры использования

Пример #1

import unittest

from selenium.webdriver.common.by import By

from WoniuBoss.lib.login_four import Login
from WoniuBoss.tools.service import Service
from parameterized import parameterized
from WoniuBoss.tools.utility import Utility
train_data = Utility.get_json('..\\config\\testdata_four.conf')
query_login = Utility.get_excel_GUI_tuple(train_data[0])


class Logining(unittest.TestCase):
    def setUp(self):
        self.driver = Service.get_driver('..\\config\\base_UI_four.conf')
        self.login = Login(self.driver)

    def tearDown(self):
        self.driver.quit()

    @parameterized.expand(query_login)
    def test_login(self, uname, upass, vcode, expect):
        login_data = {
            'uname': uname,
            'upass': upass,
            'vcode': vcode,
        }
        self.login.do_login('..\\config\\base_UI_four.conf', login_data)
        if Service.is_element_present(self.driver, By.ID, 'btn-decrypt'):
            actual = 'success'
        else:

Пример #2

from WoniuBoss.lib.job import Job
from WoniuBoss.tools.utility import Utility
from WoniuBoss.tools.service import Service
from parameterized import parameterized
import unittest
import time

# 获取测试数据
jpb_datas = Utility.get_json('../config/testdata.conf')
tech_data = Utility.get_excel_GUI_tuple(jpb_datas[11])
edit_one_data = Utility.get_excel_GUI_tuple(jpb_datas[12])
edit_two_data = Utility.get_excel_GUI_tuple(jpb_datas[13])
edit_three_data = Utility.get_excel_GUI_tuple(jpb_datas[14])


class Testjob(unittest.TestCase):
    def setUp(self):
        print('test start')
        self.driver = Service.get_driver('../config/base.conf')
        Service.miss_login(self.driver, '../config/base.conf')
        self.driver.find_element_by_link_text(u'就业管理').click()
        self.job = Job(self.driver)

    def tearDown(self):
        print('test over')
        time.sleep(2)
        self.driver.quit()

    # 技术面试
    @parameterized.expand(tech_data)
    def test_excute_tech(self, question, result, expect):

Пример #3

from selenium.webdriver.common.by import By
from WoniuBoss.tools.utility import Utility
from WoniuBoss.tools.service import Service
from WoniuBoss.lib.login import Login
from parameterized import parameterized
import unittest
import time

# 获取测试数据
login_datas = Utility.get_json("../config/testdata.conf")
login_data = Utility.get_excel_GUI_tuple(login_datas[0])


class TestLogin(unittest.TestCase):
    def setUp(self):
        print('test start')
        self.driver = Service.get_driver('../config/base.conf')
        Service.open_page(self.driver, '../config/base.conf')
        self.login = Login(self.driver)

    def tearDown(self):
        print('test over')
        time.sleep(2)
        self.driver.quit()

    # 测试登录功能
    @parameterized.expand(login_data)
    def test_login(self, login_userName, login_userPASS, login_checkcode,
                   login_expect):
        contents = {
            'username': login_userName,

Пример #4

from WoniuBoss.lib.report import Report
from WoniuBoss.tools.utility import Utility
from WoniuBoss.tools.service import Service
from parameterized import parameterized
import unittest
import time

# 获取测试数据
date_datas = Utility.get_json('../config/testdata.conf')
console_data = Utility.get_excel_GUI_tuple(date_datas[7])
sale_data = Utility.get_excel_GUI_tuple(date_datas[8])
market_data = Utility.get_excel_GUI_tuple(date_datas[9])
job_data = Utility.get_excel_GUI_tuple(date_datas[10])


class TestReport(unittest.TestCase):

    def setUp(self):
        print('test start')
        self.driver = Service.get_driver('../config/base.conf')
        Service.miss_login(self.driver, '../config/base.conf')
        self.driver.find_element_by_link_text(u'报表中心').click()
        self.report = Report(self.driver)

    def tearDown(self):
        print('test over')
        time.sleep(2)
        self.driver.quit()

    # 咨询部
    @parameterized.expand(console_data)

Пример #5

from selenium.webdriver.common.by import By
from selenium.webdriver.support.wait import WebDriverWait
from WoniuBoss.lib.market import Market
from WoniuBoss.tools.utility import Utility
from WoniuBoss.tools.service import Service
from parameterized import parameterized
import unittest
import time

# 获取测试数据
market_datas = Utility.get_json("../config/testdata.conf")
market_decode_data = Utility.get_excel_GUI_tuple(market_datas[1])
market_add_data = Utility.get_excel_GUI_tuple(market_datas[2])
market_upload_data = Utility.get_excel_GUI_tuple(market_datas[3])


class TestMarket(unittest.TestCase):
    def setUp(self):
        print('test start')
        self.driver = Service.get_driver('../config/base.conf')
        Service.miss_login(self.driver, '../config/base.conf')
        self.driver.find_element_by_link_text(u'市场营销').click()
        self.market = Market(self.driver)

    def tearDown(self):
        print('test over')
        time.sleep(2)
        self.driver.quit()

    # 解密功能
    @parameterized.expand(market_decode_data)

Пример #6

Файл: test_report_UI_four.py Проект: woniuboss-project/woniuboss-xa-xbc

import unittest
import time
from WoniuBoss.lib.login_four import Login
from WoniuBoss.lib.report_four import Report
from WoniuBoss.tools.service import Service
from parameterized import parameterized
from WoniuBoss.tools.utility import Utility
train_data = Utility.get_json('..\\config\\testdata_four.conf')
query_seek = Utility.get_excel_GUI_tuple(train_data[6])
query_market = Utility.get_excel_GUI_tuple(train_data[7])
query_teach = Utility.get_excel_GUI_tuple(train_data[8])
query_job = Utility.get_excel_GUI_tuple(train_data[9])


class Reporting(unittest.TestCase):
    def setUp(self):
        self.driver = Service.get_driver('..\\config\\base_UI_four.conf')
        self.login = Login(self.driver)
        self.report = Report(self.driver)

    def tearDown(self):
        self.driver.quit()

    #咨询部——搜索
    @parameterized.expand(query_seek)
    def test_console_seek(self, uname, upass, vcode, password, timeone,
                          timetwo, expect):
        seek_data = {
            'uname': uname,
            'upass': upass,
            'vcode': vcode,

Пример #7

import unittest
import time
from selenium.webdriver.common.by import By

from WoniuBoss.lib.training_ui import Train
from WoniuBoss.tools.service import Service
from parameterized import parameterized
from WoniuBoss.tools.utility import Utility
train_data = Utility.get_json('..\\config\\testdata.conf')
query_seek = Utility.get_excel_GUI_tuple(train_data[0])
query_add = Utility.get_excel_GUI_tuple(train_data[1])
query_edit = Utility.get_excel_GUI_tuple(train_data[2])
query_tail = Utility.get_excel_GUI_tuple(train_data[3])
query_delt = Utility.get_excel_GUI_tuple(train_data[4])

query_deliver = Utility.get_excel_GUI_tuple(train_data[5])
query_look = Utility.get_excel_GUI_tuple(train_data[6])

query_public = Utility.get_excel_GUI_tuple(train_data[7])

query_resource = Utility.get_excel_GUI_tuple(train_data[8])
query_prorate = Utility.get_excel_GUI_tuple(train_data[9])
print(query_prorate)


class Training(unittest.TestCase):
    def setUp(self):
        self.driver = Service.get_driver('..\\config\\base_UI.conf')
        self.train = Train(self.driver)

    def tearDown(self):

Пример #8

Файл: test_market_UI_four.py Проект: woniuboss-project/woniuboss-xa-xbc

import unittest
import time
from WoniuBoss.lib.login_four import Login
from WoniuBoss.lib.marketing_four import Market
from WoniuBoss.tools.service import Service
from parameterized import parameterized
from WoniuBoss.tools.utility import Utility
train_data = Utility.get_json('..\\config\\testdata_four.conf')
query_seek = Utility.get_excel_GUI_tuple(train_data[1])
query_add = Utility.get_excel_GUI_tuple(train_data[2])
query_edit = Utility.get_excel_GUI_tuple(train_data[3])
quert_upload = Utility.get_excel_GUI_tuple(train_data[4])
query_email = Utility.get_excel_GUI_tuple(train_data[5])


class Marketing(unittest.TestCase):
    def setUp(self):
        self.driver = Service.get_driver('..\\config\\base_UI_four.conf')
        self.login = Login(self.driver)
        self.market = Market(self.driver)

    def tearDown(self):
        self.driver.quit()

    # #查询
    @parameterized.expand(query_seek)
    def test_seek(self, uname, upass, vcode, password, region, status, source,
                  time1, time2, content, expect):
        seek_data = {
            'uname': uname,
            'upass': upass,

Пример #9

Файл: test_job_UI_four.py Проект: woniuboss-project/woniuboss-xa-xbc

import unittest
import time

from WoniuBoss.lib.JOB_four import Job
from WoniuBoss.lib.login_four import Login

from WoniuBoss.tools.service import Service
from parameterized import parameterized
from WoniuBoss.tools.utility import Utility
train_data = Utility.get_json('..\\config\\testdata_four.conf')
query_seek = Utility.get_excel_GUI_tuple(train_data[10])
query_view = Utility.get_excel_GUI_tuple(train_data[11])
query_record = Utility.get_excel_GUI_tuple(train_data[12])
query_submit = Utility.get_excel_GUI_tuple(train_data[13])
query_add = Utility.get_excel_GUI_tuple(train_data[14])
query_bus = Utility.get_excel_GUI_tuple(train_data[15])
bus_add = Utility.get_excel_GUI_tuple(train_data[16])


class GET_JOB(unittest.TestCase):
    def setUp(self):
        self.driver = Service.get_driver('..\\config\\base_UI_four.conf')
        self.login = Login(self.driver)
        self.job = Job(self.driver)

    def tearDown(self):
        self.driver.quit()

    #模拟面试-查询
    @parameterized.expand(query_seek)
    def test_simulation_seek(self, uname, upass, vcode, password, interview,