Uses of Class
com.onenetwork.platform.data.sql.SqlParams
| Package | Description |
|---|---|
| com.onenetwork.platform.data.model |
APIs for reading and writing Models developed with the SDK.
|
| com.onenetwork.platform.data.model.perm |
Interfaces and helper classes for implementing customized permission policies on Models.
|
| com.onenetwork.platform.data.sql |
Services for ad-hoc querying and other lower-level database access.
|
| com.onenetwork.platform.integ.edi |
Used for parsing, processing and generating EDI messages in X12 and/or EDIFACT format.
|
| com.onenetwork.platform.integ.fixlen |
Service for parsing "fixed-length format" files, i.e.
|
| com.onenetwork.platform.integ.msg |
APIs for using Platform's message queuing system.
|
| com.onenetwork.platform.integ.oagis | |
| com.onenetwork.platform.integ.sap |
Used for parsing, processing and generating SAP "IDoc" files.
|
| com.onenetwork.platform.report.summary |
-
Uses of SqlParams in com.onenetwork.platform.data.model
Methods in com.onenetwork.platform.data.model with parameters of type SqlParams Modifier and Type Method Description <T extends Model>
longModelDataService. count(java.lang.Class<T> clazz, PlatformUserContext context, SqlParams params, ModelFilter... filters)This method is similar toModelDataService.read(Class, PlatformUserContext, SqlParams, ModelQueryComponent...)with one key difference - it returns total count of models.<T extends Model>
java.util.List<T>ModelDataService. read(java.lang.Class<T> topLevelClass, PlatformUserContext context, SqlParams params, ModelQueryComponent... queryComponents)Reads Model objects from the database using user-provided filter, sort and retrieval criteria.<T extends Model>
java.util.List<ModelAudit<T>>ModelDataService. readAudit(java.lang.Class<T> modelClass, PlatformUserContext ctx, SqlParams params, ModelQueryComponent... queryComponents)Reads audit records for Models from the database using user-provided filter and sort criteria. -
Uses of SqlParams in com.onenetwork.platform.data.model.perm
Methods in com.onenetwork.platform.data.model.perm that return SqlParams Modifier and Type Method Description SqlParamsWhereClauseContribution. getParams()Methods in com.onenetwork.platform.data.model.perm with parameters of type SqlParams Modifier and Type Method Description voidWhereClauseContribution. setParams(SqlParams params) -
Uses of SqlParams in com.onenetwork.platform.data.sql
Methods in com.onenetwork.platform.data.sql that return SqlParams Modifier and Type Method Description static SqlParamsSqlParams. fromJSON(org.json.JSONObject json)Given a JSON, returns a SqlParams object.SqlParamsQueryRequest. getParams()Returns the params to bind to the sql querySqlParamsSqlParams. setBooleanValue(java.lang.String paramName, boolean value)Set a Boolean paramSqlParamsSqlParams. setByteValue(java.lang.String paramName, byte value)Set a Byte paramSqlParamsSqlParams. setCollectionValue(java.lang.String paramName, java.util.Collection<?> values)Binds multiple params for the given name.SqlParamsSqlParams. setDoubleValue(java.lang.String paramName, double value)Set a Double paramSqlParamsSqlParams. setFloatValue(java.lang.String paramName, float value)Set a Float paramSqlParamsSqlParams. setIntValue(java.lang.String paramName, int value)Set an Integer paramSqlParamsSqlParams. setLongValue(java.lang.String paramName, long value)Set a Long paramSqlParamsSqlParams. setNullBooleanValue(java.lang.String paramName)Indicates that the null value should be bound for the given boolean parameter.SqlParamsSqlParams. setNullByteValue(java.lang.String paramName)Indicates that the null value should be bound for the given byte parameterSqlParamsSqlParams. setNullDoubleValue(java.lang.String paramName)Indicates that the null value should be bound for the given double parameterSqlParamsSqlParams. setNullFloatValue(java.lang.String paramName)Indicates that the null value should be bound for the given float parameterSqlParamsSqlParams. setNullIntValue(java.lang.String paramName)Indicates that the null value should be bound for the given int parameterSqlParamsSqlParams. setNullLongValue(java.lang.String paramName)Indicates that the null value should be bound for the given long parameterSqlParamsSqlParams. setNullShortValue(java.lang.String paramName)Indicates that the null value should be bound for the given short parameterSqlParamsSqlParams. setNullStringValue(java.lang.String paramName)Indicates that the null value should be bound for the given string parameterSqlParamsSqlParams. setNullTimestampValue(java.lang.String paramName)Indicates that the null value should be bound for the given timestamp parameterSqlParamsSqlParams. setNullValue(java.lang.String paramName, int daoDataType)Deprecated.Not intended for use by clientsSqlParamsSqlParams. setShortValue(java.lang.String paramName, short value)Set a Short paramSqlParamsSqlParams. setStringValue(java.lang.String paramName, java.lang.String value)Set a String paramSqlParamsSqlParams. setTimestampUTCValue(java.lang.String paramName, java.sql.Timestamp value)Set a Timestamp parameter bound to the UTC timezone, which will be used when it's constructed as a SQL TIMESTAMP value for the database.SqlParamsSqlParams. setTimestampValue(java.lang.String paramName, java.sql.Timestamp value)Set a Timestamp paramSqlParamsSqlParams. setValue(java.lang.String param, java.lang.Object paramVal)Use this method if data type of sqlparam value is not known up front.Methods in com.onenetwork.platform.data.sql with parameters of type SqlParams Modifier and Type Method Description SqlResultSqlService. executeQuery(java.lang.String sql, SqlParams sqlParams)Given an SQL query and params to be bound, executes the SQL and returns the result.SqlResultSqlService. executeQuery(java.lang.String sql, SqlParams sqlParams, PlatformUserContext context)Given an SQL query and params to be bound, executes the SQL and returns the result.SqlResultSqlService. executeQuery(java.lang.String groupName, java.lang.String sqlDefName, SqlParams sqlParams)Lookup and executes the SQL and returns the result.SqlResultSqlService. executeQuery(java.lang.String groupName, java.lang.String sqlDefName, SqlParams sqlParams, PlatformUserContext context)Lookup and executes the SQL and returns the result.voidSqlService. executeStoredProcedure(java.lang.String execProcCommand, SqlParams sqlParams)Given the name of the stored procedure and the params to be bound the procedure is executed.longSqlService. getNumberOfRows(java.lang.String sql, SqlParams sqlParams)Wraps the given SQL with a "select count(*) from (...)" to return a total count of rows which would be returned for the given query.voidSqlParams. putAll(SqlParams sqlParams)Takes all the params from the given argument and merges them into this SqlParams object.voidQueryRequest. setParams(SqlParams params)Sets the params to bind to the sql queryConstructors in com.onenetwork.platform.data.sql with parameters of type SqlParams Constructor Description SqlParams(SqlParams sqlParams)Constructs a new SqlParams which copies the bindings from the given objectSqlQueryRequest(java.lang.String sql, SqlParams params)Construct a request with query and params.SqlQueryRequest(java.lang.String sql, SqlParams params, java.lang.Long pageSize, java.lang.Long firstRowNumber)Construts a new sql query request -
Uses of SqlParams in com.onenetwork.platform.integ.edi
Methods in com.onenetwork.platform.integ.edi with parameters of type SqlParams Modifier and Type Method Description voidBaseNetChangeEDIOutboundGenerator. populateCustomParams(SqlParams sqlParams, PlatformUserContext pltUserContext)Override this method if you need to use additional SqlParams as part of retrieving the models to generate outbound. -
Uses of SqlParams in com.onenetwork.platform.integ.fixlen
Methods in com.onenetwork.platform.integ.fixlen with parameters of type SqlParams Modifier and Type Method Description voidBaseNetChangeFixLenOutboundGenerator. populateCustomParams(SqlParams sqlParams, PlatformUserContext pltUserContext)Override this method if you need to use additional SqlParams as part of retrieving the models to generate outbound. -
Uses of SqlParams in com.onenetwork.platform.integ.msg
Methods in com.onenetwork.platform.integ.msg that return SqlParams Modifier and Type Method Description SqlParamsOutboundInterfaceWriteRequest. getSqlParams()Returns the params to be bound, if anyMethods in com.onenetwork.platform.integ.msg with parameters of type SqlParams Modifier and Type Method Description voidOutboundInterfaceWriteRequest. setSqlParams(SqlParams sqlParams)Sets params to be bound, if anyConstructors in com.onenetwork.platform.integ.msg with parameters of type SqlParams Constructor Description OutboundInterfaceWriteRequest(java.lang.String outboundInterfaceName, java.lang.String outboundInterfaceVersion, QueueRef outboundQueueRef, SqlParams sqlParams)OutboundInterfaceWriteRequest(java.lang.String outboundInterfaceName, java.lang.String outboundInterfaceVersion, QueueRef outboundQueueRef, SqlParams sqlParams, java.lang.Long netChangeThresholdInMillis)ReportOutboundInterfaceWriteRequest(java.lang.String outboundInterfaceName, java.lang.String outboundInterfaceVersion, QueueRef outboundQueueRef, SqlParams sqlParams, java.lang.String reportFavoriteName)SysIdOutboundInterfaceWriteRequest(java.lang.String outboundInterfaceName, java.lang.String outboundInterfaceVersion, QueueRef outboundQueueRef, java.util.List<java.lang.Long> sysIds, SqlParams sqlParams)Constructs a Request to generate an outbound request. -
Uses of SqlParams in com.onenetwork.platform.integ.oagis
Methods in com.onenetwork.platform.integ.oagis with parameters of type SqlParams Modifier and Type Method Description voidBaseOAGISOutboundGenerator. populateCustomParams(SqlParams sqlParams, PlatformUserContext pltUserContext)Override this method if you need to use additional SqlParams as part of retrieving the models to generate outbound. -
Uses of SqlParams in com.onenetwork.platform.integ.sap
Methods in com.onenetwork.platform.integ.sap with parameters of type SqlParams Modifier and Type Method Description voidBaseNetChangeIDocOutboundGenerator. populateCustomParams(SqlParams sqlParams, PlatformUserContext pltUserContext)Override this method if you need to use additional SqlParams as part of retrieving the models to generate outbound. -
Uses of SqlParams in com.onenetwork.platform.report.summary
Methods in com.onenetwork.platform.report.summary that return SqlParams Modifier and Type Method Description SqlParamsReportSummaryRequest. getSqlParams()Original sqlParams of Report executionConstructors in com.onenetwork.platform.report.summary with parameters of type SqlParams Constructor Description ReportSummaryRequest(ReportSummaryRow reportSummaryRow, java.lang.String reportName, SqlDef sqlDef, SqlParams sqlParams, TableMetaData tableMeta, boolean exportRequest, PlatformUserContext platformUserContext)Constructs the request, setting all parameters as provided.