def test_CouponEntity_status(): ''' CouponEntity的status起作用 :return: ''' params = test_data["case5"]["params"] result = api_client.http_post(url, params, api_client.MANAGER_TOKEN, api_client.LOGIN_TYPE_MANAGER) mysql_util.query(test_data["case5"]["verify_sql"]) total_count = mysql_util.fetchOneRow()[0] assert total_count == result["result"]["queryData"]["totalCount"]
def test_CouponEntity_couponName(): ''' CouponEntity的couponName起作用 :return: ''' params = test_data["case6"]["params"] result = api_client.http_post(url, params, api_client.MANAGER_TOKEN, api_client.LOGIN_TYPE_MANAGER) assert result[ "result" ][ "queryData" ][ "dataList" ][ 0 ][ "couponName" ] == \ test_data[ "case6" ][ "params" ][ "param" ][ "couponName" ] mysql_util.query(test_data["case6"]["verify_sql"]) total_count = mysql_util.fetchOneRow()[0] assert result["result"]["queryData"]["totalCount"] == total_count
def test_add_business_coupon(): ''' 创建业务券成功-基本流程 :return: ''' params = test_data["case1"]["params"] mysql_util.update(test_data["case1"]["init_sql1"]) mysql_util.query(test_data["case1"]["init_sql2"]) if mysql_util.getRowCount(): coupon_code_id = mysql_util.fetchOneRow()[0] delete_sql = test_data["case1"]["init_sql3"] mysql_util.update(delete_sql.format(coupon_code_id)) result = api_client.http_post(url, params, api_client.MANAGER_TOKEN, api_client.LOGIN_TYPE_MANAGER) assert result["result"] == True
def test_query_with_default_params(): ''' 默认参数查询管理列表 :return: ''' params = test_data["case1"]["params"] result = api_client.http_post(url, params, api_client.MANAGER_TOKEN, api_client.LOGIN_TYPE_MANAGER) assert result["result"]["queryData"]["pageSize"] == test_data["case1"][ "params"]["pageSize"] # 数据库结果条数与查询结果条数比较 mysql_util.query(test_data["case1"]["verify_sql"]) sql_result_count = mysql_util.fetchOneRow()[0] if sql_result_count > result["result"]["queryData"]["pageSize"]: data_list_count = result["result"]["queryData"]["pageSize"] assert data_list_count == result["result"]["queryData"]["pageSize"] else: data_list_count = sql_result_count assert data_list_count == len( result["result"]["queryData"]["dataList"])
def test_query_approve_list_with_listType(): ''' 使用listType查询审批列表 :return: ''' params = test_data["case2"]["params"] result = api_client.http_post(url, params, api_client.MANAGER_TOKEN, api_client.LOGIN_TYPE_MANAGER) # 数据库结果条数与查询结果条数比较 mysql_util.query(test_data["case2"]["verify_total_count_sql"]) total_count = mysql_util.fetchOneRow()[0] assert total_count == result["result"]["queryData"]["totalCount"] mysql_util.query(test_data["case2"]["verify_been_approval_count_sql"]) been_approval_count = mysql_util.fetchOneRow()[0] assert been_approval_count == result["result"]["approvalCount"] mysql_util.query(test_data["case2"]["verify_not_approval_count_sql"]) not_approval_count = mysql_util.fetchOneRow()[0] assert not_approval_count == result["result"]["notApprovalCount"]