Packages

p

scalikejdbc

package scalikejdbc

Ordering
  1. Alphabetic
Visibility
  1. Public
  2. Protected

Package Members

  1. package globalsettings
  2. package interpolation
  3. package metadata

Type Members

  1. 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

  2. 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

  3. 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.

  4. class AuthenticatedDataSourceConnectionPool extends ConnectionPool

    Connection Pool using external DataSource

    Connection Pool using external DataSource

    Note: Commons-DBCP doesn't support this API.

  5. 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.

  6. trait Binders[A] extends TypeBinder[A] with ParameterBinderFactory[A]

    Provides both of TypeBinder and ParameterBinderFactory for the specified type A.

  7. class BoneCPConnectionPool extends ConnectionPool

    BoneCP Connection Pool

    BoneCP Connection Pool

    See also

    https://github.com/wwadge/bonecp

  8. class Commons2ConnectionPool extends ConnectionPool

    Commons DBCP Connection Pool

    Commons DBCP Connection Pool

    See also

    http://commons.apache.org/proper/commons-dbcp/

  9. class CommonsConnectionPool extends ConnectionPool

    Commons DBCP Connection Pool

    Commons DBCP Connection Pool

    See also

    http://commons.apache.org/proper/commons-dbcp/

  10. abstract class ConnectionPool extends AutoCloseable

    Connection Pool

  11. trait ConnectionPoolContext extends AnyRef

    Connection pool context

  12. trait ConnectionPoolFactory extends AnyRef

    Connection Pool Factory

  13. 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

  14. 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()
      }
    
    }
  15. trait DBConnection extends LogSupport with LoanPattern with AutoCloseable

    Basic Database Accessor which holds a JDBC connection.

  16. case class DBConnectionAttributes(driverName: Option[String] = None, timeZoneSettings: TimeZoneSettings = TimeZoneSettings()) extends Product with Serializable

    Additional attributes for current JDBC connection.

  17. 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") }
    }
  18. trait DataSourceCloser extends AutoCloseable

    Resource manager which closes a DataSource.

  19. class DataSourceConnectionPool extends ConnectionPool

    Connection Pool using external DataSource

  20. case class DataSourceConnectionPoolSettings(driverName: String = null) extends Product with Serializable

    Settings for DataSourceConnectionPool

  21. 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.

    Example:
    1. 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
  22. trait HasExtractor extends WithExtractor

    Represents that this SQL already has an extractor

  23. case class IllegalRelationshipException(message: String) extends IllegalStateException with Product with Serializable

    Exception which represents that an illegal relationship is found.

  24. case class InvalidColumnNameException(name: String) extends Exception with Product with Serializable

    Exception which represents invalid key is specified.

  25. sealed trait IsolationLevel extends AnyRef
  26. case class JDBCSettings(url: String, user: String, password: String, driverName: String) extends Product with Serializable

    JDBC Settings

  27. case class JDBCUrl(host: String, port: Int, database: String) extends Product with Serializable

    JDBC URL which contains host, port and database name

  28. final class JavaUtilDateConverter extends AnyVal

    java.util.Date Converter to several types.

  29. trait JavaUtilDateConverterImplicits extends AnyRef

    Implicit conversions for date time values.

  30. case class LikeConditionEscapeUtil(escapeChar: String) extends Product with Serializable

    Utility to escape like condition special characters.

  31. trait LoanPattern extends AnyRef

    Loan pattern implementation

  32. case class LoggingSQLAndTimeSettings(enabled: Boolean = true, singleLineMode: Boolean = false, printUnprocessedStackTrace: Boolean = false, stackTraceDepth: Int = 15, logLevel: Symbol = Symbol("debug"), warningEnabled: Boolean = false, warningThresholdMillis: Long = 3000L, warningLogLevel: Symbol = Symbol("warn"), maxColumnSize: Option[Int] = Some(100), maxBatchParamSize: Option[Int] = Some(20)) extends Product with Serializable

    Settings for logging SQL and timing

  33. sealed abstract class LowPriorityImplicitsParameterBinderFactory1 extends AnyRef
  34. sealed abstract class LowPriorityTypeBinderImplicits extends AnyRef
  35. case class MultipleConnectionPoolContext(contexts: (Any, ConnectionPool)*) extends ConnectionPoolContext with Product with Serializable

    Multiple connection pool context

  36. case class NameBindingSQLValidatorSettings(ignoredParams: IgnoredParamsValidation = ExceptionForIgnoredParams) extends Product with Serializable

    Settings for Name binding SQL validator

  37. 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.

  38. 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(Symbol("named"), "jdbc:...", "user", "password")
    val users = NamedDB(Symbol("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.

  39. trait NoExtractor extends WithExtractor

    Represents that this SQL doesn't have an extractor yet

  40. class OneToManies10SQL[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  41. 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]
  42. 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]
  43. 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]
  44. 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]
  45. 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]
  46. 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]
  47. 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]
  48. 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]
  49. 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]
  50. 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]
  51. 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]
  52. 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]
  53. 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]
  54. 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]
  55. 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]
  56. 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]
  57. 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]
  58. 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]
  59. 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]
  60. 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]
  61. 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]
  62. 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]
  63. 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]
  64. 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]
  65. 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]
  66. 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]
  67. 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]
  68. 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]
  69. 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]
  70. 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]
  71. 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]
  72. 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]
  73. 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]
  74. 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]
  75. 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]
  76. 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]
  77. 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]
  78. 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]
  79. 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]
  80. 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]
  81. 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]
  82. 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]
  83. 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]
  84. 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]
  85. 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]
  86. 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]
  87. 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]
  88. 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]
  89. 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]
  90. 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]
  91. 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]
  92. 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]
  93. 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]
  94. 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]
  95. 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]
  96. 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]
  97. 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]
  98. 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]
  99. 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]
  100. class OneToManies2SQL[A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  101. final class OneToManies2SQLToCollection[A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToCollection[Z, E] with OneToManies2Extractor[A, B1, B2, E, Z]
  102. 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]
  103. class OneToManies2SQLToList[A, B1, B2, E <: WithExtractor, Z] extends SQL[Z, E] with SQLToList[Z, E] with OneToManies2Extractor[A, B1, B2, E, Z]
  104. 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]
  105. class OneToManies3SQL[A, B1, B2, B3, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  106. 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]
  107. 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]
  108. 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]
  109. 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]
  110. class OneToManies4SQL[A, B1, B2, B3, B4, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  111. 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]
  112. 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]
  113. 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]
  114. 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]
  115. class OneToManies5SQL[A, B1, B2, B3, B4, B5, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  116. 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]
  117. 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]
  118. 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]
  119. 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]
  120. class OneToManies6SQL[A, B1, B2, B3, B4, B5, B6, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  121. 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]
  122. 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]
  123. 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]
  124. 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]
  125. class OneToManies7SQL[A, B1, B2, B3, B4, B5, B6, B7, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  126. 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]
  127. 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]
  128. 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]
  129. 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]
  130. class OneToManies8SQL[A, B1, B2, B3, B4, B5, B6, B7, B8, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  131. 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]
  132. 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]
  133. 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]
  134. 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]
  135. class OneToManies9SQL[A, B1, B2, B3, B4, B5, B6, B7, B8, B9, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  136. 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]
  137. 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]
  138. 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]
  139. 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]
  140. class OneToManySQL[A, B, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  141. 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]
  142. 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]
  143. 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]
  144. 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]
  145. class OneToOneSQL[A, B, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]
  146. 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]
  147. 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]
  148. 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]
  149. 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]
  150. class OneToXSQL[A, E <: WithExtractor, Z] extends SQL[Z, E] with AllOutputDecisionsUnsupported[Z, E]

    Endpoint of one-to-x APIs

  151. 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.

  152. 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()
  153. trait ParameterBinderFactory[A] extends AnyRef
    Annotations
    @implicitNotFound("""
    --------------------------------------------------------
    Implicit ParameterBinderFactory[${A}] for the parameter type ${A} is missing.
    You need to define ParameterBinderFactory for the type or use AsIsParameterBinder.

    (example1)
    implicit val intParameterBinderFactory: ParameterBinderFactory[Int] = ParameterBinderFactory {
    value => (stmt, idx) => stmt.setInt(idx, value)
    }

    (example2)
    case class Price(value: Int)
    object Price {
    implicit val converter: Binders[Price] = Binders.int.xmap(Price.apply, _.value)
    }

    (example3)
    val value: Any = 123
    val key: SQLSyntax = sqls"column_name"
    key -> AsIsParameterBinder(value)
    --------------------------------------------------------"""
    )
  154. trait ParameterBinderWithValue extends ParameterBinder

    ParameterBinder which holds a value to bind.

  155. 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.

  156. class ResultSetCursor extends AnyRef

    java.sql.ResultSet cursor

  157. case class ResultSetExtractorException(message: String, e: Option[Exception] = None) extends IllegalArgumentException with Product with Serializable

    Exception which represents failure on ResultSet extraction.

  158. class ResultSetIterator extends Iterator[WrappedResultSet]

    scala.collection.Iterator object which wraps java.sql.ResultSet.

  159. abstract class SQL[A, E <: WithExtractor] extends Extractor[A]

    SQL abstraction.

    SQL abstraction.

    A

    return type

  160. class SQLBatch extends AnyRef

    SQL which execute java.sql.Statement#executeBatch().

  161. class SQLBatchWithGeneratedKey extends AnyRef
  162. class SQLExecution extends AnyRef

    SQL which execute java.sql.Statement#execute().

  163. trait SQLFormatter extends AnyRef

    SQL formatter

  164. case class SQLFormatterSettings(formatterClassName: Option[String]) extends LogSupport with Product with Serializable

    Settings for SQL formatter

  165. final class SQLInterpolationString extends AnyVal

    SQLInterpolation definition

  166. class SQLLargeBatch extends AnyRef

    SQL which execute java.sql.Statement#executeLargeBatch().

  167. class SQLLargeUpdate extends AnyRef

    SQL which execute java.sql.Statement#executeLargeUpdate().

  168. trait SQLToCollection[A, E <: WithExtractor] extends SQL[A, E] with Extractor[A]

    SQL to Collection

    SQL to Collection

    A

    return type

    E

    extractor settings

  169. class SQLToCollectionImpl[A, E <: WithExtractor] extends SQL[A, E] with SQLToCollection[A, E]
  170. 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

  171. 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

  172. 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

  173. 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

  174. 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

  175. 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

  176. trait SQLToResult[A, E <: WithExtractor, C[_]] extends SQL[A, E] with Extractor[A]
  177. class SQLUpdate extends AnyRef

    SQL which execute java.sql.Statement#executeUpdate().

  178. class SQLUpdateWithGeneratedKey extends AnyRef

    SQL which execute java.sql.Statement#executeUpdate() and get generated key value.

  179. final class ScalaBigDecimalConverter extends AnyVal

    BigDecimal converter.

  180. trait ScalaBigDecimalConverterImplicits extends AnyRef

    Implicit conversions for BigDecimal values.

  181. final class SettingsProvider extends AnyRef

    Note

    does not use case class for binary-compatibility keepability

  182. 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

  183. 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

  184. class TimeZoneConverter extends AnyRef

    TimeZone converter for SQL Timestamp

  185. case class TimeZoneSettings(conversionEnabled: Boolean = false, serverTimeZone: TimeZone = TimeZone.getDefault) extends Product with Serializable

    Settings for timezone conversion

  186. case class TooManyRowsException(expected: Int, actual: Int) extends Exception with Product with Serializable

    Exception which represents too many rows returned.

  187. class Tx extends AnyRef

    DB Transaction abstraction.

  188. trait TxBoundary[A] extends AnyRef

    This type class enable users to customize the behavior of transaction boundary(commit/rollback).

  189. trait TypeBinder[+A] extends AnyRef

    Type binder for java.sql.ResultSet.

  190. class UnexpectedNullValueException extends Exception
  191. sealed trait WithExtractor extends AnyRef

    Represents an extractor is already specified or not

  192. case class WrappedResultSet(underlying: ResultSet, cursor: ResultSetCursor, index: Int) extends Product with Serializable

    java.sql.ResultSet wrapper.

Deprecated Type Members

  1. class ResultSetTraversable extends Traversable[WrappedResultSet] with LoanPattern

    scala.collection.Traversable object which wraps java.sql.ResultSet.

    scala.collection.Traversable object which wraps java.sql.ResultSet.

    Annotations
    @deprecated
    Deprecated

    (Since version 3.3.0) use ResultSetIterator instead

  2. 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

  1. object AutoSession extends AutoSession
  2. object Binders

    Provides factories of Binders and built-in Binders.

  3. object BoneCPConnectionPoolFactory extends ConnectionPoolFactory

    Connection Pool Factory

    Connection Pool Factory

    See also

    https://github.com/wwadge/bonecp

  4. object Commons2ConnectionPoolFactory extends ConnectionPoolFactory

    Connection Pool Factory

    Connection Pool Factory

    See also

    http://commons.apache.org/proper/commons-dbcp/

  5. object CommonsConnectionPoolFactory extends ConnectionPoolFactory

    Connection Pool Factory

    Connection Pool Factory

    See also

    http://commons.apache.org/proper/commons-dbcp/

  6. object ConnectionPool extends LogSupport

    Connection Pool

    Connection Pool

    The default implementation uses Commons DBCP 2 internally.

    See also

    https://commons.apache.org/proper/commons-dbcp/

  7. object ConnectionPoolFactoryRepository

    ConnectionPoolFactoryRepository

  8. 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
      }
    }
  9. object DBConnection
  10. object DBSession
  11. object DBSessionWrapper
  12. case object DefaultDataSourceCloser extends DataSourceCloser with Product with Serializable

    Default DataSourceCloser.

  13. object GeneralizedTypeConstraintsForWithExtractor

    Generalized type constraints for WithExtractor

  14. object GlobalSettings

    GlobalSettings for this library

  15. object IsolationLevel
  16. object JDBCUrl extends Serializable

    Companion object of JDBC URL

  17. object JavaUtilDateConverterImplicits extends JavaUtilDateConverterImplicits
  18. object LikeConditionEscapeUtil extends LikeConditionEscapeUtil
  19. object LoanPattern extends LoanPattern
  20. object NoConnectionPoolContext extends ConnectionPoolContext

    No Connection Pool Context

  21. case object NoSession extends DBSession with Product with Serializable

    Represents that there is no active session.

  22. object OneToManies10SQL
  23. object OneToManies10SQLToCollection
  24. object OneToManies10SQLToIterable
  25. object OneToManies10SQLToList
  26. object OneToManies10SQLToOption
  27. object OneToManies11SQL
  28. object OneToManies11SQLToCollection
  29. object OneToManies11SQLToIterable
  30. object OneToManies11SQLToList
  31. object OneToManies11SQLToOption
  32. object OneToManies12SQL
  33. object OneToManies12SQLToCollection
  34. object OneToManies12SQLToIterable
  35. object OneToManies12SQLToList
  36. object OneToManies12SQLToOption
  37. object OneToManies13SQL
  38. object OneToManies13SQLToCollection
  39. object OneToManies13SQLToIterable
  40. object OneToManies13SQLToList
  41. object OneToManies13SQLToOption
  42. object OneToManies14SQL
  43. object OneToManies14SQLToCollection
  44. object OneToManies14SQLToIterable
  45. object OneToManies14SQLToList
  46. object OneToManies14SQLToOption
  47. object OneToManies15SQL
  48. object OneToManies15SQLToCollection
  49. object OneToManies15SQLToIterable
  50. object OneToManies15SQLToList
  51. object OneToManies15SQLToOption
  52. object OneToManies16SQL
  53. object OneToManies16SQLToCollection
  54. object OneToManies16SQLToIterable
  55. object OneToManies16SQLToList
  56. object OneToManies16SQLToOption
  57. object OneToManies17SQL
  58. object OneToManies17SQLToCollection
  59. object OneToManies17SQLToIterable
  60. object OneToManies17SQLToList
  61. object OneToManies17SQLToOption
  62. object OneToManies18SQL
  63. object OneToManies18SQLToCollection
  64. object OneToManies18SQLToIterable
  65. object OneToManies18SQLToList
  66. object OneToManies18SQLToOption
  67. object OneToManies19SQL
  68. object OneToManies19SQLToCollection
  69. object OneToManies19SQLToIterable
  70. object OneToManies19SQLToList
  71. object OneToManies19SQLToOption
  72. object OneToManies20SQL
  73. object OneToManies20SQLToCollection
  74. object OneToManies20SQLToIterable
  75. object OneToManies20SQLToList
  76. object OneToManies20SQLToOption
  77. object OneToManies21SQL
  78. object OneToManies21SQLToCollection
  79. object OneToManies21SQLToIterable
  80. object OneToManies21SQLToList
  81. object OneToManies21SQLToOption
  82. object OneToManies2SQL
  83. object OneToManies2SQLToCollection
  84. object OneToManies2SQLToIterable
  85. object OneToManies2SQLToList
  86. object OneToManies2SQLToOption
  87. object OneToManies3SQL
  88. object OneToManies3SQLToCollection
  89. object OneToManies3SQLToIterable
  90. object OneToManies3SQLToList
  91. object OneToManies3SQLToOption
  92. object OneToManies4SQL
  93. object OneToManies4SQLToCollection
  94. object OneToManies4SQLToIterable
  95. object OneToManies4SQLToList
  96. object OneToManies4SQLToOption
  97. object OneToManies5SQL
  98. object OneToManies5SQLToCollection
  99. object OneToManies5SQLToIterable
  100. object OneToManies5SQLToList
  101. object OneToManies5SQLToOption
  102. object OneToManies6SQL
  103. object OneToManies6SQLToCollection
  104. object OneToManies6SQLToIterable
  105. object OneToManies6SQLToList
  106. object OneToManies6SQLToOption
  107. object OneToManies7SQL
  108. object OneToManies7SQLToCollection
  109. object OneToManies7SQLToIterable
  110. object OneToManies7SQLToList
  111. object OneToManies7SQLToOption
  112. object OneToManies8SQL
  113. object OneToManies8SQLToCollection
  114. object OneToManies8SQLToIterable
  115. object OneToManies8SQLToList
  116. object OneToManies8SQLToOption
  117. object OneToManies9SQL
  118. object OneToManies9SQLToCollection
  119. object OneToManies9SQLToIterable
  120. object OneToManies9SQLToList
  121. object OneToManies9SQLToOption
  122. object OneToManySQL
  123. object OneToManySQLToCollection
  124. object OneToManySQLToIterable
  125. object OneToManySQLToList
  126. object OneToManySQLToOption
  127. object OneToOneSQL
  128. object OneToOneSQLToCollection
  129. object OneToOneSQLToIterable
  130. object OneToOneSQLToList
  131. object OneToOneSQLToOption
  132. object OneToXSQL
  133. object ParameterBinder

    ParameterBinder factory.

  134. object ParameterBinderFactory extends LowPriorityImplicitsParameterBinderFactory1
  135. 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.

  136. 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
      }
    }
  137. object SQLBatch
  138. object SQLBatchWithGeneratedKey
  139. object SQLExecution
  140. object SQLFormatterSettings extends Serializable
  141. 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.

  142. object SQLToCollectionImpl
  143. object SQLToIterableImpl
  144. object SQLToListImpl
  145. object SQLToOptionImpl
  146. object SQLUpdate
  147. object SQLUpdateWithGeneratedKey
  148. case object ScalikejdbcBuildInfo extends Product with Serializable

    This object was generated by sbt-buildinfo.

  149. object SettingsProvider
  150. object StatementExecutor extends Serializable

    Companion object.

  151. object StringSQLRunner extends Serializable
  152. object ThreadLocalDB

    Thread-local DB.

  153. object TimeZoneConverter
  154. object TxBoundary

    TxBoundary type class instances.

  155. object TypeBinder extends LowPriorityTypeBinderImplicits

    Type binder for java.sql.ResultSet.

Deprecated Value Members

  1. object UnixTimeInMillisConverterImplicits extends JavaUtilDateConverterImplicits
    Annotations
    @deprecated
    Deprecated

    (Since version 3.4.0) use JavaUtilDateConverterImplicits

Ungrouped