Package org.diabetestechnology.drh.service.http.pg.ux

Class TabularRowsDbSession

java.lang.Object

org.diabetestechnology.drh.service.http.pg.ux.TabularRowsDbSession

@Controller
public class TabularRowsDbSession
extends Object

Constructor Summary

Constructors

Constructor	Description
TabularRowsDbSession(UdiSecondaryDbConfig udiPrimeDbConfig, AuditService auditService, org.springframework.cache.CacheManager cacheManager, UserNameService userNameService, PartyService partyService, Presentation presentation)

Method Summary

Modifier and Type	Method	Description
TabularRowsResponse<?>	customAllStudyDashboardTabularRows(TabularRowsRequest payload, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	customPopulationTabularRows(TabularRowsRequest payload, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	customStudyTabularRows(TabularRowsRequest payload, String schemaName, String masterTableNameOrViewName, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctFileInteractionRows(TabularRowsRequest payload, String schemaName, String columns, String viewName, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctOrgTabularAuditRows(TabularRowsRequest payload, String columns, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctTabularAuditRows(TabularRowsRequest payload, String columns, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctTabularAuditRowsOfUser(TabularRowsRequest payload, String columns, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	distinctTabularFileIntractionRowstRows(TabularRowsRequest payload, String schemaName, String columns, String masterTableNameOrViewName, String notEqColumnName, String notEqColumnValue, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
TabularRowsResponse<?>	fetchParticipantData(String studyId, TabularRowsRequest payload, String schemaName, String viewName, String columns, boolean includeGeneratedSqlInResp, boolean includeGeneratedSqlInErrorResp)
Object	filterByStudyDisplayId(String schemaName, String masterTableNameOrViewName, String studyDisplayId)
Object	getSubFileGridData(String schemaName, String viewName, String fileCategory, String studyId)
Object	tabularColumnCustom(String schemaName, String columns, String masterTableNameOrViewName, String columnName, String columnValue)
Object	tabularRowsCustom(String columnName, String columnValue)

Methods inherited from class java.lang.Object

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

Constructor Details

TabularRowsDbSession

public TabularRowsDbSession(UdiSecondaryDbConfig udiPrimeDbConfig,
 AuditService auditService,
 org.springframework.cache.CacheManager cacheManager,
 UserNameService userNameService,
 PartyService partyService,
 Presentation presentation)

Method Details

tabularRowsCustom

@GetMapping("/api/ux/tabular/jooq/db/drh_stateless_activity_audit/vw_activity_log/{columnName}/{columnValue}.json")
@ResponseBody
public Object tabularRowsCustom(@PathVariable
 String columnName,
 @PathVariable
 String columnValue)

filterByStudyDisplayId

@GetMapping("/api/ux/tabular/jooq/db/{schemaName}/{masterTableNameOrViewName}/study_display_id/{studyDisplayId}.json")
@ResponseBody
public Object filterByStudyDisplayId(@PathVariable
 String schemaName,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String studyDisplayId)

distinctTabularAuditRows

@PostMapping(value="/api/ux/tabular/jooq/db/distinct/audit/drh_stateless_activity_audit/vw_activity_log.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> distinctTabularAuditRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable(required=false)
 String notEqColumnName,
 @PathVariable(required=false)
 String notEqColumnValue,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

tabularColumnCustom

@GetMapping("/api/ux/tabular/jooq/db/column/{schemaName}/{masterTableNameOrViewName}/{columnName}/{columnValue}.json")
@ResponseBody
public Object tabularColumnCustom(@PathVariable(required=false)
 String schemaName,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable
 String masterTableNameOrViewName,
 @PathVariable
 String columnName,
 @PathVariable
 String columnValue)

customStudyTabularRows

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

fetchParticipantData

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

customPopulationTabularRows

@PostMapping(value="/api/ux/tabular/jooq/db/study/population/dashboard_all_research_study_view.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> customPopulationTabularRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

customAllStudyDashboardTabularRows

@PostMapping(value="/api/ux/tabular/jooq/db/research-study/dashboard/custom_dashboard_all_research_study_view.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> customAllStudyDashboardTabularRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

distinctFileInteractionRows

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

distinctTabularFileIntractionRowstRows

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

getSubFileGridData

@GetMapping("/api/ux/tabular/jooq/db/{schemaName}/{viewName}/{file_category}/{fileCategory}/study_id/{studyId}.json")
@ResponseBody
public Object getSubFileGridData(@PathVariable
 String schemaName,
 @PathVariable
 String viewName,
 @PathVariable
 String fileCategory,
 @PathVariable
 String studyId)

distinctTabularAuditRowsOfUser

@PostMapping(value="/api/ux/tabular/jooq/db/user/distinct/audit/drh_stateless_activity_audit/vw_activity_log.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> distinctTabularAuditRowsOfUser(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable(required=false)
 String notEqColumnName,
 @PathVariable(required=false)
 String notEqColumnValue,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)

distinctOrgTabularAuditRows

@PostMapping(value="/api/ux/tabular/jooq/db/distinct/org/audit/drh_stateless_activity_audit/vw_activity_log.json",
             consumes="application/json",
             produces="application/json")
@ResponseBody
public TabularRowsResponse<?> distinctOrgTabularAuditRows(@RequestBody @Nonnull
 TabularRowsRequest payload,
 @RequestParam(required=false,defaultValue="*")
 String columns,
 @PathVariable(required=false)
 String notEqColumnName,
 @PathVariable(required=false)
 String notEqColumnValue,
 @RequestHeader(value="X-Include-Generated-SQL-In-Response",required=false)
 boolean includeGeneratedSqlInResp,
 @RequestHeader(value="X-Include-Generated-SQL-In-Error-Response",required=false,defaultValue="true")
 boolean includeGeneratedSqlInErrorResp)