Represents a SQL query interface to a database
no type hierarchy
no supertypes hierarchy
SQLOperationsSQLClientJDBCClient| Inherited Attributes |
Attributes inherited from: Objecthash, string |
| Methods | |
call | shared SQLOperations call(String sql, Anything(Throwable|ResultSet) resultHandler)Calls the given SQL Parameters:
|
callWithParams | shared SQLOperations 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:
|
query | shared SQLOperations query(String sql, Anything(Throwable|ResultSet) resultHandler)Executes the given SQL Parameters:
|
querySingle | shared 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:
|
querySingleWithParams | shared 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:
|
queryWithParams | shared SQLOperations queryWithParams(String sql, Array params, Anything(Throwable|ResultSet) resultHandler)Executes the given SQL Parameters:
|
update | shared SQLOperations update(String sql, Anything(Throwable|UpdateResult) resultHandler)Executes the given SQL statement which may be an Parameters:
|
updateWithParams | shared SQLOperations updateWithParams(String sql, Array params, Anything(Throwable|UpdateResult) resultHandler)Executes the given prepared statement which may be an Parameters:
|
| Inherited Methods |
Methods inherited from: Objectequals |