Python read_excel Beispiele

Beispiel #1

from Public.log import logger, LOG
import os
import requests
import json
import ddt
import unittest
from Public.read_excel import read_excel
from Public.db_commit import db_commit
from Public.cogfig import EXECL_PATH
from Interface.test_requests_pk import requests_packge
wenjian = EXECL_PATH + '\\jekn.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian, 'Sheet3')


@ddt.ddt()
class Test_Login(unittest.TestCase):
    def setUp(self):
        logger("运行")

    def tearDown(self):
        pass

    @ddt.data(*excel.next())
    def test_shuj(self, data):
        print(data)
        api = requests_packge(url=data['url'],
                              requersts_type=data['期望请求方式'],
                              mobile=int(data['quantity']),
                              code=int(data['lever']),
                              bs_flag=data['bs_flag'])
        api.getJson().get('retMsg')

Beispiel #2

import unittest
import ast
import ddt
import json
import time
from Interface.test_login import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
import requests
from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel
from Public.redis_value import redis_dta

wenjian = EXECL_PATH + '\\jekn.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian,'逐仓平仓开多开空')
db_link=db_commit()
rise='316040'

url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1= {"Content-Type": "application/json", }
api_kill= requests.get(url=url,headers=headers_1)
time.sleep(3)

test = Test_Login(rise)
token_test = test.test_log()#调用方法
update_redis=redis_dta()#调用缓存方法，实例化类，调用方法
'''
限价买涨+加买跌+【平仓】手动平仓
一个用户开多开空
'''

Beispiel #3

Datei: test_Messy.py Projekt: XiaoHengli-Geek/deep

from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel
from Interface.test_login import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
from Interface.Character import Character_split
import ddt
slice_Character = Character_split()  #截取字符
db_link = db_commit()
rise = '315702'
wenjian = EXECL_PATH + '\\creata_interface.xlsx'  #查询到对应的case文件

excel_zhang = read_excel(wenjian, '限价买涨')
import unittest


@ddt.ddt
class Test_order_Limit(unittest.TestCase):
    def setUp(self):
        LOG.info('限价买涨计算强平价开始')

    def tearDown(self):
        LOG.info('限价买涨计算强平价结束')

    @ddt.data(*excel_zhang.next())
    def test_order_Limit(self, data):
        test = Test_Login(rise)
        token_test = test.test_log()
        quantity = float(data['quantity(数量)'])
        lever = float(data['lever(杠杆)'])

Beispiel #4

import unittest

import ddt
import json
from Interface.test_login import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
import requests
from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel
from Interface.Character import Character_split

import time
wenjian = EXECL_PATH + '\\all_create_order.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian, '全仓限价开多+开空强平价')
excel_drop = read_excel(wenjian, '全仓限价开多')
db_link = db_commit()
single = '315768'
single_to = '315915'

url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1 = {
    "Content-Type": "application/json",
}
api_kill = requests.get(url=url, headers=headers_1)
time.sleep(3)
slice_Character = Character_split()  #截取字符
'''
全仓限价开多+开空强平价
一个用户开多+开空

Beispiel #5

Datei: mock.py Projekt: XiaoHengli-Geek/deep

import unittest
import time
import ddt
import json
from Public.cogfig import EXECL_PATH
from Interface.test_mock import test_mock_mi
test_send = test_mock_mi()
import math
from Public.read_excel import read_excel
from unittest import mock
wenjian = EXECL_PATH + '\\jekn.xlsx'  #查询到对应的case文件
index_excel = read_excel(wenjian, '指数价')
#上一次指数价
last_prices = 9409.9


@ddt.ddt()
class TestClient(unittest.TestCase):
    def test_fail_request(self, test):
        #     #调用方法实例化，f获得test_send的实例
        #     f=test_send.test_send_requestr()
        #     #把返回值作为mock，mock
        #     f=mock.Mock(return_value='404')
        #     #调用属性实例化
        #     print(type(f))
        #     self.assertEqual(f(), '404')
        #指数价

        #统计
        sum = 0
        #金额不为0的用户，保存进入prices

Beispiel #6

Datei: test_Limit_buy_drop.py Projekt: XiaoHengli-Geek/deep

import unittest

import ddt
import json
from Interface.test_login_denglu import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
import requests
from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel

wenjian = EXECL_PATH + '\\jekn.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian, '限价买跌')
db_link = db_commit()
test = Test_Login('315702', '315703')
token_test = test.test_log()
'''
限价买跌
'''


@ddt.ddt()
class Test_Login(unittest.TestCase):
    def setUp(self):
        LOG.info('限价买跌计算强平价开始')

    def tearDown(self):
        LOG.info('限价买跌计算强平价结束')

    @ddt.data(*excel.next())

Beispiel #7

Datei: test_buy_Linmit.py Projekt: XiaoHengli-Geek/deep

# coding=utf-8
import unittest
import ast
import ddt
import json
import time
from Interface.test_login import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
import requests
from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel
from Interface.Character import Character_split
wenjian = EXECL_PATH + '\\jekn.xlsx'  #查询到对应的case文件
excel_zhang = read_excel(wenjian, '限价买涨')
excel_die = read_excel(wenjian, '限价买跌')
db_link=db_commit()
rise='315508'
drop='315703'
slice_Character=Character_split()#截取字符
url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1= {"Content-Type": "application/json", }
api_kill= requests.get(url=url,headers=headers_1)
time.sleep(3)
'''
限价买涨+加买跌
一个用户买跌买涨
第二个用户也买跌买涨
'''
@ddt.ddt()

Beispiel #8

import unittest
from Interface.test_login import Test_Login
from Public.log import LOG
from Public.read_excel import read_excel
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit  #数据库
import ddt
import requests
import time
from Interface.tese_requests_single import requests_single
wenjian = EXECL_PATH + '\\cancel_order.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian, '全仓撤单')
db_link = db_commit()

url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1 = {
    "Content-Type": "application/json",
}
api_kill = requests.get(url=url, headers=headers_1)
time.sleep(3)
rise = '315900'
'''
撤单接口异常测试
'''


@ddt.ddt()
class create_order(unittest.TestCase):
    def setUp(self):
        LOG.info('下单接口测试结束')

Beispiel #9

import unittest
from Interface.test_login import Test_Login
from Public.log import LOG
from Public.read_excel import read_excel
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit #数据库
import ddt
import requests
import time
from Interface.tese_requests_single import requests_single
wenjian = EXECL_PATH + '\\append_bail.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian, '调整保证金')
db_link=db_commit()

url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1= {"Content-Type": "application/json", }
api_kill= requests.get(url=url,headers=headers_1)
time.sleep(3)
rise='316173'

'''
撤单接口异常测试
'''
@ddt.ddt()
class create_order(unittest.TestCase):
    def setUp(self):
        LOG.info('下单接口测试结束')
    def tearDown(self):

        LOG.info('下单接口测试结束')

Beispiel #10

Datei: test_crete.py Projekt: XiaoHengli-Geek/deep

# coding=utf-8
import unittest
import ast
import ddt
import json
import time
from Interface.test_login import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
import requests
from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel

wenjian = EXECL_PATH + '\\creata_interface.xlsx'  #查询到对应的case文件
excel_zhang = read_excel(wenjian, '下单1')
excel_die = read_excel(wenjian, '下单2')
db_link = db_commit()
rise = '315702'
drop = '315703'

url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1 = {
    "Content-Type": "application/json",
}
api_kill = requests.get(url=url, headers=headers_1)
time.sleep(3)
'''
限价买涨+加买跌纯下单
两个用户，不用去计算任何强平价
'''

Beispiel #11

Datei: test_create_order_interface.py Projekt: XiaoHengli-Geek/deep

import unittest
from Interface.test_login import Test_Login
from Public.log import LOG
from Public.read_excel import read_excel
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit  #数据库
import ddt
import requests
import time
from Interface.tese_requests_single import requests_single

wenjian = EXECL_PATH + '\\creata_interface.xlsx'  #查询到对应的case文件
excel = read_excel(wenjian, '下单接口测试')
db_link = db_commit()

url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1 = {
    "Content-Type": "application/json",
}
api_kill = requests.get(url=url, headers=headers_1)
time.sleep(3)
rise = '315655'
'''
下单异常测试
'''


@ddt.ddt()
class create_order(unittest.TestCase):
    def setUp(self):
        LOG.info('下单接口测试结束')

Beispiel #12

Datei: test_all_rise.py Projekt: XiaoHengli-Geek/deep

import unittest

import ddt
import json
from Interface.test_login import Test_Login
from Public.cogfig import EXECL_PATH
from Public.db_commit import db_commit
import requests
import time
from Public.log import LOG
from Interface.tese_requests_single import requests_single
from Public.read_excel import read_excel
from Interface.Character import Character_split

wenjian = EXECL_PATH + '\\all_create_order.xlsx'  #查询到对应的case文件
excel_rise = read_excel(wenjian, '全仓限价开多')
excel_drop = read_excel(wenjian, '全仓限价开空')
db_link = db_commit()
rise = '316220'
drop = '315944'
url = 'https://t01-mapi.deepcoin.pro/site/kill'
headers_1 = {
    "Content-Type": "application/json",
}
api_kill = requests.get(url=url, headers=headers_1)
time.sleep(3)
slice_Character = Character_split()  #截取字符
'''
全仓限价开多+开空强平价
一个用户开多，一个用户开空
减少用户余额，计算强评价