RSQL-Parser和布尔查询值导致IllegalArgumentException错误。

huangapple
go评论115阅读模式
英文:

RSQL-Parser and boolean query values failing with IllegalArgumentException

问题

我有一个 REST API，我使用 RSQL 解析器实现了查询功能。它对一切都很有效，但布尔值 "true" 和 "false" 除外。

以下是我 RSQL 规范，根据 Baeldung 的示例稍作修改以处理 API 中的枚举值：

  1. public class GenericRsqlSpecification<T> implements Specification<T> {
  3.   private String property;
  4.   private ComparisonOperator operator;
  5.   private List<String> arguments;
  7.   public GenericRsqlSpecification(String property, ComparisonOperator operator, List<String> arguments) {
  8.     this.property = property;
  9.     this.operator = operator;
  10.     this.arguments = arguments;
  11.   }
  13.   @Override
  14.   public Predicate toPredicate(Root<T> root, CriteriaQuery<?> query, CriteriaBuilder builder) {
  15.     // ... （代码在此省略）
  16.   }
  18.   // ... （代码在此省略）
  19. }

关于 Car 模型的部分如下：

  1. public class CarDO {
  2.   @Id
  3.   @GeneratedValue(strategy = GenerationType.IDENTITY)
  4.   private Long id;
  5.   @Column(nullable = false)
  6.   @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME)
  7.   private ZonedDateTime dateCreated = ZonedDateTime.now();
  8.   @Column(nullable = false)
  9.   private String licensePlate;
  10.   @Column(nullable = false)
  11.   private int seatCount;
  12.   @Column(nullable = false)
  13.   private boolean convertible;
  14.   @Column(nullable = false)
  15.   private int rating;
  16.   @Column(nullable = false)
  17.   @Enumerated(EnumType.STRING)
  18.   private EngineType engineType;
  19.   @Column(nullable = false)
  20.   private String manufacturer;
  21.   @Column(nullable = false)
  22.   private boolean selected;
  23.   @OneToOne(fetch = FetchType.EAGER)
  24.   @JoinTable(name = "driver_with_car",
  25.     joinColumns = {@JoinColumn(name = "car_id")},
  26.     inverseJoinColumns = {@JoinColumn(name = "driver_id")})
  27.   private DriverDO driver;
  28.   //Constructors, Getters and Setters not included.
  29. }

目前，对这个问题不太确定如何解决。目前，搜索只会引发以下异常：

  1. java.lang.IllegalArgumentException: Parameter value [true] did not match expected type [java.lang.Boolean (n/a)]

有关其余代码的 Github 存储库链接请参见 car-booking-system。

英文:

I have a rest API which I have implemented a query feature using RSQL-Parser. It works great for everything but boolean values "true" & "false".
This is my Rsql Specification following examples from Baeldung with some minor alterations to deal with Enum values have in the API.

  1. public class GenericRsqlSpecification&lt;T&gt; implements Specification&lt;T&gt; {
  3.   private String property;
  4.   private ComparisonOperator operator;
  5.   private List&lt;String&gt; arguments;
  7.   public GenericRsqlSpecification(String property, ComparisonOperator operator, List&lt;String&gt; arguments) {
  8.     this.property = property;
  9.     this.operator = operator;
  10.     this.arguments = arguments;
  11.   }
  13.   @Override
  14.   public Predicate toPredicate(Root&lt;T&gt; root, CriteriaQuery&lt;?&gt; query,
  15.                                CriteriaBuilder builder) {
  16.     Path&lt;String&gt; propertyExpression = parseProperty(root);
  17.     List&lt;Object&gt; args = castArguments(propertyExpression);
  18.     Object argument = args.get(0);
  19.     switch (RsqlSearchOperation.getSimpleOperator(operator)) {
  20.       case EQUAL:
  21.         if (argument instanceof String)
  22.           return builder.like(propertyExpression,
  23.             argument.toString().replace(&#39;*&#39;, &#39;%&#39;));
  24.         else if (argument == null)
  25.           return builder.isNull(propertyExpression);
  26.         else return builder.equal(propertyExpression, argument);
  28.       case NOT_EQUAL:
  29.         if (argument instanceof String)
  30.           return builder.notLike(propertyExpression,
  31.             argument.toString().replace(&#39;*&#39;, &#39;%&#39;));
  32.         else if (argument == null)
  33.           return builder.isNotNull(propertyExpression);
  34.         else return builder.notEqual(propertyExpression, argument);
  36.       case GREATER_THAN:
  37.         return builder.greaterThan(propertyExpression,
  38.           argument.toString());
  40.       case GREATER_THAN_OR_EQUAL:
  41.         return builder.greaterThanOrEqualTo(propertyExpression,
  42.           argument.toString());
  44.       case LESS_THAN:
  45.         return builder.lessThan(propertyExpression,
  46.           argument.toString());
  48.       case LESS_THAN_OR_EQUAL:
  49.         return builder.lessThanOrEqualTo(propertyExpression,
  50.           argument.toString());
  51.       case IN:
  52.         return propertyExpression.in(args);
  53.       case NOT_IN:
  54.         return builder.not(propertyExpression.in(args));
  55.     }
  57.     return null;
  58.   }
  60.   private Path&lt;String&gt; parseProperty(Root&lt;T&gt; root) {
  61.     Path&lt;String&gt; path;
  62.     if (property.contains(&quot;.&quot;)) {
  63.       // Nested properties
  64.       String[] pathSteps = property.split(&quot;\\.&quot;);
  65.       String step = pathSteps[0];
  66.       path = root.get(step);
  67.       From lastFrom = root;
  69.       for (int i = 1; i &lt;= pathSteps.length - 1; i++) {
  70.         if (path instanceof PluralAttributePath) {
  71.           PluralAttribute attr = ((PluralAttributePath) path).getAttribute();
  72.           Join join = getJoin(attr, lastFrom);
  73.           path = join.get(pathSteps[i]);
  74.           lastFrom = join;
  75.         } else if (path instanceof SingularAttributePath) {
  76.           SingularAttribute attr = ((SingularAttributePath) path).getAttribute();
  77.           if (attr.getPersistentAttributeType() != Attribute.PersistentAttributeType.BASIC) {
  78.             Join join = lastFrom.join(attr, JoinType.LEFT);
  79.             path = join.get(pathSteps[i]);
  80.             lastFrom = join;
  81.           } else {
  82.             path = path.get(pathSteps[i]);
  83.           }
  84.         } else {
  85.           path = path.get(pathSteps[i]);
  86.         }
  87.       }
  88.     } else {
  89.       path = root.get(property);
  90.     }
  91.     return path;
  92.   }
  94.   private Join getJoin(PluralAttribute attr, From from) {
  95.     switch (attr.getCollectionType()) {
  96.       case COLLECTION:
  97.         return from.join((CollectionAttribute) attr);
  98.       case SET:
  99.         return from.join((SetAttribute) attr);
  100.       case LIST:
  101.         return from.join((ListAttribute) attr);
  102.       case MAP:
  103.         return from.join((MapAttribute) attr);
  104.       default:
  105.         return null;
  106.     }
  107.   }
  109.   private List&lt;Object&gt; castArguments(Path&lt;?&gt; propertyExpression) {
  110.     Class&lt;?&gt; type = propertyExpression.getJavaType();
  112.     return arguments.stream().map(arg -&gt; {
  113.       if (type.equals(Integer.class)) return Integer.parseInt(arg);
  114.       else if (type.equals(Long.class)) return Long.parseLong(arg);
  115.       else if (type.equals(Byte.class)) return Byte.parseByte(arg);
  116.       else if (type.equals(Boolean.class)) return Boolean.parseBoolean(arg);
  117.       else if (type.equals(EngineType.class)) return EngineType.valueOf(arg);
  118.       else if (type.equals(OnlineStatus.class)) return OnlineStatus.valueOf(arg);
  119.       else return arg;
  120.     }).collect(Collectors.toList());
  121.   }
  122. //GETTERS &amp; SETTERS left out.
  123. }

Car Model

  1. public class CarDO {
  2.   @Id
  3.   @GeneratedValue(strategy = GenerationType.IDENTITY)
  4.   private Long id;
  5.   @Column(nullable = false)
  6.   @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME)
  7.   private ZonedDateTime dateCreated = ZonedDateTime.now();
  8.   @Column(nullable = false)
  9.   private String licensePlate;
  10.   @Column(nullable = false)
  11.   private int seatCount;
  12.   @Column(nullable = false)
  13.   private boolean convertible;
  14.   @Column(nullable = false)
  15.   private int rating;
  16.   @Column(nullable = false)
  17.   @Enumerated(EnumType.STRING)
  18.   private EngineType engineType;
  19.   @Column(nullable = false)
  20.   private String manufacturer;
  21.   @Column(nullable = false)
  22.   private boolean selected;
  23.   @OneToOne(fetch = FetchType.EAGER)
  24.   @JoinTable(name = &quot;driver_with_car&quot;,
  25.     joinColumns = {@JoinColumn(name = &quot;car_id&quot;)},
  26.     inverseJoinColumns = {@JoinColumn(name = &quot;driver_id&quot;)})
  27.   private DriverDO driver;
  28. //Constructors, Getters and Setters not included.
  29. }

Not really sure on how to work around this issue. Currently, the search just fails with this exception

  1. java.lang.IllegalArgumentException: Parameter value [true] did not match expected type [java.lang.Boolean (n/a)]

Github repo for rest of the code
car-booking-system

答案1

得分: 1

在一个“这不可能是这样，但是算了” 的瞬间，我将可转换和选择的数据类型从boolean更改为Boolean，然后一切正常运作。

  1. public class CarDO {
  2.   @Id
  3.   @GeneratedValue(strategy = GenerationType.IDENTITY)
  4.   private Long id;
  5.   @Column(nullable = false)
  6.   @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME)
  7.   private ZonedDateTime dateCreated = ZonedDateTime.now();
  8.   @Column(nullable = false)
  9.   private String licensePlate;
  10.   @Column(nullable = false)
  11.   private int seatCount;
  12.   @Column(nullable = false)
  13.   private Boolean convertible;
  14.   @Column(nullable = false)
  15.   private int rating;
  16.   @Column(nullable = false)
  17.   @Enumerated(EnumType.STRING)
  18.   private EngineType engineType;
  19.   @Column(nullable = false)
  20.   private String manufacturer;
  21.   @Column(nullable = false)
  22.   private Boolean selected;
  23.   @OneToOne(fetch = FetchType.EAGER)
  24.   @JoinTable(name = "driver_with_car",
  25.     joinColumns = {@JoinColumn(name = "car_id")},
  26.     inverseJoinColumns = {@JoinColumn(name = "driver_id")})
  27.   private DriverDO driver;
  28. }
英文:

So on a "That can't be it but what the heck" moment I changed the datatype of convertible and selected to Boolean instead of boolean and all worked fine.

  1. public class CarDO {
  2.   @Id
  3.   @GeneratedValue(strategy = GenerationType.IDENTITY)
  4.   private Long id;
  5.   @Column(nullable = false)
  6.   @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME)
  7.   private ZonedDateTime dateCreated = ZonedDateTime.now();
  8.   @Column(nullable = false)
  9.   private String licensePlate;
  10.   @Column(nullable = false)
  11.   private int seatCount;
  12.   @Column(nullable = false)
  13.   private Boolean convertible;
  14.   @Column(nullable = false)
  15.   private int rating;
  16.   @Column(nullable = false)
  17.   @Enumerated(EnumType.STRING)
  18.   private EngineType engineType;
  19.   @Column(nullable = false)
  20.   private String manufacturer;
  21.   @Column(nullable = false)
  22.   private Boolean selected;
  23.   @OneToOne(fetch = FetchType.EAGER)
  24.   @JoinTable(name = &quot;driver_with_car&quot;,
  25.     joinColumns = {@JoinColumn(name = &quot;car_id&quot;)},
  26.     inverseJoinColumns = {@JoinColumn(name = &quot;driver_id&quot;)})
  27.   private DriverDO driver;

huangapple
  • 本文由 发表于 2020年10月8日 22:04:48
  • 转载请务必保留本文链接：https://go.coder-hub.com/64264235.html
  • java
  • spring-boot
  • spring-data
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定