Package com.oracle.bmc.opsi.model

Class DataObjectStandardQuery

java.lang.Object

com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

com.oracle.bmc.opsi.model.DataObjectQuery

com.oracle.bmc.opsi.model.DataObjectStandardQuery

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

Information required to execute query on data objects.

Query is given in standard SQL syntax providing flexibility to form complex queries such as queries with joins and nested queries.
Note: Objects should always be created or deserialized using the DataObjectStandardQuery.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 DataObjectStandardQuery.Builder, which maintain a set of all explicitly set fields called DataObjectStandardQuery.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	DataObjectStandardQuery.Builder

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

DataObjectQuery.QueryType

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors

Constructor	Description
DataObjectStandardQuery(List<DataObjectBindParameter> bindParams, Double queryExecutionTimeoutInSeconds, String statement, DataObjectQueryTimeFilters timeFilters)	Deprecated.

Method Summary

Modifier and Type	Method	Description
static DataObjectStandardQuery.Builder	builder()	Create a new builder.
boolean	equals(Object o)
String	getStatement()	SQL query statement with standard Oracle supported SQL syntax.
DataObjectQueryTimeFilters	getTimeFilters()
int	hashCode()
DataObjectStandardQuery.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.client.internal.ExplicitlySetBmcModel

markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object

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

Constructor Detail

DataObjectStandardQuery

@Deprecated
public DataObjectStandardQuery(List<DataObjectBindParameter> bindParams,
                               Double queryExecutionTimeoutInSeconds,
                               String statement,
                               DataObjectQueryTimeFilters timeFilters)

Deprecated.

Method Detail

builder

public static DataObjectStandardQuery.Builder builder()

Create a new builder.

toBuilder

public DataObjectStandardQuery.Builder toBuilder()

getStatement

public String getStatement()

SQL query statement with standard Oracle supported SQL syntax.

• When Warehouse (e.g: Awr hub) data objects are queried, use the actual names of underlying data objects (e.g: tables, views) in the query. The same query that works through JDBC connection with the OperationsInsightsWarehouseUsers credentials will work here and vice-versa. SCHEMA.VIEW syntax can also be used here. - When OPSI data objects are queried, use name of the respective OPSI data object, just like how views are used in a query. Identifier of the OPSI data object cannot be used in the query.

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