def read_config():
global path, sheetname2, sheetname1, itemcode_data, data, gateway_sn, sleeptime, url
cf = configparser.ConfigParser()
cf.read("config.ini", )
path = cf.get('file', 'path')
sheetname1 = cf.get('file', 'sheetname1')
sheetname2 = cf.get('file', 'sheetname2')
# print (path)
# print(sheetname1)
# print(sheetname2)
itemcode_data = ExcleHelper(path, sheetname1)
data = ExcleHelper(path, sheetname2)
url = cf.get('env', 'url')
gateway_sn = cf.get('sn', 'gateway_sn')
sleeptime = cf.get('time', 'sleeptime')
print('设备sn为%s' % gateway_sn)
print('间隔时间为%s' % sleeptime)
print('环境信息为%s' % url)
def value(sheetname, api_name):
data = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\test.xlsx',
sheetname)
url = data.get_value(api_name, 'url')
path = data.get_value(api_name, 'path')
headers1 = data.get_value(api_name, 'headers')
method = data.get_value(api_name, 'method')
base_params = data.get_value(api_name, 'params')
cache['url'] = url
cache['path'] = path
cache['headers1'] = headers1
cache['method'] = method
cache['base-params'] = base_params
return cache
from kafka import KafkaConsumer
from kafka import KafkaProducer
import threading
import datetime, time
from src.common.excel_simple import ExcleHelper
data = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\kafka.xls', 'data')
server_list = ["cdh1.f-qa.igen:9092,cdh2.f-qa.igen:9092,cdh3.f-qa.igen:9092"]
i = 1
# b = str.encode('编码类型') # 利用字符串的encode方法编码成bytes，默认为utf-8类型
#
# bytes.decode('编码类型')：将bytes对象解码成字符串，默认使用utf-8进行解码。
while i < 4:
#采集器sn为804998682，sensor2703
msg = {
"t_gc1": "158",
"Etdy_ge1": "0.00",
"HR_Ege_t1": "3509",
"Pcg_dcg1": "-1120.00",
"Et_use1": "23001",
"INV_T0": "37",
"Etdy_use1": "3.63",
"PG_C3": "0.00",
"Et_pu1": "18756",
"t_gc_tdy1": "0.00",
"B_left_cap1": "82",
"zs1": "9987",
"AV1": "237.30",
"AV2": "0.00",
"PG_C2": "0.00",
"AV3": "0.00",
"PG_C1": "4.50",
def setUpClass(cls):
# cls.data=ExcleHelper(r'D:\xingit\wsy\ApiAuto\config\test.xlsx','Sheet2')
cls.data = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\test.xlsx',
'username')
#encoding:utf-8
import requests
import json
import time,datetime
import socket
import threading
from src.common.excel_simple import ExcleHelper
data=ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\storage.xlsx','case')
#首条比例信息
def radio(generationValue,useValue,buyValue,chargeValue,self_use,self_charge,buy_use):
if generationValue>0:
#自发自用比例
useRatio=min(self_use,useValue,generationValue)/generationValue
#自发充电比例
chargeRatio=min(self_charge,chargeValue,generationValue)/generationValue
if useRatio+chargeRatio>1:
chargeRatio=1-useRatio
gridRatio=0
print('自发自用比例为%s,自发充电比例为%s,自发并网比例为%s'%(useRatio,chargeRatio,gridRatio))
else:
#自发并网比例
gridRatio=1-useRatio-chargeRatio
print('自发自用比例为%s,自发充电比例为%s,自发并网比例为%s'%(useRatio,chargeRatio,gridRatio))
else:
useRatio=None
chargeRatio=None
gridRatio=None
print('自发自用比例为%s,自发充电比例为%s,自发并网比例为%s'%(useRatio,chargeRatio,gridRatio))
if useValue>0:
#用电来源于发电量比例
# print (result)
# print (type(result))
#将埋点编号存到列表中
result2 = result['result']
result2_len = len(result2)
# print (result2)
# print (type(result2))
result3 = []
j = 0
while j < result2_len:
result4 = result2[j]['eventvalue']
print(result4)
result3.append(result4)
j += 1
mydata = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\maidian.xlsx',
'Sheet1')
rows_num = mydata.get_row()
print(rows_num)
i = 1
while i < rows_num:
maidian_data = mydata.get_value(i, '埋点编号')
maidian_data2 = int(maidian_data)
# print (maidian_data2)
maidian_data3 = str(maidian_data2)
# print (maidian_data3)
if maidian_data3 in result3:
# print ('该埋点:%s已在talkdata中'%maidian_data3)
print('pass')
else:
print('该埋点:%s不在talkdata中' % maidian_data3)
class Solarmanbusiness(TaskSet):
data = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\test.xlsx', 'phone')
#手机账号登录
@task(1)
def test_001(self):
# log.info("开始执行test_001")
url = self.data.get_value('login_mobile', 'url')
path = self.data.get_value('login_mobile', 'path')
headers1 = self.data.get_value('login_mobile', 'headers')
base_params = self.data.get_value('login_mobile', 'params')
#json.loads是将转化为json
payload = json.loads(base_params)
headers = json.loads(headers1)
# print type(headers)
print(url + path)
response = self.client.post(url=url + path,
data=payload,
headers=headers)
print(response.status_code)
assert response.status_code == 200
result = json.loads(response.content)
access_token = result['access_token']
bearer = result['token_type']
Authorization = bearer + " " + access_token
cache['Authorization1'] = Authorization
# print cache
# log.info("test_001 pass")
#获取商家列表
@task(1)
def test_002(self):
url = self.data.get_value('get_list', 'url')
path = self.data.get_value('get_list', 'path')
method = self.data.get_value('get_list', 'method')
base_params = self.data.get_value('get_list', 'params')
# Authorization=self.test_001()
Authorization = cache['Authorization1']
print("token002为%s'%Authorization")
headers = {
"authorization": "%s" % Authorization,
"User-agent": "okhttp/3.9.1"
}
print(url + path)
response = self.client.get(url=url + path, headers=headers)
print(response.status_code)
assert response.status_code == 200
result = json.loads(response.content)
# print type(result)
rog_id = result[0]['org']['id']
cache['rog_id'] = rog_id
return rog_id
#手机商家登录
@task(1)
def test_003(self):
url = self.data.get_value('login_mobile002', 'url')
path = self.data.get_value('login_mobile002', 'path')
headers1 = self.data.get_value('login_mobile002', 'headers')
method = self.data.get_value('login_mobile002', 'method')
base_params = self.data.get_value('login_mobile002', 'params')
#json.loads是将转化为json
payload = json.loads(base_params)
#org_id=self.test_002()
org_id = cache['rog_id']
# print org_id
headers = json.loads(headers1)
# data={'org_id':'%d' %org_id}
payload['org_id'] = org_id
# print payload
# print type(payload)
print(url + path)
response = self.client.post(url=url + path,
data=payload,
headers=headers)
print(response.status_code)
assert response.status_code == 200
result = json.loads(response.content)
access_token = result['access_token']
bearer = result['token_type']
Authorization = bearer + " " + access_token
print('token003为%s' % Authorization)
cache['Authorization2'] = Authorization
#获取用户信息
@task(1)
def test_004(self):
url = self.data.get_value('get_userinfo', 'url')
path = self.data.get_value('get_userinfo', 'path')
method = self.data.get_value('get_userinfo', 'method')
base_params = self.data.get_value('get_userinfo', 'params')
#Authorization=self.test_003()
Authorization = cache['Authorization2']
headers = {
"authorization": "%s" % Authorization,
"User-agent": "okhttp/3.9.1"
}
print(url + path)
if method == "get":
response = self.client.get(url=url + path, headers=headers)
print(response.status_code)
assert response.status_code == 20
result = json.loads(response.content)
roleid = result['orgUser']['roleId']
cache['roleid'] = roleid
class Login():
data = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\test.xlsx',
'username')
#用户名账号登录
def test_tag001(self):
url = self.data.get_value('login_username', 'url')
path = self.data.get_value('login_username', 'path')
headers1 = self.data.get_value('login_username', 'headers')
base_params = self.data.get_value('login_username', 'params')
#json.loads是将转化为json
payload = json.loads(base_params)
headers = json.loads(headers1)
# print type(headers)
# print (url+path)
response = requests.post(url=url + path, data=payload, headers=headers)
result = json.loads(response.content)
access_token = result['access_token']
bearer = result['token_type']
Authorization = bearer + " " + access_token
cache['Authorization1'] = Authorization
#获取商家列表
def test_tag002(self):
url = self.data.get_value('get_list003', 'url')
path = self.data.get_value('get_list003', 'path')
method = self.data.get_value('get_list003', 'method')
base_params = self.data.get_value('get_list003', 'params')
Authorization = cache['Authorization1']
headers = {
"authorization": "%s" % Authorization,
"User-agent": "okhttp/3.9.1"
}
print(url + path)
response = requests.get(url=url + path, headers=headers)
result = json.loads(response.content)
# print type(result)
rog_id = result[0]['org']['id']
cache['rog_id'] = rog_id
#用户名商家登录
def test_user003(self):
url = self.data.get_value('login_username002', 'url')
path = self.data.get_value('login_username002', 'path')
headers1 = self.data.get_value('login_username002', 'headers')
method = self.data.get_value('login_username002', 'method')
base_params = self.data.get_value('login_username002', 'params')
#json.loads是将转化为json
payload = json.loads(base_params)
#org_id=self.test_002()
org_id = cache['rog_id']
# print org_id
headers = json.loads(headers1)
# data={'org_id':'%d' %org_id}
payload['org_id'] = org_id
# print payload
# print type(payload)
print(url + path)
response = requests.post(url=url + path, data=payload, headers=headers)
result = json.loads(response.content)
access_token = result['access_token']
bearer = result['token_type']
Authorization = bearer + " " + access_token
cache['Authorization2'] = Authorization
return cache
#encoding=utf-8
import requests, json
from src.common.excel_simple import ExcleHelper
data = ExcleHelper(r'D:\xingit\wsy\ApiAuto-py3\config\test.xlsx', 'role')
cache = {}
url = data.get_value('login_username', 'url')
path1 = data.get_value('login_username', 'path')
headers1 = data.get_value('login_username', 'headers')
base_params1 = data.get_value('login_username', 'params')
path2 = data.get_value('get_list', 'path')
path3 = data.get_value('login_username1', 'path')
headers3 = data.get_value('login_username1', 'headers')
base_params3 = data.get_value('login_username1', 'params')
path4 = data.get_value('get_userinfo', 'path')
path5 = data.get_value('modify_role', 'path')
path6 = data.get_value('role_info', 'path')
payload1 = json.loads(base_params1)
head1 = json.loads(headers1)
payload3 = json.loads(base_params3)
head3 = json.loads(headers3)
print(url + path1)
print(url + path2)
print(url + path3)
print(url + path4)
print(url + path5)
print(url + path6)
def login():
