Packages

trait SQLOperations extends AnyRef

Represents a SQL query interface to a database

Linear Supertypes
AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. SQLOperations
  2. AnyRef
  3. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Abstract Value Members

  1. abstract def asJava: AnyRef
  2. abstract def query(sql: String, resultHandler: Handler[AsyncResult[ResultSet]]): SQLOperations

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

    resultHandler

    the handler which is called once the operation completes. It will return a ResultSet.

  3. abstract def queryFuture(sql: String): Future[ResultSet]

    Like query but returns a scala.concurrent.Future instead of taking an AsyncResultHandler.

  4. abstract def querySingle(sql: String, handler: Handler[AsyncResult[JsonArray]]): SQLOperations

    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

    handler

    the result handler

    returns

    self

  5. abstract def querySingleFuture(sql: String): Future[JsonArray]

    Like querySingle but returns a scala.concurrent.Future instead of taking an AsyncResultHandler.

  6. abstract def querySingleWithParams(sql: String, arguments: JsonArray, handler: Handler[AsyncResult[JsonArray]]): SQLOperations

    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

    handler

    the result handler

    returns

    self

  7. abstract def querySingleWithParamsFuture(sql: String, arguments: JsonArray): Future[JsonArray]

    Like querySingleWithParams but returns a scala.concurrent.Future instead of taking an AsyncResultHandler.

  8. abstract def queryWithParams(sql: String, params: JsonArray, resultHandler: Handler[AsyncResult[ResultSet]]): SQLOperations

    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.

    resultHandler

    the handler which is called once the operation completes. It will return a ResultSet.

  9. abstract def queryWithParamsFuture(sql: String, params: JsonArray): Future[ResultSet]

    Like queryWithParams but returns a scala.concurrent.Future instead of taking an AsyncResultHandler.

  10. abstract def update(sql: String, resultHandler: Handler[AsyncResult[UpdateResult]]): SQLOperations

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

    resultHandler

    the handler which is called once the operation completes.

  11. abstract def updateFuture(sql: String): Future[UpdateResult]

    Like update but returns a scala.concurrent.Future instead of taking an AsyncResultHandler.

  12. abstract def updateWithParams(sql: String, params: JsonArray, resultHandler: Handler[AsyncResult[UpdateResult]]): SQLOperations

    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.

    resultHandler

    the handler which is called once the operation completes.

  13. abstract def updateWithParamsFuture(sql: String, params: JsonArray): Future[UpdateResult]

    Like updateWithParams but returns a scala.concurrent.Future instead of taking an AsyncResultHandler.

Concrete Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  5. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  6. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  7. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  8. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  9. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
  10. def hashCode(): Int
    Definition Classes
    AnyRef → Any
  11. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  12. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  13. final def notify(): Unit
    Definition Classes
    AnyRef
  14. final def notifyAll(): Unit
    Definition Classes
    AnyRef
  15. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  16. def toString(): String
    Definition Classes
    AnyRef → Any
  17. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  18. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  19. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from AnyRef

Inherited from Any

Ungrouped