Packages

p

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
Linear Supertypes
UnixTimeInMillisConverterImplicits, ScalaBigDecimalConverterImplicits, SQLInterpolation, QueryDSLFeature, SQLSyntaxSupportFeature, SQLInterpolationFeature, SQLInterpolationCoreTypeAlias, Implicits, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. scalikejdbc
  2. UnixTimeInMillisConverterImplicits
  3. ScalaBigDecimalConverterImplicits
  4. SQLInterpolation
  5. QueryDSLFeature
  6. SQLSyntaxSupportFeature
  7. SQLInterpolationFeature
  8. SQLInterpolationCoreTypeAlias
  9. Implicits
  10. AnyRef
  11. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Type Members

  1. type AsteriskProvider = scalikejdbc.interpolation.AsteriskProvider
    Definition Classes
    SQLInterpolationCoreTypeAlias
  2. 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
  3. type Closable = AnyRef { def close(): Unit }
  4. type ColumnName[A] = ColumnSQLSyntaxProvider[SQLSyntaxSupport[A], A]
    Definition Classes
    SQLSyntaxSupportFeature
  5. 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
  6. trait ConditionSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#PagingSQLBuilder[A] with (QueryDSLFeature.this)#GroupBySQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  7. case class DeleteSQLBuilder extends (QueryDSLFeature.this)#SQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with (QueryDSLFeature.this)#WhereSQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with Product with Serializable
    Definition Classes
    QueryDSLFeature
  8. trait ExceptQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  9. trait ForUpdateQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  10. trait GroupBySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#PagingSQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  11. case class InsertSQLBuilder extends (QueryDSLFeature.this)#SQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with Product with Serializable
    Definition Classes
    QueryDSLFeature
  12. trait IntersectQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  13. 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
  14. case class PartialResultSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  15. 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
  16. case class PartialSubQueryResultSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  17. 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
  18. 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
  19. type ResultAllProvider = scalikejdbc.interpolation.ResultAllProvider
    Definition Classes
    SQLInterpolationCoreTypeAlias
  20. type ResultName[A] = ResultNameSQLSyntaxProvider[SQLSyntaxSupport[A], A]
    Definition Classes
    SQLSyntaxSupportFeature
  21. trait ResultNameSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProvider[A]
    Definition Classes
    SQLSyntaxSupportFeature
  22. case class ResultSQLSyntaxProvider[S <: (SQLSyntaxSupportFeature.this)#SQLSyntaxSupport[A], A] extends (SQLSyntaxSupportFeature.this)#SQLSyntaxProviderCommonImpl[S, A] with Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  23. trait SQLBuilder[A] extends AnyRef
    Definition Classes
    QueryDSLFeature
  24. type SQLSyntax = scalikejdbc.interpolation.SQLSyntax
    Definition Classes
    SQLInterpolationCoreTypeAlias
  25. trait SQLSyntaxProvider[A] extends Dynamic
    Definition Classes
    SQLSyntaxSupportFeature
  26. trait SQLSyntaxSupport[A] extends AnyRef
    Definition Classes
    SQLSyntaxSupportFeature
  27. case class SelectSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A] with (QueryDSLFeature.this)#SubQuerySQLBuilder[A] with Product with Serializable
    Definition Classes
    QueryDSLFeature
  28. type SubQueryResultName = SubQueryResultNameSQLSyntaxProvider
    Definition Classes
    SQLSyntaxSupportFeature
  29. case class SubQueryResultNameSQLSyntaxProvider extends Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  30. case class SubQueryResultSQLSyntaxProvider extends Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  31. trait SubQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  32. case class SubQuerySQLSyntaxProvider extends (SQLSyntaxSupportFeature.this)#ResultAllProvider with (SQLSyntaxSupportFeature.this)#AsteriskProvider with Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  33. type SubQuerySyntaxProvider = SubQuerySQLSyntaxProvider
    Definition Classes
    SQLSyntaxSupportFeature
  34. type SyntaxProvider[A] = QuerySQLSyntaxProvider[SQLSyntaxSupport[A], A]
    Definition Classes
    SQLSyntaxSupportFeature
  35. case class TableAsAliasSQLSyntax extends (SQLSyntaxSupportFeature.this)#SQLSyntax with Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  36. case class TableDefSQLSyntax extends (SQLSyntaxSupportFeature.this)#SQLSyntax with Product with Serializable
    Definition Classes
    SQLSyntaxSupportFeature
  37. trait UnionQuerySQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  38. trait UpdateOperation extends AnyRef
    Definition Classes
    QueryDSLFeature
  39. case class UpdateSQLBuilder extends (QueryDSLFeature.this)#SQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with (QueryDSLFeature.this)#WhereSQLBuilder[(QueryDSLFeature.this)#UpdateOperation] with Product with Serializable
    Definition Classes
    QueryDSLFeature
  40. trait WhereSQLBuilder[A] extends (QueryDSLFeature.this)#SQLBuilder[A]
    Definition Classes
    QueryDSLFeature
  41. type LocalTimeConverter = scalikejdbc.jodatime.LocalTimeConverter
    Annotations
    @deprecated
    Deprecated

    (Since version 3.0.0) Use scalikejdbc.jodatime.LocalTimeConverter instead

Value Members

  1. val SQLSyntax: scalikejdbc.interpolation.SQLSyntax.type
    Definition Classes
    SQLInterpolationCoreTypeAlias
  2. implicit def convertBigDecimal(bd: BigDecimal): ScalaBigDecimalConverter
    Definition Classes
    ScalaBigDecimalConverterImplicits
  3. implicit def convertJavaSqlDateToConverter(t: Date): UnixTimeInMillisConverter
    Definition Classes
    UnixTimeInMillisConverterImplicits
  4. implicit def convertJavaSqlTimeToConverter(t: Time): UnixTimeInMillisConverter
    Definition Classes
    UnixTimeInMillisConverterImplicits
  5. implicit def convertJavaSqlTimestampToConverter(t: Timestamp): UnixTimeInMillisConverter
    Definition Classes
    UnixTimeInMillisConverterImplicits
  6. implicit def convertJavaUtilDateToConverter(t: Date): UnixTimeInMillisConverter
    Definition Classes
    UnixTimeInMillisConverterImplicits
  7. implicit def convertLocalTimeToConverter(t: LocalTime): scalikejdbc.jodatime.LocalTimeConverter
    Definition Classes
    UnixTimeInMillisConverterImplicits
  8. val delete: scalikejdbc.QueryDSLFeature.QueryDSL.delete.type
    Definition Classes
    QueryDSLFeature
  9. val deleteFrom: scalikejdbc.QueryDSLFeature.QueryDSL.deleteFrom.type
    Definition Classes
    QueryDSLFeature
  10. val insert: scalikejdbc.QueryDSLFeature.QueryDSL.insert.type
    Definition Classes
    QueryDSLFeature
  11. val insertInto: scalikejdbc.QueryDSLFeature.QueryDSL.insertInto.type
    Definition Classes
    QueryDSLFeature
  12. def opt[A](v: Any): Option[A]

    Option value converter.

    Option value converter.

    A

    raw type

    v

    nullable raw value

    returns

    optional value

  13. implicit def scalikejdbcSQLInterpolationImplicitDef(s: StringContext): SQLInterpolationString
    Definition Classes
    Implicits
    Annotations
    @inline()
  14. implicit def scalikejdbcSQLSyntaxToStringImplicitDef(syntax: scalikejdbc.interpolation.SQLSyntax): String
    Definition Classes
    Implicits
    Annotations
    @inline()
  15. val select: scalikejdbc.QueryDSLFeature.QueryDSL.select.type
    Definition Classes
    QueryDSLFeature
  16. val selectFrom: scalikejdbc.QueryDSLFeature.QueryDSL.selectFrom.type
    Definition Classes
    QueryDSLFeature
  17. val sqls: scalikejdbc.interpolation.SQLSyntax.type
    Definition Classes
    SQLInterpolationCoreTypeAlias
  18. val update: scalikejdbc.QueryDSLFeature.QueryDSL.update.type
    Definition Classes
    QueryDSLFeature
  19. def using[R <: Closable, A](resource: R)(f: (R) ⇒ A): A

Inherited from UnixTimeInMillisConverterImplicits

Inherited from ScalaBigDecimalConverterImplicits

Inherited from SQLInterpolation

Inherited from QueryDSLFeature

Inherited from SQLSyntaxSupportFeature

Inherited from SQLInterpolationFeature

Inherited from SQLInterpolationCoreTypeAlias

Inherited from Implicits

Inherited from AnyRef

Inherited from Any

Ungrouped