我需要将谓词添加到 JSONB 列的现有谓词列表中。
Entity:
@Entity
@Table(name = "a")
@TypeDefs({
@TypeDef(name = "jsonb", typeClass = JsonBinaryType.class),
})
public class EntityA {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "a_id_seq")
@SequenceGenerator(sequenceName = "a_id_seq", allocationSize = 1, name = "a_id_seq")
@Column(name = "id")
private long id;
@Column(name = "name")
private String name;
@Column(name = "json")
@Type(type = "jsonb")
private Json json;
private static class Json {
private String name;
private Integer number;
private String random;
}
}
规格:
public Specification<EntityA> buildSpecification(Filter filter){
return (root, query, cb) -> {
List<Predicate> predicates = new ArrayList<>();
Expression<String> nameExpression = root.get("name");
Predicate namePredicate = nameExpression.in(filter.getNames());
predicates.add(namePredicate);
//TODO add a predicate for JSONB here
return cb.and(predicates.toArray(new Predicate[0]));
};
我的输入将是 List jsonNames 或 List jsonNumbers,我想使用此输入构建 CriteriaBuilder.In 并获取任何匹配项。
Filter:
@Data
public class Filter {
private List<String> names;
private List<String> jsonNames;
private List<Integer> jsonNumbers;
}
对于 PostgreSQL
Predicate inJsonNumbers = cb
.function("jsonb_extract_path_text",
String.class,
root.get("json"),
cb.literal("number"))
.in(filter.getJsonNumbers())
Predicate inJsonNames = cb
.function("jsonb_extract_path_text",
String.class,
root.get("json"),
cb.literal("name"))
.in(filter.getJsonNames())
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)