slick.jdbc

StaticQuery

class StaticQuery[-P, +R] extends (P) ⇒ Invoker[R]

A builder for Plain SQL queries.

Source
StaticQuery.scala
Linear Supertypes
(P) ⇒ Invoker[R], AnyRef, Any
Type Hierarchy Learn more about scaladoc diagrams
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. StaticQuery
  2. Function1
  3. AnyRef
  4. Any
Implicitly
  1. by staticQueryToInvoker
  2. by any2stringadd
  3. by any2stringfmt
  4. by any2ArrowAssoc
  5. by any2Ensuring
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new StaticQuery(query: String, pconv: SetParameter[P], rconv: GetResult[R])

Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any
  3. final def ##(): Int

    Definition Classes
    AnyRef → Any
  4. def +(s: String): StaticQuery[P, R]

    Append a string to this query

  5. def +?[T](v: T)(implicit p: SetParameter[T]): StaticQuery[P, R]

    Append a bind variable to this query

  6. def ->[B](y: B): (StaticQuery[P, R], B)

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to ArrowAssoc[StaticQuery[P, R]] performed by method any2ArrowAssoc in scala.Predef.
    Definition Classes
    ArrowAssoc
    Annotations
    @inline()
  7. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  8. final def ==(arg0: Any): Boolean

    Definition Classes
    Any
  9. def andThen[A](g: (Invoker[R]) ⇒ A): (P) ⇒ A

    Definition Classes
    Function1
    Annotations
    @unspecialized()
  10. def apply(param: P): StaticQueryInvoker[P, R]

    Definition Classes
    StaticQuery → Function1
  11. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  12. final def buildColl[C[_]](implicit session: SessionDef, canBuildFrom: CanBuildFrom[Nothing, R, C[R]]): C[R]

    Execute the statement and return a fully materialized collection.

    Execute the statement and return a fully materialized collection.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
  13. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  14. def compose[A](g: (A) ⇒ P): (A) ⇒ Invoker[R]

    Definition Classes
    Function1
    Annotations
    @unspecialized()
  15. def ensuring(cond: (StaticQuery[P, R]) ⇒ Boolean, msg: ⇒ Any): StaticQuery[P, R]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to Ensuring[StaticQuery[P, R]] performed by method any2Ensuring in scala.Predef. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Ensuring
  16. def ensuring(cond: (StaticQuery[P, R]) ⇒ Boolean): StaticQuery[P, R]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to Ensuring[StaticQuery[P, R]] performed by method any2Ensuring in scala.Predef. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Ensuring
  17. def ensuring(cond: Boolean, msg: ⇒ Any): StaticQuery[P, R]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to Ensuring[StaticQuery[P, R]] performed by method any2Ensuring in scala.Predef. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Ensuring
  18. def ensuring(cond: Boolean): StaticQuery[P, R]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to Ensuring[StaticQuery[P, R]] performed by method any2Ensuring in scala.Predef. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Ensuring
  19. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  20. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  21. final def execute(implicit session: SessionDef): Unit

    Execute the statement and ignore the results.

    Execute the statement and ignore the results.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
  22. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  23. final def first(implicit session: SessionDef): R

    Execute the statement and return the first row of the result set.

    Execute the statement and return the first row of the result set. If the result set is empty, a NoSuchElementException is thrown.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
  24. final def firstOption(implicit session: SessionDef): Option[R]

    Execute the statement and return the first row of the result set wrapped in Some, or None if the result set is empty.

    Execute the statement and return the first row of the result set wrapped in Some, or None if the result set is empty.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
  25. final def foreach(f: (R) ⇒ Unit, maxRows: Int = 0)(implicit session: SessionDef): Unit

    Execute the statement and call f for each converted row of the result set.

    Execute the statement and call f for each converted row of the result set.

    maxRows

    Maximum number of rows to read from the result (0 for unlimited).

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
  26. def formatted(fmtstr: String): String

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StringFormat performed by method any2stringfmt in scala.Predef.
    Definition Classes
    StringFormat
    Annotations
    @inline()
  27. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  28. val getStatement: String

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    StaticQueryInvokerStatementInvoker
  29. def hashCode(): Int

    Definition Classes
    AnyRef → Any
  30. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  31. final def iterator(implicit session: SessionDef): CloseableIterator[R]

    Execute the statement and return a CloseableIterator of the converted results.

    Execute the statement and return a CloseableIterator of the converted results. The iterator must either be fully read or closed explicitly.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
  32. def iteratorTo(maxRows: Int)(implicit session: SessionDef): CloseableIterator[R]

    Execute the statement and return a CloseableIterator of the converted results.

    Execute the statement and return a CloseableIterator of the converted results. The iterator must either be fully read or closed explicitly.

    maxRows

    Maximum number of rows to read from the result (0 for unlimited).

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    StatementInvokerInvoker
  33. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  34. final def notify(): Unit

    Definition Classes
    AnyRef
  35. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  36. def results(maxRows: Int, defaultType: ResultSetType = ResultSetType.ForwardOnly, defaultConcurrency: ResultSetConcurrency = ResultSetConcurrency.ReadOnly, defaultHoldability: ResultSetHoldability = ResultSetHoldability.Default, autoClose: Boolean = true)(implicit session: SessionDef): Either[Int, PositionedResultIterator[R]]

    Invoke the statement and return the raw results.

    Invoke the statement and return the raw results.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    StatementInvoker
  37. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  38. def toString(): String

    Definition Classes
    Function1 → AnyRef → Any
  39. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  40. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  41. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  42. def [B](y: B): (StaticQuery[P, R], B)

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to ArrowAssoc[StaticQuery[P, R]] performed by method any2ArrowAssoc in scala.Predef.
    Definition Classes
    ArrowAssoc

Shadowed Implicit Value Members

  1. def +(other: String): String

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StringAdd performed by method any2stringadd in scala.Predef.
    Shadowing
    This implicitly inherited member is shadowed by one or more members in this class.
    To access this member you can use a type ascription:
    (staticQuery: StringAdd).+(other)
    Definition Classes
    StringAdd
  2. val self: Any

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StringAdd performed by method any2stringadd in scala.Predef.
    Shadowing
    This implicitly inherited member is ambiguous. One or more implicitly inherited members have similar signatures, so calling this member may produce an ambiguous implicit conversion compiler error.
    To access this member you can use a type ascription:
    (staticQuery: StringAdd).self
    Definition Classes
    StringAdd
  3. val self: Any

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StringFormat performed by method any2stringfmt in scala.Predef.
    Shadowing
    This implicitly inherited member is ambiguous. One or more implicitly inherited members have similar signatures, so calling this member may produce an ambiguous implicit conversion compiler error.
    To access this member you can use a type ascription:
    (staticQuery: StringFormat).self
    Definition Classes
    StringFormat

Deprecated Value Members

  1. final def build[To](implicit session: SessionDef, canBuildFrom: CanBuildFrom[Nothing, R, To]): To

    Execute the statement and return a fully materialized collection of the specified type.

    Execute the statement and return a fully materialized collection of the specified type.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0) Invoker convenience features will be removed. Invoker is intended for low-level JDBC use only.

  2. final def enumerate[B, RR >: R](iter: IterV[RR, B])(implicit session: SessionDef): IterV[RR, B]

    Execute the statement and feed the converted rows of the result set into an iteratee.

    Execute the statement and feed the converted rows of the result set into an iteratee.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0) Use Reactive Streams in the new Action-based API instead of Slick iteratees

  3. def firstFlatten[B](implicit session: SessionDef, ev: <:<[R, Option[B]]): Option[B]

    If the result type of this Invoker is of the form Option[T], execute the statement and return the first row of the result set, or None if the result set is empty.

    If the result type of this Invoker is of the form Option[T], execute the statement and return the first row of the result set, or None if the result set is empty.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 2.1) Use .first.flatten instead of .firstFlatten

  4. final def foldLeft[B](z: B)(op: (B, R) ⇒ B)(implicit session: SessionDef): B

    Execute the statement and left-fold the converted rows of the result set.

    Execute the statement and left-fold the converted rows of the result set.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0) Invoker convenience features will be removed. Invoker is intended for low-level JDBC use only.

  5. final def list(implicit session: SessionDef): List[R]

    Execute the statement and return an immutable and fully materialized list of the results.

    Execute the statement and return an immutable and fully materialized list of the results.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0) Invoker convenience features will be removed. Invoker is intended for low-level JDBC use only.

  6. def mapResult[U](f: (R) ⇒ U): Invoker[U]

    Create a new Invoker which applies the mapping function f to each row of the result set.

    Create a new Invoker which applies the mapping function f to each row of the result set.

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0) Invoker convenience features will be removed. Invoker is intended for low-level JDBC use only.

  7. final def toMap[T, U](implicit session: SessionDef, ev: <:<[R, (T, U)]): Map[T, U]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to StaticQueryInvoker[Unit, R] performed by method staticQueryToInvoker in slick.jdbc.StaticQuery. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Definition Classes
    Invoker
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0) Invoker convenience features will be removed. Invoker is intended for low-level JDBC use only.

  8. def x: StaticQuery[P, R]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to ArrowAssoc[StaticQuery[P, R]] performed by method any2ArrowAssoc in scala.Predef.
    Shadowing
    This implicitly inherited member is ambiguous. One or more implicitly inherited members have similar signatures, so calling this member may produce an ambiguous implicit conversion compiler error.
    To access this member you can use a type ascription:
    (staticQuery: ArrowAssoc[StaticQuery[P, R]]).x
    Definition Classes
    ArrowAssoc
    Annotations
    @deprecated
    Deprecated

    (Since version 2.10.0) Use leftOfArrow instead

  9. def x: StaticQuery[P, R]

    Implicit information
    This member is added by an implicit conversion from StaticQuery[P, R] to Ensuring[StaticQuery[P, R]] performed by method any2Ensuring in scala.Predef. This conversion will take place only if P is a superclass of Unit (P >: Unit).
    Shadowing
    This implicitly inherited member is ambiguous. One or more implicitly inherited members have similar signatures, so calling this member may produce an ambiguous implicit conversion compiler error.
    To access this member you can use a type ascription:
    (staticQuery: Ensuring[StaticQuery[P, R]]).x
    Definition Classes
    Ensuring
    Annotations
    @deprecated
    Deprecated

    (Since version 2.10.0) Use resultOfEnsuring instead

Inherited from (P) ⇒ Invoker[R]

Inherited from AnyRef

Inherited from Any

Inherited by implicit conversion staticQueryToInvoker from StaticQuery[P, R] to StaticQueryInvoker[Unit, R]

Inherited by implicit conversion any2stringadd from StaticQuery[P, R] to StringAdd

Inherited by implicit conversion any2stringfmt from StaticQuery[P, R] to StringFormat

Inherited by implicit conversion any2ArrowAssoc from StaticQuery[P, R] to ArrowAssoc[StaticQuery[P, R]]

Inherited by implicit conversion any2Ensuring from StaticQuery[P, R] to Ensuring[StaticQuery[P, R]]

Ungrouped