Expandable

abstract def getCopy(params: List[(SqlStatement) ⇒ Unit]): ParameterizableSql

Classes that inherit the Sql trait will have to implement a method to copy themselves given just a different set of parameters.

abstract val listParams: Map[String, ListParam]

The names of list params mapped to their size

abstract val params: List[(SqlStatement) ⇒ Unit]

A list of anonymous functions that insert parameters into a SqlStatement

abstract def queryParams: QueryParams

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

def applyParams(stmt: PreparedStatement): Unit

def asCollection[U, T[_]](parser: RowParser[U])(implicit cbf: CanBuildFrom[T[U], U, T[U]], connection: Connection): T[U]

Execute this query and get back the result as an arbitrary collection of records

final def asInstanceOf[T0]: T0

def asIterable[A](parser: RowParser[A])(implicit connection: Connection): Iterable[A]

Execute this query and get back the result as an iterable of records

def asIterator[A](parser: RowParser[A], fetchSize: Int = 100)(implicit connection: Connection): Iterator[A]

The asIterator method returns an Iterator that will stream data out of the database.

def asList[A](parser: RowParser[A])(implicit connection: Connection): List[A]

Execute this query and get back the result as a List of records

def asMap[U, V](parser: RowParser[(U, V)])(implicit connection: Connection): Map[U, V]

Execute this query and get back the result as a Map of records

def asPairCollection[U, V, T[_, _]](parser: RowParser[(U, V)])(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]], connection: Connection): T[U, V]

Execute this query and get back the result as an arbitrary collection of key value pairs

def asScalar[A]()(implicit connection: Connection): A

Execute this query and get back the result as a single value.

def asScalarOption[A]()(implicit connection: Connection): Option[A]

Execute this query and get back the result as an optional single value.

def asSeq[A](parser: RowParser[A])(implicit connection: Connection): Seq[A]

Execute this query and get back the result as a sequence of records

def asSet[A](parser: RowParser[A])(implicit connection: Connection): Set[A]

Execute this query and get back the result as a Set of records

def asSingle[A](parser: RowParser[A])(implicit connection: Connection): A

Execute this query and get back the result as a single record

def asSingleOption[A](parser: RowParser[A])(implicit connection: Connection): Option[A]

Execute this query and get back the result as an optional single record

def clone(): AnyRef

def commaSeparated(name: String, count: Int): Unit

Replace the provided identifier with a comma separated list of parameters WARNING: modifies this Expandable in place

def commas(name: String, count: Int): Expandable

Shorthand for calling commaSeparated within an expand block.

SQL("SELECT * FROM users WHERE id IN ({ids})").commas("ids", 10)

SQL("SELECT * FROM users WHERE id IN ({ids})").expand { implicit query =>
  commaSeparated("ids", 10)
}

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

def execute()(implicit connection: Connection): Boolean

Execute a statement

def executeInsertCollection[U, T[_]](parser: RowParser[U])(implicit cbf: CanBuildFrom[T[U], U, T[U]], connection: Connection): T[U]

Execute the query and get the auto-incremented keys using a RowParser.

def executeInsertInt()(implicit connection: Connection): Int

Execute the query and get the auto-incremented key as an Int

def executeInsertInts()(implicit connection: Connection): List[Int]

Execute the query and get the auto-incremented keys as a List of Ints

def executeInsertLong()(implicit connection: Connection): Long

Execute the query and get the auto-incremented key as a Long

def executeInsertLongs()(implicit connection: Connection): List[Long]

Execute the query and get the auto-incremented keys as a a List of Longs

def executeInsertSingle[U](parser: RowParser[U])(implicit connection: Connection): U

Execute the query and get the auto-incremented key using a RowParser.

def executeUpdate()(implicit connection: Connection): Int

Execute an update

def expand(f: (Expandable) ⇒ Unit): Expandable

Expand out the query by turning an TraversableOnce into several parameters

def finalize(): Unit

final def getClass(): Class[_]

def hashCode(): Int

final def isInstanceOf[T0]: Boolean

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def on(f: (SqlStatement) ⇒ Unit): ParameterizableSql

Put in values for parameters in the query

def onTuples[A](name: String, tuples: TraversableOnce[A])(f: (A, TupleStatement) ⇒ Unit): ParameterizableSql

Put in values for tuple parameters in the query

val parsedParams: Map[String, List[Int]]

val parsedQuery: String

def results()(implicit connection: Connection): ResultSet

Provides direct access to the underlying java.sql.ResultSet.

val results = SQL(query).results()
. . .
SqlResult(results).asList[A](parser)
// or
results.close()

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

def toString(): String

def tupled(name: String, columns: Seq[String], count: Int): Unit

Replace the provided identifier with a comma separated list of tuples WARNING: modifies this Expandable in place

final def wait(): Unit

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

final def wait(arg0: Long): Unit