Value Members

1.  final def !=(arg0: Any): Boolean

   Definition Classes

   Any

2.  final def ##(): Int

   Definition Classes

   Any

3.  final def ==(arg0: Any): Boolean

   Definition Classes

   Any

4.  final def asInstanceOf[T0]: T0

   Definition Classes

   Any

5.  def batchCallableWithParamsL(sqlStatement: String, inArgs: List[JsonArray], outArgs: List[JsonArray]): Task[List[Integer]]

   Batch a callable statement with all entries from the args list.

   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.

   sqlStatement

   sql statement

   inArgs

   the callable statement input arguments

   outArgs

   the callable statement output arguments

6.  def batchL(sqlStatements: List[String]): Task[List[Integer]]

   Batch simple SQL strings and execute the batch where the async result contains a array of Integers.

   Batch simple SQL strings and execute the batch where the async result contains a array of Integers.

   sqlStatements

   sql statement

7.  def batchWithParamsL(sqlStatement: String, args: List[JsonArray]): Task[List[Integer]]

   Batch a prepared statement with all entries from the args list.

   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.

   sqlStatement

   sql statement

   args

   the prepared statement arguments

8.  def callL(sql: String): Task[ResultSet]

   Calls the given SQL PROCEDURE which returns the result from the procedure.

   Calls the given SQL PROCEDURE which returns the result from the procedure.

   sql

   the SQL to execute. For example {call getEmpName}.

   See also

   java.sql.CallableStatement#execute(String)

9.  def callWithParamsL(sql: String, params: JsonArray, outputs: JsonArray): Task[ResultSet]

   Calls the given SQL PROCEDURE which returns the result from the procedure.

   Calls the given SQL PROCEDURE which returns the result from the procedure.

   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"]
   

   sql

   the SQL to execute. For example {call getEmpName (?, ?)}.

   params

   these are the parameters to fill the statement.

   outputs

   these are the outputs to fill the statement.

   See also

   java.sql.CallableStatement#execute(String)

10.  def closeL(): Task[Unit]

    Closes the connection.

    Closes the connection. Important to always close the connection when you are done so it's returned to the pool.

11.  def commitL(): Task[Unit]

    Commits all changes made since the previous commit/rollback.

12.  def executeL(sql: String): Task[Unit]

    Executes the given SQL statement

    Executes the given SQL statement

    sql

    the SQL to execute. For example CREATE TABLE IF EXISTS table ...

    See also

    java.sql.Statement#execute(String)

13.  def getClass(): Class[_ <: AnyVal]

    Definition Classes

    AnyVal → Any

14.  def getTransactionIsolationL(): Task[TransactionIsolation]

    Attempts to return the transaction isolation level for this Connection object to the one given.

15.  final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

16.  def queryL(sql: String): Task[ResultSet]

    Executes the given SQL SELECT statement which returns the results of the query.

    Executes the given SQL SELECT statement which returns the results of the query.

    sql

    the SQL to execute. For example SELECT * FROM table ....

    See also

    java.sql.Statement#executeQuery(String)

    java.sql.PreparedStatement#executeQuery(String)

17.  def querySingleL(sql: String): Task[JsonArray]

    Execute a one shot SQL statement that returns a single SQL row.

    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.

    sql

    the statement to execute

    returns

    self

18.  def querySingleWithParamsL(sql: String, arguments: JsonArray): Task[JsonArray]

    Execute a one shot SQL statement with arguments that returns a single SQL row.

    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.

    sql

    the statement to execute

    arguments

    the arguments

    returns

    self

19.  def queryStreamL(sql: String): Task[SQLRowStream]

    Executes the given SQL SELECT statement which returns the results of the query as a read stream.

    Executes the given SQL SELECT statement which returns the results of the query as a read stream.

    sql

    the SQL to execute. For example SELECT * FROM table ....

    See also

    java.sql.Statement#executeQuery(String)

    java.sql.PreparedStatement#executeQuery(String)

20.  def queryStreamWithParamsL(sql: String, params: JsonArray): Task[SQLRowStream]

    Executes the given SQL SELECT statement which returns the results of the query as a read stream.

    Executes the given SQL SELECT statement which returns the results of the query as a read stream.

    sql

    the SQL to execute. For example SELECT * FROM table ....

    params

    these are the parameters to fill the statement.

    See also

    java.sql.Statement#executeQuery(String)

    java.sql.PreparedStatement#executeQuery(String)

21.  def queryWithParamsL(sql: String, params: JsonArray): Task[ResultSet]

    Executes the given SQL SELECT prepared statement which returns the results of the query.

    Executes the given SQL SELECT prepared statement which returns the results of the query.

    sql

    the SQL to execute. For example SELECT * FROM table ....

    params

    these are the parameters to fill the statement.

    See also

    java.sql.Statement#executeQuery(String)

    java.sql.PreparedStatement#executeQuery(String)

22.  def rollbackL(): Task[Unit]

    Rolls back all changes made since the previous commit/rollback.

23.  def setAutoCommitL(autoCommit: Boolean): Task[Unit]

    Sets the auto commit flag for this connection.

    Sets the auto commit flag for this connection. True by default.

    autoCommit

    the autoCommit flag, true by default.

    See also

    java.sql.Connection#setAutoCommit(boolean)

24.  def setTransactionIsolationL(isolation: TransactionIsolation): Task[Unit]

    Attempts to change the transaction isolation level for this Connection object to the one given.

    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.

    isolation

    the level of isolation

25.  val target: SQLConnection
26.  def toString(): String

    Definition Classes

    Any

27.  def updateL(sql: String): Task[UpdateResult]

    Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE statement.

    Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE statement.

    sql

    the SQL to execute. For example INSERT INTO table ...

    See also

    java.sql.Statement#executeUpdate(String)

    java.sql.PreparedStatement#executeUpdate(String)

28.  def updateWithParamsL(sql: String, params: JsonArray): Task[UpdateResult]

    Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE statement with the given parameters

    Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE statement with the given parameters

    sql

    the SQL to execute. For example INSERT INTO table ...

    params

    these are the parameters to fill the statement.

    See also

    java.sql.Statement#executeUpdate(String)

    java.sql.PreparedStatement#executeUpdate(String)