GeezerVison is showing github.com — Java: MultiDataSource 为 APIAuto 自动分组提供 @raw 原生 SQL 片段配置 · giantank/APIJSON-Demo@2dc31e8
File treeExpand file treeCollapse file tree Open diff view settings APIJSON-Java-Server/APIJSONBoot-MultiDataSource/src/main/java/apijson/demo
Expand file treeCollapse file tree Open diff view settings Collapse file Copy file name to clipboardExpand all lines: APIJSON-Java-Server/APIJSONBoot-MultiDataSource/src/main/java/apijson/demo/DemoSQLConfig.java +12Lines changed: 12 additions & 0 deletions | Original file line number | Diff line number | Diff line change |
|---|
@@ -164,6 +164,18 @@ public String getUserIdKey(String database, String schema, String datasource, St | 164 | 164 | RAW_MAP.put("commentWhereItem1","(`Comment`.`userId` = 38710 AND `Comment`.`momentId` = 470)"); | 165 | 165 | RAW_MAP.put("to_days(now())-to_days(`date`)<=7", ""); // 给 @having 使用 | 166 | 166 | RAW_MAP.put("sexShowStr", "CASE sex WHEN 0 THEN '男' WHEN 1 THEN '女' ELSE '其它' END"); // 给 @having 使用 | | 167 | + RAW_MAP.put("length(url)-length(substring_index(url,'/',-1))-1", ""); // APIAuto 获取分组 | | 168 | + RAW_MAP.put("length(url) - length(substring_index(url,'/',-1)) - 1", ""); // APIAuto 获取分组 | | 169 | + RAW_MAP.put("substr(url,1,length(url)-length(substring_index(url,'/',-1))-1)", ""); // APIAuto 获取分组 | | 170 | + RAW_MAP.put("substr(url,1,length(url) - length(substring_index(url,'/',-1)) - 1)", ""); // APIAuto 获取分组 | | 171 | + RAW_MAP.put("substr(url,1,length(url)-length(substring_index(url,'/',-1))-1) url", ""); // APIAuto 获取分组 | | 172 | + RAW_MAP.put("substr(url,1,length(url) - length(substring_index(url,'/',-1)) - 1) url", ""); // APIAuto 获取分组 | | 173 | + RAW_MAP.put("length(substr(url,1,length(url)-length(substring_index(url,'/',-1))-1))", ""); // APIAuto 获取分组 | | 174 | + RAW_MAP.put("ifnull(`group`,'_')", ""); // APIAuto 获取分组 | | 175 | + RAW_MAP.put("any_value(ifnull(`group`,'_'))", ""); // APIAuto 获取分组 | | 176 | + RAW_MAP.put("CASE WHEN length(`group`) > 0 THEN `group` ELSE '_' END", ""); // APIAuto 获取分组 | | 177 | + RAW_MAP.put("(CASE WHEN length(`group`) > 0 THEN `group` ELSE '_' END)", ""); // APIAuto 获取分组 | | 178 | + RAW_MAP.put("(CASE WHEN length(`group`) > 0 THEN `group` ELSE '_' END) `name`", ""); // APIAuto 获取分组 | 167 | 179 | } | 168 | 180 |
| 169 | 181 |
| |
|