python自动化测试数据处理&断言response提取变量值

每次跑完自动化测试，需要删除测试垃圾数据，不需要通过连接数据库删除，直接删除接口获取id，然后再做删除处理。

我之前根据数据库链接，删除数据库表会造成db性能慢，处理方式不够专业和科学

1、可以使用如下语句(先新增数据，后删除数据)

assert_CodeMsg(code=‘0000’, msg=‘success’, rsp=admin_xxxx)
id = admin_template_create[‘result’][‘id’]#新增后删除测试数据
templa1e_delete = xxxx.XXX_api.admin_templa1e_delete(id=id, headers=token)
assert templa1e_delete[‘code’] == ‘0000’

2、python自动化测试提取变量语句

[response]: {‘result’: {‘pageSize’: 10, ‘currentPage’: 1, ‘totalRows’: ‘1’, ‘totalPages’: 1, ‘records’: [{‘id’: ‘111111111111111111111111’, ‘tenantId’: ‘11120’, ‘tenantName’: ‘111111111111’, ‘appId’: ‘10017’, ‘name’: ‘人车关系绑定失败通知’, ‘appName’: ‘11111111111’, ‘code’: ‘QW_100000035’, ‘type’: 6, ‘title’: ‘Notification of failed binding of human vehicle relationship’, ‘content’: ‘Notification of failed binding of human vehicle relationship\nVIN：${Vxxxx}’, ‘isEnabled’: 1, ‘createBy’: ‘1140160876234’, ‘createTime’: 1732630778000, ‘smsTemplateStatus’: 2, ‘subType’: 1, ‘redirectUrl’: ‘-’}]}, ‘code’: ‘0000’, ‘msg’: ‘success’}

assert admin_template_details_query[‘result’][‘records’][0][‘name’]==‘人车关系绑定失败通知’