Python get_xls Examples

Example #1

File: testGetAddress.py Project: abao0713/interfaceTest2

import unittest
import paramunittest
import readConfig as readConfig
from commonsrc import Log as Log
from commonsrc import common
from commonsrc import configHttp as ConfigHttp
from commonsrc import login_status

getAddress_xls = common.get_xls("userCase.xlsx", "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)
        self.token = str(token)

Example #2

import unittest
import paramunittest
import readConfig as readConfig
from commonsrc import Log as Log
from commonsrc import common
from commonsrc import configHttp as ConfigHttp
from commonsrc import login_status

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

Example #3

File: testRegisterQuick.py Project: abao0713/interfaceTest2

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

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

Example #4

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

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

Example #5

import unittest
import paramunittest
import json
from commonsrc import common
from commonsrc.Log import MyLog
import readConfig as readConfig
from commonsrc import configHttp
import warnings, os
import xlrd
from xlutils3.copy import copy
from commonsrc.test_login import test_login
import time

assigneeInfo_xls = common.get_xls("test_hos.xls", "api")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
proDir = readConfig.proDir


@paramunittest.parametrized(*assigneeInfo_xls)
class ProductInfo(unittest.TestCase):
    def setParameters(self, No, Api_name, Host, Request_url, Method,
                      Request_data_type, Request_data, Return_data, Check_data,
                      Result):
        """
        set params
        :return:
        """
        self.No = No
        self.Api_name = Api_name
        self.Host = str(Host)

Example #6

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

register_xls = common.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:
        """

Example #7

import unittest
import paramunittest
import readConfig as readConfig
from commonsrc import configHttp
from commonsrc import login_status
from commonsrc import common
from commonsrc.Log import MyLog

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

Example #8

File: testLogout.py Project: abao0713/interfaceTest2

import unittest
import paramunittest
import readConfig as ReadConfig
from commonsrc.Log import MyLog
from commonsrc import common
from commonsrc import configHttp
from commonsrc import login_status

localReadConfig = ReadConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogout_xls = common.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)

Example #9

File: testDeleteAddress.py Project: abao0713/interfaceTest2

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

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

Example #10

File: GetProductInfo.py Project: abao0713/interfaceTest2

import unittest
import paramunittest
from commonsrc import common
from commonsrc.Log import MyLog
import readConfig as readConfig
from commonsrc 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 #11

import unittest
import paramunittest
import readConfig as readConfig
from commonsrc import common
from commonsrc import configHttp
from commonsrc.Log import MyLog
from commonsrc import login_status

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

Example #12

File: testLogin.py Project: abao0713/interfaceTest2

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

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

Example #13

File: testGenerate.py Project: abao0713/interfaceTest2

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

localGenerate_xls = common.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

Example #14

File: test_assignee.py Project: abao0713/interfaceTest2

import unittest
import paramunittest
import json
from commonsrc import common
from commonsrc.Log import MyLog
import readConfig as readConfig
from commonsrc import configHttp
import warnings

assigneeInfo_xls = common.get_xls("assignee.xls", "api")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
proDir = readConfig.proDir


@paramunittest.parametrized(*assigneeInfo_xls)
class ProductInfo(unittest.TestCase):
    def setParameters(self, No, api_name, HOST, request_url, method,
                      request_data_type, request_data, return_data, check_data,
                      result):
        """
        set params
        :return:
        """
        self.No = No
        self.api_name = api_name
        self.HOST = str(HOST)
        self.request_url = str(request_url)
        self.method = method
        self.request_data_type = request_data_type
        self.request_data = request_data.encode('utf-8')

Example #15

from commonsrc import common
from commonsrc import configHttp
import readConfig as readConfig
import requests
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
localLogin_xls = common.get_xls("userCase.xlsx", "login")
localAddAddress_xls = common.get_xls("userCase.xlsx", "addAddress")


# login
def get_login_cookies():
    host = localReadConfig.get_http("url")
    headers = {
        "Host": "www.mujin.assignee.com",
        "Connection": "keep-alive",
        "Content-Length": "2",
        "Accept": "application/json, text/plain, */*",
        "Origin": "https://www.mujin.assignee.com"
    }
    data = {
        "username": 1222,
        "password": "******",
        "jCaptchaCode": "",
        "holder": "SPONSOR"
    }

    response = requests.post(host + "/api/login",
                             data=data,
                             headers=headers,
                             verify=False)