Introducing
Changes Is Enemy, But We Must Prepared . –
I have been code with spring boot and thymeleaf, When the *User Interface * add a new search criteria the backend code (my repository, service and controller) must changed too. Honestly I don’t like that. to much changing :(.
I try searching library to handle changes, so make minimum rewriting code when User Interface Changed.
And Woww Gotchaaaa… RSQL-PARSER
What Is Rsql-Parser
RSQL-Parser is a query language for parametrized filtering of entries in RESTful APIs. It’s based on FIQL (Feed Item Query Language) – an URI-friendly syntax for expressing filters across the entries in an Atom Feed. FIQL is great for use in URI; there are no unsafe characters, so URL encoding is not required. On the other side, FIQL’s syntax is not very intuitive and URL encoding isn’t always that big deal, so RSQL also provides a friendlier syntax for logical operators and some of the comparison operators.-Github Rsql parser
Before we go to dev this is pom.xml i have used
- spring-boot-starter-parent: 1.3.5
- lombok :1.16.8
- mysql
- rsql-parser : 2.1.0
- commons-lang : 2.6
- hibernate-java8 : 5.0.5.Final
- java 8
This Is my Table
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
CREATE TABLE `table_testing_rsql` ( `id` bigint(20) NOT NULL, `date_test` date DEFAULT NULL, `big_decimal_test` decimal(38,10) DEFAULT NULL, `date_time_test` datetime DEFAULT NULL, `varchar_test` varchar(100) DEFAULT NULL, `int_test` int(11) DEFAULT NULL, `float_test` float(10,1) DEFAULT NULL, `char_test` char(1) DEFAULT NULL, `double_test` double DEFAULT NULL, PRIMARY KEY (`id`) ) |
i have try to cover all datatype we usually using in the application.
JPARsqlConverter.java
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
if (op.equals(EQUAL)) { if (type.equals(String.class) && argument.toString().contains("*")) { return builder.like(attrPath, argument.toString().replace('*', '%')); } else if (argument == null) { return builder.isNull(attrPath); } else { return builder.equal(attrPath, argument); } } if (op.equals(NOT_EQUAL)) { if (type.equals(String.class) && argument.toString().contains("*")) { return builder.notLike(attrPath, argument.toString().replace('*', '%')); } else if (argument == null) { return builder.isNotNull(attrPath); } else { return builder.notEqual(attrPath, argument); } } |
All value String convert into Object appropriate with the Pojo Attribute DataType.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
public Object castDynamicClass(Class dynamicClass, String value){ Object object=null; try{ Constructor <?> cons =(Constructor<?>) dynamicClass.getConstructor(new Class<?>[]{String.class}); object = cons.newInstance(new Object[]{value}); return object; } catch (Exception e) { e.printStackTrace(); } return null; } |
Implementation RSQL in Services layer
|
1 2 3 4 |
public List<TableTestingRsql> findBySpec(String p_filter) { return repo.findAll(RsqlSpecification.<TableTestingRsql>rsql(p_filter)); } |
Simple Like That..
p_filter like this
– Where Clause Equals –> bigDecimalTest==1234556.1234567890
– Where Clause Not Equals –>idTest!=1
– Where Clause IN –> charTest=in=(A,B)
– Where Clause Not In –> doubleTest=out=(1.456789,156789.56789)
– Where Clause Grater Than –>doubleTest=gt=156789.56789
– Where Clause Less Than –> floatTest=le=5.5
– Where Clause Like –> varcharTest==ou**
– Where Clause Not Like –> varcharTest!=ou**
– Complex Query clausa –> ( dateTest=in=(2016-05-24,2016-05-25);intTest=in=(1,4)),idTest==5″
note :
Logical AND –> ;
Logical OR –> ,-
i Have create 10 classes test too prove all is well.
And then , this is the result testing Junit.
| MySql Type | Java Type | Operator == | Operator != | >> and >= | < and <= | IN(..) | Not IN (..) |
|---|---|---|---|---|---|---|---|
| bigint | BigInteger | OK | OK | OK | OK | OK | OK |
| date | LocalDate | OK | OK | OK | OK | OK | OK |
| decimal | BigDecimal | OK | OK | OK | OK | OK | OK |
| datetime | LocalDateTime | OK | OK | OK | OK | OK | OK |
| varchar | String | OK | OK | OK | OK | OK | OK |
| int | Integer | OK | OK | OK | OK | OK | OK |
| float | Float | OK | OK | OK | OK | Not OK | Not OK |
| char | Character | OK | OK | OK | OK | OK | OK |
| double | Double | OK | OK | OK | OK | OK | OK|OK |
References
– Github RSQL-parser
– Baeldung
– For Full Code Check My Github.com
