Sql

Abstract Value Members

abstract def getFilledStatement(connection: Connection, getGeneratedKeys: Boolean = false): PreparedStatement

Concrete Value Members

final def !=(arg0: AnyRef): Boolean

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

Definition Classes
Any
final def ##(): Int

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

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

Definition Classes
Any
def apply()(implicit connection: Connection): Stream[Row]

Executes this SQL statement as query, returns result as Row stream.
def as[T](parser: ResultSetParser[T])(implicit connection: Connection): T

Executes this statement as query and convert result as T, using parser.
final def asInstanceOf[T0]: T0

Definition Classes
Any
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
final def eq(arg0: AnyRef): Boolean

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

Definition Classes
AnyRef → Any
def execute()(implicit connection: Connection): Boolean

Executes this SQL statement.
Executes this SQL statement.
returns
true if resultset was returned from execution (statement is query), or false if it executed update
def execute1(getGeneratedKeys: Boolean = false)(implicit connection: Connection): (PreparedStatement, Int)
def executeInsert[A](generatedKeysParser: ResultSetParser[A] = SqlParser.scalar[Long].singleOpt)(implicit connection: Connection): A

Executes this SQL as an insert statement.
Executes this SQL as an insert statement.
generatedKeysParser
Parser for generated key (default: scalar long)
returns
Parsed generated keys
```
import anorm.SqlParser.scalar

val keys1 = SQL("INSERT INTO Test(x) VALUES ({x})").
  on("x" -> "y").executeInsert()

val keys2 = SQL("INSERT INTO Test(x) VALUES ({x})").
  on("x" -> "y").executeInsert(scalar[String].singleOpt)
// ... generated string key
```

def executeQuery()(implicit connection: Connection): SqlQueryResult

Executes this SQL query, and returns its result.

implicit val conn: Connection = openConnection
val res: SqlQueryResult =
  SQL("SELECT text_col FROM table WHERE id = {code}").
  on("code" -> code).executeQuery()
// Check execution context; e.g. res.statementWarning
val str = res as scalar[String].single // going with row parsing

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

Executes this SQL as an update statement.
Executes this SQL as an update statement.
returns
Count of updated row(s)

Annotations
@throws( "If statement is query not update" )
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def hashCode(): Int

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

Definition Classes
Any
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def toString(): String

Definition Classes
AnyRef → Any
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( ... )

Deprecated Value Members

def filledStatement(implicit connection: Connection): PreparedStatement

Annotations
@deprecated
Deprecated
(Since version 2.3.0) Use getFilledStatement or executeQuery
def list[A](rowParser: RowParser[A])(implicit connection: Connection): Seq[A]

Annotations
@deprecated
Deprecated
(Since version 2.3.0) Use as with rowParser.*
def parse[T](parser: ResultSetParser[T])(implicit connection: Connection): T

Annotations
@deprecated
Deprecated
(Since version 2.3.0) Use as
def single[T](rowParser: RowParser[T])(implicit connection: Connection): T

Annotations
@deprecated
Deprecated
(Since version 2.3.0) Use as with rowParser.single
def singleOpt[T](rowParser: RowParser[T])(implicit connection: Connection): Option[T]

Annotations
@deprecated
Deprecated
(Since version 2.3.0) Use as with rowParser.singleOpt

sealed trait Sql extends AnyRef

Abstract Value Members

abstract def getFilledStatement(connection: Connection, getGeneratedKeys: Boolean = false): PreparedStatement

Concrete Value Members

final def !=(arg0: AnyRef): Boolean

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: AnyRef): Boolean

final def ==(arg0: Any): Boolean

def apply()(implicit connection: Connection): Stream[Row]

def as[T](parser: ResultSetParser[T])(implicit connection: Connection): T

final def asInstanceOf[T0]: T0

def clone(): AnyRef

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

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

def execute1(getGeneratedKeys: Boolean = false)(implicit connection: Connection): (PreparedStatement, Int)

def executeInsert[A](generatedKeysParser: ResultSetParser[A] = SqlParser.scalar[Long].singleOpt)(implicit connection: Connection): A

def executeQuery()(implicit connection: Connection): SqlQueryResult

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

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

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

def toString(): String

final def wait(): Unit

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

final def wait(arg0: Long): Unit

Deprecated Value Members

def filledStatement(implicit connection: Connection): PreparedStatement

def list[A](rowParser: RowParser[A])(implicit connection: Connection): Seq[A]

def parse[T](parser: ResultSetParser[T])(implicit connection: Connection): T

def single[T](rowParser: RowParser[T])(implicit connection: Connection): T

def singleOpt[T](rowParser: RowParser[T])(implicit connection: Connection): Option[T]

Inherited from AnyRef

Inherited from Any

Ungrouped