Represents a connection to a SQL database
AnythingSQLConnectionBasicIdentifiableObjectAnythingno subtypes hierarchy
| Initializer |
SQLConnection(SQLConnection unknown) |
| Inherited Attributes |
Attributes inherited from: Objecthash, string |
| Methods | |
batch | shared default SQLConnection batch(List<String> sqlStatements, Anything(Throwable|List<Integer>) handler)Batch simple SQL strings and execute the batch where the async result contains a array of Integers. Parameters:
|
batchCallableWithParams | shared default SQLConnection batchCallableWithParams(String sqlStatement, List<Array> inArgs, List<Array> outArgs, Anything(Throwable|List<Integer>) handler)Batch a callable statement with all entries from the args list. Each entry is a batch. The size of the lists inArgs and outArgs MUST be the equal. The operation completes with the execution of the batch where the async result contains a array of Integers. Parameters:
|
batchWithParams | shared default SQLConnection batchWithParams(String sqlStatement, List<Array> args, Anything(Throwable|List<Integer>) handler)Batch a prepared statement with all entries from the args list. Each entry is a batch. The operation completes with the execution of the batch where the async result contains a array of Integers. Parameters:
|
call | shared actual default SQLConnection call(String sql, Anything(Throwable|ResultSet) resultHandler)Calls the given SQL Parameters:
Refines SQLOperations.call |
callWithParams | shared actual default SQLConnection callWithParams(String sql, Array params, Array outputs, Anything(Throwable|ResultSet) resultHandler)Calls the given SQL The index of params and outputs are important for both arrays, for example when dealing with a prodecure that takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like: params = [VALUE1, VALUE2, null] outputs = [null, null, "VARCHAR"] Parameters:
Refines SQLOperations.callWithParams |
close | shared default void close()Closes the connection. Important to always close the connection when you are done so it's returned to the pool. |
close | shared default void close(Anything(Throwable?) handler)Closes the connection. Important to always close the connection when you are done so it's returned to the pool. Parameters:
|
commit | shared default SQLConnection commit(Anything(Throwable?) handler)Commits all changes made since the previous commit/rollback. Parameters:
|
execute | shared default SQLConnection execute(String sql, Anything(Throwable?) resultHandler)Executes the given SQL statement Parameters:
|
getTransactionIsolation | shared default SQLConnection getTransactionIsolation(Anything(Throwable|TransactionIsolation) handler)Attempts to return the transaction isolation level for this Connection object to the one given. Parameters:
|
query | shared actual default SQLConnection query(String sql, Anything(Throwable|ResultSet) resultHandler)Executes the given SQL Parameters:
Refines SQLOperations.query |
querySingle | shared actual default SQLOperations querySingle(String sql, Anything(Throwable|Array?) handler)Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by getting a connection from the pool (this object) and return it back after the execution. Only the first result from the result set is returned. Parameters:
Refines SQLOperations.querySingle |
querySingleWithParams | shared actual default SQLOperations querySingleWithParams(String sql, Array arguments, Anything(Throwable|Array?) handler)Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the boilerplate code by getting a connection from the pool (this object) and return it back after the execution. Only the first result from the result set is returned. Parameters:
|
queryStream | shared default SQLConnection queryStream(String sql, Anything(Throwable|SQLRowStream) handler)Executes the given SQL Parameters:
|
queryStreamWithParams | shared default SQLConnection queryStreamWithParams(String sql, Array params, Anything(Throwable|SQLRowStream) handler)Executes the given SQL Parameters:
|
queryWithParams | shared actual default SQLConnection queryWithParams(String sql, Array params, Anything(Throwable|ResultSet) resultHandler)Executes the given SQL Parameters:
Refines SQLOperations.queryWithParams |
rollback | shared default SQLConnection rollback(Anything(Throwable?) handler)Rolls back all changes made since the previous commit/rollback. Parameters:
|
setAutoCommit | shared default SQLConnection setAutoCommit(Boolean autoCommit, Anything(Throwable?) resultHandler)Sets the auto commit flag for this connection. True by default. Parameters:
|
setOptions | shared default SQLConnection setOptions(SQLOptions options)Sets the desired options to be applied to the current connection when statements are executed. The options are not applied globally but applicable to the current connection. For example changing the transaction isolation level will only affect statements run on this connection and not future or current connections acquired from the connection pool. This method is not async in nature since the apply will only happen at the moment a query is run. Parameters:
|
setQueryTimeout | shared default SQLConnection setQueryTimeout(Integer timeoutInSeconds)Sets a connection wide query timeout. It can be over written at any time and becomes active on the next query call. Parameters:
|
setTransactionIsolation | shared default SQLConnection setTransactionIsolation(TransactionIsolation isolation, Anything(Throwable?) handler)Attempts to change the transaction isolation level for this Connection object to the one given. The constants defined in the interface Connection are the possible transaction isolation levels. Parameters:
|
update | shared actual default SQLConnection update(String sql, Anything(Throwable|UpdateResult) resultHandler)Executes the given SQL statement which may be an Parameters:
Refines SQLOperations.update |
updateWithParams | shared actual default SQLConnection updateWithParams(String sql, Array params, Anything(Throwable|UpdateResult) resultHandler)Executes the given prepared statement which may be an Parameters:
Refines SQLOperations.updateWithParams |
| Inherited Methods |
Methods inherited from: Objectequals |
Methods inherited from: SQLOperations |