Esempi in Python per get_xls

Esempio n. 1

# coding:utf-8
import json
import unittest
import requests
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp

one_xls = common.get_xls("data.xls", "one")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


#print update_xls[0][3]
@paramunittest.parametrized(*one_xls)
class jobone(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      msg):
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.param = str(param)
        self.result = str(result)
        self.stat = str(stat)
        self.msg = msg
        self.response = None
        self.info = None
        self.logintoken = None

Esempio n. 2

# coding:utf-8
import json
import unittest
import requests
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp

count_xls= common.get_xls("data.xls", "count")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
#print update_xls[0][3]
@paramunittest.parametrized(*count_xls)
class Count(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat, msg):
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.param = str(param)
        self.result = str(result)
        self.stat = str(stat)
        self.msg =msg
        self.response = None
        self.info = None
        self.logintoken=None

    def description(self):
        return self.case_name

Esempio n. 3

# coding:utf-8
import json
import unittest
import requests
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp

remove_xls = common.get_xls("data.xls", "remove")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
#print updater_xls


@paramunittest.parametrized(*remove_xls)
class remove(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      msg):
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.param = str(param)
        self.result = str(result)
        self.stat = str(stat)
        self.msg = msg
        self.response = None
        self.info = None
        self.logintoken = None

Esempio n. 4

File: testuupdate.py Progetto: bopopescu/RY

# coding:utf-8
import json
import unittest
import requests
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp

updateu_xls = common.get_xls("data.xls", "Uupdate")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


#print updateu_xls
@paramunittest.parametrized(*updateu_xls)
class Uupdate(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      msg):
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.param = str(param)
        self.result = str(result)
        self.stat = str(stat)
        self.msg = msg
        self.response = None
        self.info = None
        self.logintoken = None

Esempio n. 5

# coding:utf-8
import json
import unittest
import requests
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp

updater_xls= common.get_xls("data.xls", "Rupdate")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
#print updater_xls

@paramunittest.parametrized(*updater_xls)
class Rupdate(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat, msg):
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.param = str(param)
        self.result = str(result)
        self.stat = str(stat)
        self.msg =msg
        self.response = None
        self.info = None
        self.logintoken=None

    def description(self):

Esempio n. 6

File: testmodelsize.py Progetto: bopopescu/RY

import json
import re
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp
import requests

totalmodelsize_xls = common.get_xls("data.xls", "totalmodelsize")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
#print totalmodelsize_xls


@paramunittest.parametrized(*totalmodelsize_xls)
class Totalmodelsize(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param goods_id:
        :param result:
        :param code:
        :param msg:
        :return:

Esempio n. 7

# coding:utf-8
import json
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp

model_xls = common.get_xls("data.xls", "model")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
#print updater_xls


@paramunittest.parametrized(*model_xls)
class remove(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      msg):
        self.case_name = str(case_name)
        self.method = str(method)
        self.token = str(token)
        self.param = str(param)
        self.result = str(result)
        self.stat = str(stat)
        self.msg = msg
        self.response = None
        self.info = None
        self.logintoken = None

Esempio n. 8

File: businessCommon.py Progetto: maninone/first

from interfaceTest.common import common
from interfaceTest.common import configHttp
import interfaceTest.readConfig as readConfig

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


# login
def login():
    """
    login
    :return: token
    """
    # set url
    url = common.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()

Esempio n. 9

import json
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp
exist_xls = common.get_xls("data.xls", "exist")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


@paramunittest.parametrized(*exist_xls)
class Exist(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      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)

Esempio n. 10

import json
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp
import requests

get_xls = common.get_xls("data.xls", "get")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


@paramunittest.parametrized(*get_xls)
class Get(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      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)

Esempio n. 11

import json
import re
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp
import requests

getall_xls = common.get_xls("data.xls", "getall")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
#print getall_xls


@paramunittest.parametrized(*getall_xls)
class Getall(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      msg):
        """
        set params
        :param case_name:
        :param method:
        :param token:
        :param goods_id:
        :param result:
        :param code:
        :param msg:
        :return:

Esempio n. 12

File: testUploadImg.py Progetto: Xiakk/test1

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

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

Esempio n. 13

import json
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp
import requests

sharedcount_xls = common.get_xls("data.xls", "sharedcount")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


@paramunittest.parametrized(*sharedcount_xls)
class Sharedcount(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      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)

Esempio n. 14

import json
import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common import businessCommon
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common import configHttp as configHttp
import requests

sharedgetall_xls = common.get_xls("data.xls", "sharedgetall")
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()


@paramunittest.parametrized(*sharedgetall_xls)
class Sharedgetall(unittest.TestCase):
    def setParameters(self, case_name, method, token, param, result, stat,
                      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)

Esempio n. 15

File: testGetProductInfo.py Progetto: maninone/first

import unittest
import paramunittest
from interfaceTest.common import common
from interfaceTest.common.Log import MyLog
import interfaceTest.readConfig as readConfig
from interfaceTest.common 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)

Esempio n. 16

# -*- coding:utf-8 -*-
import unittest
import paramunittest

#调用方法
#读取配置信息
from interfaceTest import readConfig
from interfaceTest.common import common
from interfaceTest.common.Log import Logg
import configHttp

localReadConfig = readConfig.ReadConfig()
#调用get post封装的请求方法
localConfigHttp = configHttp.ConfigHttp()
#调用读取excel方法
studentLogin_xls = common.get_xls("userCase.xlsx", "studentLogin")
#调用log中的方法
log = Logg()


#参数化
@paramunittest.parametrized(*studentLogin_xls)
class StudentLogin(unittest.TestCase):
    global log, logger, resultPath

    def setParameters(self, case_name, method, url, parameter, resultType,
                      errno, error):
        self.case_name = str(case_name)
        self.method = str(method)
        self.url = str(url)
        self.parameter = str(parameter)