test_searchByOther.py
11.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
# -*- coding: utf-8 -*-
# @Time : 2021/8/10 17:33
# @Author : Ljq
# @File : test_searchByOther.py
# @Software: PyCharm
"""
进门单列表其他他查询条件
"""
import unittest
from bs4 import BeautifulSoup
from commons.scripts.readConf import rC
from commons.api import zcApi as zcA
from commons.basic import getLookupList as gLL
from commons.ConfigDB import mysql_selectAll as msa
from commons.api.entranceFeeBillList import operationDoUndo as oDU
from commons.api.entranceFeeBillList import entranceFeeBillList as eFBL, operationDoUpdate as oDUp
import time,random
from commons.MySession import sessionSy
session = sessionSy
class test_listPage(unittest.TestCase):
"""沈阳市场-进门单列表：attr进门单属性查询测试"""
def setUp(self) -> None:
pass
def tearDown(self) -> None:
pass
@classmethod
def setUpClass(cls) -> None:
cls.gatewayHost = rC.returnOptionsItems("host", "gatewayHost")
cls.jmsfHost = rC.returnOptionsItems("host", "jmsfHost")
cls.ic = rC.returnOptionsItems("testInfo", "sy_cardNumRe_01")
carTypeList = gLL.get_LookupList(session=session,host=cls.jmsfHost,providerName="车型").json()[1:]
categoryList = gLL.get_LookupList(session=session,host=cls.jmsfHost, providerName="货物品类").json()[1:]
authDepartmentList = zcA.get_dep(session=session,host=cls.gatewayHost).json()["data"]
entranceFeeBillTypeList = gLL.get_LookupList(session=session,host=cls.jmsfHost, providerName="称重类型").json()[1:]
entranceFeeBillStateList = gLL.get_LookupList(session=session,host=cls.jmsfHost, providerName="状态").json()[1:]
tradeTypeList = gLL.get_LookupList(session=session,host=cls.jmsfHost, providerName="交易类型").json()[1:]
cls.carType = random.sample(carTypeList, 1)[0]
cls.category = random.sample(categoryList, 1)[0]
cls.authDepartment = random.sample(authDepartmentList, 1)[0]
cls.entranceFeeBillType = random.sample(entranceFeeBillTypeList, 1)[0]
cls.entranceFeeBillState = random.sample(entranceFeeBillStateList, 1)[0]
cls.tradeType = random.sample(tradeTypeList, 1)[0]
@classmethod
def tearDownClass(cls) -> None:
pass
def test_searchByCardTepy(self):
"""进门单列表-查询：车型查询测试"""
print(self.carType)
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,carTypeName=self.carType["text"])
number = cre_res.json()["data"]["number"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,carTypeId=self.carType["value"])
print(resListPage.json())
carTypeList=list(set([i["carTypeName"] for i in resListPage.json()["rows"]]))
assert resListPage.json()["rows"][0]["number"] == number,"车型查询失败查询失败"
assert len(carTypeList) == 1,"车型查询失败查询失败"
assert self.carType["text"]==carTypeList[0],"车型查询失败查询失败"
def test_searchBycategory(self):
"""进门单列表-查询：货物品类查询测试"""
goods="雪莲果"
categoryName = "水果"
res = gLL.get_LookupList(session=session,host=self.jmsfHost,providerName="货物品类")
categoryId = [i["value"] for i in res.json() if i["text"]==categoryName]
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,keyword=goods)
number = cre_res.json()["data"]["number"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,categoryId=categoryId)
print(resListPage.json())
assert resListPage.json()["rows"][0]["number"] == number,"货物品类查询失败"
def test_searchByProductName(self):
"""进门单列表-查询：商品查询测试"""
productName = "蔬菜"
productId = gLL.get_product(session=session,host=self.jmsfHost,productName=productName).json()["data"][0]["id"]
print(productId)
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,keyword=productName)
number = cre_res.json()["data"]["number"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,productName=productName,productId=productId)
print(resListPage.json())
productNameList=list(set([i["productName"] for i in resListPage.json()["rows"]]))
assert resListPage.json()["rows"][0]["number"] == number,"商品查询测试失败"
assert len(productNameList) == 1,"商品查询测试失败"
assert productName==productNameList[0],"商品查询测试失败"
def test_searchByDepartment(self):
"""进门单列表-查询：部门查询查询测试"""
print(self.authDepartment)
print(self.authDepartment["name"])
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,depName=self.authDepartment["name"])
number = cre_res.json()["data"]["number"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,dep=self.authDepartment["id"])
# print(resListPage.json())
depNameList=list(set([i["depName"] for i in resListPage.json()["rows"]]))
assert resListPage.json()["rows"][0]["number"] == number,"部门查询查询测试失败"
assert len(depNameList) == 1,"部门查询查询测试失败"
assert self.authDepartment["name"]==depNameList[0],"部门查询查询测试失败"
def test_searchByRegionId(self):
"""进门单列表-查询：部门查询查询测试"""
depName = "水果部"
res = gLL.get_LookupList(session=session,host=self.jmsfHost,providerName="接车部门")
dep = [i["value"] for i in res.json() if i["text"] == depName]
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,depName=depName)
number = cre_res.json()["data"]["number"]
print("number",number)
orderId = cre_res.json()["data"]["id"]
oDUp.do_updateOrder(session=session,host=self.jmsfHost,attrValue=number)
res = eFBL.get_orderView(session=session,host=self.jmsfHost,orderId=orderId)
# bs取值
orderDetailsList = BeautifulSoup(res.text, "html.parser").findAll("input")
orderDetailsDict = {i.get("name"): i.get("value") for i in orderDetailsList}
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,dep=dep,regionId=orderDetailsDict["regionId"])
depNameList=list(set([i["depName"] for i in resListPage.json()["rows"]]))
assert resListPage.json()["rows"][0]["number"] == number,"部门查询查询测试失败"
assert len(depNameList) == 1,"部门查询查询测试失败"
assert depName==depNameList[0],"部门查询查询测试失败"
def test_searchByBillType(self):
"""进门单列表-查询：称重类型查询测试"""
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,type="1")
print(resListPage.json())
resList=list(set([i["type"] for i in resListPage.json()["rows"]]))
assert len(resList) == 1,"称重类型查询测试失败"
assert "整车"==resList[0],"称重类型查询测试失败"
def test_searchByStatus(self):
"""进门单列表-查询：交易状态查询测试"""
status = "4"
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,carTypeName=self.carType["text"])
number = cre_res.json()["data"]["number"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,status=status)
print(resListPage.json())
statusList=list(set([i["status"] for i in resListPage.json()["rows"]]))
assert resListPage.json()["rows"][0]["number"] != number,"交易状态查询测试失败"
assert len(statusList) == 1,"交易状态查询测试失败"
assert "已缴费"==statusList[0],"交易状态查询测试失败"
def test_searchByTradeType(self):
"""进门单列表-查询：交易类型查询测试"""
print(self.tradeType)
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,transactionName=self.tradeType["text"])
number = cre_res.json()["data"]["number"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,tradeTypeId=self.tradeType["value"])
print(resListPage.json())
carTypeList=list(set([i["tradeTypeName"] for i in resListPage.json()["rows"]]))
assert resListPage.json()["rows"][0]["number"] == number,"交易类型查询测试失败"
assert len(carTypeList) == 1,"交易类型查询测试失败"
assert self.tradeType["text"]==carTypeList[0],"交易类型查询测试失败"
def test_searchByCreatedTime(self):
"""进门单列表-查询：进场时间查询测试"""
ic = self.ic
plate = f"川A{random.randint(10000, 99999)}"
goods = "雪莲果"
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,plate=plate,keyword=goods)
number = cre_res.json()["data"]["number"]
eFBL.do_payOrder(session=session,host=self.jmsfHost,attrValue=number,ic=ic)
createdTime = eFBL.listPage(session=session,host=self.jmsfHost,attrValue=number).json()["rows"][0]["created"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,startTime=createdTime,endTime=createdTime)
print(resListPage.json())
createdTimeList = list(set([i["created"] for i in resListPage.json()["rows"]]))
assert len(createdTimeList) == 1,"进场时间查询测试失败"
assert createdTimeList[0]==createdTime,"进场时间查询测试失败"
def test_searchByPaymentTime(self):
"""进门单列表-查询：缴费时间查询测试"""
ic = self.ic
plate = f"川A{random.randint(10000, 99999)}"
goods = "雪莲果"
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,plate=plate,keyword=goods)
number = cre_res.json()["data"]["number"]
eFBL.do_payOrder(session=session,host=self.jmsfHost,attrValue=number,ic=ic)
createdTime = eFBL.listPage(session=session,host=self.jmsfHost,attrValue=number).json()["rows"][0]["paymentTime"]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost,startPayTime=createdTime,endPayTime=createdTime)
print(resListPage.json())
createdTimeList = list(set([i["paymentTime"] for i in resListPage.json()["rows"]]))
assert len(createdTimeList) == 1,"缴费时间查询测试失败"
assert createdTimeList[0]==createdTime,"缴费时间查询测试失败"
def test_searchByRefundTime(self):
"""进门单列表-操作：退款时间查询"""
plate = f"川A{random.randint(10000,99999)}"
goods = "雪莲果"
cre_res = zcA.create_jmsf(session=session,host=self.gatewayHost,plate=plate,keyword=goods)
number = cre_res.json()["data"]["number"]
res_pay = eFBL.do_payOrder(session=session,host=self.jmsfHost,attrValue=number)
time.sleep(3)
res_undo = oDU.do_undoOrder(session=session,host=self.jmsfHost,attrValue=number)
refundTime = msa(f'SELECT efbd.operator_time FROM entrance_fee_bill efb JOIN entrance_fee_bill_detail efbd ON efb.id=efbd.bill_id WHERE efb.number="{number}";')[0][0]
resListPage = eFBL.listPage(session=session,host=self.jmsfHost, startRefundTime=refundTime, endRefundTime=refundTime)
assert resListPage.json()["rows"][0]["number"]==number,"退款时间查询失败"
refundNumberList = list(set([i["number"] for i in resListPage.json()["rows"]]))
res_msa = [i[0] for i in msa(f'SELECT efb.number FROM entrance_fee_bill efb JOIN entrance_fee_bill_detail efbd ON efb.id=efbd.bill_id WHERE efbd.operator_time="{refundTime}";')]
assert res_msa.sort()==refundNumberList.sort(),"查询结果与数据库结果不一致"
"""
三个时间查询暂不涉及
"""