t

io.rdbc.sapi

Statement

trait Statement extends AnyRef

Represent a SQL statement

Methods of this trait allow to bind argument values to parameters either by name or index. Classes extending this trait can be used as an alternative to sql string interpolator - SqlInterpolator.

Linear Supertypes
AnyRef, Any
Ordering
  1. Grouped
  2. Alphabetic
  3. By Inheritance
Inherited
  1. Statement
  2. AnyRef
  3. Any
Implicitly
  1. by any2stringadd
  2. by StringFormat
  3. by Ensuring
  4. by ArrowAssoc
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Abstract Value Members

  1. abstract def bind(args: (String, Any)*): ExecutableStatement

    Binds each parameter by name.

    Binds each parameter by name.

    Example:

    val insert = conn.insert("insert into table(p1, p2) values (:p1, :p2)")
insert.map(_.bind("p1" -> "str", "p2" -> 10L)).foreach(_.execute())

    Throws:

  2. abstract def bindByIdx(args: Any*): ExecutableStatement

    Binds each parameter by index.

    Binds each parameter by index.

    Parameters are ordered, each value in params sequence will be bound to the corresponding parameter.

    Example:

    val insert = conn.insert("insert into table(p1, p2) values (:p1, :p2)")
insert.map(_.bind("str", 10L)).foreach(_.execute())

    Throws:

  3. abstract def bindByIdxF(args: Any*): Future[ExecutableStatement]

    Binds each parameter by index and wraps a result in a Future.

    Binds each parameter by index and wraps a result in a Future.

    Parameters are ordered, each value in params sequence will be bound to the corresponding parameter.

    This is not an asynchronous operation, it's only an utility method that wraps bindByIdx result with a Future to allow chaining bind operations with asynchronous operations.

    Example:

    for {
  insert <- conn.insert("insert into table(p1, p2) values (:p1, :p2)")
  bound <- insert.bindByIdxF("str", 10L)
  _ <- bound.execute()
} yield ()

    Resulting future can fail with:

  4. abstract def bindF(args: (String, Any)*): Future[ExecutableStatement]

    Binds each parameter by name and wraps a result in a Future.

    Binds each parameter by name and wraps a result in a Future.

    This is not an asynchronous operation, it's only an utility method that wraps bind result with a Future to allow chaining bind operations with asynchronous operations.

    Example:

    for {
  insert <- conn.insert("insert into table(p1, p2) values (:p1, :p2)")
  bound <- insert.bindF("p1" -> "str", "p2" -> 10L)
  _ <- bound.execute()
} yield ()

    Resulting future can fail with:

  5. abstract def noParams: ExecutableStatement

    Creaes an executable version of the statement object without providing any parameters.

    Creaes an executable version of the statement object without providing any parameters.

    Example:

    val insert = conn.statement("insert into table(p1, p2) values ('str', 10)")
insert.map(_.noParams).foreach(_.execute())
  6. abstract def noParamsF: Future[ExecutableStatement]

    Creates an executable version of the statement object without providing any parameters and wraps a result in a future

    Creates an executable version of the statement object without providing any parameters and wraps a result in a future

    This is not an asynchronous operation, it's only an utility method that wraps noParams result with a Future to allow chaining bind operations with asynchronous operations.

    Example:

    for {
  insert     <- conn.statement("insert into table(p1, p2) values ('str', 10)")
  executable <- insert.noParamsF
  _ <- bound.execute()
} yield ()
  7. abstract def streamParams(paramsPublisher: Publisher[Map[String, Any]]): Future[Unit]

    Streams statement parameters to a database.

    Streams statement parameters to a database.

    This method can be used to repeatedly execute this statement with published parameters by leveraging Reactive Streams specification's Publisher with a backpressure. Each published element is a map containing all parameters required by this statement.

    Resulting future can fail with:

Concrete Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. def +(other: String): String
    Implicit
    This member is added by an implicit conversion from Statement to any2stringadd[Statement] performed by method any2stringadd in scala.Predef.
    Definition Classes
    any2stringadd
  4. def ->[B](y: B): (Statement, B)
    Implicit
    This member is added by an implicit conversion from Statement to ArrowAssoc[Statement] performed by method ArrowAssoc in scala.Predef.
    Definition Classes
    ArrowAssoc
    Annotations
    @inline()
  5. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  6. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  7. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  8. def ensuring(cond: (Statement) ⇒ Boolean, msg: ⇒ Any): Statement
    Implicit
    This member is added by an implicit conversion from Statement to Ensuring[Statement] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  9. def ensuring(cond: (Statement) ⇒ Boolean): Statement
    Implicit
    This member is added by an implicit conversion from Statement to Ensuring[Statement] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  10. def ensuring(cond: Boolean, msg: ⇒ Any): Statement
    Implicit
    This member is added by an implicit conversion from Statement to Ensuring[Statement] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  11. def ensuring(cond: Boolean): Statement
    Implicit
    This member is added by an implicit conversion from Statement to Ensuring[Statement] performed by method Ensuring in scala.Predef.
    Definition Classes
    Ensuring
  12. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  13. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  14. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  15. def formatted(fmtstr: String): String
    Implicit
    This member is added by an implicit conversion from Statement to StringFormat[Statement] performed by method StringFormat in scala.Predef.
    Definition Classes
    StringFormat
    Annotations
    @inline()
  16. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
  17. def hashCode(): Int
    Definition Classes
    AnyRef → Any
  18. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  19. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  20. final def notify(): Unit
    Definition Classes
    AnyRef
  21. final def notifyAll(): Unit
    Definition Classes
    AnyRef
  22. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  23. def toString(): String
    Definition Classes
    AnyRef → Any
  24. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  25. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  26. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  27. def →[B](y: B): (Statement, B)
    Implicit
    This member is added by an implicit conversion from Statement to ArrowAssoc[Statement] performed by method ArrowAssoc in scala.Predef.
    Definition Classes
    ArrowAssoc

Inherited from AnyRef

Inherited from Any

Inherited by implicit conversion any2stringadd from Statement to any2stringadd[Statement]

Inherited by implicit conversion StringFormat from Statement to StringFormat[Statement]

Inherited by implicit conversion Ensuring from Statement to Ensuring[Statement]

Inherited by implicit conversion ArrowAssoc from Statement to ArrowAssoc[Statement]

Primary methods

Future utils

Ungrouped