scalikejdbc

SQL

Related Docs: object SQL | package scalikejdbc

abstract class SQL[A, E <: WithExtractor] extends Extractor[A]

SQL abstraction.

A

return type

Source
SQL.scala
Linear Supertypes
Extractor[A], AnyRef, Any
Known Subclasses
AllOutputDecisionsUnsupported, OneToManies10SQL, OneToManies10SQLToCollection, OneToManies10SQLToList, OneToManies10SQLToOption, OneToManies10SQLToTraversable, OneToManies11SQL, OneToManies11SQLToCollection, OneToManies11SQLToList, OneToManies11SQLToOption, OneToManies11SQLToTraversable, OneToManies12SQL, OneToManies12SQLToCollection, OneToManies12SQLToList, OneToManies12SQLToOption, OneToManies12SQLToTraversable, OneToManies13SQL, OneToManies13SQLToCollection, OneToManies13SQLToList, OneToManies13SQLToOption, OneToManies13SQLToTraversable, OneToManies14SQL, OneToManies14SQLToCollection, OneToManies14SQLToList, OneToManies14SQLToOption, OneToManies14SQLToTraversable, OneToManies15SQL, OneToManies15SQLToCollection, OneToManies15SQLToList, OneToManies15SQLToOption, OneToManies15SQLToTraversable, OneToManies16SQL, OneToManies16SQLToCollection, OneToManies16SQLToList, OneToManies16SQLToOption, OneToManies16SQLToTraversable, OneToManies17SQL, OneToManies17SQLToCollection, OneToManies17SQLToList, OneToManies17SQLToOption, OneToManies17SQLToTraversable, OneToManies18SQL, OneToManies18SQLToCollection, OneToManies18SQLToList, OneToManies18SQLToOption, OneToManies18SQLToTraversable, OneToManies19SQL, OneToManies19SQLToCollection, OneToManies19SQLToList, OneToManies19SQLToOption, OneToManies19SQLToTraversable, OneToManies20SQL, OneToManies20SQLToCollection, OneToManies20SQLToList, OneToManies20SQLToOption, OneToManies20SQLToTraversable, OneToManies21SQL, OneToManies21SQLToCollection, OneToManies21SQLToList, OneToManies21SQLToOption, OneToManies21SQLToTraversable, OneToManies2SQL, OneToManies2SQLToCollection, OneToManies2SQLToList, OneToManies2SQLToOption, OneToManies2SQLToTraversable, OneToManies3SQL, OneToManies3SQLToCollection, OneToManies3SQLToList, OneToManies3SQLToOption, OneToManies3SQLToTraversable, OneToManies4SQL, OneToManies4SQLToCollection, OneToManies4SQLToList, OneToManies4SQLToOption, OneToManies4SQLToTraversable, OneToManies5SQL, OneToManies5SQLToCollection, OneToManies5SQLToList, OneToManies5SQLToOption, OneToManies5SQLToTraversable, OneToManies6SQL, OneToManies6SQLToCollection, OneToManies6SQLToList, OneToManies6SQLToOption, OneToManies6SQLToTraversable, OneToManies7SQL, OneToManies7SQLToCollection, OneToManies7SQLToList, OneToManies7SQLToOption, OneToManies7SQLToTraversable, OneToManies8SQL, OneToManies8SQLToCollection, OneToManies8SQLToList, OneToManies8SQLToOption, OneToManies8SQLToTraversable, OneToManies9SQL, OneToManies9SQLToCollection, OneToManies9SQLToList, OneToManies9SQLToOption, OneToManies9SQLToTraversable, OneToManySQL, OneToManySQLToCollection, OneToManySQLToList, OneToManySQLToOption, OneToManySQLToTraversable, OneToOneSQL, OneToOneSQLToCollection, OneToOneSQLToList, OneToOneSQLToOption, OneToOneSQLToTraversable, OneToXSQL, SQLToCollection, SQLToCollectionImpl, SQLToList, SQLToListImpl, SQLToOption, SQLToOptionImpl, SQLToResult, SQLToTraversable, SQLToTraversableImpl
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. SQL
  2. Extractor
  3. AnyRef
  4. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new SQL(statement: String, parameters: Seq[Any])(f: (WrappedResultSet) ⇒ A)

    statement

    SQL template

    parameters

    parameters

    f

    extractor function

Type Members

  1. type SQLWithExtractor = SQL[A, HasExtractor]

  2. type ThisSQL = SQL[A, E]

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 batch(parameters: Seq[Any]*): SQLBatch

    Binds parameters for batch

    Binds parameters for batch

    parameters

    parameters

    returns

    SQL for batch

  6. def batchByName(parameters: Seq[(Symbol, Any)]*): SQLBatch

    Binds parameters for batch

    Binds parameters for batch

    parameters

    parameters

    returns

    SQL for batch

  7. def bind(parameters: Any*): SQL[A, E]

    Binds parameters to SQL template in order.

    Binds parameters to SQL template in order.

    parameters

    parameters

    returns

    SQL instance

  8. def bindByName(parametersByName: (Symbol, Any)*): SQL[A, E]

    Binds named parameters to SQL template.

    Binds named parameters to SQL template.

    parametersByName

    named parameters

    returns

    SQL instance

  9. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  10. def collection: SQLToCollection[A, E]

    Set execution type as collection.

    Set execution type as collection.

    returns

    SQL instance

  11. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  12. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  13. def execute(): SQLExecution

    Set execution type as execute

    Set execution type as execute

    returns

    SQL instance

  14. def executeUpdate(): SQLUpdate

    Set execution type as executeUpdate

    Set execution type as executeUpdate

    returns

    SQL instance

  15. def executeUpdateWithFilters(before: (PreparedStatement) ⇒ Unit, after: (PreparedStatement) ⇒ Unit): SQLUpdate

    Set execution type as executeUpdate with filters

    Set execution type as executeUpdate with filters

    before

    before filter

    after

    after filter

    returns

    SQL instance

  16. def executeWithFilters(before: (PreparedStatement) ⇒ Unit, after: (PreparedStatement) ⇒ Unit): SQLExecution

    Set execution type as execute with filters

    Set execution type as execute with filters

    before

    before filter

    after

    after filter

    returns

    SQL instance

  17. def extractor: (WrappedResultSet) ⇒ A

    Definition Classes
    SQL → Extractor

  18. def fetchSize: Option[Int]

    Returns fetchSize for this query.

    Returns fetchSize for this query.

    returns

    fetch size

  19. def fetchSize(fetchSize: Option[Int]): SQL.this.type

  20. def fetchSize(fetchSize: Int): SQL.this.type

    Set fetchSize for this query.

    Set fetchSize for this query.

    fetchSize

    fetch size

    returns

    this

  21. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  22. def first(): SQLToOption[A, E]

    Set execution type as first.

    Set execution type as first.

    returns

    SQL instance

  23. def foldLeft[A](z: A)(op: (A, WrappedResultSet) ⇒ A)(implicit session: DBSession): A

    folding into one value

    folding into one value

    z

    initial value

    op

    operation

  24. def foreach(op: (WrappedResultSet) ⇒ Unit)(implicit session: DBSession): Unit

    Apply the operation to all elements of result set

    Apply the operation to all elements of result set

    op

    operation

  25. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any

  26. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  27. def headOption(): SQLToOption[A, E]

    Same as #first.

    Same as #first.

    returns

    SQL instance

  28. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  29. def list(): SQLToList[A, E]

    Set execution type as list.

    Set execution type as list.

    returns

    SQL instance

  30. def map[A](f: (WrappedResultSet) ⇒ A): SQL[A, HasExtractor]

    Maps values from each scalikejdbc.WrappedResultSet object.

    Maps values from each scalikejdbc.WrappedResultSet object.

    A

    return type

    f

    extractor function

    returns

    SQL instance

  31. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  32. final def notify(): Unit

    Definition Classes
    AnyRef

  33. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  34. def one[Z](f: (WrappedResultSet) ⇒ A): OneToXSQL[A, E, Z]

    Returns One-to-X API builder.

  35. val parameters: Seq[Any]

    parameters

  36. def single(): SQLToOption[A, E]

    Set execution type as single.

    Set execution type as single.

    returns

    SQL instance

  37. val statement: String

    SQL template

  38. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef

  39. def tags: Seq[String]

  40. def tags(tags: String*): SQL.this.type

    Appends tags to this SQL object.

    Appends tags to this SQL object.

    tags

    tags

    returns

    this

  41. def toCollection: SQLToCollection[A, E]

    Same as #collection

    Same as #collection

    returns

    SQL instance

  42. def toList(): SQLToList[A, E]

    Same as #list

    Same as #list

    returns

    SQL instance

  43. def toMap(): SQL[Map[String, Any], HasExtractor]

    Maps values as a Map value from each scalikejdbc.WrappedResultSet object.

    Maps values as a Map value from each scalikejdbc.WrappedResultSet object.

    returns

    SQL instance

  44. def toOption(): SQLToOption[A, E]

    Same as #single.

    Same as #single.

    returns

    SQL instance

  45. def toString(): String

    Definition Classes
    AnyRef → Any

  46. def toTraversable(): SQLToTraversable[A, E]

    Same as #traversable.

    Same as #traversable.

    returns

    SQL instance

  47. def traversable(): SQLToTraversable[A, E]

    Set execution type as traversable.

    Set execution type as traversable.

    returns

    SQL instance

  48. def update(): SQLUpdate

    Set execution type as executeUpdate

    Set execution type as executeUpdate

    returns

    SQL instance

  49. def updateAndReturnGeneratedKey(index: Int): SQLUpdateWithGeneratedKey

  50. def updateAndReturnGeneratedKey(name: String): SQLUpdateWithGeneratedKey

  51. def updateAndReturnGeneratedKey(): SQLUpdateWithGeneratedKey

    Set execution type as updateAndReturnGeneratedKey

    Set execution type as updateAndReturnGeneratedKey

    returns

    SQL instance

  52. def updateWithFilters(before: (PreparedStatement) ⇒ Unit, after: (PreparedStatement) ⇒ Unit): SQLUpdate

    Set execution type as executeUpdate with filters

    Set execution type as executeUpdate with filters

    before

    before filter

    after

    after filter

    returns

    SQL instance

  53. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  54. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  55. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  56. def withExtractor[B](f: (WrappedResultSet) ⇒ B): SQL[B, HasExtractor]

    Attributes
    protected

  57. def withParameters(params: Seq[Any]): SQL[A, E]

    Attributes
    protected

  58. def withStatementAndParameters(state: String, params: Seq[Any]): SQL[A, E]

    Attributes
    protected

Inherited from Extractor[A]

Inherited from AnyRef

Inherited from Any

Ungrouped