Initial commit: bositao cloud (jnpf-java-cloud-v6x)

刘光辉

9 小时以前 06f314545ac3514d7ce28939920866ae8188d31c

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
package jnpf.onlinedev.util;
 
import org.junit.jupiter.api.Test;
import org.mybatis.dynamic.sql.SqlBuilder;
import org.mybatis.dynamic.sql.SqlTable;
import org.mybatis.dynamic.sql.render.RenderingStrategies;
 
import java.util.function.Predicate;
 
import static org.junit.jupiter.api.Assertions.assertEquals;
import static org.junit.jupiter.api.Assertions.assertTrue;
 
public class WorkflowListSortUtilsTest {
 
    @Test
    public void mapsAscendingStateAliasToPhysicalColumn() {
        assertOrder("flowState", true, "f_flow_state", field -> true, "records.f_flow_state");
    }
 
    @Test
    public void descendingStateHasNoLeadingAscendingState() {
        assertOrder("-flowState", true, "f_flow_state", field -> true, "records.f_flow_state DESC");
    }
 
    @Test
    public void acceptsPhysicalStateFieldFromDefaultSortConfiguration() {
        assertOrder("-f_flow_state", true, "f_flow_state", field -> true, "records.f_flow_state DESC");
    }
 
    @Test
    public void preservesRequestedMultiColumnPriority() {
        assertOrder("title,-flowState", true, "f_flow_state", field -> true,
                "records.title, records.f_flow_state DESC");
    }
 
    @Test
    public void retainsDefaultStatePriorityWhenOnlyBusinessFieldsAreSorted() {
        assertOrder("-title", true, "f_flow_state", field -> true,
                "records.f_flow_state, records.title DESC");
    }
 
    @Test
    public void restoresStateAndPrimaryKeyOrderWhenSortingIsCleared() {
        assertOrder("", true, "f_flow_state", field -> true,
                "records.f_flow_state, records.f_id DESC");
    }
 
    @Test
    public void usesDatabaseSpecificUppercaseColumnForOracleAndDm() {
        assertOrder("-flowState", true, "F_FLOW_STATE", field -> true, "records.F_FLOW_STATE DESC");
    }
 
    @Test
    public void allowsSystemStateEvenWhenDisplayOnlyFieldsAreFiltered() {
        assertOrder("virtual,-flowState,child-name", true, "f_flow_state", field -> false,
                "records.f_flow_state DESC");
    }
 
    @Test
    public void leavesNonWorkflowListsUnchanged() {
        assertOrder("-title", false, "f_flow_state", field -> true, "records.title DESC");
        assertOrder(null, false, "f_flow_state", field -> true, "records.f_id DESC");
        assertOrder("flowState", false, "f_flow_state", field -> true, "records.flowState");
    }
 
    private void assertOrder(String sidx, boolean enableFlow, String stateField, Predicate<String> allowed, String expected) {
        SqlTable table = SqlTable.of("records");
        String sql = SqlBuilder.select(table.column("f_id"), table.column(stateField).as("flowState"))
                .from(table)
                .orderBy(WorkflowListSortUtils.orderBy("records", stateField, "f_id", enableFlow, sidx, allowed))
                .build().render(RenderingStrategies.MYBATIS3).getSelectStatement();
        assertTrue(sql.contains(" order by "), sql);
        assertEquals(expected, sql.substring(sql.indexOf(" order by ") + " order by ".length()));
    }
}