scalikejdbc
package scalikejdbc
ScalikeJDBC - SQL-Based DB Access Library for Scala
Just write SQL:
ScalikeJDBC is a SQL-based DB access library for Scala developers. This library naturally wraps JDBC APIs and provides you easy-to-use APIs. Users do nothing other than writing SQL and mapping from java.sql.ResultSet objects to Scala values.
Basic Usage:
Using scalikejdbc.DBSession:
import scalikejdbc._ import org.joda.time.DateTime case class User(id: Long, name: String, birthday: Option[DateTime]) val activeUsers: List[User] = DB readOnly { session => session.list("select * from users where active = ?", true) { rs => User(id = rs.long("id"), name = rs.string("name"), birthday = Option(rs.date("birthday")).map(_.toJodaDateTime)) } }
Using scalikejdbc.SQL:
import scalikejdbc._ import org.joda.time.DateTime case class User(id: Long, name: String, birthday: Option[DateTime]) val activeUsers: List[User] = DB readOnly { implicit session => SQL("select * from users where active = ?") .bind(true) .map { rs => User(id = rs.long("id"), name = rs.string("name"), birthday = Option(rs.date("birthday")).map(_.toJodaDateTime)) }.list.apply() }
or
val activeUsers: List[User] = DB readOnly { implicit session => SQL("select * from users where active = /*'active*/true") .bindByName('active -> true) .map { rs => User(id = rs.long("id"), name = rs.string("name"), birthday = Option(rs.date("birthday")).map(_.toJodaDateTime)) }.list.apply() }
- Source
- package.scala
- Alphabetic
- By Inheritance
- scalikejdbc
- JavaUtilDateConverterImplicits
- ScalaBigDecimalConverterImplicits
- SQLInterpolation
- QueryDSLFeature
- SQLSyntaxSupportFeature
- SQLInterpolationFeature
- SQLInterpolationCoreTypeAlias
- Implicits
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Type Members
-
type
AsteriskProvider = scalikejdbc.interpolation.AsteriskProvider
- Definition Classes
- SQLInterpolationCoreTypeAlias
-
case class
BasicResultNameSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with (SQLSyntaxSupportFeature.this)#ResultNameSQLSyntaxProvider[S, A] with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
BatchParamsBuilder extends Product with Serializable
- Definition Classes
- QueryDSLFeature
- type Closable = AnyRef { def close(): Unit }
-
type
ColumnName[A] = ColumnSQLSyntaxProvider[SQLSyntaxSupport[A], A]
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
ColumnSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProvider[A] with (SQLSyntaxSupportFeature.this)#AsteriskProvider with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
trait
ConditionSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#PagingSQLBuilder[A] with (QueryDSLFeature.this)#GroupBySQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
case class
DeleteSQLBuilder extends (QueryDSLFeature.this)#SQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with (QueryDSLFeature.this)#WhereSQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with Product with Serializable
- Definition Classes
- QueryDSLFeature
-
trait
ExceptQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
trait
ForUpdateQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
trait
GroupBySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#PagingSQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
case class
InsertSQLBuilder extends (QueryDSLFeature.this)#SQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with Product with Serializable
- Definition Classes
- QueryDSLFeature
-
trait
IntersectQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
trait
PagingSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#UnionQuerySQLBuilder[A] with (QueryDSLFeature.this)#ExceptQuerySQLBuilder[A] with (QueryDSLFeature.this)#IntersectQuerySQLBuilder[A] with (QueryDSLFeature.this)#ForUpdateQuerySQLBuilder[A] with (QueryDSLFeature.this)#SubQuerySQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
case class
PartialResultSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
PartialSubQueryResultNameSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with (SQLSyntaxSupportFeature.this)#ResultNameSQLSyntaxProvider[S, A] with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
PartialSubQueryResultSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
PartialSubQuerySQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with (SQLSyntaxSupportFeature.this)#AsteriskProvider with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
QuerySQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with (SQLSyntaxSupportFeature.this)#ResultAllProvider with (SQLSyntaxSupportFeature.this)#AsteriskProvider with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
type
ResultAllProvider = scalikejdbc.interpolation.ResultAllProvider
- Definition Classes
- SQLInterpolationCoreTypeAlias
-
type
ResultName[A] = ResultNameSQLSyntaxProvider[SQLSyntaxSupport[A], A]
- Definition Classes
- SQLSyntaxSupportFeature
-
trait
ResultNameSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProvider[A]
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
ResultSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
trait
SQLBuilder[A] extends AnyRef
- Definition Classes
- QueryDSLFeature
-
type
SQLSyntax = scalikejdbc.interpolation.SQLSyntax
- Definition Classes
- SQLInterpolationCoreTypeAlias
-
trait
SQLSyntaxProvider[A] extends Dynamic with SelectDynamicMacro[A]
- Definition Classes
- SQLSyntaxSupportFeature
-
trait
SQLSyntaxSupport[A] extends AnyRef
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
SelectSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#SubQuerySQLBuilder[A] with Product with Serializable
- Definition Classes
- QueryDSLFeature
-
type
SubQueryResultName = SubQueryResultNameSQLSyntaxProvider
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
SubQueryResultNameSQLSyntaxProvider extends Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
SubQueryResultSQLSyntaxProvider extends Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
trait
SubQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
case class
SubQuerySQLSyntaxProvider extends (SQLSyntaxSupportFeature.this)#ResultAllProvider with (SQLSyntaxSupportFeature.this)#AsteriskProvider with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
type
SubQuerySyntaxProvider = SubQuerySQLSyntaxProvider
- Definition Classes
- SQLSyntaxSupportFeature
-
type
SyntaxProvider[A] = QuerySQLSyntaxProvider[SQLSyntaxSupport[A], A]
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
TableAsAliasSQLSyntax extends (SQLSyntaxSupportFeature.this)#SQLSyntax with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
case class
TableDefSQLSyntax extends (SQLSyntaxSupportFeature.this)#SQLSyntax with Product with Serializable
- Definition Classes
- SQLSyntaxSupportFeature
-
trait
UnionQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
- Definition Classes
- QueryDSLFeature
-
trait
UpdateOperation extends AnyRef
- Definition Classes
- QueryDSLFeature
-
case class
UpdateSQLBuilder extends (QueryDSLFeature.this)#SQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with (QueryDSLFeature.this)#WhereSQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with Product with Serializable
- Definition Classes
- QueryDSLFeature
-
trait
WhereSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
- Definition Classes
- QueryDSLFeature
Value Members
-
val
SQLSyntax: scalikejdbc.interpolation.SQLSyntax.type
- Definition Classes
- SQLInterpolationCoreTypeAlias
-
implicit
def
convertBigDecimal(bd: BigDecimal): ScalaBigDecimalConverter
- Definition Classes
- ScalaBigDecimalConverterImplicits
-
val
delete: scalikejdbc.QueryDSLFeature.QueryDSL.delete.type
- Definition Classes
- QueryDSLFeature
-
val
deleteFrom: scalikejdbc.QueryDSLFeature.QueryDSL.deleteFrom.type
- Definition Classes
- QueryDSLFeature
-
val
insert: scalikejdbc.QueryDSLFeature.QueryDSL.insert.type
- Definition Classes
- QueryDSLFeature
-
val
insertInto: scalikejdbc.QueryDSLFeature.QueryDSL.insertInto.type
- Definition Classes
- QueryDSLFeature
-
def
opt[A](v: Any): Option[A]
Option value converter.
Option value converter.
- A
raw type
- v
nullable raw value
- returns
optional value
-
implicit
def
scalikejdbcSQLInterpolationImplicitDef(s: StringContext): SQLInterpolationString
- Definition Classes
- Implicits
- Annotations
- @inline()
-
implicit
def
scalikejdbcSQLSyntaxToStringImplicitDef(syntax: scalikejdbc.interpolation.SQLSyntax): String
- Definition Classes
- Implicits
- Annotations
- @inline()
-
val
select: scalikejdbc.QueryDSLFeature.QueryDSL.select.type
- Definition Classes
- QueryDSLFeature
-
val
selectFrom: scalikejdbc.QueryDSLFeature.QueryDSL.selectFrom.type
- Definition Classes
- QueryDSLFeature
-
val
sqls: scalikejdbc.interpolation.SQLSyntax.type
- Definition Classes
- SQLInterpolationCoreTypeAlias
-
implicit
def
toJavaUtilDateConverter(value: Date): JavaUtilDateConverter
- Definition Classes
- JavaUtilDateConverterImplicits
-
val
update: scalikejdbc.QueryDSLFeature.QueryDSL.update.type
- Definition Classes
- QueryDSLFeature
- def using[R <: Closable, A](resource: R)(f: (R) ⇒ A): A