t

slick.jdbc.JdbcActionComponent

CountingInsertActionComposer

trait CountingInsertActionComposer[U] extends JdbcProfile.InsertActionComposer[U]

An InsertInvoker that returns the number of affected rows.

Source
JdbcActionComponent.scala
Linear Supertypes
JdbcProfile.InsertActionComposer[U], JdbcProfile.SimpleInsertActionComposer[U], JdbcProfile.InsertActionExtensionMethodsImpl[U], AnyRef, Any
Known Subclasses
H2CountingInsertActionComposerImpl, CountingInsertActionComposerImpl, SQLiteCountingInsertActionComposerImpl
Type Hierarchy
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. CountingInsertActionComposer
  2. InsertActionComposer
  3. SimpleInsertActionComposer
  4. InsertActionExtensionMethodsImpl
  5. AnyRef
  6. Any
Implicitly
  1. by any2stringadd
  2. by StringFormat
  3. by Ensuring
  4. by ArrowAssoc
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Type Members

  1. 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
  2. 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
  3. type SingleInsertOrUpdateResult = Int

    The return type for insertOrUpdate operations.

    The return type for insertOrUpdate operations. 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
  4. type SingleInsertResult = Int

    The result type when inserting a single value.

    The result type when inserting a single value.

    Definition Classes
    CountingInsertActionComposer → InsertActionExtensionMethodsImpl

Abstract Value Members

  1. abstract def +=(value: U): JdbcProfile.ProfileAction[SingleInsertResult, NoStream, Write]

    Insert a single row, skipping AutoInc columns.

    Insert a single row, skipping AutoInc columns.

    Definition Classes
    SimpleInsertActionComposer → InsertActionExtensionMethodsImpl
  2. abstract def forceInsert(value: U): JdbcProfile.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
    SimpleInsertActionComposer
  3. abstract def forceInsertAll(values: Iterable[U]): JdbcProfile.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
    SimpleInsertActionComposer
  4. abstract def forceInsertExpr[TT](c: TT)(implicit shape: Shape[_ <: FlatShapeLevel, TT, U, _]): JdbcProfile.ProfileAction[QueryInsertResult, NoStream, Write]

    Insert a single row from a scalar expression

    Insert a single row from a scalar expression

    Definition Classes
    InsertActionComposer
  5. abstract def forceInsertQuery[TT, C[_]](compiledQuery: CompiledStreamingExecutable[Query[TT, U, C], _, _]): JdbcProfile.ProfileAction[QueryInsertResult, NoStream, Write]

    Insert data produced by another query

    Insert data produced by another query

    Definition Classes
    InsertActionComposer
  6. abstract def forceInsertQuery[TT, C[_]](query: Query[TT, U, C]): JdbcProfile.ProfileAction[QueryInsertResult, NoStream, Write]

    Insert data produced by another query

    Insert data produced by another query

    Definition Classes
    InsertActionComposer
  7. abstract def forceInsertStatement: String

    Get the SQL statement for a forced insert

    Get the SQL statement for a forced insert

    Definition Classes
    SimpleInsertActionComposer
  8. abstract 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
    InsertActionComposer
  9. abstract 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
    InsertActionComposer
  10. abstract 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
    InsertActionComposer
  11. abstract def insertAll(values: Iterable[U], rowsPerStatement: JdbcProfile.RowsPerStatement = defaultRowsPerStatement): JdbcProfile.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
    SimpleInsertActionComposer
  12. abstract def insertOrUpdate(value: U): JdbcProfile.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
    SimpleInsertActionComposer
  13. abstract def insertOrUpdateAll(values: Iterable[U], option: JdbcProfile.RowsPerStatement = defaultRowsPerStatement): JdbcProfile.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
    SimpleInsertActionComposer
  14. abstract def insertStatement: String

    Get the SQL statement for a standard (soft) insert

    Get the SQL statement for a standard (soft) insert

    Definition Classes
    SimpleInsertActionComposer
  15. abstract def returning[RT, RU, C[_]](value: Query[RT, RU, C]): JdbcProfile.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.

Concrete Value Members

  1. final def ++=(values: Iterable[U]): JdbcProfile.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