Python readExcel 예제들

예제 #1

파일: test01case.py 프로젝트: jiguobin1/ApiTest

 def test02case(self):
     u'''用例2：错误密码登录'''
     data = readExcel().get_excel_info('login', 3)
     self.info = RunMain().run_main('post', url, data)
     ss = json.loads(self.info)  # 将响应转换为字典格式
     self.assertEqual(ss['code'], 200)
     self.assertEqual(ss['message'], '登录成功')

예제 #2

파일: test01case.py 프로젝트: jiguobin1/ApiTest

 def test01case(self):
     u'''用例1：登录正常系'''
     data = readExcel().get_excel_info('login', 2)  #获取用例数据值，转换成为map类型
     self.info = RunMain().run_main('post', url, data)
     ss = json.loads(self.info)  # 将响应转换为字典格式
     self.assertEqual(ss['code'], 200)
     self.assertEqual(
         ss['message'],
         '登录成功',
     )

예제 #3

파일: Signutil.py 프로젝트: liyuanjiejieke/zidonghua

def signa():

    cls = readExcel().get_xls('userCase.xlsx', 'test')

    str = cls[0]
    print(str.get('case_name'))

예제 #4

파일: testoptionAgree.py 프로젝트: qingqingwoxin1/interfaceTest

"""
import unittest
import paramunittest
import urllib.parse

#导入相应的方法
from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility
from common.configDB import DB

#实例化参数
readconfig = ReadConfig()
optionAgree_xls = readExcel().get_xls('userCase.xlsx', 'optionAgree')
util = Utility()
db = DB()


@paramunittest.parametrized(*optionAgree_xls)
class addProjectAudit(unittest.TestCase):
    #实例化Excel表中的数据
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:

예제 #5

import unittest
import paramunittest
import urllib.parse
import time

# 导入相应的方法
from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility
from common.configDB import DB

# 实例化参数
readconfig = ReadConfig()
addProjectAudit_xls = readExcel().get_xls('userCase.xlsx', 'addProjectAudit')
util = Utility()
db = DB()
# 准备数据
# del_sql = "delete from m_project_member where p_id=673 and user_id=15"
# query_sql = "select * from m_project_member where p_id=673 and user_id=15"
file = "../testFile/sqlFile/m_project_member"
f = open(file, "r")
read_data = f.readlines()
@paramunittest.parametrized(*addProjectAudit_xls)
class addProjectAudit(unittest.TestCase):
    # 实例化Excel表中的数据
    def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content):
        """
               :param case_no:
               :param case_name:

예제 #6

import unittest
import paramunittest
import urllib.parse
import time

# 导入相应的方法
from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility
from common.configDB import DB

# 实例化参数
readconfig = ReadConfig()
collectProjectInfo_xls = readExcel().get_xls('userCase.xlsx',
                                             'collectProjectInfo')
util = Utility()
db = DB()


@paramunittest.parametrized(*collectProjectInfo_xls)
class collectProjectInfo(unittest.TestCase):
    # 实例化Excel表中的数据
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:

예제 #7

파일: testgetStatement.py 프로젝트: qingqingwoxin1/interfaceTest

import selenium
import unittest
import urllib.parse
import paramunittest

from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility

readconfig = ReadConfig()
getStatement_xls = readExcel().get_xls('userCase.xlsx', 'getStatement')
util = Utility()


@paramunittest.parametrized(*getStatement_xls)
class testGetStatement(unittest.TestCase):
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:
               :param path:
               :param expect_content:
               :return:
               """
        self.case_no = str(case_no)

예제 #8

import requests
import json
import unittest
from testFile.get_cookie import Get_Cookie
from common.configHttp import RunMain
import paramunittest
from testFile.geturlParams import geturlParams
from testFile.readExcel import readExcel

url = geturlParams().get_Url()  # 获取拼接到的url
login_xls = readExcel().get_xls('userCase.xlsx', 'tian')


@paramunittest.parametrized(*login_xls)
class testUserTian(unittest.TestCase):
    def setParameters(self, case_name, path, query, method):
        self.case_name = case_name
        self.path = path
        self.query = query
        self.method = method

    def description(self):
        self.case_name

    def setUp(self):
        print(self.case_name + '测试前准备,看看我有咩有被执行！！！！')
        print('获取cookie')
        response1 = requests.get(url='http://127.0.0.1:9999/login',
                                 data={
                                     "name": "xiaoming",
                                     "pwd": "111"

예제 #9

读取Excel中的测试用例，使用unittest来进行断言
"""
import unittest
import paramunittest
import urllib.parse
import time


from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility
from common.configDB import DB
readconfig = ReadConfig()
taskTypeInfo_xls = readExcel().get_xls('userCase.xlsx','taskTypeInfo')
util = Utility()
db=DB()
headers = {'token':readconfig.get_token('token'),'userid':readconfig.get_userid('userid')}

@paramunittest.parametrized(*taskTypeInfo_xls)
class testTaskTypeInfo(unittest.TestCase):
    def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:
               :param path:
               :param expect_content:

예제 #10

import json
import unittest
import sys

sys.path.append("./")
from common.configHttp import runMain
import testFile.getUrlParams as getUrlParams
import urllib.parse
import paramunittest

import testFile.readExcel as readExcel

url = getUrlParams.getUrlParams().get_Url()
login_xls = readExcel.readExcel().get_xls("userCase.xlsx", "login")


@paramunittest.parametrized(*login_xls)
class testUserLogin(unittest.TestCase):
    def setParameters(self, case_name, path, query, method):
        self.case_name = str(case_name)
        self.path = str(path)
        self.query = str(query)
        self.method = str(method)

    def description(self):
        self.case_name

    def setUp(self):
        print(self.case_name + "测试开始前准备")

    def tearDown(self):

예제 #11

파일: testInfo.py 프로젝트: qingqingwoxin1/interfaceTest

"""
读取Excel中的测试用例，使用unittest来进行断言
"""
import unittest
import paramunittest
import urllib.parse

from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility

readconfig = ReadConfig()
Info_xls = readExcel().get_xls('userCase.xlsx', 'Info')
util = Utility()

# 调用我们的geturlParams获取我们拼接的url
# url = geturlParams().get_url(readConfig.get_http('baseurl_first'),'')


@paramunittest.parametrized(*Info_xls)
class testInfo(unittest.TestCase):
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:

예제 #12

# @Time    : 2020/3/6 14:39
# @Author  : Mysunshine
# @File    : test01case.py
# 读取userCase.xlsx中的用例，使用unittest来进行断言校验

import json
import unittest
from common.configHttp import RunMain
import paramunittest
from testFile import geturlParams
import urllib.parse
from testFile import readExcel

url = geturlParams.geturlParams().get_Url()
# login_xls返回值为嵌套列表
login_xls = readExcel.readExcel().get_xls('userCase.xlsx', 'login')
headers = {'Content-Type': 'application/json'}


# @paramunittest.parametrized参数化
@paramunittest.parametrized(*login_xls)
class testUserLogin(unittest.TestCase):
    def setParameters(self, case_name, path, query, method):
        """
        set params
        :param case_name:获取表格中case_name
        :param path:获取表格中path
        :param query:获取表格中query
        :param method:获取表格中method
        :return:
        """

예제 #13

파일: testcheckDataTime.py 프로젝트: qingqingwoxin1/interfaceTest

"""
读取Excel中的测试用例，使用unittest来进行断言
"""
import unittest
import paramunittest
import urllib.parse

from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility

readconfig = ReadConfig()
checkDataTime_xls = readExcel().get_xls('userCase.xlsx', 'checkDataTime')
util = Utility()

# 调用我们的geturlParams获取我们拼接的url
# url = geturlParams().get_url(readConfig.get_http('baseurl_first'),'')


@paramunittest.parametrized(*checkDataTime_xls)
class TestcheckDataTime(unittest.TestCase):
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:

예제 #14

파일: test01case.py 프로젝트: lxlovely/interfaceTest

# from testFile import get_token
from testFile import geturlParams
from testFile import readConfig
from testFile import readExcel
import urllib.parse
from testFile import get_token

#paramunittest是unittest实现参数化的一个专门的模块，可以传入多组参数，自动生成多个用例
# import paramunittest
from ddt import ddt, data, unpack

url = geturlParams.geturl_Now().get_url()  #调用我们的geturlParams获取我们拼接的URL
get_token = get_token.get_token()  #实例化获取登录凭证
print(url)
#读取Excel中的内容。获得列表数据,列表里的每一组就是一个用例
caselist_xls = readExcel.readExcel().get_xls('caselist.xlsx', 'Flash')
# print(caselist_xls)


#参数化获取的Excel数据
@paramunittest.parametrized(*caselist_xls)  #列表里的每一组就是一个用例
class testFlash(unittest.TestCase):
    def setParameters(self, case_name, method, path, data):  #初始化参数
        """
        set params
        :param case_name:
        :param path
        :param data
        :param method
        :return:
        """

예제 #15

파일: testIndex.py 프로젝트: qingqingwoxin1/interfaceTest

"""
读取Excel中的测试用例，使用unittest来进行断言
"""
import unittest
import paramunittest
import urllib.parse

from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility

readconfig = ReadConfig()
index_xls = readExcel().get_xls('userCase.xlsx', 'index')
util = Utility()

# 调用我们的geturlParams获取我们拼接的url
# url = geturlParams().get_url(readConfig.get_http('baseurl_first'),'')


@paramunittest.parametrized(*index_xls)
class testindex(unittest.TestCase):
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method:
               :param expect_result:

예제 #16

import paramunittest
import urllib.parse
import time

# 导入相应的方法
from testFile.geturlParams import geturlParams
from testFile.readConfig import ReadConfig
from testFile.readExcel import readExcel
from common.configHttp import RunMain
from common.util import Utility
from common.configDB import DB
from common.log import Logger

# 实例化参数
readconfig = ReadConfig()
getCollect_xls = readExcel().get_xls('userCase.xlsx', 'getCollect')
util = Utility()
db = DB()
log = Logger().get_logger()


@paramunittest.parametrized(*getCollect_xls)
class getCollect(unittest.TestCase):
    # 实例化Excel表中的数据
    def setParameters(self, case_no, case_name, path, parameter, method,
                      expect_result, expect_content):
        """
               :param case_no:
               :param case_name:
               :param parameter:
               :param method: