StringSQLRunner

scalikejdbc.StringSQLRunner
See theStringSQLRunner companion object
case class StringSQLRunner(sql: String)

String SQL Runner

Basic Usage:

import scalikejdbc.StringSQLRunner._

val result: List[Map[String, Any]] = "insert into users values (1, 'Alice')".run()

val users: List[Map[String, Any]] = "select * from users".run()

Value parameters

sql

SQL value

Attributes

Companion
object
Source
StringSQLRunner.scala
Graph
Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all

Members list

Value members

Concrete methods

def as[A](implicit t: ClassTag[A]): A

Returns SQL result as single value

Returns SQL result as single value

Type parameters

A

value type

Attributes

Returns

a single result as A

Source
StringSQLRunner.scala
def asList[A](implicit t: ClassTag[A]): List[A]

Returns SQL results as List[A]

Returns SQL results as List[A]

Type parameters

A

value type

Attributes

Returns

results as List[A]

Source
StringSQLRunner.scala
def asOption[A](implicit t: ClassTag[A]): Option[A]

Returns SQL result as single value optionally

Returns SQL result as single value optionally

Type parameters

A

value type

Attributes

Returns

a single result as A optionally

Source
StringSQLRunner.scala
def execute()(implicit session: DBSession): Boolean

Runs all SQL and returns result as Boolean value

Runs all SQL and returns result as Boolean value

Value parameters

session

DB Session

Attributes

Returns

results as Boolean

Source
StringSQLRunner.scala
def run()(implicit session: DBSession): List[Map[String, Any]]

Runs all SQL and returns result as List[Map[String, Any]]

Runs all SQL and returns result as List[Map[String, Any]]

Value parameters

session

DB Session

Attributes

Returns

results as List[Map]

Source
StringSQLRunner.scala
def show()(implicit session: DBSession): Unit

Shows all the result

Shows all the result

Value parameters

session

DB Session

Attributes

Source
StringSQLRunner.scala

Inherited methods

def productElementNames: Iterator[String]

Attributes

Inherited from:
Product
def productIterator: Iterator[Any]

Attributes

Inherited from:
Product

Inherited fields

protected val log: Log

Logger

Logger

Attributes

Inherited from:
LogSupport (hidden)
Source
LogSupport.scala