Python get_xls 예제들

예제 #1

import unittest
import paramunittest
import readConfig as readConfig
from common import Log as Log
from common import common_base
from common import configHttp as ConfigHttp
from common import businessCommon

addressList_xls = common_base.get_xls("userCase.xlsx", "getAddressList")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()
info = {}


@paramunittest.parametrized(*addressList_xls)
class GetAddressList(unittest.TestCase):
    def setParameters(self, case_name, method, token, result, code, msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.result = str(result)

예제 #2

import unittest
import paramunittest
import readConfig as readConfig
from common import common_base
from common import configHttp
from common.Log import MyLog
from common import businessCommon

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogin_xls = common_base.get_xls("userCase.xlsx", "login")
localAccountSetting_xls = common_base.get_xls("userCase.xlsx", "accountSetting")


@paramunittest.parametrized(*localAccountSetting_xls)
class AccountSetting(unittest.TestCase):

    def setParameters(self, case_name, method, token, sex, telephone, nickname, birthday, country_id, result, code, msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param sex:
        :param telephone:
        :param nickname:
        :param birthday:
        :param country_id:
        :param result:
        :param code:
        :param msg:

예제 #3

파일: testRegister.py 프로젝트: baicailinux/interfaceTest

import readConfig as readConfig
from common.Log import MyLog
from common import configHttp
from common import common_base
import unittest
import paramunittest
from common import configDB

register_xls = common_base.get_xls("userCase.xlsx", "register")
localConfigHttp = configHttp.ConfigHttp()
localReadConfig = readConfig.ReadConfig()
localConfigDB = configDB.MyDB()


@paramunittest.parametrized(*register_xls)
class Register(unittest.TestCase):
    def setParameters(self, case_name, method, token, email, password,
                      confirmpwd, result, code, msg):
        """
        set parameters
        :param case_name:
        :param method:
        :param token:
        :param email:
        :param password:
        :param confirmpwd:
        :param result:
        :param code:
        :param msg:
        :return:
        """

예제 #4

import unittest
import paramunittest
import readConfig as readConfig
from common import Log as Log
from common import common_base
from common import configHttp as ConfigHttp
from common import businessCommon

addAddress_xls = common_base.get_xls("userCase.xlsx", "addAddress")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()


@paramunittest.parametrized(*addAddress_xls)
class AddAddress(unittest.TestCase):
    def setParameters(self, case_name, method, token, sex, fname, lname, tel, standby_tel, address1, address2, city, state, postcode, country_id, tax_number, company, fax, is_default, result, code, msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param sex:
        :param fname:
        :param lname:
        :param tel:
        :param standby_tel:
        :param address1:
        :param address2:
        :param city:
        :param state:
        :param postcode:

예제 #5

import readConfig as readConfig
import unittest
import paramunittest
from common.Log import MyLog
from common import configHttp
from common import common_base
from common import configDB

localRegisterQuick_xls = common_base.get_xls("userCase.xlsx", "registerquick")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localConfigDB = configDB.MyDB()


@paramunittest.parametrized(*localRegisterQuick_xls)
class RegisterQuick(unittest.TestCase):

    def setParameters(self, case_name, method, token, email, result, code, msg):
        """
        set parameters
        :param case_name:
        :param method:
        :param token:
        :param email:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)

예제 #6

import unittest
import paramunittest
import readConfig as readConfig
from common import Log as Log
from common import common_base
from common import configHttp as ConfigHttp

login_xls = common_base.get_xls("userCase.xlsx", "login")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()
info = {}


@paramunittest.parametrized(*login_xls)
class Login(unittest.TestCase):
    def setParameters(self, case_name, method, token, email, password, result, code, msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param email:
        :param password:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)

예제 #7

파일: testGenerate.py 프로젝트: baicailinux/interfaceTest

import unittest
import paramunittest
import readConfig as readConfig
from common.Log import MyLog
from common import common_base
from common import configHttp

localGenerate_xls = common_base.get_xls("userCase.xlsx", "generate")
localConfigHttp = configHttp.ConfigHttp()
localReadConfig = readConfig.ReadConfig()


@paramunittest.parametrized(*localGenerate_xls)
class Generate(unittest.TestCase):
    def setParameters(self, case_name, method, result, code, msg):
        """
        set parameters
        :param case_name:
        :param method:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.result = str(result)
        self.code = str(code)
        self.msg = str(msg)
        self.response = None
        self.info = None

예제 #8

파일: businessCommon.py 프로젝트: baicailinux/interfaceTest

from common import common_base
from common import configHttp
import readConfig as readConfig

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogin_xls = common_base.get_xls("userCase.xlsx", "login")
localAddAddress_xls = common_base.get_xls("userCase.xlsx", "addAddress")


# login
def login():
    """
    login
    :return: token
    """
    # set url
    url = common_base.get_url_from_xml('login')
    localConfigHttp.set_url(url)

    # set header
    token = localReadConfig.get_headers("token_v")
    header = {"token": token}
    localConfigHttp.set_headers(header)

    # set param
    data = {"email": localLogin_xls[0][3], "password": localLogin_xls[0][4]}
    localConfigHttp.set_data(data)

    # login
    response = localConfigHttp.post().json()

예제 #9

파일: testLoginFB.py 프로젝트: baicailinux/interfaceTest

import unittest
import paramunittest
import readConfig as readConfig
from common.Log import MyLog
from common import common_base
from common import configHttp

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLoginFB_xls = common_base.get_xls("userCase.xlsx", "loginFB")


@paramunittest.parametrized(*localLoginFB_xls)
class LoginFB(unittest.TestCase):
    def setParameters(self, case_name, method, token, email, facebook_id,
                      fbtoken, invite_agency, code, msg):
        """
        set parameters
        :param case_name:
        :param method:
        :param token:
        :param email:
        :param facebook_id:
        :param fbtoken:
        :param invite_agency:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)

예제 #10

파일: testGetProductInfo.py 프로젝트: baicailinux/interfaceTest

import unittest
import paramunittest
from common import common_base
from common.Log import MyLog
import readConfig as readConfig
from common import configHttp as configHttp

productInfo_xls = common_base.get_xls("productCase.xlsx", "getProductInfo")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


@paramunittest.parametrized(*productInfo_xls)
class ProductInfo(unittest.TestCase):
    def setParameters(self, case_name, method, token, goods_id, result, code,
                      msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param goods_id:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.goodsId = str(goods_id)

예제 #11

import unittest
import paramunittest
import readConfig as ReadConfig
from common.Log import MyLog
from common import common_base
from common import configHttp
from common import businessCommon

localReadConfig = ReadConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogout_xls = common_base.get_xls("userCase.xlsx", "logout")


@paramunittest.parametrized(*localLogout_xls)
class Logout(unittest.TestCase):
    def setParameters(self, case_name, method, token, result, code, msg):
        """
        set parameters
        :param case_name:
        :param method:
        :param token:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.result = str(result)
        self.code = str(code)

예제 #12

파일: testUploadImg.py 프로젝트: baicailinux/interfaceTest

import os
import unittest
import paramunittest
import readConfig as readConfig
from common import common_base
from common import configHttp
from common import businessCommon
from common.Log import MyLog

localUploadImg_xls = common_base.get_xls("userCase.xlsx", "uploadImg")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


@paramunittest.parametrized(*localUploadImg_xls)
class UploadImg(unittest.TestCase):
    def setParameters(self, case_name, method, token, whole, file, result,
                      code, msg):
        """
        set param
        :param case_name:
        :param method:
        :param token:
        :param whole:
        :param file:
        :param result:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)

예제 #13

import unittest
import paramunittest
import readConfig as readConfig
from common import Log as Log
from common import common_base
from common import configHttp as ConfigHttp

deleteAddress_xls = common_base.get_xls("userCase.xlsx", "deleteAddress")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()


@paramunittest.parametrized(*deleteAddress_xls)
class DeleteAddress(unittest.TestCase):
    def setParameters(self, case_name, method, address_id, result, code, msg):
        """
        set params
        :param case_name:
        :param method:
        :param address_id:
        :param code:
        :param result:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.address_id = str(address_id)
        self.code = str(code)
        self.result = str(result)
        self.msg = str(msg)

예제 #14

파일: testUpdatePassword.py 프로젝트: baicailinux/interfaceTest

import unittest
import paramunittest
import readConfig as readConfig
from common import configHttp
from common import businessCommon
from common import common_base
from common.Log import MyLog

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localUpdatePassword_xls = common_base.get_xls("userCase.xlsx",
                                              "updatePassword")


@paramunittest.parametrized(*localUpdatePassword_xls)
class UpdatePassword(unittest.TestCase):
    def setParameters(self, case_name, method, token, old_password, password,
                      password_confirm, result, code, msg):
        """
        set parameters
        :param case_name:
        :param method:
        :param token:
        :param old_password:
        :param password:
        :param password_confirm:
        :param result:
        :param code:
        :param msg:
        :return:
        """