class SQLiteCountingInsertActionComposerImpl[U] extends CountingInsertActionComposerImpl[U]
- Alphabetic
- By Inheritance
- SQLiteCountingInsertActionComposerImpl
- CountingInsertActionComposerImpl
- CountingInsertActionComposer
- InsertActionComposerImpl
- InsertActionComposer
- SimpleInsertActionComposer
- InsertActionExtensionMethodsImpl
- AnyRef
- Any
- by StringFormat
- by Ensuring
- by ArrowAssoc
- Hide All
- Show All
- Public
- Protected
Instance Constructors
- new SQLiteCountingInsertActionComposerImpl(compiled: SQLiteProfile.CompiledInsert)
Type Members
- class InsertOrUpdateAction extends JdbcProfile.SimpleJdbcProfileAction[SingleInsertOrUpdateResult]
- Definition Classes
- InsertActionComposerImpl
- class InsertOrUpdateAllAction extends MultiInsertAction
- Definition Classes
- InsertActionComposerImpl
- class InsertQueryAction extends JdbcProfile.SimpleJdbcProfileAction[QueryInsertResult]
- Definition Classes
- InsertActionComposerImpl
- class MultiInsertAction extends JdbcProfile.SimpleJdbcProfileAction[MultiInsertResult]
- Definition Classes
- InsertActionComposerImpl
- final class SingleInsertAction extends JdbcProfile.SimpleJdbcProfileAction[SingleInsertResult]
- Definition Classes
- InsertActionComposerImpl
- type MultiInsertResult = Option[Int]
The result type when inserting a collection of values.
The result type when inserting a collection of values.
- Definition Classes
- CountingInsertActionComposer → InsertActionExtensionMethodsImpl
- type QueryInsertResult = Int
The result type of operations that insert data produced by another query
The result type of operations that insert data produced by another query
- Definition Classes
- CountingInsertActionComposer → InsertActionComposer
- type SingleInsertOrUpdateResult = Int
The return type for
insertOrUpdateoperations.The return type for
insertOrUpdateoperations. Note that the Option return value will be None if it was an update and Some if it was an insert- Definition Classes
- CountingInsertActionComposer → SimpleInsertActionComposer
- type SingleInsertResult = Int
The result type when inserting a single value.
The result type when inserting a single value.
- Definition Classes
- CountingInsertActionComposer → InsertActionExtensionMethodsImpl
Value Members
- final def ++=(values: Iterable[U]): SQLiteProfile.ProfileAction[MultiInsertResult, NoStream, Write]
Insert multiple rows, skipping AutoInc columns.
Insert multiple rows, skipping AutoInc columns. Uses JDBC's batch update feature if supported by the JDBC driver. Returns Some(rowsAffected), or None if the database returned no row count for some part of the batch. If any part of the batch fails, an exception is thrown.
This method is a shorthand for insertAll with RowsPerStatement.One.
- Definition Classes
- SimpleInsertActionComposer → InsertActionExtensionMethodsImpl
- def +=(value: U): SQLiteProfile.ProfileAction[SingleInsertResult, NoStream, Write]
Insert a single row, skipping AutoInc columns.
Insert a single row, skipping AutoInc columns.
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer → InsertActionExtensionMethodsImpl
- val compiled: SQLiteProfile.CompiledInsert
- Definition Classes
- InsertActionComposerImpl
- def forceInsert(value: U): SQLiteProfile.ProfileAction[SingleInsertResult, NoStream, Write]
Insert a single row, including AutoInc columns.
Insert a single row, including AutoInc columns. This is not supported by all database engines (see slick.jdbc.JdbcCapabilities.forceInsert).
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def forceInsertAll(values: Iterable[U]): SQLiteProfile.ProfileAction[MultiInsertResult, NoStream, Write]
Insert multiple rows, including AutoInc columns.
Insert multiple rows, including AutoInc columns. This is not supported by all database engines (see slick.jdbc.JdbcCapabilities.forceInsert). Uses JDBC's batch update feature if supported by the JDBC driver. Returns Some(rowsAffected), or None if the database returned no row count for some part of the batch. If any part of the batch fails, an exception is thrown.
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def forceInsertExpr[TT](c: TT)(implicit shape: Shape[_ <: FlatShapeLevel, TT, U, _]): SQLiteProfile.ProfileAction[QueryInsertResult, NoStream, Write]
Insert a single row from a scalar expression
Insert a single row from a scalar expression
- Definition Classes
- InsertActionComposerImpl → InsertActionComposer
- def forceInsertQuery[TT, C[_]](compiledQuery: CompiledStreamingExecutable[Query[TT, U, C], _, _]): SQLiteProfile.ProfileAction[QueryInsertResult, NoStream, Write]
Insert data produced by another query
Insert data produced by another query
- Definition Classes
- InsertActionComposerImpl → InsertActionComposer
- def forceInsertQuery[TT, C[_]](query: Query[TT, U, C]): SQLiteProfile.ProfileAction[QueryInsertResult, NoStream, Write]
Insert data produced by another query
Insert data produced by another query
- Definition Classes
- InsertActionComposerImpl → InsertActionComposer
- def forceInsertStatement: String
Get the SQL statement for a forced insert
Get the SQL statement for a forced insert
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def forceInsertStatementFor[TT, C[_]](compiledQuery: CompiledStreamingExecutable[Query[TT, U, C], _, _]): String
Get the SQL statement for inserting data produced by another query
Get the SQL statement for inserting data produced by another query
- Definition Classes
- InsertActionComposerImpl → InsertActionComposer
- def forceInsertStatementFor[TT, C[_]](query: Query[TT, U, C]): String
Get the SQL statement for inserting data produced by another query
Get the SQL statement for inserting data produced by another query
- Definition Classes
- InsertActionComposerImpl → InsertActionComposer
- def forceInsertStatementFor[TT](c: TT)(implicit shape: Shape[_ <: FlatShapeLevel, TT, U, _]): String
Get the SQL statement for inserting a single row from a scalar expression
Get the SQL statement for inserting a single row from a scalar expression
- Definition Classes
- InsertActionComposerImpl → InsertActionComposer
- def insertAll(values: Iterable[U], rowsPerStatement: SQLiteProfile.RowsPerStatement): SQLiteProfile.ProfileAction[MultiInsertResult, NoStream, Write]
Insert multiple rows, skipping AutoInc columns.
Insert multiple rows, skipping AutoInc columns.
- values
the rows to insert
- rowsPerStatement
RowsPerStatement.All to use a single statement to insert all rows at once, or RowsPerStatement.One to use a separate SQL statement for each row. Even so, if supported this will use JDBC's batching functionality.
- returns
Some(rowsAffected), or None if the database returned no row count for some part of the batch. If any part of the batch fails, an exception is thrown.
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def insertOrUpdate(value: U): SQLiteProfile.ProfileAction[SingleInsertOrUpdateResult, NoStream, Write]
Insert a single row if its primary key does not exist in the table, otherwise update the existing record.
Insert a single row if its primary key does not exist in the table, otherwise update the existing record. Note that the return value will be None if an update was performed and Some if the operation was insert
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def insertOrUpdateAll(values: Iterable[U], rowsPerStatement: SQLiteProfile.RowsPerStatement): SQLiteProfile.ProfileAction[MultiInsertResult, NoStream, Write]
Insert multiple rows if its primary key does not exist in the table, otherwise update the existing record.
Insert multiple rows if its primary key does not exist in the table, otherwise update the existing record. Returns Some(rowsAffected), or None if the database returned no row count for some part of the batch. If any part of the batch fails, an exception is thrown. The option parameter specifies how the operation is to be performed.(default is RowsPerStatement.All) Note unlike insertOrUpdate, client-side emulation is not supported.
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def insertStatement: String
Get the SQL statement for a standard (soft) insert
Get the SQL statement for a standard (soft) insert
- Definition Classes
- InsertActionComposerImpl → SimpleInsertActionComposer
- def returning[RT, RU, C[_]](value: Query[RT, RU, C]): SQLiteProfile.ReturningInsertActionComposer[U, RU]
Add a mapping from the inserted values and the generated key to compute a new return value.
Add a mapping from the inserted values and the generated key to compute a new return value. When using insertAll, some JDBC drivers may not be able to return the generated key. In that case, the collection of keys returned by insertAll will be Nil.
- Definition Classes
- CountingInsertActionComposerImpl → CountingInsertActionComposer
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...