com.oracle.bmc.opsi.model

Class DataObjectTemplatizedQuery

java.lang.Object

com.oracle.bmc.http.internal.ExplicitlySetBmcModel

com.oracle.bmc.opsi.model.DataObjectQuery

com.oracle.bmc.opsi.model.DataObjectTemplatizedQuery

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20200630")
public final class DataObjectTemplatizedQuery
extends DataObjectQuery

Information required in a structured template to form and execute query on a data object.
Note: Objects should always be created or deserialized using the DataObjectTemplatizedQuery.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the DataObjectTemplatizedQuery.Builder, which maintain a set of all explicitly set fields called ExplicitlySetBmcModel.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take ExplicitlySetBmcModel.__explicitlySet__ into account. The constructor, on the other hand, does not set ExplicitlySetBmcModel.__explicitlySet__ (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DataObjectTemplatizedQuery.Builder

Nested classes/interfaces inherited from class com.oracle.bmc.opsi.model.DataObjectQuery

DataObjectQuery.QueryType

Constructor Summary

Constructors

Constructor and Description
DataObjectTemplatizedQuery(List<DataObjectBindParameter> bindParams, Double queryExecutionTimeoutInSeconds, List<String> selectList, String fromClause, List<String> whereConditionsList, List<String> groupByList, List<String> havingConditionsList, List<String> orderByList, DataObjectQueryTimeFilters timeFilters) Deprecated.

Method Summary

Modifier and Type	Method and Description
static DataObjectTemplatizedQuery.Builder	builder() Create a new builder.
boolean	equals(Object o)
String	getFromClause() Unique data object name that will be added into the FROM clause of the query, just like a view name in FROM clause.
List<String>	getGroupByList() List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.
List<String>	getHavingConditionsList() List of items to be added into the HAVING clause of the query; items will be added with AND separation.
List<String>	getOrderByList() List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.
List<String>	getSelectList() List of items to be added into the SELECT clause of the query; items will be added with comma separation.
DataObjectQueryTimeFilters	getTimeFilters()
List<String>	getWhereConditionsList() List of items to be added into the WHERE clause of the query; items will be added with AND separation.
int	hashCode()
DataObjectTemplatizedQuery.Builder	toBuilder()
String	toString()
String	toString(boolean includeByteArrayContents) Return a string representation of the object.

Methods inherited from class com.oracle.bmc.opsi.model.DataObjectQuery

getBindParams, getQueryExecutionTimeoutInSeconds

Methods inherited from class com.oracle.bmc.http.internal.ExplicitlySetBmcModel

markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

DataObjectTemplatizedQuery

@Deprecated
public DataObjectTemplatizedQuery(List<DataObjectBindParameter> bindParams,
                                              Double queryExecutionTimeoutInSeconds,
                                              List<String> selectList,
                                              String fromClause,
                                              List<String> whereConditionsList,
                                              List<String> groupByList,
                                              List<String> havingConditionsList,
                                              List<String> orderByList,
                                              DataObjectQueryTimeFilters timeFilters)

Deprecated.

Method Detail

builder

public static DataObjectTemplatizedQuery.Builder builder()

Create a new builder.

toBuilder

public DataObjectTemplatizedQuery.Builder toBuilder()

getSelectList

public List<String> getSelectList()

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

Returns:

the value

getFromClause

public String getFromClause()

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.

Returns:

the value

getWhereConditionsList

public List<String> getWhereConditionsList()

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’)

Returns:

the value

getGroupByList

public List<String> getGroupByList()

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

Returns:

the value

getHavingConditionsList

public List<String> getHavingConditionsList()

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

Returns:

the value

getOrderByList

public List<String> getOrderByList()

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

Returns:

the value

getTimeFilters

public DataObjectQueryTimeFilters getTimeFilters()

toString

public String toString()

Overrides:

toString in class DataObjectQuery

toString

public String toString(boolean includeByteArrayContents)

Return a string representation of the object.

Overrides:

toString in class DataObjectQuery

Parameters:

includeByteArrayContents - true to include the full contents of byte arrays

Returns:

string representation

equals

public boolean equals(Object o)

Overrides:

equals in class DataObjectQuery

hashCode

public int hashCode()

Overrides:

hashCode in class DataObjectQuery