scalikejdbc
package scalikejdbc
- Alphabetic
- Public
- All
Type Members
-
case class
ActiveSession
(conn: Connection, connectionAttributes: DBConnectionAttributes, tx: Option[Tx] = None, isReadOnly: Boolean = false, settings: SettingsProvider = SettingsProvider.default) extends DBSession with Product with Serializable
Active session implementation of scalikejdbc.DBSession.
Active session implementation of scalikejdbc.DBSession.
This class provides readOnly/autoCommit/localTx/withinTx blocks and session objects.
import scalikejdbc._ val userIdList = DB autoCommit { session: DBSession => session.list("select * from user") { rs => rs.int("id") } }
- conn
connection
- tx
transaction
- isReadOnly
is read only
-
trait
AllOutputDecisionsUnsupported
[Z, E <: WithExtractor] extends SQL[Z, E]
All output decisions are unsupported by default.
All output decisions are unsupported by default.
- Z
return type
- E
extractor constraint
-
case class
AsIsParameterBinder
(value: Any) extends ParameterBinderWithValue with Product with Serializable
Type unsafe ParameterBinder which holds any value and binds it as-is to PreparedStatement.
-
class
AuthenticatedDataSourceConnectionPool
extends ConnectionPool
Connection Pool using external DataSource
Connection Pool using external DataSource
Note: Commons-DBCP doesn't support this API.
-
case class
AutoSession
(settings: SettingsProvider) extends DBSession with Product with Serializable
Represents that already existing session will be used or a new session will be started.
-
trait
Binders
[A] extends TypeBinder[A] with ParameterBinderFactory[A]
Provides both of TypeBinder and ParameterBinderFactory for the specified type A.
-
class
BoneCPConnectionPool
extends ConnectionPool
BoneCP Connection Pool
BoneCP Connection Pool
- See also
-
class
Commons2ConnectionPool
extends ConnectionPool
Commons DBCP Connection Pool
Commons DBCP Connection Pool
- See also
-
class
CommonsConnectionPool
extends ConnectionPool
Commons DBCP Connection Pool
Commons DBCP Connection Pool
- See also
-
abstract
class
ConnectionPool
extends AnyRef
Connection Pool
-
trait
ConnectionPoolContext
extends AnyRef
Connection pool context
-
trait
ConnectionPoolFactory
extends AnyRef
Connection Pool Factory
-
case class
ConnectionPoolSettings
(initialSize: Int = 0, maxSize: Int = 8, connectionTimeoutMillis: Long = 5000L, validationQuery: String = null, connectionPoolFactoryName: String = null, driverName: String = null, warmUpTime: Long = 100L, timeZone: String = null) extends Product with Serializable
Settings for ConnectionPool
-
case class
DB
(conn: Connection, connectionAttributes: DBConnectionAttributes = DBConnectionAttributes(), settingsProvider: SettingsProvider = SettingsProvider.default) extends DBConnection with Product with Serializable
Basic Database Accessor
Basic Database Accessor
Using DBSession:
import scalikejdbc._ case class User(id: Int, name: String) using(ConnectionPool(name).borrow()) { conn => val users = DB(conn) readOnly { session => session.list("select * from user") { rs => User(rs.int("id"), rs.string("name")) } } DB(conn) autoCommit { session => session.update("insert into user values (?,?)", 123, "Alice") } DB(conn) localTx { session => session.update("insert into user values (?,?)", 123, "Alice") } }
Using SQL:
import scalikejdbc._ case class User(id: Int, name: String) using(ConnectionPool.borrow()) { conn => val users = DB(conn) readOnly { implicit session => SQL("select * from user").map { rs => User(rs.int("id"), rs.string("name")) }.list.apply() } DB(conn) autoCommit { implicit session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } DB(conn) localTx { implicit session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } }
-
trait
DBConnection
extends LogSupport with LoanPattern
Basic Database Accessor which holds a JDBC connection.
-
case class
DBConnectionAttributes
(driverName: Option[String] = None, timeZoneSettings: TimeZoneSettings = TimeZoneSettings()) extends Product with Serializable
Additional attributes for current JDBC connection.
-
trait
DBSession
extends LogSupport with LoanPattern
DB Session
DB Session
This class provides readOnly/autoCommit/localTx/withinTx blocks and session objects.
import scalikejdbc._ val userIdList = DB autoCommit { session: DBSession => session.list("select * from user") { rs => rs.int("id") } }
-
class
DataSourceConnectionPool
extends ConnectionPool
Connection Pool using external DataSource
-
case class
DataSourceConnectionPoolSettings
(driverName: String = null) extends Product with Serializable
Settings for DataSourceConnectionPool
-
trait
EntityEquality
extends AnyRef
Entity identifier provider for equality (especially for scalikejdbc.RelationalSQL operation).
Entity identifier provider for equality (especially for scalikejdbc.RelationalSQL operation).
Notice: Inheritance is not supported.
class Person(val id: Long) extends EntityEquality { override val entityIdentity = id } class Member(override val id: Long) extends Person(id) val p1 = new Person(123) val p2 = new Person(123) val m1 = new Member(123) val m2 = new Member(123) p1 == p2 && p2 == p1 // true p1 == m1 || m1 == p1 // false m1 == m2 && m2 == m1 // true
Example: -
trait
HasExtractor
extends WithExtractor
Represents that this SQL already has an extractor
-
case class
IllegalRelationshipException
(message: String) extends IllegalStateException with Product with Serializable
Exception which represents that an illegal relationship is found.
-
case class
InvalidColumnNameException
(name: String) extends Exception with Product with Serializable
Exception which represents invalid key is specified.
-
case class
JDBCSettings
(url: String, user: String, password: String, driverName: String) extends Product with Serializable
JDBC Settings
-
case class
JDBCUrl
(host: String, port: Int, database: String) extends Product with Serializable
JDBC URL which contains host, port and database name
-
case class
LikeConditionEscapeUtil
(escapeChar: String) extends Product with Serializable
Utility to escape like condition special characters.
-
trait
LoanPattern
extends AnyRef
Loan pattern implementation
-
final
class
LocalTimeConverter
extends AnyVal
org.joda.time.LocalTime converter.
-
case class
LoggingSQLAndTimeSettings
(enabled: Boolean = true, singleLineMode: Boolean = false, printUnprocessedStackTrace: Boolean = false, stackTraceDepth: Int = 15, logLevel: Symbol = 'debug, warningEnabled: Boolean = false, warningThresholdMillis: Long = 3000L, warningLogLevel: Symbol = 'warn, maxColumnSize: Option[Int] = Some(100), maxBatchParamSize: Option[Int] = Some(20)) extends Product with Serializable
Settings for logging SQL and timing
- trait LowPriorityImplicitsParameterBinderFactory0 extends AnyRef
- trait LowPriorityImplicitsParameterBinderFactory1 extends LowPriorityImplicitsParameterBinderFactory0
- trait LowPriorityTypeBinderImplicits extends AnyRef
-
case class
MultipleConnectionPoolContext
(contexts: (Any, ConnectionPool)*) extends ConnectionPoolContext with Product with Serializable
Multiple connection pool context
-
case class
NameBindingSQLValidatorSettings
(ignoredParams: IgnoredParamsValidation = ExceptionForIgnoredParams) extends Product with Serializable
Settings for Name binding SQL validator
-
case class
NamedAutoSession
(name: Any, settings: SettingsProvider = SettingsProvider.default) extends DBSession with Product with Serializable
Represents that already existing session will be used or a new session which is retrieved from named connection pool will be started.
-
case class
NamedDB
(name: Any, settingsProvider: SettingsProvider = SettingsProvider.default)(implicit context: ConnectionPoolContext = NoConnectionPoolContext) extends DBConnection with Product with Serializable
Named Basic DB Accessor
Named Basic DB Accessor
It's easier to use named ConnectionPool with this class.
ConnectionPool.add('named, "jdbc:...", "user", "password") val users = NamedDB('named) readOnly { session => session.list("select * from user") }
-
trait
NoExtractor
extends WithExtractor
Represents that this SQL doesn't have an extractor yet
- class OneToManies10SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies10SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies10Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E, Z]
- class OneToManies10SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies10Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E, Z]
- class OneToManies10SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies10Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E, Z]
- class OneToManies10SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies10Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E, Z]
- class OneToManies11SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies11SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies11Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E, Z]
- class OneToManies11SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies11Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E, Z]
- class OneToManies11SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies11Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E, Z]
- class OneToManies11SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies11Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E, Z]
- class OneToManies12SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies12SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies12Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E, Z]
- class OneToManies12SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies12Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E, Z]
- class OneToManies12SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies12Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E, Z]
- class OneToManies12SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies12Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E, Z]
- class OneToManies13SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies13SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies13Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E, Z]
- class OneToManies13SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies13Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E, Z]
- class OneToManies13SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies13Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E, Z]
- class OneToManies13SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies13Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E, Z]
- class OneToManies14SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies14SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies14Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E, Z]
- class OneToManies14SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies14Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E, Z]
- class OneToManies14SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies14Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E, Z]
- class OneToManies14SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies14Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E, Z]
- class OneToManies15SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies15SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies15Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E, Z]
- class OneToManies15SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies15Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E, Z]
- class OneToManies15SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies15Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E, Z]
- class OneToManies15SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies15Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E, Z]
- class OneToManies16SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies16SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies16Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E, Z]
- class OneToManies16SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies16Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E, Z]
- class OneToManies16SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies16Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E, Z]
- class OneToManies16SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies16Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, E, Z]
- class OneToManies17SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies17SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies17Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E, Z]
- class OneToManies17SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies17Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E, Z]
- class OneToManies17SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies17Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E, Z]
- class OneToManies17SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies17Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, E, Z]
- class OneToManies18SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies18SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies18Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E, Z]
- class OneToManies18SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies18Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E, Z]
- class OneToManies18SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies18Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E, Z]
- class OneToManies18SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies18Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, E, Z]
- class OneToManies19SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies19SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies19Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E, Z]
- class OneToManies19SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies19Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E, Z]
- class OneToManies19SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies19Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E, Z]
- class OneToManies19SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies19Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, E, Z]
- class OneToManies20SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies20SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies20Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E, Z]
- class OneToManies20SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies20Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E, Z]
- class OneToManies20SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies20Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E, Z]
- class OneToManies20SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies20Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, E, Z]
- class OneToManies21SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies21SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies21Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E, Z]
- class OneToManies21SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies21Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E, Z]
- class OneToManies21SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies21Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E, Z]
- class OneToManies21SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies21Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, E, Z]
- class OneToManies2SQL [A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies2SQLToCollection [A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with OneToManies2Extractor[A, B1, B2, E, Z]
- class OneToManies2SQLToList [A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with OneToManies2Extractor[A, B1, B2, E, Z]
- class OneToManies2SQLToOption [A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies2Extractor[A, B1, B2, E, Z]
- class OneToManies2SQLToTraversable [A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies2Extractor[A, B1, B2, E, Z]
- class OneToManies3SQL [A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies3SQLToCollection [A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies3Extractor[A, B1, B2, B3, E, Z]
- class OneToManies3SQLToList [A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies3Extractor[A, B1, B2, B3, E, Z]
- class OneToManies3SQLToOption [A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies3Extractor[A, B1, B2, B3, E, Z]
- class OneToManies3SQLToTraversable [A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies3Extractor[A, B1, B2, B3, E, Z]
- class OneToManies4SQL [A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies4SQLToCollection [A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies4Extractor[A, B1, B2, B3, B4, E, Z]
- class OneToManies4SQLToList [A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies4Extractor[A, B1, B2, B3, B4, E, Z]
- class OneToManies4SQLToOption [A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies4Extractor[A, B1, B2, B3, B4, E, Z]
- class OneToManies4SQLToTraversable [A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies4Extractor[A, B1, B2, B3, B4, E, Z]
- class OneToManies5SQL [A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies5SQLToCollection [A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies5Extractor[A, B1, B2, B3, B4, B5, E, Z]
- class OneToManies5SQLToList [A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies5Extractor[A, B1, B2, B3, B4, B5, E, Z]
- class OneToManies5SQLToOption [A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies5Extractor[A, B1, B2, B3, B4, B5, E, Z]
- class OneToManies5SQLToTraversable [A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies5Extractor[A, B1, B2, B3, B4, B5, E, Z]
- class OneToManies6SQL [A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies6SQLToCollection [A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies6Extractor[A, B1, B2, B3, B4, B5, B6, E, Z]
- class OneToManies6SQLToList [A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies6Extractor[A, B1, B2, B3, B4, B5, B6, E, Z]
- class OneToManies6SQLToOption [A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies6Extractor[A, B1, B2, B3, B4, B5, B6, E, Z]
- class OneToManies6SQLToTraversable [A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies6Extractor[A, B1, B2, B3, B4, B5, B6, E, Z]
- class OneToManies7SQL [A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies7SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies7Extractor[A, B1, B2, B3, B4, B5, B6, B7, E, Z]
- class OneToManies7SQLToList [A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies7Extractor[A, B1, B2, B3, B4, B5, B6, B7, E, Z]
- class OneToManies7SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies7Extractor[A, B1, B2, B3, B4, B5, B6, B7, E, Z]
- class OneToManies7SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies7Extractor[A, B1, B2, B3, B4, B5, B6, B7, E, Z]
- class OneToManies8SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies8SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies8Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, E, Z]
- class OneToManies8SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies8Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, E, Z]
- class OneToManies8SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies8Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, E, Z]
- class OneToManies8SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies8Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, E, Z]
- class OneToManies9SQL [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- final class OneToManies9SQLToCollection [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies9Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E, Z]
- class OneToManies9SQLToList [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies9Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E, Z]
- class OneToManies9SQLToOption [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies9Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E, Z]
- class OneToManies9SQLToTraversable [A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManies9Extractor[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E, Z]
- class OneToManySQL [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- class OneToManySQLToCollection [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManyExtractor[A, B, E, Z]
- class OneToManySQLToList [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManyExtractor[A, B, E, Z]
- class OneToManySQLToOption [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManyExtractor[A, B, E, Z]
- class OneToManySQLToTraversable [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToManyExtractor[A, B, E, Z]
- class OneToOneSQL [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
- class OneToOneSQLToCollection [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToOneExtractor[A, B, E, Z]
- class OneToOneSQLToList [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToOneExtractor[A, B, E, Z]
- class OneToOneSQLToOption [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToOption[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToOneExtractor[A, B, E, Z]
- class OneToOneSQLToTraversable [A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToTraversable[Z, E] with AllOutputDecisionsUnsupported[Z, E] with OneToOneExtractor[A, B, E, Z]
-
class
OneToXSQL
[A, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
Endpoint of one-to-x APIs
-
trait
ParameterBinder
extends AnyRef
Enables customizing StatementExecutor#bindParams behavior.
Enables customizing StatementExecutor#bindParams behavior.
val bytes = Array[Byte](1,2,3, ...) val in = ByteArrayInputStream(bytes) val bin = ParameterBinder( value = in, binder = (stmt, idx) => stmt.setBinaryStream(idx, in, bytes.length) ) sql"insert into table (bin) values (${bin})".update.apply()
-
trait
ParameterBinderFactory
[A] extends AnyRef
- Annotations
- @implicitNotFound( ... )
-
trait
ParameterBinderWithValue
extends ParameterBinder
ParameterBinder which holds a value to bind.
-
case class
ReadOnlyNamedAutoSession
(name: Any, settings: SettingsProvider = SettingsProvider.default) extends DBSession with Product with Serializable
Represents that already existing session will be used or a new read-only session which is retrieved from named connection pool will be started.
-
class
ResultSetCursor
extends AnyRef
java.sql.ResultSet cursor
-
case class
ResultSetExtractorException
(message: String, e: Option[Exception] = None) extends IllegalArgumentException with Product with Serializable
Exception which represents failure on ResultSet extraction.
-
class
ResultSetTraversable
extends Traversable[WrappedResultSet] with LoanPattern
scala.collection.Traversable object which wraps java.sql.ResultSet.
-
abstract
class
SQL
[A, E <: WithExtractor] extends Extractor[A]
SQL abstraction.
SQL abstraction.
- A
return type
-
class
SQLBatch
extends AnyRef
SQL which execute java.sql.Statement#executeBatch().
- class SQLBatchWithGeneratedKey extends AnyRef
-
class
SQLExecution
extends AnyRef
SQL which execute java.sql.Statement#execute().
-
trait
SQLFormatter
extends AnyRef
SQL formatter
-
case class
SQLFormatterSettings
(formatterClassName: Option[String]) extends LogSupport with Product with Serializable
Settings for SQL formatter
-
final
class
SQLInterpolationString
extends AnyVal
SQLInterpolation definition
-
trait
SQLToCollection
[A, E <: WithExtractor] extends SQL[A, E] with Extractor[A]
SQL to Collection
SQL to Collection
- A
return type
- E
extractor settings
- class SQLToCollectionImpl [A, E <: WithExtractor] extends SQL[A, E] with SQLToCollection[A, E]
-
trait
SQLToList
[A, E <: WithExtractor] extends SQL[A, E] with SQLToResult[A, E, List]
SQL to List
SQL to List
- A
return type
- E
extractor settings
-
class
SQLToListImpl
[A, E <: WithExtractor] extends SQL[A, E] with SQLToList[A, E]
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.immutable.List value.
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.immutable.List value.
- A
return type
-
trait
SQLToOption
[A, E <: WithExtractor] extends SQL[A, E] with SQLToResult[A, E, Option]
SQL to Option
SQL to Option
- A
return type
- E
extractor settings
-
class
SQLToOptionImpl
[A, E <: WithExtractor] extends SQL[A, E] with SQLToOption[A, E]
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.Option value.
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.Option value.
- A
return type
- trait SQLToResult [A, E <: WithExtractor, C[_]] extends SQL[A, E] with Extractor[A]
-
trait
SQLToTraversable
[A, E <: WithExtractor] extends SQL[A, E] with SQLToResult[A, E, Traversable]
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Traversable value.
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Traversable value.
- A
return type
-
class
SQLToTraversableImpl
[A, E <: WithExtractor] extends SQL[A, E] with SQLToTraversable[A, E]
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Traversable value.
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Traversable value.
- A
return type
-
class
SQLUpdate
extends AnyRef
SQL which execute java.sql.Statement#executeUpdate().
-
class
SQLUpdateWithGeneratedKey
extends AnyRef
SQL which execute java.sql.Statement#executeUpdate() and get generated key value.
-
final
class
ScalaBigDecimalConverter
extends AnyVal
BigDecimal converter.
-
trait
ScalaBigDecimalConverterImplicits
extends AnyRef
Implicit conversions for BigDecimal values.
-
final
class
SettingsProvider
extends AnyRef
- Note
does not use case class for binary-compatibility keepability
-
case class
StatementExecutor
(underlying: PreparedStatement, template: String, connectionAttributes: DBConnectionAttributes, singleParams: Seq[Any] = Nil, tags: Seq[String] = Nil, isBatch: Boolean = false, settingsProvider: SettingsProvider = SettingsProvider.default) extends LogSupport with UnixTimeInMillisConverterImplicits with Product with Serializable
java.sql.Statement Executor.
java.sql.Statement Executor.
- underlying
preparedStatement
- template
SQL template
- singleParams
parameters for single execution (= not batch execution)
- isBatch
is batch flag
-
case class
StringSQLRunner
(sql: String) extends LogSupport with Product with Serializable
String SQL Runner
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
-
class
TimeZoneConverter
extends AnyRef
TimeZone converter for SQL Timestamp
-
case class
TimeZoneSettings
(conversionEnabled: Boolean = false, serverTimeZone: TimeZone = TimeZone.getDefault) extends Product with Serializable
Settings for timezone conversion
-
case class
TooManyRowsException
(expected: Int, actual: Int) extends Exception with Product with Serializable
Exception which represents too many rows returned.
-
class
Tx
extends AnyRef
DB Transaction abstraction.
-
trait
TxBoundary
[A] extends AnyRef
This type class enable users to customize the behavior of transaction boundary(commit/rollback).
-
trait
TypeBinder
[+A] extends AnyRef
Type binder for java.sql.ResultSet.
- class UnexpectedNullValueException extends Exception
-
final
class
UnixTimeInMillisConverter
extends AnyVal
Unix Time Converter to several types.
-
trait
UnixTimeInMillisConverterImplicits
extends AnyRef
Implicit conversions for date time values.
-
sealed
trait
WithExtractor
extends AnyRef
Represents an extractor is already specified or not
-
case class
WrappedResultSet
(underlying: ResultSet, cursor: ResultSetCursor, index: Int) extends Product with Serializable
java.sql.ResultSet wrapper.
Value Members
- object AutoSession extends AutoSession
-
object
Binders
Provides factories of Binders and built-in Binders.
-
object
BoneCPConnectionPoolFactory
extends ConnectionPoolFactory
Connection Pool Factory
Connection Pool Factory
- See also
-
object
Commons2ConnectionPoolFactory
extends ConnectionPoolFactory
Connection Pool Factory
Connection Pool Factory
- See also
-
object
CommonsConnectionPoolFactory
extends ConnectionPoolFactory
Connection Pool Factory
Connection Pool Factory
- See also
-
object
ConnectionPool
extends LogSupport
Connection Pool
Connection Pool
The default implementation uses Commons DBCP 2 internally.
-
object
ConnectionPoolFactoryRepository
ConnectionPoolFactoryRepository
-
object
DB
extends LoanPattern with Serializable
Basic Database Accessor
Basic Database Accessor
You can start with DB and blocks if using scalikejdbc.ConnectionPool.singleton().
Using DBSession:
ConnectionPool.singleton("jdbc:...","user","password") case class User(id: Int, name: String) val users = DB readOnly { session => session.list("select * from user") { rs => User(rs.int("id"), rs.string("name")) } } DB autoCommit { session => session.update("insert into user values (?,?)", 123, "Alice") } DB localTx { session => session.update("insert into user values (?,?)", 123, "Alice") } using(DB(ConnectionPool.borrow())) { db => db.begin() try { DB withTx { session => session.update("update user set name = ? where id = ?", "Alice", 123) } db.commit() } catch { case e => db.rollbackIfActive() throw e } }
Using SQL:
ConnectionPool.singleton("jdbc:...","user","password") case class User(id: Int, name: String) val users = DB readOnly { implicit session => SQL("select * from user").map { rs => User(rs.int("id"), rs.string("name")) }.list.apply() } DB autoCommit { implicit session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } DB localTx { implicit session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } using(DB(ConnectionPool.borrow())) { db => db.begin() try { DB withTx { implicit session => SQL("update user set name = ? where id = ?").bind("Alice", 123).update.apply() } db.commit() } catch { case e => db.rollbackIfActive() throw e } }
- object DBSession
-
object
GeneralizedTypeConstraintsForWithExtractor
Generalized type constraints for WithExtractor
-
object
GlobalSettings
GlobalSettings for this library
-
object
JDBCUrl
extends Serializable
Companion object of JDBC URL
- object LikeConditionEscapeUtil extends LikeConditionEscapeUtil
- object LoanPattern extends LoanPattern
-
object
NoConnectionPoolContext
extends ConnectionPoolContext
No Connection Pool Context
-
object
NoSession
extends DBSession with Product with Serializable
Represents that there is no active session.
- object OneToManies10SQL
- object OneToManies10SQLToCollection
- object OneToManies10SQLToList
- object OneToManies10SQLToOption
- object OneToManies10SQLToTraversable
- object OneToManies11SQL
- object OneToManies11SQLToCollection
- object OneToManies11SQLToList
- object OneToManies11SQLToOption
- object OneToManies11SQLToTraversable
- object OneToManies12SQL
- object OneToManies12SQLToCollection
- object OneToManies12SQLToList
- object OneToManies12SQLToOption
- object OneToManies12SQLToTraversable
- object OneToManies13SQL
- object OneToManies13SQLToCollection
- object OneToManies13SQLToList
- object OneToManies13SQLToOption
- object OneToManies13SQLToTraversable
- object OneToManies14SQL
- object OneToManies14SQLToCollection
- object OneToManies14SQLToList
- object OneToManies14SQLToOption
- object OneToManies14SQLToTraversable
- object OneToManies15SQL
- object OneToManies15SQLToCollection
- object OneToManies15SQLToList
- object OneToManies15SQLToOption
- object OneToManies15SQLToTraversable
- object OneToManies16SQL
- object OneToManies16SQLToCollection
- object OneToManies16SQLToList
- object OneToManies16SQLToOption
- object OneToManies16SQLToTraversable
- object OneToManies17SQL
- object OneToManies17SQLToCollection
- object OneToManies17SQLToList
- object OneToManies17SQLToOption
- object OneToManies17SQLToTraversable
- object OneToManies18SQL
- object OneToManies18SQLToCollection
- object OneToManies18SQLToList
- object OneToManies18SQLToOption
- object OneToManies18SQLToTraversable
- object OneToManies19SQL
- object OneToManies19SQLToCollection
- object OneToManies19SQLToList
- object OneToManies19SQLToOption
- object OneToManies19SQLToTraversable
- object OneToManies20SQL
- object OneToManies20SQLToCollection
- object OneToManies20SQLToList
- object OneToManies20SQLToOption
- object OneToManies20SQLToTraversable
- object OneToManies21SQL
- object OneToManies21SQLToCollection
- object OneToManies21SQLToList
- object OneToManies21SQLToOption
- object OneToManies21SQLToTraversable
- object OneToManies2SQL
- object OneToManies2SQLToCollection
- object OneToManies2SQLToList
- object OneToManies2SQLToOption
- object OneToManies2SQLToTraversable
- object OneToManies3SQL
- object OneToManies3SQLToCollection
- object OneToManies3SQLToList
- object OneToManies3SQLToOption
- object OneToManies3SQLToTraversable
- object OneToManies4SQL
- object OneToManies4SQLToCollection
- object OneToManies4SQLToList
- object OneToManies4SQLToOption
- object OneToManies4SQLToTraversable
- object OneToManies5SQL
- object OneToManies5SQLToCollection
- object OneToManies5SQLToList
- object OneToManies5SQLToOption
- object OneToManies5SQLToTraversable
- object OneToManies6SQL
- object OneToManies6SQLToCollection
- object OneToManies6SQLToList
- object OneToManies6SQLToOption
- object OneToManies6SQLToTraversable
- object OneToManies7SQL
- object OneToManies7SQLToCollection
- object OneToManies7SQLToList
- object OneToManies7SQLToOption
- object OneToManies7SQLToTraversable
- object OneToManies8SQL
- object OneToManies8SQLToCollection
- object OneToManies8SQLToList
- object OneToManies8SQLToOption
- object OneToManies8SQLToTraversable
- object OneToManies9SQL
- object OneToManies9SQLToCollection
- object OneToManies9SQLToList
- object OneToManies9SQLToOption
- object OneToManies9SQLToTraversable
- object OneToManySQL
- object OneToManySQLToCollection
- object OneToManySQLToList
- object OneToManySQLToOption
- object OneToManySQLToTraversable
- object OneToOneSQL
- object OneToOneSQLToCollection
- object OneToOneSQLToList
- object OneToOneSQLToOption
- object OneToOneSQLToTraversable
- object OneToXSQL
-
object
ParameterBinder
ParameterBinder factory.
- object ParameterBinderFactory extends LowPriorityImplicitsParameterBinderFactory1
-
object
ReadOnlyAutoSession
extends DBSession with Product with Serializable
Represents that already existing session will be used or a new read-only session will be started.
-
object
SQL
SQL abstraction's companion object
SQL abstraction's companion object
ConnectionPool.singleton("jdbc:...","user","password") case class User(id: Int, name: String) val users = DB.readOnly { implicit session => SQL("select * from user").map { rs => User(rs.int("id"), rs.string("name")) }.list.apply() } DB .autoCommit { implicit session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } DB localTx { implicit session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } using(DB(ConnectionPool.borrow())) { db => db.begin() try { DB withTx { implicit session => SQL("update user set name = ? where id = ?").bind("Alice", 123).update.apply() } db.commit() } catch { case e => db.rollbackIfActive() throw e } }
- object SQLBatch
- object SQLBatchWithGeneratedKey
- object SQLExecution
- object SQLFormatterSettings extends Serializable
-
object
SQLTemplateParser
extends JavaTokenParsers with LogSupport
SQL Template Parser.
SQL Template Parser.
This parser supports following templates.
Basic SQL Template:
select * from user where id = ? and user_name = ?
Anorm-like SQL Template:
select * from user where id = {id} and user_name = {userName}
Executable SQL Template:
select * from user where id = /*'id*/123 and user_name = /*'userName*/\'Alice'
ExecutableSQL
is the template which contains parameter names just as comments with dummy values without specific syntax. The template is a valid SQL, so you can check it is correct before building into app. - object SQLToCollectionImpl
- object SQLToListImpl
- object SQLToOptionImpl
- object SQLToTraversableImpl
- object SQLUpdate
- object SQLUpdateWithGeneratedKey
-
object
ScalikejdbcBuildInfo
extends Product with Serializable
This object was generated by sbt-buildinfo.
- object SettingsProvider
-
object
StatementExecutor
extends Serializable
Companion object.
- object StringSQLRunner extends Serializable
-
object
ThreadLocalDB
Thread-local DB.
- object TimeZoneConverter
-
object
TxBoundary
TxBoundary type class instances.
-
object
TypeBinder
extends LowPriorityTypeBinderImplicits with UnixTimeInMillisConverterImplicits
Type binder for java.sql.ResultSet.
- object UnixTimeInMillisConverterImplicits extends UnixTimeInMillisConverterImplicits