Python get_excel_value Exemples

Exemple #1

Fichier : ese_case2.py Projet : OnyxMoonshard/ese_auto_test_1.6

from until import getDir
from until.common import get_excel_value

import sys

from case.public1.ADDRESSDETAILS_OTHER_WAREHOUSE_NONLOGIN import PublicCase2_3
from case.public1.PARCEL_DETAILS_MULTIPLY import PublicCase3_2
from case.public1.CUSTOMSDDTAILS_US_NOCOMMERCIALINVOICE import PublicCase4_1
from case.public1.REVIEWMYORDER import PublicCase5_1
from case.public1.PAYMENTOPTIONS_USUK import PublicCase6_1
from case.public1.PRINTDOCS import PublicCase7_1

# proDir = getDir.proDir
now = time.strftime("%Y_%m_%d %H:%M:%S")
case2 = get_excel_value("test_data.xlsx", "case2")


@paramunittest.parametrized(*case2)
class EseCase2(unittest.TestCase):
    '''美国至非中国多商品单一收货人匿名下单'''

    def setParameters(self, case_name, ese_from_postcode, ese_to_postcode, ese_weight, ese_length,
                      ese_width, ese_height, ese_shipper_contactname, ese_shipper_company, ese_shipper_addr1,
                      ese_shipper_addr2, ese_shipper_city, ese_shipper_state, ese_shipper_zipcode, ese_shipper_email,
                      ese_shipper_phone, ese_receiver_contactname, ese_receiver_company, ese_receiver_addr1,
                      ese_receiver_addr2, ese_receiver_city, ese_receiver_district, ese_receiver_provnice,
                      ese_receiver_zipcode, ese_receiver_email, ese_receiver_phone, ese_tracking_waybill_no,
                      ese_item_name, ese_item_weight, ese_item_quantity, ese_unit_value, ese_item_details,
                      ese_pay_cardno, ese_pay_youxiaoqi, ese_pay_cvc, ese_pay_postcode, ese_successful):

Exemple #2

Fichier : ese_case5.py Projet : OnyxMoonshard/ese_auto_test_1.6

import os
import time
import unittest  # 导入单元测试包

import paramunittest
from selenium import webdriver
from selenium.webdriver import ActionChains

import resources
from until import getDir
from until.common import get_excel_value

# proDir = getDir.proDir
now = time.strftime("%Y_%m_%d %H:%M:%S")
case5 = get_excel_value("test_data.xlsx", "case5")


@paramunittest.parametrized(*case5)
class EseCase5(unittest.TestCase):
    '''英国至非中国用户注册'''
    def setParameters(self, case_name, ese_from_postcode, ese_to_postcode,
                      ese_weight, ese_length, ese_width, ese_height, forename,
                      surname, email, password, confirmpassword,
                      invitationcode, ese_successful):
        """
        从 excel 中获取用例
        :param case_name: 用例名称
        :param ese_from_postcode: 发货人邮编
        :param ese_to_postcode: 收货人邮编
        :param ese_weight: 总重量
        :param ese_length: 总长度

Exemple #3

from until import getDir
from until.common import get_excel_value

import sys

from case.public1.ADDRESSDETAILS_OTHER_WAREHOUSE_LOGIN import PublicCase2_4
from case.public1.PARCEL_DETAILS_MULTIPLY import PublicCase3_2
from case.public1.CUSTOMSDDTAILS_US_NOCOMMERCIALINVOICE import PublicCase4_1
from case.public1.REVIEWMYORDER import PublicCase5_1
from case.public1.PAYMENTOPTIONS_USUK import PublicCase6_1
from case.public1.PRINTDOCS import PublicCase7_1

# proDir = getDir.proDir
now = time.strftime("%Y_%m_%d %H:%M:%S")
case3 = get_excel_value("test_data.xlsx", "case3")


@paramunittest.parametrized(*case3)
class EseCase3(unittest.TestCase):
    '''美国至非中国多商品单一收货人匿名下单'''
    def setParameters(
            self, case_name, ese_from_postcode, ese_to_postcode, ese_weight,
            ese_length, ese_width, ese_height, ese_shipper_contactname,
            ese_shipper_company, ese_shipper_addr1, ese_shipper_addr2,
            ese_shipper_city, ese_shipper_state, ese_shipper_zipcode,
            ese_shipper_email, ese_shipper_phone, ese_receiver_contactname,
            ese_receiver_company, ese_receiver_addr1, ese_receiver_addr2,
            ese_receiver_city, ese_receiver_district, ese_receiver_provnice,
            ese_receiver_zipcode, ese_receiver_email, ese_receiver_phone,
            ese_tracking_waybill_no, ese_item_name, ese_item_weight,

Exemple #4

import os
import time
import unittest  # 导入单元测试包

import paramunittest
from selenium import webdriver
from selenium.webdriver import ActionChains

import resources
from until import getDir
from until.common import get_excel_value

# proDir = getDir.proDir
now = time.strftime("%Y_%m_%d %H:%M:%S")
case4 = get_excel_value("test_data.xlsx", "case4")


@paramunittest.parametrized(*case4)
class EseCase4(unittest.TestCase):
    '''英国至非中国MY PARCELS OVERVIEW'''

    def setParameters(self, case_name, ese_from_postcode, ese_to_postcode, ese_weight, ese_length, ese_width,
                      ese_height,username,password, ese_successful ):
        """
        从 excel 中获取用例
        :param case_name: 用例名称
        :param username: 用户名
        :param password: 密码
        :param ese_from_postcode: 发货人邮编
        :param ese_to_postcode: 收货人邮编
        :param ese_weight: 总重量

Exemple #5

Fichier : ese_case6.py Projet : OnyxMoonshard/ese_auto_test_1.6

import os
import time
import unittest  # 导入单元测试包

import paramunittest
from selenium import webdriver
from selenium.webdriver import ActionChains

import resources
from until import getDir
from until.common import get_excel_value

# proDir = getDir.proDir
now = time.strftime("%Y_%m_%d %H:%M:%S")
case6 = get_excel_value("test_data.xlsx", "case6")


@paramunittest.parametrized(*case6)
class EseCase6(unittest.TestCase):
    '''英国至非中国忘记密码+重置密码'''
    def setParameters(self, case_name, ese_from_postcode, ese_to_postcode, ese_weight, ese_length, ese_width,
                      ese_height,email,password,confirmpassword,reset_org_password,reset_new_password,reset_confirm_password, ese_successful ):
        """
        从 excel 中获取用例
        :param case_name: 用例名称
        :param ese_from_postcode: 发货人邮编
        :param ese_to_postcode: 收货人邮编
        :param ese_weight: 总重量
        :param ese_length: 总长度
        :param ese_width: 总宽度
        :param ese_height: 总高度

Exemple #6

Fichier : ese_case1.py Projet : OnyxMoonshard/ese_auto_test_1.6

import os
import time
import unittest  # 导入单元测试包
import resources
from selenium.webdriver.common.action_chains import ActionChains
import paramunittest
from selenium import webdriver
from until import getDir
from until.common import get_excel_value
import sys
from case.public1.ADDRESSDETAILS_CN_WAREHOUSE_NONLOGIN import PublicCase1
from case.public1.PARCEL_DETAILS_MULTIPLY import PublicCase4

# proDir = getDir.proDir
now = time.strftime("%Y_%m_%d %H:%M:%S")
case1 = get_excel_value("test_data.xlsx", "case1")


@paramunittest.parametrized(*case1)
class EseCase1(unittest.TestCase):
    '''英国至非中国多商品单一收货人匿名下单'''
    def setParameters(
            self, case_name, ese_from_postcode, ese_to_postcode, ese_weight,
            ese_length, ese_width, ese_height, ese_shipper_contactname,
            ese_shipper_company, ese_shipper_addr1, ese_shipper_addr2,
            ese_shipper_city, ese_shipper_state, ese_shipper_zipcode,
            ese_shipper_email, ese_shipper_phone, ese_receiver_contactname,
            ese_receiver_company, ese_receiver_addr1, ese_receiver_addr2,
            ese_receiver_city, ese_receiver_district, ese_receiver_provnice,
            ese_receiver_zipcode, ese_receiver_email, ese_receiver_phone,
            ese_tracking_waybill_no, ese_item_name, ese_item_weight,