Python get_xls Examples

Example #1

File: testEditGroupManager.py Project: TikiLv/interface_20191213

# -*- coding: utf-8 -*-

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

addGroupManager = common.get_xls("userCase.xls", "editGroupManager")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()


@paramunittest.parametrized(*addGroupManager)
class EditGroupManager(unittest.TestCase):
    def setParameters(self, case_name, name, remarks, authoritys, code, msg):
        '''

        :param case_name:
        :param name:
        :param remarks:
        :param authoritys:
        :param code:
        :param msg:
        :return:
        '''
        self.case_name = str(case_name)
        self.name = str(name)
        self.remarks = str(remarks)

Example #2

File: testLogin.py Project: TikiLv/interface_20191213

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

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


@paramunittest.parametrized(*login_xls)
class Login(unittest.TestCase):
    def setParameters(self, case_name, method, token, account, 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)

Example #3

File: testGetList.py Project: TikiLv/interface_20191213

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

getList = common.get_xls('getList.xls', 'getlist')
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()
info = {}


@paramunittest.parametrized(*getList)
class GetList(unittest.TestCase):
    def setParameters(self, case_name, method, parameter, pageNum, pageSize,
                      code, msg):
        '''

        :param case_name:
        :param method:
        :param parameter:
        :param pageNum:
        :param pageSize:
        :param code:
        :param msg:
        :return:
        '''

        self.case_name = str(case_name)

Example #4

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

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogin_xls = common.get_xls("userCase.xls", "login")
localAccountSetting_xls = common.get_xls("userCase.xls", "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:

Example #5

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

getAddress_xls = common.get_xls("userCase.xls", "getAddress")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()
info = {}


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

Example #6

File: testEditStudent.py Project: TikiLv/interface_20191213

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

editStudent = common.get_xls("userCase.xls", "editStudent")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()
info = {}


@paramunittest.parametrized(*editStudent)
class editStudent(unittest.TestCase):
    def setParameters(self, case_name, method, name, schoolNumber, startDate,
                      gradeId, classId, address, code, msg):
        '''

        :param case_name:
        :param method:
        :param name:
        :param schoolNumber:
        :param startDate:
        :param gradeId:
        :param classId:
        :param address:
        :param code:
        :param msg:
        :return:

Example #7

File: testLogout.py Project: TikiLv/interface_20191213

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

localReadConfig = ReadConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogout_xls = common.get_xls("userCase.xls", "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)

Example #8

File: testAddUserManager.py Project: TikiLv/interface_20191213

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

addUserManager = common.get_xls("userCase.xls","addUserManager")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()
info = {}

@paramunittest.parametrized(*addUserManager)
class AddUserManager(unittest.TestCase):
    def setParameters(self, case_name, account, name, password, mobile, code, msg):
        """

        :param case_name:
        :param account:
        :param name:
        :param password:
        :param mobile:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.account = str(account)
        self.name = str(name)
        self.password = str(password)

Example #9

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

getGrade = common.get_xls("userCase.xls", "getGrade")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()


@paramunittest.parametrized(*getGrade)
class getGrade(unittest.TestCase):
    def setParameters(self, case_name, code, msg):
        """

        :param case_name:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.code = int(code)
        self.msg = str(msg)
        self.gradeId = []

    def description(self):
        '''

Example #10

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

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLoginFB_xls = common.get_xls("userCase.xls", "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)

Example #11

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

deleteGroupManager = common.get_xls("userCase.xls", "deleteGroupManager")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()


@paramunittest.parametrized(*deleteGroupManager)
class DeleteGroupManager(unittest.TestCase):
    def setParameters(self, case_name, method, code, msg):
        """

        :param case_name:
        :param method:
        :param id:
        :param code:
        :param msg:
        :return:
        """
        self.case_name = str(case_name)
        self.method = str(method)
        self.code = int(code)
        self.msg = str(msg)

    def description(self):

Example #12

File: testDeleteUserManager.py Project: TikiLv/interface_20191213

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

deleteUserManager = common.get_xls("userCase.xls", "deleteUserManager")
localReadConfig = readConfig.ReadConfig()
configHttp = ConfigHttp.ConfigHttp()

@paramunittest.parametrized(*deleteUserManager)
class DeleteUserManager(unittest.TestCase):
    def setParameters(self, case_name, method, code, msg):
        '''
        :param case_name:
        :param method:
        :param code:
        :param msg:
        :return:
        '''
        self.case_name = str(case_name)
        self.method = str(method)
        self.code = int(code)
        self.msg = str(msg)
        self.pageNum = 1
        self.pageSize = 10

    def setUp(self):
        self.log = Log.MyLog.get_log()

Example #13

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

localUploadImg_xls = common.get_xls("userCase.xls", "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)

Example #14

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

productInfo_xls = common.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)

Example #15

File: testDeleteAddress.py Project: TikiLv/interface_20191213

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

deleteAddress_xls = common.get_xls("userCase.xls", "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)

Example #16

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

localGenerate_xls = common.get_xls("userCase.xls", "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

Example #17

File: testRegister.py Project: TikiLv/interface_20191213

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

register_xls = common.get_xls("userCase.xls", "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:
        """

Example #18

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

localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localUpdatePassword_xls = common.get_xls("userCase.xls", "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:
        """
        self.case_name = str(case_name)