scalikejdbc-core/scalikejdbc/SQLToListImpl

SQLToListImpl

class SQLToListImpl[A, E <: WithExtractor](val statement: String, val rawParameters: Seq[Any])(val extractor: WrappedResultSet => A) extends SQL[A, E] with SQLToList[A, E]

SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.immutable.List value.

Type Params
A

return type

Value Params
extractor

extractor function

rawParameters

parameters

statement

SQL template

Companion
object
trait SQLToList[A, E]
trait SQLToResult[A, E, List]
class SQL[A, E]
trait Extractor[A]
class Object
trait Matchable
class Any

Type members

Inherited types

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

Value members

Inherited methods

def apply(implicit session: DBSession, context: ConnectionPoolContext, hasExtractor: ThisSQL =:= SQLWithExtractor): List[A]
Inherited from
SQLToResult
def batch(parameters: Seq[Any]*): SQLBatch

Binds parameters for batch

Binds parameters for batch

Value Params
parameters

parameters

Returns

SQL for batch

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

Binds parameters for batch

Binds parameters for batch

Value Params
generatedKeyName

generated key name

parameters

parameters

Returns

SQL for batch

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

Binds parameters for batch

Binds parameters for batch

Value Params
parameters

parameters

Returns

SQL for batch

Inherited from
SQL
def batchByName(parameters: Seq[(String, Any)]*): SQLBatch

Binds parameters for batch

Binds parameters for batch

Value Params
parameters

parameters

Returns

SQL for batch

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

Binds parameters to SQL template in order.

Binds parameters to SQL template in order.

Value Params
parameters

parameters

Returns

SQL instance

Inherited from
SQL
def bindByName(parametersByName: (String, Any)*): SQL[A, E]

Binds named parameters to SQL template.

Binds named parameters to SQL template.

Value Params
parametersByName

named parameters

Returns

SQL instance

Inherited from
SQL
def collection: SQLToCollection[A, E]

Set execution type as collection.

Set execution type as collection.

Returns

SQL instance

Inherited from
SQL
def dbSettingSettings(settings: SettingsProvider): SQLToListImpl[A, E]
Inherited from
SQL
def execute: SQLExecution

Set execution type as execute

Set execution type as execute

Returns

SQL instance

Inherited from
SQL
def executeUpdate: SQLUpdate

Set execution type as executeUpdate

Set execution type as executeUpdate

Returns

SQL instance

Inherited from
SQL
def executeUpdateWithFilters(before: PreparedStatement => Unit, after: PreparedStatement => Unit): SQLUpdate

Set execution type as executeUpdate with filters

Set execution type as executeUpdate with filters

Value Params
after

after filter

before

before filter

Returns

SQL instance

Inherited from
SQL
def executeWithFilters(before: PreparedStatement => Unit, after: PreparedStatement => Unit): SQLExecution

Set execution type as execute with filters

Set execution type as execute with filters

Value Params
after

after filter

before

before filter

Returns

SQL instance

Inherited from
SQL
def fetchSize: Option[Int]

Returns fetchSize for this query.

Returns fetchSize for this query.

Returns

fetch size

Inherited from
SQL
def fetchSize(fetchSize: Option[Int]): SQLToListImpl[A, E]
Inherited from
SQL
def fetchSize(fetchSize: Int): SQLToListImpl[A, E]

Set fetchSize for this query.

Set fetchSize for this query.

Value Params
fetchSize

fetch size

Returns

this

Inherited from
SQL
def first: SQLToOption[A, E]

Set execution type as first.

Set execution type as first.

Returns

SQL instance

Inherited from
SQL
def foldLeft[A](z: A)(op: (A, WrappedResultSet) => A)(implicit session: DBSession): A

folding into one value

folding into one value

Value Params
op

operation

z

initial value

Inherited from
SQL
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

Value Params
op

operation

Inherited from
SQL
def headOption: SQLToOption[A, E]

Same as #first.

Same as #first.

Returns

SQL instance

Inherited from
SQL
def iterable: SQLToIterable[A, E]

Set execution type as iterable.

Set execution type as iterable.

Returns

SQL instance

Inherited from
SQL
def largeBatch(parameters: Seq[Any]*): SQLLargeBatch

Binds parameters for largeBatch

Binds parameters for largeBatch

Value Params
parameters

parameters

Returns

SQL for batch

Inherited from
SQL
def largeUpdate: SQLLargeUpdate

Set execution type as executeLargeUpdate

Set execution type as executeLargeUpdate

Returns

SQL instance

Inherited from
SQL
def largeUpdateWithFilters(before: PreparedStatement => Unit, after: PreparedStatement => Unit): SQLLargeUpdate

Set execution type as executeLargeUpdate with filters

Set execution type as executeLargeUpdate with filters

Value Params
after

after filter

before

before filter

Returns

SQL instance

Inherited from
SQL
def list: SQLToList[A, E]

Set execution type as list.

Set execution type as list.

Returns

SQL instance

Inherited from
SQL
def map[A](f: WrappedResultSet => A): SQL[A, HasExtractor]

Maps values from each scalikejdbc.WrappedResultSet object.

Maps values from each scalikejdbc.WrappedResultSet object.

Type Params
A

return type

Value Params
f

extractor function

Returns

SQL instance

Inherited from
SQL
def one[Z](f: WrappedResultSet => A): OneToXSQL[A, E, Z]

Returns One-to-X API builder.

Returns One-to-X API builder.

Inherited from
SQL
def queryTimeout: Option[Int]

Returns queryTimeout for this query.

Returns queryTimeout for this query.

Returns

query timeout seconds

Inherited from
SQL
def queryTimeout(seconds: Option[Int]): SQLToListImpl[A, E]
Inherited from
SQL
def queryTimeout(seconds: Int): SQLToListImpl[A, E]

Set queryTimeout for this query.

Set queryTimeout for this query.

Value Params
seconds

query timeout seconds

Returns

this

Inherited from
SQL
def result[AA](f: WrappedResultSet => AA, session: DBSession): List[AA]
Inherited from
SQLToList
def single: SQLToOption[A, E]

Set execution type as single.

Set execution type as single.

Returns

SQL instance

Inherited from
SQL
def stripMargin: SQL[A, E]
Inherited from
SQL
def stripMargin(marginChar: Char): SQL[A, E]
Inherited from
SQL
def tags: Seq[String]

Returns tags for this SQL object.

Returns tags for this SQL object.

Returns

tags

Inherited from
SQL
def tags(tags: String*): SQLToListImpl[A, E]

Appends tags to this SQL object.

Appends tags to this SQL object.

Value Params
tags

tags

Returns

this

Inherited from
SQL
def toCollection: SQLToCollection[A, E]

Same as #collection

Same as #collection

Returns

SQL instance

Inherited from
SQL
def toIterable: SQLToIterable[A, E]

Same as #iterable.

Same as #iterable.

Returns

SQL instance

Inherited from
SQL
def toList: SQLToList[A, E]

Same as #list

Same as #list

Returns

SQL instance

Inherited from
SQL
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

Inherited from
SQL
def toOption: SQLToOption[A, E]

Same as #single.

Same as #single.

Returns

SQL instance

Inherited from
SQL
def update: SQLUpdate

Set execution type as executeUpdate

Set execution type as executeUpdate

Returns

SQL instance

Inherited from
SQL
def updateAndReturnGeneratedKey: SQLUpdateWithGeneratedKey

Set execution type as updateAndReturnGeneratedKey

Set execution type as updateAndReturnGeneratedKey

Returns

SQL instance

Inherited from
SQL
def updateWithFilters(before: PreparedStatement => Unit, after: PreparedStatement => Unit): SQLUpdate

Set execution type as executeUpdate with filters

Set execution type as executeUpdate with filters

Value Params
after

after filter

before

before filter

Returns

SQL instance

Inherited from
SQL

Concrete fields

override val extractor: WrappedResultSet => A
override val rawParameters: Seq[Any]
override val statement: String

Inherited fields

final lazy val parameters: Seq[Any]
Inherited from
SQL