Python get_excel Exemples

Exemple #1

import json
import unittest
from urllib import parse

import paramunittest

from common import commom, configHTTP
from common.commom import logger

local_config_http = configHTTP.Config_Http()
addclass_excel = commom.get_excel("testCase.xlsx", "newAddClass")


@paramunittest.parametrized(*addclass_excel)
class addClass(unittest.TestCase):
    def setUp(self):
        pass

    def setParameters(self, case_name, method, url, parameter, code, status,
                      message):
        self.case_name = str(case_name)
        self.method = str(method)
        self.url = str(url)
        self.parameter = str(parameter)
        self.code = str(code)
        self.status = str(status)
        self.message = str(message)
        print(self.parameter)

    def test_addClass(self):
        login_cookies = commom.get_chatbot_login()

Exemple #2

import unittest

import paramunittest

import common
from common import commom, configHTTP
from common.Log import Log

local_cinfig_Http = configHTTP.Config_Http()

querySatisfactionsExport_excel = commom.get_excel("testCase.xlsx",
                                                  "querySatisfactionsExport")


@paramunittest.parametrized(*querySatisfactionsExport_excel)
class querySatisfactionsExport(unittest.TestCase):
    def setUp(self):
        pass

    def setParameters(self, case_name, method, url, parameter, code, status,
                      message):
        self.case_name = str(case_name)
        self.method = str(method)
        self.url = str(url)
        self.parameter = str(parameter)
        self.code = str(code)
        self.status = str(status)
        self.message = str(message)

    def test_querySatisfactionsExport(self):
        login_cookie = commom.get_chatbot_login()

Exemple #3

import json
import unittest

import paramunittest

from common import commom, configHTTP
from common.Log import Log

local_Config_Http = configHTTP.Config_Http()
evaluationConfigSave_excel = commom.get_excel("testCase.xlsx",
                                              "evaluationConfigSave")


@paramunittest.parametrized(*evaluationConfigSave_excel)
class evaluationConfigSave(unittest.TestCase):
    def setUp(self):
        pass

    def setParameters(self, case_name, method, url, parameter, code, status,
                      message):
        self.case_name = str(case_name)
        self.method = str(method)
        self.url = str(url)
        self.parameter = str(parameter)
        self.code = str(code)
        self.message = str(message)

    def test_evaluationConfigSave(self):
        login_cookies = commom.get_chatbot_login()
        local_Config_Http.get_cookies(login_cookies)
        header = {

Exemple #4

Fichier : test_summaryExportSum.py Projet : qiquan1011/customerApi

import unittest
import urllib
from urllib.parse import urlencode, quote_plus, quote

import paramunittest
import urllib3
from requests import request

from common import commom
from common.Log import Log
from common.commom import logger
from common.configHTTP import Config_Http

local_config_HTTP = Config_Http()

summaryExportSum_excel = commom.get_excel("testCase.xlsx", "summaryExportSum")


@paramunittest.parametrized(*summaryExportSum_excel)
class summaryExportSum(unittest.TestCase):
    def setUp(self):
        pass

    def setParameters(self, case_name, method, url, parameter, code, status,
                      message):
        self.case_name = str(case_name)
        self.method = str(method)
        self.url = str(url)
        self.parameter = str(parameter)
        self.code = str(code)
        self.status = str(status)

Exemple #5

Fichier : testquerySatisfaction.py Projet : qiquan1011/customerApi

import json
import unittest

import paramunittest as paramunittest

from common import configHTTP, commom
from parameterized import parameterized

from common.Log import Log

from common.commom import get_chatbot_login, logger

local_config_Http = configHTTP.Config_Http()
queerySatisfaction_excel = commom.get_excel("testCase.xlsx",
                                            "querySatisfactions")


@paramunittest.parametrized(*queerySatisfaction_excel)
class querySatisfaction(unittest.TestCase):
    def setUp(self):
        pass

    def setParameters(self, case_name, method, url, parameter, code, success,
                      message):
        self.case_name = str(case_name)
        self.method = str(method)
        self.url = str(url)
        self.parameter = str(parameter)
        self.code = str(code)
        print("self.code是：", self.code)
        self.success = str(success)