SQL

Instance Constructors

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

statement
SQL template
rawParameters
parameters
f
extractor function

Type Members

type SQLWithExtractor = SQL[A, HasExtractor]
type ThisSQL = SQL[A, E]

Value Members

final def !=(arg0: Any): Boolean

Definition Classes
AnyRef → Any
final def ##(): Int

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

Definition Classes
AnyRef → Any
final def asInstanceOf[T0]: T0

Definition Classes
Any
def batch(parameters: Seq[Any]*): SQLBatch

Binds parameters for batch
Binds parameters for batch
parameters
parameters
returns
SQL for batch
def batchAndReturnGeneratedKey(generatedKeyName: String, parameters: Seq[Any]*): SQLBatchWithGeneratedKey

Binds parameters for batch
Binds parameters for batch
generatedKeyName
generated key name
parameters
parameters
returns
SQL for batch
def batchAndReturnGeneratedKey(parameters: Seq[Any]*): SQLBatchWithGeneratedKey

Binds parameters for batch
Binds parameters for batch
parameters
parameters
returns
SQL for batch
def batchByName(parameters: Seq[(Symbol, Any)]*): SQLBatch

Binds parameters for batch
Binds parameters for batch
parameters
parameters
returns
SQL for batch
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
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
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
def collection: SQLToCollection[A, E]

Set execution type as collection.
Set execution type as collection.
returns
SQL instance
final def eq(arg0: AnyRef): Boolean

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

Definition Classes
AnyRef → Any
def execute(): SQLExecution

Set execution type as execute
Set execution type as execute
returns
SQL instance
def executeUpdate(): SQLUpdate

Set execution type as executeUpdate
Set execution type as executeUpdate
returns
SQL instance
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
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
def extractor: (WrappedResultSet) ⇒ A

Definition Classes
SQL → Extractor
def fetchSize: Option[Int]

Returns fetchSize for this query.
Returns fetchSize for this query.
returns
fetch size
def fetchSize(fetchSize: Option[Int]): SQL.this.type
def fetchSize(fetchSize: Int): SQL.this.type

Set fetchSize for this query.
Set fetchSize for this query.
fetchSize
fetch size
returns
this
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
def first(): SQLToOption[A, E]

Set execution type as first.
Set execution type as first.
returns
SQL instance
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
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
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def hashCode(): Int

Definition Classes
AnyRef → Any
def headOption(): SQLToOption[A, E]

Same as #first.
Same as #first.
returns
SQL instance
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
def list(): SQLToList[A, E]

Set execution type as list.
Set execution type as list.
returns
SQL instance
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
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
def one[Z](f: (WrappedResultSet) ⇒ A): OneToXSQL[A, E, Z]

Returns One-to-X API builder.
final lazy val parameters: Seq[Any]
def queryTimeout: Option[Int]

Returns queryTimeout for this query.
Returns queryTimeout for this query.
returns
query timeout seconds
def queryTimeout(seconds: Option[Int]): SQL.this.type
def queryTimeout(seconds: Int): SQL.this.type

Set queryTimeout for this query.
Set queryTimeout for this query.
seconds
query timeout seconds
returns
this
def single(): SQLToOption[A, E]

Set execution type as single.
Set execution type as single.
returns
SQL instance
val statement: String

SQL template
def stripMargin: SQL[A, E]
def stripMargin(marginChar: Char): SQL[A, E]
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def tags: Seq[String]

Returns tags for this SQL object.
Returns tags for this SQL object.
returns
tags
def tags(tags: String*): SQL.this.type

Appends tags to this SQL object.
Appends tags to this SQL object.
tags
tags
returns
this
def toCollection: SQLToCollection[A, E]

Same as #collection
Same as #collection
returns
SQL instance
def toList(): SQLToList[A, E]

Same as #list
Same as #list
returns
SQL instance
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
def toOption(): SQLToOption[A, E]

Same as #single.
Same as #single.
returns
SQL instance
def toString(): String

Definition Classes
AnyRef → Any
def toTraversable(): SQLToTraversable[A, E]

Same as #traversable.
Same as #traversable.
returns
SQL instance
def traversable(): SQLToTraversable[A, E]

Set execution type as traversable.
Set execution type as traversable.
returns
SQL instance
def update(): SQLUpdate

Set execution type as executeUpdate
Set execution type as executeUpdate
returns
SQL instance
def updateAndReturnGeneratedKey(index: Int): SQLUpdateWithGeneratedKey
def updateAndReturnGeneratedKey(name: String): SQLUpdateWithGeneratedKey
def updateAndReturnGeneratedKey(): SQLUpdateWithGeneratedKey

Set execution type as updateAndReturnGeneratedKey
Set execution type as updateAndReturnGeneratedKey
returns
SQL instance
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
final def wait(): Unit

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

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

Definition Classes
AnyRef
Annotations
@throws( ... )
def withExtractor[B](f: (WrappedResultSet) ⇒ B): SQL[B, HasExtractor]

Attributes
protected
def withParameters(params: Seq[Any]): SQL[A, E]

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

Attributes
protected

Related Docs: object SQL | package scalikejdbc

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

Instance Constructors

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

Type Members

type SQLWithExtractor = SQL[A, HasExtractor]

type ThisSQL = SQL[A, E]

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

final def asInstanceOf[T0]: T0

def batch(parameters: Seq[Any]*): SQLBatch

def batchAndReturnGeneratedKey(generatedKeyName: String, parameters: Seq[Any]*): SQLBatchWithGeneratedKey

def batchAndReturnGeneratedKey(parameters: Seq[Any]*): SQLBatchWithGeneratedKey

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

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

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

def clone(): AnyRef

def collection: SQLToCollection[A, E]

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

def execute(): SQLExecution

def executeUpdate(): SQLUpdate

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

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

def extractor: (WrappedResultSet) ⇒ A

def fetchSize: Option[Int]

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

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

def finalize(): Unit

def first(): SQLToOption[A, E]

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

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

final def getClass(): Class[_]

def hashCode(): Int

def headOption(): SQLToOption[A, E]

final def isInstanceOf[T0]: Boolean

def list(): SQLToList[A, E]

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

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

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

final lazy val parameters: Seq[Any]

def queryTimeout: Option[Int]

def queryTimeout(seconds: Option[Int]): SQL.this.type

def queryTimeout(seconds: Int): SQL.this.type

def single(): SQLToOption[A, E]

val statement: String

def stripMargin: SQL[A, E]

def stripMargin(marginChar: Char): SQL[A, E]

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

def tags: Seq[String]

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

def toCollection: SQLToCollection[A, E]

def toList(): SQLToList[A, E]

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

def toOption(): SQLToOption[A, E]

def toString(): String

def toTraversable(): SQLToTraversable[A, E]

def traversable(): SQLToTraversable[A, E]

def update(): SQLUpdate

def updateAndReturnGeneratedKey(index: Int): SQLUpdateWithGeneratedKey

def updateAndReturnGeneratedKey(name: String): SQLUpdateWithGeneratedKey

def updateAndReturnGeneratedKey(): SQLUpdateWithGeneratedKey

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

final def wait(): Unit

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

final def wait(arg0: Long): Unit

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

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

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

Inherited from Extractor[A]

Inherited from AnyRef

Inherited from Any

Ungrouped