scalikejdbc
package scalikejdbc
- Alphabetic
- Public
- Protected
Package Members
- package globalsettings
- package interpolation
- package metadata
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
- class CommonsConnectionPool extends ConnectionPool
Commons DBCP Connection Pool
Commons DBCP Connection Pool
- abstract class ConnectionPool extends AutoCloseable
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 with AutoCloseable
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 with AutoCloseable
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") } }
- trait DataSourceCloser extends AutoCloseable
Resource manager which closes a DataSource.
- 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.
- sealed trait IsolationLevel extends AnyRef
- 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
- final class JavaUtilDateConverter extends AnyVal
java.util.Date
Converter to several types. - trait JavaUtilDateConverterImplicits extends AnyRef
Implicit conversions for date time values.
- case class LikeConditionEscapeUtil(escapeChar: String) extends Product with Serializable
Utility to escape like condition special characters.
- trait LoanPattern extends AnyRef
Loan pattern implementation
- case class LoggingSQLAndTimeSettings(enabled: Boolean = true, singleLineMode: Boolean = false, printUnprocessedStackTrace: Boolean = false, stackTraceDepth: Int = 15, logLevel: String = "debug", warningEnabled: Boolean = false, warningThresholdMillis: Long = 3000L, warningLogLevel: String = "warn", maxColumnSize: Option[Int] = Some(100), maxBatchParamSize: Option[Int] = Some(20)) extends Product with Serializable
Settings for logging SQL and timing
- sealed abstract class LowPriorityImplicitsParameterBinderFactory1 extends AnyRef
- sealed abstract class 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") }
Please note that a single NamedDB instance should be used only once, as the connection is closed after being used. To re-use an instance, use the .setAutoClose(false) method.
- 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 OneToManies10SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies11SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies12SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies13SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies14SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies15SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies16SQLToIterable[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 SQLToIterable[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 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 OneToManies17SQLToIterable[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 SQLToIterable[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 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 OneToManies18SQLToIterable[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 SQLToIterable[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 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 OneToManies19SQLToIterable[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 SQLToIterable[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 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 OneToManies20SQLToIterable[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 SQLToIterable[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 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 OneToManies21SQLToIterable[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 SQLToIterable[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 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 OneToManies2SQLToIterable[A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[Z, E] with AllOutputDecisionsUnsupported[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 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 OneToManies3SQLToIterable[A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies4SQLToIterable[A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies5SQLToIterable[A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies6SQLToIterable[A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies7SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies8SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManies9SQLToIterable[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToManySQLToIterable[A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 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 OneToOneSQLToIterable[A, B, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToIterable[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 OneToXSQL[A, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
Endpoint of one-to-x APIs
- final case class OverwrittenZoneId(value: ZoneId) extends AnyVal with Product with Serializable
A hold of a specific ZoneId instance to be passed as an implicit parameter for TypeBinder.
- 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 ResultSetIterator extends Iterator[WrappedResultSet]
scala.collection.Iterator 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
- class SQLLargeBatch extends AnyRef
SQL which execute java.sql.Statement#executeLargeBatch().
- class SQLLargeUpdate extends AnyRef
SQL which execute java.sql.Statement#executeLargeUpdate().
- 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 SQLToIterable[A, E <: WithExtractor] extends SQL[A, E] with SQLToResult[A, E, Iterable]
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Iterable value.
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Iterable value.
- A
return type
- class SQLToIterableImpl[A, E <: WithExtractor] extends SQL[A, E] with SQLToIterable[A, E]
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Iterable value.
SQL which execute java.sql.Statement#executeQuery() and returns the result as scala.collection.Iterable value.
- A
return type
- 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]
- 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 AutoCloseable 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
- 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.
Deprecated Type Members
- trait UnixTimeInMillisConverterImplicits extends JavaUtilDateConverterImplicits
Implicit conversions for date time values.
Implicit conversions for date time values.
- Annotations
- @deprecated
- Deprecated
(Since version 3.4.0) use JavaUtilDateConverterImplicits
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
- object CommonsConnectionPoolFactory extends ConnectionPoolFactory
Connection Pool Factory
Connection Pool Factory
- 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 DBConnection
- object DBSession
- object DBSessionWrapper
- case object DefaultDataSourceCloser extends DataSourceCloser with Product with Serializable
Default DataSourceCloser.
- object GeneralizedTypeConstraintsForWithExtractor
Generalized type constraints for WithExtractor
- object GlobalSettings
GlobalSettings for this library
- object IsolationLevel
- object JDBCUrl extends Serializable
Companion object of JDBC URL
- object JavaUtilDateConverterImplicits extends JavaUtilDateConverterImplicits
- object LikeConditionEscapeUtil extends LikeConditionEscapeUtil
- object LoanPattern extends LoanPattern
- object NoConnectionPoolContext extends ConnectionPoolContext
No Connection Pool Context
- case object NoSession extends DBSession with Product with Serializable
Represents that there is no active session.
- object OneToManies10SQL
- object OneToManies10SQLToCollection
- object OneToManies10SQLToIterable
- object OneToManies10SQLToList
- object OneToManies10SQLToOption
- object OneToManies11SQL
- object OneToManies11SQLToCollection
- object OneToManies11SQLToIterable
- object OneToManies11SQLToList
- object OneToManies11SQLToOption
- object OneToManies12SQL
- object OneToManies12SQLToCollection
- object OneToManies12SQLToIterable
- object OneToManies12SQLToList
- object OneToManies12SQLToOption
- object OneToManies13SQL
- object OneToManies13SQLToCollection
- object OneToManies13SQLToIterable
- object OneToManies13SQLToList
- object OneToManies13SQLToOption
- object OneToManies14SQL
- object OneToManies14SQLToCollection
- object OneToManies14SQLToIterable
- object OneToManies14SQLToList
- object OneToManies14SQLToOption
- object OneToManies15SQL
- object OneToManies15SQLToCollection
- object OneToManies15SQLToIterable
- object OneToManies15SQLToList
- object OneToManies15SQLToOption
- object OneToManies16SQL
- object OneToManies16SQLToCollection
- object OneToManies16SQLToIterable
- object OneToManies16SQLToList
- object OneToManies16SQLToOption
- object OneToManies17SQL
- object OneToManies17SQLToCollection
- object OneToManies17SQLToIterable
- object OneToManies17SQLToList
- object OneToManies17SQLToOption
- object OneToManies18SQL
- object OneToManies18SQLToCollection
- object OneToManies18SQLToIterable
- object OneToManies18SQLToList
- object OneToManies18SQLToOption
- object OneToManies19SQL
- object OneToManies19SQLToCollection
- object OneToManies19SQLToIterable
- object OneToManies19SQLToList
- object OneToManies19SQLToOption
- object OneToManies20SQL
- object OneToManies20SQLToCollection
- object OneToManies20SQLToIterable
- object OneToManies20SQLToList
- object OneToManies20SQLToOption
- object OneToManies21SQL
- object OneToManies21SQLToCollection
- object OneToManies21SQLToIterable
- object OneToManies21SQLToList
- object OneToManies21SQLToOption
- object OneToManies2SQL
- object OneToManies2SQLToCollection
- object OneToManies2SQLToIterable
- object OneToManies2SQLToList
- object OneToManies2SQLToOption
- object OneToManies3SQL
- object OneToManies3SQLToCollection
- object OneToManies3SQLToIterable
- object OneToManies3SQLToList
- object OneToManies3SQLToOption
- object OneToManies4SQL
- object OneToManies4SQLToCollection
- object OneToManies4SQLToIterable
- object OneToManies4SQLToList
- object OneToManies4SQLToOption
- object OneToManies5SQL
- object OneToManies5SQLToCollection
- object OneToManies5SQLToIterable
- object OneToManies5SQLToList
- object OneToManies5SQLToOption
- object OneToManies6SQL
- object OneToManies6SQLToCollection
- object OneToManies6SQLToIterable
- object OneToManies6SQLToList
- object OneToManies6SQLToOption
- object OneToManies7SQL
- object OneToManies7SQLToCollection
- object OneToManies7SQLToIterable
- object OneToManies7SQLToList
- object OneToManies7SQLToOption
- object OneToManies8SQL
- object OneToManies8SQLToCollection
- object OneToManies8SQLToIterable
- object OneToManies8SQLToList
- object OneToManies8SQLToOption
- object OneToManies9SQL
- object OneToManies9SQLToCollection
- object OneToManies9SQLToIterable
- object OneToManies9SQLToList
- object OneToManies9SQLToOption
- object OneToManySQL
- object OneToManySQLToCollection
- object OneToManySQLToIterable
- object OneToManySQLToList
- object OneToManySQLToOption
- object OneToOneSQL
- object OneToOneSQLToCollection
- object OneToOneSQLToIterable
- object OneToOneSQLToList
- object OneToOneSQLToOption
- object OneToXSQL
- object ParameterBinder
ParameterBinder factory.
- object ParameterBinderFactory extends LowPriorityImplicitsParameterBinderFactory1
- case 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 SQLToIterableImpl
- object SQLToListImpl
- object SQLToOptionImpl
- object SQLUpdate
- object SQLUpdateWithGeneratedKey
- case 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
Type binder for java.sql.ResultSet.
Deprecated Value Members
- object UnixTimeInMillisConverterImplicits extends JavaUtilDateConverterImplicits
- Annotations
- @deprecated
- Deprecated
(Since version 3.4.0) use JavaUtilDateConverterImplicits