SimpleInsertActionComposer

slick.jdbc.JdbcActionComponent.SimpleInsertActionComposer

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

Type members

Types

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

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 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

Insert a single row, skipping AutoInc columns.

Insert a single row, skipping AutoInc columns.

Attributes

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

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

Source
JdbcActionComponent.scala
def forceInsertStatement: String

Get the SQL statement for a forced insert

Get the SQL statement for a forced insert

Attributes

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.

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

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

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

Source
JdbcActionComponent.scala

Concrete 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

Source
JdbcActionComponent.scala