添加几个测试用的sql

abel533 · abel533 · commit b06f28cfb51e · 2018-04-07T19:25:55.000+08:00
diff --git a/src/test/java/com/github/pagehelper/sql/SqlTest.java b/src/test/java/com/github/pagehelper/sql/SqlTest.java
@@ -67,6 +67,29 @@ public void testSqlParser() throws JSQLParserException {
         System.out.println(countSqlParser.getSmartCountSql("select * from (select * from aa10 WHERE aaa100 LIKE 'AAB05%' " +
                 "union " +
                 "select * from aa10 where aaa100 = 'AAC031')"));
+
+        System.out.println(countSqlParser.getSmartCountSql("select so.id,so.address,so.area_code,so.area_id,so.del_flag,so.email,so.fax,so.grade,so.icon,so.master, so.name,so.parent_id,so.parent_ids,so.phone,so.remarks,so.type,so.zip_code from sys_organization so LEFT JOIN sys_user_organization suo ON (suo.org_id = so.id or FIND_IN_SET(suo.org_id,so.parent_ids)) where suo.user_id = ? group by so.id LIMIT ? "));
+    }
+
+
+    @Test
+    public void testSqlParser11() throws JSQLParserException {
+        CountSqlParser countSqlParser = new CountSqlParser();
+        System.out.println(countSqlParser.getSmartCountSql(
+                "select so.id,so.address,so.area_code,so.area_id,so.del_flag,so.email," +
+                        "so.fax,so.grade,so.icon,so.master, so.name,so.parent_id,so.parent_ids," +
+                        "so.phone,so.remarks,so.type,so.zip_code " +
+                        "from sys_organization so " +
+                        "LEFT JOIN sys_user_organization suo ON (suo.org_id = so.id or FIND_IN_SET(suo.org_id,so.parent_ids)) " +
+                        "where suo.user_id = ? group by so.id LIMIT ? "));
+
+        System.out.println(countSqlParser.getSmartCountSql(
+                "select so.id,so.address,so.area_code,so.area_id,so.del_flag,so.email," +
+                        "so.fax,so.grade,so.icon,so.master, so.name,so.parent_id,so.parent_ids," +
+                        "so.phone,so.remarks,so.type,so.zip_code " +
+                        "from sys_organization so " +
+                        "LEFT JOIN sys_user_organization suo ON (suo.org_id = so.id or FIND_IN_SET(suo.org_id,so.parent_ids)) " +
+                        "where suo.user_id = ?"));
     }
 
     @Test
