com.oracle.bmc.opsi.model

Class DataObjectTemplatizedQuery.Builder

java.lang.Object

com.oracle.bmc.opsi.model.DataObjectTemplatizedQuery.Builder

Enclosing class:

DataObjectTemplatizedQuery

public static class DataObjectTemplatizedQuery.Builder
extends Object

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
DataObjectTemplatizedQuery.Builder	bindParams(List<DataObjectBindParameter> bindParams)
DataObjectTemplatizedQuery	build()
DataObjectTemplatizedQuery.Builder	copy(DataObjectTemplatizedQuery model)
DataObjectTemplatizedQuery.Builder	fromClause(String fromClause) Unique data object name that will be added into the FROM clause of the query, just like a view name in FROM clause.
DataObjectTemplatizedQuery.Builder	groupByList(List<String> groupByList) List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.
DataObjectTemplatizedQuery.Builder	havingConditionsList(List<String> havingConditionsList) List of items to be added into the HAVING clause of the query; items will be added with AND separation.
DataObjectTemplatizedQuery.Builder	orderByList(List<String> orderByList) List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.
DataObjectTemplatizedQuery.Builder	queryExecutionTimeoutInSeconds(Double queryExecutionTimeoutInSeconds)
DataObjectTemplatizedQuery.Builder	selectList(List<String> selectList) List of items to be added into the SELECT clause of the query; items will be added with comma separation.
DataObjectTemplatizedQuery.Builder	timeFilters(DataObjectQueryTimeFilters timeFilters)
DataObjectTemplatizedQuery.Builder	whereConditionsList(List<String> whereConditionsList) List of items to be added into the WHERE clause of the query; items will be added with AND separation.

Methods inherited from class java.lang.Object

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

Constructor Detail

Builder

public Builder()

Method Detail

bindParams

public DataObjectTemplatizedQuery.Builder bindParams(List<DataObjectBindParameter> bindParams)

queryExecutionTimeoutInSeconds

public DataObjectTemplatizedQuery.Builder queryExecutionTimeoutInSeconds(Double queryExecutionTimeoutInSeconds)

selectList

public DataObjectTemplatizedQuery.Builder selectList(List<String> selectList)

List of items to be added into the SELECT clause of the query; items will be added with comma separation.

Parameters:

selectList - the value to set

Returns:

this builder

fromClause

public DataObjectTemplatizedQuery.Builder fromClause(String fromClause)

Unique data object name that will be added into the FROM clause of the query, just like a view name in FROM clause.

• Use actual name of the data objects (e.g: tables, views) in case of Warehouse (e.g: Awr hub) data objects query. SCHEMA.VIEW name syntax can also be used here. e.g: SYS.DBA_HIST_SNAPSHOT or DBA_HIST_SNAPSHOT
• Use name of the data object (e.g: SQL_STATS_DO) in case of OPSI data objects. Identifier of the OPSI data object cannot be used here.

Parameters:

fromClause - the value to set

Returns:

this builder

whereConditionsList

public DataObjectTemplatizedQuery.Builder whereConditionsList(List<String> whereConditionsList)

List of items to be added into the WHERE clause of the query; items will be added with AND separation. Item can contain a single condition or multiple conditions. Single condition e.g: “optimizer_mode=‘mode1’” Multiple conditions e.g: (module=‘module1’ OR module=‘module2’)

Parameters:

whereConditionsList - the value to set

Returns:

this builder

groupByList

public DataObjectTemplatizedQuery.Builder groupByList(List<String> groupByList)

List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.

Parameters:

groupByList - the value to set

Returns:

this builder

havingConditionsList

public DataObjectTemplatizedQuery.Builder havingConditionsList(List<String> havingConditionsList)

List of items to be added into the HAVING clause of the query; items will be added with AND separation.

Parameters:

havingConditionsList - the value to set

Returns:

this builder

orderByList

public DataObjectTemplatizedQuery.Builder orderByList(List<String> orderByList)

List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.

Parameters:

orderByList - the value to set

Returns:

this builder

timeFilters

public DataObjectTemplatizedQuery.Builder timeFilters(DataObjectQueryTimeFilters timeFilters)

build

public DataObjectTemplatizedQuery build()

copy

public DataObjectTemplatizedQuery.Builder copy(DataObjectTemplatizedQuery model)