def test_cpLackMaterialSub_statusPage(self, gettokenfixture, key, value):
s = gettokenfixture
self.log.info("缺料提报状态查询接口")
r = SRMBase(s)
msg = r.cpLackMaterialSub_statusPage(key, value)
status = jsonpath.jsonpath(msg.json(), '$..status')[0]
self.log.info("查询结果是:%s" % msg.json())
assert status == value
def test_lackMaterial(self, gettokenfixture, key, value):
s = gettokenfixture
self.log.info("缺料提报删除")
r = SRMBase(s)
page = r.cpLackMaterialSub_statusPage(key, value)
self.log.info("查询第一条是:%s" % page.json()["data"]["records"][0])
lackMaterialSubId = jsonpath.jsonpath(page.json(),
'$..lackMaterialSubId')[0]
msg = r.lackMaterial(lackMaterialSubId)
sql = "SELECT STATE FROM CP_LACK_MATERIAL_SUB " \
"WHERE LACK_MATERIAL_SUB_ID = '%s'" % lackMaterialSubId
state = Db_Oracle().select(sql)
assert state["STATE"] == 0