com.inductiveautomation.ignition.client.script

Class ClientDBUtilities

java.lang.Object

com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities

com.inductiveautomation.ignition.client.script.ClientDBUtilities

public class ClientDBUtilities
extends AbstractDBUtilities

These are DB utilities that are common to the client system as a whole (designer, client)

Field Summary

Fields

Modifier and Type	Field and Description
protected AbstractClientContext	context

Fields inherited from class com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities

ARRAY, BIGINT, BINARY, BIT, BLOB, BOOLEAN, CHAR, CLOB, DATALINK, DATE, DECIMAL, DISTINCT, DOUBLE, FLOAT, INTEGER, JAVA_OBJECT, LONGNVARCHAR, LONGVARBINARY, LONGVARCHAR, NCHAR, NCLOB, NULL, NUMERIC, NVARCHAR, ORACLE_CURSOR, OTHER, READ_COMMITTED, READ_UNCOMMITTED, REAL, REF, REPEATABLE_READ, ROWID, SDF_THREAD_LOCAL, SERIALIZABLE, SMALLINT, SQLXML, STRUCT, TIME, TIMESTAMP, TINYINT, VARBINARY, VARCHAR

Constructor Summary

Constructors

Constructor and Description
ClientDBUtilities(AbstractClientContext context)

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	_beginTransaction(java.lang.String datasource, int isolationLevel, long timeout)
protected void	_call(SProcCall call) Calls a stored procedure, so safe for client use without permission check.
protected void	_closeTransaction(java.lang.String txId)
protected void	_commitTransaction(java.lang.String txId)
protected java.util.List<? extends DatasourceMeta>	_findDatasources()
protected void	_rollbackTransaction(java.lang.String txId)
protected Dataset	_runPrepQuery(java.lang.String query, java.lang.String datasource, java.lang.String txId, java.lang.Object[] args)
protected java.lang.Integer	_runPrepStmt(java.lang.String query, java.lang.String datasource, java.lang.String txId, boolean getIds, boolean skipAudit, java.lang.Object[] args)
protected Dataset	_runQuery(java.lang.String query, java.lang.String datasource, java.lang.String txId)
protected java.lang.Integer	_runUpdateQuery(java.lang.String q, java.lang.String datasource, java.lang.String txId, boolean getIds, boolean skipAudit)
Dataset	getConnectionInfo()
java.lang.Object	runNamedQuery(java.lang.String path, org.python.core.PyDictionary parameters) This invokes the gateway rpc, which only uses the saved query version.

Methods inherited from class com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities

beginTransaction, closeTransaction, commitTransaction, createSProcCall, dataSetToCSV, dateFormat, error, execSProcCall, getConnectionInfo, getConnections, getDatasource, rollbackTransaction, runPrepQuery, runPrepStmt, runPrepStmt, runPrepStmtGetKey, runPrepStmtGetKey, runPrepUpdate, runQuery, runScalarPrepQuery, runScalarQuery, runUpdateQuery, runUpdateQueryGetKey, runUpdateQueryGetKey, toDataSet, toDataset, toDataSet, toPyDataSet

Methods inherited from class java.lang.Object

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

Field Detail

context

protected final AbstractClientContext context

Constructor Detail

ClientDBUtilities

public ClientDBUtilities(AbstractClientContext context)

Method Detail

getConnectionInfo

public Dataset getConnectionInfo()

runNamedQuery

public java.lang.Object runNamedQuery(java.lang.String path,
                                      org.python.core.PyDictionary parameters)
                               throws GatewayException

This invokes the gateway rpc, which only uses the saved query version. Named queries are "safe", so does not need the ClientProtection annotation.

Parameters:

path - Path of the query to run. Will use the Published version

parameters - Map of parameters to run. May be null

Returns:

Results of the query. May be null or empty if the query failed or returned no results.

Throws:

GatewayException - If path is invalid or query can't be run.

_beginTransaction

protected java.lang.String _beginTransaction(java.lang.String datasource,
                                             int isolationLevel,
                                             long timeout)
                                      throws java.lang.Exception

Specified by:

_beginTransaction in class AbstractDBUtilities

Throws:

java.lang.Exception

_commitTransaction

protected void _commitTransaction(java.lang.String txId)
                           throws java.lang.Exception

Specified by:

_commitTransaction in class AbstractDBUtilities

Throws:

java.lang.Exception

_rollbackTransaction

protected void _rollbackTransaction(java.lang.String txId)
                             throws java.lang.Exception

Specified by:

_rollbackTransaction in class AbstractDBUtilities

Throws:

java.lang.Exception

_closeTransaction

protected void _closeTransaction(java.lang.String txId)
                          throws java.lang.Exception

Specified by:

_closeTransaction in class AbstractDBUtilities

Throws:

java.lang.Exception

_runUpdateQuery

protected java.lang.Integer _runUpdateQuery(java.lang.String q,
                                            java.lang.String datasource,
                                            java.lang.String txId,
                                            boolean getIds,
                                            boolean skipAudit)
                                     throws java.lang.Exception

Specified by:

_runUpdateQuery in class AbstractDBUtilities

Throws:

java.lang.Exception

_runPrepStmt

protected java.lang.Integer _runPrepStmt(java.lang.String query,
                                         java.lang.String datasource,
                                         java.lang.String txId,
                                         boolean getIds,
                                         boolean skipAudit,
                                         java.lang.Object[] args)
                                  throws java.lang.Exception

Specified by:

_runPrepStmt in class AbstractDBUtilities

Throws:

java.lang.Exception

_runPrepQuery

protected Dataset _runPrepQuery(java.lang.String query,
                                java.lang.String datasource,
                                java.lang.String txId,
                                java.lang.Object[] args)
                         throws java.lang.Exception

Specified by:

_runPrepQuery in class AbstractDBUtilities

Throws:

java.lang.Exception

_runQuery

protected Dataset _runQuery(java.lang.String query,
                            java.lang.String datasource,
                            java.lang.String txId)
                     throws java.lang.Exception

Specified by:

_runQuery in class AbstractDBUtilities

Throws:

java.lang.Exception

_findDatasources

protected java.util.List<? extends DatasourceMeta> _findDatasources()

Specified by:

_findDatasources in class AbstractDBUtilities

_call

protected void _call(SProcCall call)
              throws java.lang.Exception

Calls a stored procedure, so safe for client use without permission check.

Specified by:

_call in class AbstractDBUtilities

Throws:

java.lang.Exception