[SoapUI] 通过JSONAssert比较两个环境的JSON Response,定制化错误信息到Excel

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
package ScriptLibrary;
 
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import org.skyscreamer.jsonassert.JSONCompareMode;
import org.skyscreamer.jsonassert.JSONCompareResult;
import org.skyscreamer.jsonassert.comparator.DefaultComparator;
import org.skyscreamer.jsonassert.JSONCompare;
 
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.HashMap;
import java.util.Map;
 
import static org.skyscreamer.jsonassert.comparator.JSONCompareUtil.*;
 
/**
 * Created by jenny zhang on 2017/9/19.
 */
public class LooseyJSONComparator extends DefaultComparator {  
    private int scale;        //精度,scale=5,表示精确到小数点后5位
    private Double accuracy;  //精度,accuracy=0.00001,表示精确到小数点后5位
    String extraInfo;
    def log;
    ArrayList<String> ignoreKeys;
    def testRunner
    def context
    def extraInfoMap
 
    public LooseyJSONComparator(JSONCompareMode mode, int scale,String extraInfo,def log) {
        super(mode);
        this.scale = scale;
        this.accuracy = 1.0/Math.pow(10,scale);
        this.extraInfo = extraInfo;
        this.log = log;
    }
     
    public LooseyJSONComparator(JSONCompareMode mode, int scale,def log,def context,def testRunner,def extraInfoMap,ArrayList<String> ignoreKeys) {
        super(mode);
        this.scale = scale;
        this.accuracy = 1.0/Math.pow(10,scale);
        this.log = log;
        this.context = context
        this.testRunner = testRunner
        this.extraInfoMap = extraInfoMap
        this.ignoreKeys = ignoreKeys;
    }
     
    public static void assertEquals( String expected, String actual, int scale, def log,def context=null,def testRunner=null,def extraInfoMap=null,ArrayList<String> ignoreKeys=null) throws JSONException {
        JSONCompareResult result = JSONCompare.compareJSON(expected, actual, new LooseyJSONComparator(JSONCompareMode.NON_EXTENSIBLE,scale,log,testRunner,context,extraInfoMap,ignoreKeys));
        if (result.failed()) {
            def currentStepIndex = context.currentStepIndex
            def testSuiteName = testRunner.testCase.getTestStepAt(currentStepIndex).getParent().getParent().getName()
         
            def failMessage = result.getMessage();
             
            if(failMessage.contains("Expected:")&&failMessage.contains("got:")&&(testRunner!=null)&&(context!=null)&&(extraInfoMap!=null)){
                //移除老板不想看的信息
                def keysToRemoveForBoss = ["RequestIdBmk", "RequestIdTest"]
                def extraInfoMapForBoss = extraInfoMap.findAll({!keysToRemoveForBoss.contains(it.key)})
             
                def topRow=["Test Suite","Test Case"]
                topRow = topRow+extraInfoMapForBoss.keySet()
                topRow = topRow+["DataPoint","Bmk Env","Test Env","DetailedJsonPath"]
                 
                //获取当前自动化测试Project所在的路径
                String projectPath = context.expand( '${projectDir}' )
                WriteExcel writeExcel = new WriteExcel(testRunner,context,log)
                 
                //处理fail message,解析出来写入excel
                ArrayList failMessageList = new ArrayList()
                failMessageList = writeExcel.parseFailMessage(failMessage,extraInfoMapForBoss)
                 
                //定义Excel的路径和名字
                String filePath = projectPath+ "/TestResult/" + testSuiteName + "_Fail.xlsx"
                File testResultFile = new File(filePath)
                 
                //如果Excel不存在,就先创建带列名的Excel
                if(!testResultFile.exists()){
                    writeExcel.createExcel(testResultFile,topRow)
                }
                //追加信息到Excel
                writeExcel.addExcel(filePath,failMessageList)
            }
            //打印QA和Developer想要的错误信息到SoapUI报告
            def extraInfoForQAAndDev = extraInfoMap.collect { k,v -> "$k=$v" }.join(',')
            throw new AssertionError(extraInfoForQAAndDev+failMessage);
        }
        else{
            log.info "pass";
        }
    }
     
    public static void assertEquals( String expected, String actual, int scale, String extraInfo,def log) throws JSONException {
        JSONCompareResult result = JSONCompare.compareJSON(expected, actual, new LooseyJSONComparator(JSONCompareMode.NON_EXTENSIBLE,scale,extraInfo,log));
        if (result.failed()) {
            def failMessage = result.getMessage();
            throw new AssertionError(extraInfo + failMessage);
        }
        else{
            log.info "pass";
        }
    }
 
    @Override
    protected void compareJSONArrayOfJsonObjects(String key, JSONArray expected, JSONArray actual, JSONCompareResult result) throws JSONException {
        String uniqueKey = findUniqueKey(expected);
        if (uniqueKey == null || !isUsableAsUniqueKey(uniqueKey, actual)) {
            // An expensive last resort
            recursivelyCompareJSONArray(key, expected, actual, result);
            return;
        }
         
        Map<Object, JSONObject> expectedValueMap = arrayOfJsonObjectToMap(expected, uniqueKey, log);
        Map<Object, JSONObject> actualValueMap = arrayOfJsonObjectToMap(actual, uniqueKey, log);
        for (Object id : expectedValueMap.keySet()) {
            if (!actualValueMap.containsKey(id)) {
                result.missing(formatUniqueKey(key, uniqueKey, expectedValueMap.get(id).get(uniqueKey)),
                        expectedValueMap.get(id));
                continue;
            }
            JSONObject expectedValue = expectedValueMap.get(id);
            JSONObject actualValue = actualValueMap.get(id);
             
            compareValues(formatUniqueKey(key, uniqueKey, id), expectedValue, actualValue, result);
        }
        for (Object id : actualValueMap.keySet()) {
            if (!expectedValueMap.containsKey(id)) {
                result.unexpected(formatUniqueKey(key, uniqueKey, actualValueMap.get(id).get(uniqueKey)), actualValueMap.get(id));
            }
        }
    }
     
    @Override
    protected void checkJsonObjectKeysActualInExpected(String prefix, JSONObject expected, JSONObject actual, JSONCompareResult result) {
        Set<String> actualKeys = getKeys(actual);
        for (String key : actualKeys) {
            if ((!expected.has(key))&&(!ignoreKeys.find{it == key})) {
                result.unexpected(prefix, key);
            }
        }
    }
 
    private String getCompareValue(String value) {
        try{
            return new BigDecimal(value).setScale(scale, RoundingMode.HALF_EVEN).toString();
        } catch (NumberFormatException e) {
            return value;   //value may = NaN, in this case, return value directly.
        }
    }
 
    private boolean isNumeric(Object value) {
        try {
            Double.parseDouble(value.toString());
            return true;
        } catch (NumberFormatException e) {
            return false;
        }
    }
 
    public Map<Object, JSONObject> arrayOfJsonObjectToMap(JSONArray array, String uniqueKey,def log) throws JSONException {
        Map<Object, JSONObject> valueMap = new HashMap<Object, JSONObject>();
        for (int i = 0; i < array.length(); ++i) {
            JSONObject jsonObject = (JSONObject) array.get(i);
            Object id = jsonObject.get(uniqueKey);
            id = isNumeric(id) ? getCompareValue(id.toString()) : id;
            valueMap.put(id, jsonObject);
        }
        return valueMap;
    }
 
    @Override
    public void compareValues(String prefix, Object expectedValue, Object actualValue, JSONCompareResult result) throws JSONException {
        if (areLeaf(expectedValue, actualValue)) {         
            if (isNumeric(expectedValue) && isNumeric(actualValue)) {
                //For special numeric, such as NaN, convert to string to compare
                boolean equalsAsSpecialNumeric = (expectedValue.toString().equals(actualValue.toString()))
                 
                //For normal numeric, such as 153.6960001, 1.56E5, subtract and then get abosolute value
                boolean equalsAsGeneralNumeric = Math.abs(Double.parseDouble(expectedValue.toString())-Double.parseDouble(actualValue.toString()))<accuracy;
                 
                if (equalsAsSpecialNumeric||equalsAsGeneralNumeric) {
                    result.passed();
                } else {
                    result.fail(prefix, expectedValue, actualValue);
                }
                return;
            }
        }
        super.compareValues(prefix, expectedValue, actualValue, result);
    }
 
    private boolean areLeaf(Object expectedValue, Object actualValue) {
        boolean isLeafExpectedValue = !(expectedValue instanceof JSONArray)&&!(expectedValue instanceof JSONObject);
        boolean isLeafActualValue = !(actualValue instanceof JSONArray)&&!(actualValue instanceof JSONObject);
        return isLeafExpectedValue&&isLeafActualValue;
    }
}

  

posted on   张缤分  阅读(1598)  评论(0编辑  收藏  举报

编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· 25岁的心里话
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 按钮权限的设计及实现
历史上的今天:
2017-10-17 [SoapUI] Groovy获取HTTP Status

导航

< 2025年3月 >
23 24 25 26 27 28 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 1 2 3 4 5

统计

点击右上角即可分享
微信分享提示