A simple SQL query builder utility
Pre-requisites:
- Define metadata of entities(Optional)
- Define the report config supported by the builder utility.
what this utility does ?
- Translates a Report config to a RAW SQL query. Client can execute the query on their RDBMS datasource.
Supports:
- Simple select query
- Supports 3-5 level join query
- Supports filters on string and integer datatypes
- Supports Orderby
- Supports groupBy
Sample Request: https://github.com/ManikantaKandagatla/querybuilder/tree/master/src/main/resources/samples for request paylod needs to be send to this utility
API:
-
POST : http://localhost:8080/getData Request payload: sample request
-
POST : http://localhost:8080/buildQuery Request payload: sample request
How to run:
- Download the code
- Change the datasource properties accordingly in application.properties
- Run : mvn clean install
- Start springboot application -> main class: QuerybuilderApplication