Python Service.get_excell_data Examples

Example #1

File: LoginTest.py Project: ojbk6943/woniusales

import requests
from parameterized import parameterized
from interface.util.Service import Service
import unittest

# 打开首页
roles = Service.get_role_info(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "讲师")

# 首页
open_page_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "open_page", "open", 2, 4, 7)

# 登录页
login_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "login", "login", 2, 4, 7)

# 解密
decode_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "decode", "decode", 2, 4, 7)

# 登陆账户
login_info = Service.get_role_info(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "咨询主管")


class LoginTest(unittest.TestCase):

Example #2

File: TrainResourceTest.py Project: ojbk6943/woniusales

import re
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service
from interface.util.Utility import Utility

# 登录页
open_training_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "training-resource", "open", 2, 4, 7)

add_training_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "training-resource", "add", 2, 4, 7)

query_training_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "training-resource", "query", 2, 4, 7)

page_training_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "training-resource", "paging", 2, 4, 7)

open_tracking_training_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "training-resource", "oTracking", 2, 4, 7)

tracking_training_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "training-resource", "save", 2, 4, 7)

Example #3

import re
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service


# 登录页
open_public_resource_data = Service.get_excell_data("C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "public_resource", "open", 2, 4, 7)

claim_public_resource_data = Service.get_excell_data("C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "public_resource", "claim", 2, 4, 7)

query_public_resource_data = Service.get_excell_data("C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "public_resource", "query", 2, 4, 7)



class PublicResourceTest(unittest.TestCase):

    # 自定义, 咨询主管账户
    def setUp(self):
        self.session = requests.session()
        # 登陆、解密
        Service.get_login(
            self.session, "C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "咨询主管")
        Service.get_decode(
            self.session, "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/decode.xlsx",
                          "decode", 2, 4, 7)

Example #4

File: DeliverResourceTest.py Project: ojbk6943/woniusales

import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service

# 登录页
open_deliver_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "deliver_resource", "open", 2, 4, 7)

query_deliver_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "deliver_resource", "query", 2, 4, 7)

update_deliver_resource_data = Service.get_excell_data(
    "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "deliver_resource", "update", 2, 4, 7)


class DeliverResourceTest(unittest.TestCase):

    # 自定义, 咨询主管账户
    def setUp(self):
        self.session = requests.session()
        # 登陆、解密
        Service.get_login(
            self.session,
            "C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx",
            "管理员")
        Service.get_decode(
            self.session,

Example #5

File: AllotResourceTest.py Project: ojbk6943/woniusales

import re

import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service


# 登录页
allot_allocation_resource_data = Service.get_excell_data("C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "allot-resource", "allot", 2, 4, 7)

query_allocation_resource_data = Service.get_excell_data("C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "allot-resource", "query", 2, 4, 7)

scale_allocation_resource_data = Service.get_excell_data("C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
    "allot-resource", "scale", 2, 4, 7)

class AllotResourceTest(unittest.TestCase):

    # 自定义, 咨询主管账户
    def setUp(self):
        self.session = requests.session()
        # 登陆、解密
        Service.get_login(
            self.session, "C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "咨询主管")
        Service.get_decode(
            self.session, "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/decode.xlsx",
                          "decode", 2, 4, 7)

    # 分配资源