Packages

•  package root

  edit this text on github

  edit this text on github

  Scala Language-Integrated Connection Kit

  This is the API documentation for the Slick database library. It should be used as an additional resource to the user manual.

  Further documentation for Slick can be found on the documentation pages.

  To the slick package list...

  Definition Classes

  root

•  package slick

  Definition Classes

  root

•  package jdbc

  Contains the abstract JdbcProfile and related code.

  Contains the abstract JdbcProfile and related code. This includes all JDBC-related code, facilities for Plain SQL queries, and JDBC-specific profile components.

  Definition Classes

  slick

•  trait SQLiteProfile extends JdbcProfile with MultipleRowsPerStatementSupport

  Slick profile for SQLite.

  Slick profile for SQLite.

  This profile implements slick.jdbc.JdbcProfile without the following capabilities:

  • slick.relational.RelationalCapabilities.functionDatabase, slick.relational.RelationalCapabilities.functionUser: Functions.user and Functions.database are not available in SQLite. Slick will return empty strings for both.
  • slick.relational.RelationalCapabilities.joinFull, slick.relational.RelationalCapabilities.joinRight: Right and full outer joins are emulated because there is not native support for them.
  • slick.jdbc.JdbcCapabilities.mutable: SQLite does not allow mutation of result sets. All cursors are read-only.
  • slick.sql.SqlCapabilities.sequence: Sequences are not supported by SQLite.
  • slick.jdbc.JdbcCapabilities.returnInsertOther: When returning columns from an INSERT operation, only a single column may be specified which must be the table's AutoInc column.
  • slick.relational.RelationalCapabilities.typeBigDecimal: SQLite does not support a decimal type.
  • slick.relational.RelationalCapabilities.typeBlob: Blobs are not supported by the SQLite JDBC driver (but binary data in the form of Array[Byte] is).
  • slick.relational.RelationalCapabilities.zip: Row numbers (required by zip and zipWithIndex) are not supported. Trying to generate SQL code which uses this feature throws a SlickException.
  • slick.jdbc.JdbcCapabilities.insertOrUpdate: InsertOrUpdate operations are emulated on the client side if the data to insert contains an AutoInc field. Otherwise the operation is performed natively on the server side.
  • slick.jdbc.JdbcCapabilities.defaultValueMetaData: The stable xerial sqlite-jdbc driver 3.7.2 does not return default values for columns in the DatabaseMetaData. Consequently they also do not appear in Slick's model. This has been fixed in sqlite-jdbc, but the only released version that contains the fix is milestone 3.7.15-M1. You can use it instead of the stable 3.7.2 in order to get default values with SQLite. Also see https://code.google.com/p/sqlite-jdbc/issues/detail?id=27
  • slick.jdbc.JdbcCapabilities.booleanMetaData: SQLite doesn't have booleans, so Slick maps to INTEGER instead. Other jdbc drivers like MySQL map TINYINT(1) back to a Scala Boolean. SQLite maps INTEGER to an Integer and that's how it shows up in the jdbc meta data, thus the original type is lost.
  • slick.jdbc.JdbcCapabilities.distinguishesIntTypes: SQLite does not distinguish integer types and maps them all to Int in the meta data.
  • slick.jdbc.JdbcCapabilities.supportsByte: SQLite does not distinguish integer types and maps them all to Int in the meta data.
  • slick.jdbc.JdbcCapabilities.returnMultipleInsertKey: SQLite returns the last generated key only.

  Definition Classes

  jdbc

• BasicAPI
• BasicQueryActionExtensionMethodsImpl
• BasicStreamingQueryActionExtensionMethodsImpl
• CheckInsertBuilder
• ColumnDDLBuilder
• Commit
• CountingInsertActionComposer
• CountingInsertActionComposerImpl
• DDL
• DeleteActionExtensionMethodsImpl
• DriverJdbcType
• FastPathExtensionMethods
• FromPart
• HavingPart
• InsertActionComposer
• InsertActionComposerImpl
• InsertActionExtensionMethodsImpl
• InsertBuilder
• IntoInsertActionComposer
• JdbcAPI
• JdbcActionExtensionMethods
• JdbcCodeGen
• JdbcCompiledInsert
• JdbcImplicitColumnTypes
• JdbcInsertCodeGen
• JdbcLowPriorityAPI
• JdbcQueryActionExtensionMethodsImpl
• JdbcSchemaActionExtensionMethodsImpl
• JdbcStreamingQueryActionExtensionMethodsImpl
• JdbcType
• JdbcTypes
• MappedColumnTypeFactory
• MappedJdbcType
• MappingCompiler
• MutatingResultAction
• OtherPart
• PopStatementParameters
• PushStatementParameters
• QueryBuilder
• QueryInvoker
• QueryInvokerImpl
• QuotingSymbolNamer
• RelationalAPI
• RelationalColumnOptions
• RelationalImplicitColumnTypes
• RelationalSchemaActionExtensionMethodsImpl
• ReturningInsertActionComposer
• ReturningInsertActionComposerImpl
• Rollback
• SQLiteColumnDDLBuilder
• SQLiteCountingInsertActionComposerImpl
• SQLiteInsertBuilder
• SQLiteJdbcTypes
• SQLiteModelBuilder
• SQLiteQueryBuilder
• SQLiteTableDDLBuilder
• SQLiteUpsertBuilder
• SchemaDescriptionDef
• SelectPart
• Sequence
• SequenceDDLBuilder
• SetTransactionIsolation
• SimpleInsertActionComposer
• SimpleJdbcProfileAction
• SqlColumnOptions
• StartTransaction
• StatementPart
• Table
• TableDDLBuilder
• TableQueryExtensionMethods
• UpdateActionExtensionMethodsImpl
• UpdateInsertBuilder
• UpsertBuilder
• WherePart

slick.jdbc.SQLiteProfile

SQLiteQueryBuilder