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 "));
|
}
|
}
|