Repository navigation
Releases: BalaVigneshTechMango/QueryBuilderTool
Release list
QueryBuilderAPI-V1.0.7
Merge pull request #16 from BalaVigneshTechMango/feature/Task-90-dyna…
QueryBuilderAPI-V1.0.6
Merge pull request #15 from BalaVigneshTechMango/feature/Task-82-vali…
QueryBuilderAPI-V1.0.5
Updated the Response for fetch column Details API as column list and primary and foreign key.
Update the query for fetch column details.
Created enum for key column.
Created response pojo for iteration of column details.
QueryBuilder-V1.0.4
In the Release Add New Feature Joins.
Request Json is updated as table dot column name and add joins list.
Validation for column list, where condition columns and on condition columns are validated.
Query has been updated as a table and column add its datatype as in a single query. And Get data type and validation query are updated.
Fetch column details response is changed with table list.
Used separate constants for query.
QueryBuilderAPI-V1.0.3
Code Review Change (18/20 - CR.)
Add application context path.
Updated the controller,service and dao as per the core logic.
Change Named Parameter JdbcTemplate.
Added Logger for API flow.
QueryBuilderAPI-V1.0.2
Query build after validating the fields column and table name.
updated using Map Sql Parameter query.
Update get data type of the column in where condition by using list of column and table name.
QueryBuilderAPI-V1.0.1
Add Business validation and Spring validation
Created method to check the schema exists.
Schema name in database and validate it as valid schema name or not.
Created method to get column and datatype using table Name.
In Where clause using table Name get the column datatype as per the datatype the sql query will generate.
QueryBuilderAPI
Using dataBase name get the Entire table details like table Name with column and datatype.
Filter API for Select query with and without where condition returns the QueryResult.
Preview API for Select query with and without where condition returns the PreviewQuery.
Joins with multiple tables with and without where condition Query Preview and QueryResult can get in return.