case class StringSQLRunner(sql: String) extends LogSupport with Product with Serializable
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()
- sql
SQL value
- Source
- StringSQLRunner.scala
Linear Supertypes
Ordering
- Alphabetic
- By Inheritance
Inherited
- StringSQLRunner
- Serializable
- Serializable
- Product
- Equals
- LogSupport
- AnyRef
- Any
- Hide All
- Show All
Visibility
- Public
- All
Instance Constructors
-
new
StringSQLRunner(sql: String)
- sql
SQL value
Value Members
-
final
def
!=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
##(): Int
- Definition Classes
- AnyRef → Any
-
final
def
==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
def
as[A](implicit t: ClassTag[A]): A
Returns SQL result as single value
Returns SQL result as single value
- A
value type
- returns
a single result as A
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
-
def
asList[A](implicit t: ClassTag[A]): List[A]
Returns SQL results as List[A]
Returns SQL results as List[A]
- 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
- A
value type
- returns
a single result as A optionally
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
execute()(implicit session: DBSession = AutoSession): Boolean
Runs all SQL and returns result as Boolean value
Runs all SQL and returns result as Boolean value
- session
DB Session
- returns
results as Boolean
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
-
val
log: Log
Logger
Logger
- Attributes
- protected
- Definition Classes
- LogSupport
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
-
def
run()(implicit session: DBSession = AutoSession): 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]]
- session
DB Session
- returns
results as List[Map]
-
def
show()(implicit session: DBSession = AutoSession): Unit
Shows all the result
Shows all the result
- session
DB Session
- val sql: String
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
-
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( ... )