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 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)

6.  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)

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

   Close the client and release all resources.

   Close the client and release all resources. Call the handler when close is complete.

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

   Definition Classes

   AnyVal → Any

9.  def getConnectionL(): Task[SQLConnection]

   Returns a connection that can be used to perform SQL operations on.

   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.

10.  final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

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

    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.

    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.

    sql

    the statement to execute

    returns

    self

12.  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

13.  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

14.  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)

15.  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)

16.  def queryWithParamsL(sql: String, arguments: JsonArray): Task[ResultSet]

    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.

    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.

    sql

    the statement to execute

    arguments

    the arguments to the statement

    returns

    self

17.  val target: SQLClient
18.  def toString(): String

    Definition Classes

    Any

19.  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)

20.  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)