Package org.techbd.service.http.hub.prime.ux

Class TabularRowsController

java.lang.Object

org.techbd.service.http.hub.prime.ux.TabularRowsController

@Controller
public class TabularRowsController
extends Object

Constructor Summary

Constructors

Constructor	Description
TabularRowsController(UdiPrimeJpaConfig udiPrimeJpaConfig)

Method Summary

Modifier and Type	Method	Description
Object	getSubmissionCountsBetweenDates(String schemaName, String viewName, String columnName1, String columnValue1, String dateField, String startDateTimeValue, String endDateTimeValue)
TabularRowsResponse<?>	tabularRows(String schemaName, String masterTableNameOrViewName, TabularRowsRequest payload, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
Object	tabularRowsCustom(String schemaName, String masterTableNameOrViewName, String columnName, String columnValue)
Object	tabularRowsCustomWithMultipleParams(String schemaName, String masterTableNameOrViewName, String columnName, String columnValue, String columnName2, String columnValue2)
Object	tabularRowsCustomWithMultipleParamsChecks(String schemaName, String masterTableNameOrViewName, String columnName1, String columnValue1, String columnName2, String columnValue2, String columnName3, String columnValue3)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

TabularRowsController

public TabularRowsController(UdiPrimeJpaConfig udiPrimeJpaConfig)

Method Details

tabularRows

@PostMapping(value={"/api/ux/tabular/jooq/{masterTableNameOrViewName}.json","/api/ux/tabular/jooq/{schemaName}/{masterTableNameOrViewName}.json"},
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> tabularRows(@PathVariable(required=false)
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false,defaultValue="false")
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

tabularRowsCustom

@GetMapping("/api/ux/tabular/jooq/{schemaName}/{masterTableNameOrViewName}/{columnName}/{columnValue}.json")
@ResponseBody
public Object tabularRowsCustom(@PathVariable(required=false)
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String columnName,
 @PathVariable
 String columnValue)

tabularRowsCustomWithMultipleParams

@GetMapping("/api/ux/tabular/jooq/{schemaName}/{masterTableNameOrViewName}/{columnName}/{columnValue}/{columnName2}/{columnValue2}.json")
@ResponseBody
public Object tabularRowsCustomWithMultipleParams(@PathVariable(required=false)
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String columnName,
 @PathVariable
 String columnValue,
 @PathVariable
 String columnName2,
 @PathVariable
 String columnValue2)

tabularRowsCustomWithMultipleParamsChecks

@GetMapping("/api/ux/tabular/jooq/multiparam/{schemaName}/{masterTableNameOrViewName}/{columnName1}/{columnValue1}/{columnName2}/{columnValue2}/{columnName3}/{columnValue3}.json")
@ResponseBody
public Object tabularRowsCustomWithMultipleParamsChecks(@PathVariable(required=false)
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String columnName1,
 @PathVariable
 String columnValue1,
 @PathVariable
 String columnName2,
 @PathVariable
 String columnValue2,
 @PathVariable
 String columnName3,
 @PathVariable
 String columnValue3)

getSubmissionCountsBetweenDates

@GetMapping({"/api/ux/tabular/jooq/{schemaName}/{viewName}/{dateField}/{startDateTimeValue}/{endDateTimeValue}.json","/api/ux/tabular/jooq/{schemaName}/{viewName}/{columnName1}/{columnValue1}/{dateField}/{startDateTimeValue}/{endDateTimeValue}.json"})
@ResponseBody
public Object getSubmissionCountsBetweenDates(@PathVariable(required=true)
 String schemaName,
 @PathVariable
 String viewName,
 @PathVariable(required=false)
 String columnName1,
 @PathVariable(required=false)
 String columnValue1,
 @PathVariable
 String dateField,
 @PathVariable
 String startDateTimeValue,
 @PathVariable
 String endDateTimeValue)
                                       throws UnsupportedEncodingException

Throws:

UnsupportedEncodingException