ReturningInsertActionComposer

slick.jdbc.JdbcActionComponent.ReturningInsertActionComposer

An InsertActionComposer that returns generated keys or other columns.

Attributes

Source:
JdbcActionComponent.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Self type

Members list

Concise view

Type members

Inherited types

type MultiInsertResult = Seq[RU]

The result type when inserting a collection of values.

The result type when inserting a collection of values.

Attributes

Inherited from:
IntoInsertActionComposer
Source:
JdbcActionComponent.scala
type QueryInsertResult = Seq[RU]
type SingleInsertOrUpdateResult = Option[RU]

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

Inherited from:
IntoInsertActionComposer
Source:
JdbcActionComponent.scala

The result type when inserting a single value.

The result type when inserting a single value.

Attributes

Inherited from:
IntoInsertActionComposer
Source:
JdbcActionComponent.scala

Value members

Abstract methods

def into[R](f: (U, RU) => R): IntoInsertActionComposer[U, R]

Specifies a mapping from inserted values and generated keys to a desired value.

Specifies a mapping from inserted values and generated keys to a desired value.

Attributes

R

target type of the mapping

f

Function that maps inserted values and generated keys to a desired value.

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

Insert a single row, skipping AutoInc columns.

Insert a single row, skipping AutoInc columns.

Attributes

Inherited from:
SimpleInsertActionComposer
Source:
JdbcActionComponent.scala

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

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

Insert data produced by another query

Insert data produced by another query

Attributes

Inherited from:
InsertActionComposer
Source:
JdbcActionComponent.scala

Insert data produced by another query

Insert data produced by another query

Attributes

Inherited from:
InsertActionComposer
Source:
JdbcActionComponent.scala

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.

Attributes

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

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

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

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