InsertActionComposer

slick.jdbc.JdbcActionComponent.InsertActionComposer

Extension methods to generate the JDBC-specific insert actions.

Attributes

Source:
JdbcActionComponent.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes

Members list

Concise view

Type members

Types

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

Inherited types

The result type when inserting a collection of values.

The result type when inserting a collection of values.

Attributes

Inherited from:
InsertActionExtensionMethodsImpl
Source:
RelationalProfile.scala

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

The result type when inserting a single value.

The result type when inserting a single value.

Attributes

Inherited from:
InsertActionExtensionMethodsImpl
Source:
RelationalProfile.scala

Value members

Abstract methods

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

Source:
JdbcActionComponent.scala

Insert data produced by another query

Insert data produced by another query

Attributes

Source:
JdbcActionComponent.scala

Insert data produced by another query

Insert data produced by another query

Attributes

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

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

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

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

Get the SQL statement for a forced insert

Get the SQL statement for a forced insert

Attributes

Inherited from:
SimpleInsertActionComposer
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