puzhibing
4 天以前 3650ce7f5d42d1bef58abea9693f20d1f209d3b0
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
package com.ruoyi.order.mapper;
 
import org.junit.jupiter.api.Test;
 
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.nio.charset.StandardCharsets;
import java.util.stream.Collectors;
 
import static org.junit.jupiter.api.Assertions.assertFalse;
import static org.junit.jupiter.api.Assertions.assertNotNull;
import static org.junit.jupiter.api.Assertions.assertTrue;
 
class VinChargingOrderMapperStructureTest {
 
    @Test
    void usesOnlyVinOrderTablesAndSupportsRequiredFilters() throws IOException {
        InputStream input = getClass().getClassLoader().getResourceAsStream("mapper/order/TVinChargingOrderMapper.xml");
        assertNotNull(input);
        String mapper;
        try (BufferedReader reader = new BufferedReader(new InputStreamReader(input, StandardCharsets.UTF_8))) {
            mapper = reader.lines().collect(Collectors.joining("\n")).toLowerCase();
        }
        assertTrue(mapper.contains("from t_vin_charging_order o"));
        assertTrue(mapper.contains("from t_vin_charging_order_accounting_strategy"));
        assertTrue(mapper.contains("query.vin"));
        assertTrue(mapper.contains("query.platenum"));
        assertTrue(mapper.contains("query.phone"));
        assertTrue(mapper.contains("query.siteids"));
        assertTrue(mapper.contains("query.companyid"));
        assertTrue(mapper.contains("query.fleetid"));
        assertTrue(mapper.contains("o.company_id = #{query.companyid}"));
        assertTrue(mapper.contains("o.fleet_id = #{query.fleetid}"));
        assertTrue(mapper.contains("countaccountingstrategies"));
        assertTrue(mapper.contains("group by charging_order_id"));
        assertTrue(mapper.contains("pageappletorders"));
        assertTrue(mapper.contains("o.vin_id in"));
        assertTrue(mapper.contains("o.app_user_id = #{appuserid}"));
        assertTrue(mapper.contains("order by o.create_time desc, o.id desc"));
        assertTrue(mapper.contains("limit #{offset}, #{pagesize}"));
        assertTrue(mapper.contains("getchargingvinstatus"));
        assertTrue(mapper.contains("o.status = 3"));
        assertTrue(mapper.contains("group by o.vin_id"));
        assertFalse(mapper.contains("t_vin_management"));
        assertFalse(mapper.contains("t_card_"));
        assertFalse(mapper.contains("from t_charging_order "));
    }
}