SqlQuery

Instance Constructors

new SqlQuery(query: String, argsInitialOrder: List[String] = immutable.this.List.empty[Nothing], queryTimeout: Option[Int] = scala.None)

Annotations
@deprecated
Deprecated
(Since version 2.3.2) Do not use the SqlQuery constructor directly because it does not parse the query. Use SQL(...) instead.

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.
Executes this SQL statement as query, returns result as Row stream.

Definition Classes
Sql
val argsInitialOrder: List[String]
def as[T](parser: ResultSetParser[T])(implicit connection: Connection): T

Executes this statement as query and convert result as T, using parser.
Executes this statement as query and convert result as T, using parser.

Definition Classes
Sql
def asBatch[T]: BatchSql
final def asInstanceOf[T0]: T0

Definition Classes
Any
def asSimple[T](parser: RowParser[T] = defaultParser): SimpleSql[T]

Prepares query as a simple one.
Prepares query as a simple one.
parser
Row parser
```
import anorm.{ SQL, SqlParser }

SQL("SELECT 1").asSimple(SqlParser.scalar[Int])
```
def canEqual(that: Any): Boolean

Definition Classes
SqlQuery → Equals
def clone(): AnyRef

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

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

Definition Classes
SqlQuery → Equals → 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

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

Definition Classes
Sql
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
```
Definition Classes
Sql

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

Definition Classes: Sql

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)

Definition Classes
Sql
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 getFilledStatement(connection: Connection, getGeneratedKeys: Boolean = false): PreparedStatement

Definition Classes
SqlQuery → Sql
def hashCode(): Int

Definition Classes
SqlQuery → 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
def productArity: Int

Definition Classes
SqlQuery → Product
def productElement(n: Int): Any

Definition Classes
SqlQuery → Product
def productIterator: Iterator[Any]

Definition Classes
Product
def productPrefix: String

Definition Classes
SqlQuery → Product
val query: String
val queryTimeout: Option[Int]
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def toString(): String

Definition Classes
SqlQuery → 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( ... )
def withQueryTimeout(seconds: Option[Int]): SqlQuery

Deprecated Value Members

def copy(query: String = this.query, argsInitialOrder: List[String] = this.argsInitialOrder, queryTimeout: Option[Int] = this.queryTimeout): SqlQuery

Annotations
@deprecated
Deprecated
(Since version 2.3.2) SqlQuery will become a trait in 2.4.0
def filledStatement(implicit connection: Connection): PreparedStatement

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

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

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

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

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

class SqlQuery extends Sql with Product with Serializable

Instance Constructors

new SqlQuery(query: String, argsInitialOrder: List[String] = immutable.this.List.empty[Nothing], queryTimeout: Option[Int] = scala.None)

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]

val argsInitialOrder: List[String]

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

def asBatch[T]: BatchSql

final def asInstanceOf[T0]: T0

def asSimple[T](parser: RowParser[T] = defaultParser): SimpleSql[T]

def canEqual(that: Any): Boolean

def clone(): AnyRef

final def eq(arg0: AnyRef): Boolean

def equals(obj: 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 getFilledStatement(connection: Connection, getGeneratedKeys: Boolean = false): PreparedStatement

def hashCode(): Int

final def isInstanceOf[T0]: Boolean

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def productArity: Int

def productElement(n: Int): Any

def productIterator: Iterator[Any]

def productPrefix: String

val query: String

val queryTimeout: Option[Int]

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

def withQueryTimeout(seconds: Option[Int]): SqlQuery

Deprecated Value Members

def copy(query: String = this.query, argsInitialOrder: List[String] = this.argsInitialOrder, queryTimeout: Option[Int] = this.queryTimeout): SqlQuery

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 Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from Sql

Inherited from AnyRef

Inherited from Any

Ungrouped