| Initializer |
SQLClient(SQLClient unknown) |
| Inherited Attributes |
Attributes inherited from: Objecthash, string |
| Methods | |
call | shared actual default SQLClient call(String sql, Anything(Throwable|ResultSet) handler)Calls the given SQL Parameters:
Refines SQLOperations.call |
callWithParams | shared actual default SQLClient callWithParams(String sql, Array params, Array outputs, Anything(Throwable|ResultSet) handler)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()Close the client |
close | shared default void close(Anything(Throwable?) handler)Close the client and release all resources. Call the handler when close is complete. Parameters:
|
getConnection | shared default SQLClient getConnection(Anything(Throwable|SQLConnection) handler)Returns a connection that can be used to perform SQL operations on. It's important to remember to close the connection when you are done, so it is returned to the pool. Parameters:
|
query | shared actual default SQLClient query(String sql, Anything(Throwable|ResultSet) handler)Execute a single SQL statement, this method acquires a connection from the the pool and executes the SQL statement and returns it back after the execution. 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:
|
queryWithParams | shared actual default SQLClient queryWithParams(String sql, Array arguments, Anything(Throwable|ResultSet) handler)Execute a single SQL prepared statement, this method acquires a connection from the the pool and executes the SQL prepared statement and returns it back after the execution. Parameters:
Refines SQLOperations.queryWithParams |
update | shared actual default SQLClient update(String sql, Anything(Throwable|UpdateResult) handler)Executes the given SQL statement which may be an Parameters:
Refines SQLOperations.update |
updateWithParams | shared actual default SQLClient updateWithParams(String sql, Array params, Anything(Throwable|UpdateResult) handler)Executes the given prepared statement which may be an Parameters:
Refines SQLOperations.updateWithParams |
| Inherited Methods |
Methods inherited from: Objectequals |
Methods inherited from: SQLOperations |