StringSQLRunner

case class StringSQLRunner(sql: String) extends LogSupport

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 Params
sql

SQL value

Companion
object
trait Serializable
trait Product
trait Equals
trait LogSupport
class Object
trait Matchable
class Any

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 Params
A

value type

Returns

a single result as A

def asList[A](implicit t: ClassTag[A]): List[A]

Returns SQL results as List[A]

Returns SQL results as List[A]

Type Params
A

value type

Returns

results as List[A]

def asOption[A](implicit t: ClassTag[A]): Option[A]

Returns SQL result as single value optionally

Returns SQL result as single value optionally

Type Params
A

value type

Returns

a single result as A optionally

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 Params
session

DB Session

Returns

results as Boolean

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 Params
session

DB Session

Returns

results as List[Map]

def show(implicit session: DBSession): Unit

Shows all the result

Shows all the result

Value Params
session

DB Session

Inherited methods

def productElementNames: Iterator[String]
Inherited from
Product
def productIterator: Iterator[Any]
Inherited from
Product

Inherited fields

protected val log: Log

Logger

Logger

Inherited from
LogSupport