Slick
3.6.1
API
Generated with
Slick is developed by Typesafe and EPFL Lausanne.
Slick is developed by Typesafe and EPFL Lausanne.
Slick/slick/slick.jdbc/JdbcActionComponent/CountingInsertActionComposer

CountingInsertActionComposer

slick.jdbc.JdbcActionComponent.CountingInsertActionComposer
trait CountingInsertActionComposer[U] extends InsertActionComposer[U]

An InsertInvoker that returns the number of affected rows.

Attributes

Source
JdbcActionComponent.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Show all

Members list

Type members

Types

type MultiInsertResult = Option[Int]

The result type when inserting a collection of values.

The result type when inserting a collection of values.

Attributes

Source
JdbcActionComponent.scala
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

Attributes

Source
JdbcActionComponent.scala
type SingleInsertOrUpdateResult = Int

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

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

Attributes

Source
JdbcActionComponent.scala
type SingleInsertResult = Int

The result type when inserting a single value.

The result type when inserting a single value.

Attributes

Source
JdbcActionComponent.scala

Value members

Abstract methods

def returning[RT, RU, C[_]](value: Query[RT, RU, C]): ReturningInsertActionComposer[U, RU]

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.

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.

Attributes

Source
JdbcActionComponent.scala

Inherited methods

final def ++=(values: Iterable[U]): FixedSqlAction[MultiInsertResult, NoStream, Write]

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.

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.

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def +=(value: U): FixedSqlAction[SingleInsertResult, NoStream, Write]

Insert a single row, skipping AutoInc columns.

Insert a single row, skipping AutoInc columns.

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def forceInsert(value: U): FixedSqlAction[SingleInsertResult, NoStream, Write]

Insert a single row, including AutoInc columns. This is not supported by all database engines (see slick.jdbc.JdbcCapabilities.forceInsert).

Insert a single row, including AutoInc columns. This is not supported by all database engines (see slick.jdbc.JdbcCapabilities.forceInsert).

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def forceInsertAll(values: Iterable[U]): FixedSqlAction[MultiInsertResult, NoStream, Write]

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.

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.

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def forceInsertExpr[TT](c: TT)(implicit shape: Shape[_ <: FlatShapeLevel, TT, U, _]): FixedSqlAction[QueryInsertResult, NoStream, Write]

Insert a single row from a scalar expression

Insert a single row from a scalar expression

Attributes

Inherited from:
InsertActionComposer
Source
JdbcActionComponent.scala
def forceInsertQuery[TT, C[_]](compiledQuery: CompiledStreamingExecutable[Query[TT, U, C], _, _]): FixedSqlAction[QueryInsertResult, NoStream, Write]

Insert data produced by another query

Insert data produced by another query

Attributes

Inherited from:
InsertActionComposer
Source
JdbcActionComponent.scala
def forceInsertQuery[TT, C[_]](query: Query[TT, U, C]): FixedSqlAction[QueryInsertResult, NoStream, Write]

Insert data produced by another query

Insert data produced by another query

Attributes

Inherited from:
InsertActionComposer
Source
JdbcActionComponent.scala
def forceInsertStatement: String

Get the SQL statement for a forced insert

Get the SQL statement for a forced insert

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
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

Attributes

Inherited from:
InsertActionComposer
Source
JdbcActionComponent.scala
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

Attributes

Inherited from:
InsertActionComposer
Source
JdbcActionComponent.scala
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

Attributes

Inherited from:
InsertActionComposer
Source
JdbcActionComponent.scala
def insertAll(values: Iterable[U], rowsPerStatement: RowsPerStatement): FixedSqlAction[MultiInsertResult, NoStream, Write]

Insert multiple rows, skipping AutoInc columns.

Insert multiple rows, skipping AutoInc columns.

Value parameters

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.

values

the rows to insert

Attributes

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.

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def insertOrUpdate(value: U): FixedSqlAction[SingleInsertOrUpdateResult, NoStream, Write]

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

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

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def insertOrUpdateAll(values: Iterable[U], option: RowsPerStatement): FixedSqlAction[MultiInsertResult, NoStream, Write]

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.

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.

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
def insertStatement: String

Get the SQL statement for a standard (soft) insert

Get the SQL statement for a standard (soft) insert

Attributes

Inherited from:
SimpleInsertActionComposer
Source
JdbcActionComponent.scala
Generated with
Slick is developed by Typesafe and EPFL Lausanne.
Slick is developed by Typesafe and EPFL Lausanne.