support FIND_IN_SET cond (elunez#745)

aborn · web-flow · commit f0ed88c51eeb · 2023-07-04T17:32:22.000+08:00
* fix weird prefixes keys when use RedisUtils.scan * Column use `` for reserved key ref: https://stackoverflow.com/questions/2224503/how-to-map-an-entity-field-whose-name-is-a-reserved-word-in-jpa * add FIND_IN_SET 条件查询 * note
diff --git a/eladmin-common/src/main/java/me/zhengjie/annotation/Query.java b/eladmin-common/src/main/java/me/zhengjie/annotation/Query.java
@@ -74,7 +74,9 @@ enum Type {
         // 不为空
         ,NOT_NULL
         // 为空
-        ,IS_NULL
+        ,IS_NULL,
+        // Aborn Jiang 2022/06/01, 对应SQL: SELECT * FROM table WHERE FIND_IN_SET('querytag', table.tags);
+        FIND_IN_SET
     }
 
     /**
diff --git a/eladmin-common/src/main/java/me/zhengjie/utils/QueryHelp.java b/eladmin-common/src/main/java/me/zhengjie/utils/QueryHelp.java
@@ -166,6 +166,10 @@ public static <R, Q> Predicate getPredicate(Root<R> root, Q query, CriteriaBuild
                                         (Comparable) between.get(0), (Comparable) between.get(1)));
                             }
                             break;
+                        case FIND_IN_SET:
+                            list.add(cb.greaterThan(cb.function("FIND_IN_SET", Integer.class,
+                                    cb.literal(val.toString()), root.get(attributeName)), 0));
+                            break;
                         default: break;
                     }
                 }

Original file line number	Diff line number	Diff line change
`@@ -166,6 +166,10 @@ public static <R, Q> Predicate getPredicate(Root<R> root, Q query, CriteriaBuild`
`166`	`166`	`(Comparable) between.get(0), (Comparable) between.get(1)));`
`167`	`167`	`}`
`168`	`168`	`break;`
	`169`	`+ case FIND_IN_SET:`
	`170`	`+ list.add(cb.greaterThan(cb.function("FIND_IN_SET", Integer.class,`
	`171`	`+ cb.literal(val.toString()), root.get(attributeName)), 0));`
	`172`	`+ break;`
`169`	`173`	`default: break;`
`170`	`174`	`}`
`171`	`175`	`}`