trait InsertActionComposer[U] extends JdbcProfile.SimpleInsertActionComposer[U]
Extension methods to generate the JDBC-specific insert actions.
- Alphabetic
- By Inheritance
- InsertActionComposer
- SimpleInsertActionComposer
- InsertActionExtensionMethodsImpl
- AnyRef
- Any
- by StringFormat
- by Ensuring
- by ArrowAssoc
- Hide All
- Show All
- Public
- Protected
Type Members
- abstract type MultiInsertResult
The result type when inserting a collection of values.
The result type when inserting a collection of values.
- Definition Classes
- InsertActionExtensionMethodsImpl
- abstract type QueryInsertResult
The result type of operations that insert data produced by another query
- abstract type SingleInsertOrUpdateResult
The return type for
insertOrUpdateoperations.The return type for
insertOrUpdateoperations. Note that the Option return value will be None if it was an update and Some if it was an insert- Definition Classes
- SimpleInsertActionComposer
- abstract type SingleInsertResult
The result type when inserting a single value.
The result type when inserting a single value.
- Definition Classes
- InsertActionExtensionMethodsImpl
Abstract Value Members
- 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
- 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
- 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
- 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
- abstract def forceInsertQuery[TT, C[_]](compiledQuery: CompiledStreamingExecutable[Query[TT, U, C], _, _]): JdbcProfile.ProfileAction[QueryInsertResult, NoStream, Write]
Insert data produced by another query
- abstract def forceInsertQuery[TT, C[_]](query: Query[TT, U, C]): JdbcProfile.ProfileAction[QueryInsertResult, NoStream, Write]
Insert data produced by another query
- abstract def forceInsertStatement: String
Get the SQL statement for a forced insert
Get the SQL statement for a forced insert
- Definition Classes
- SimpleInsertActionComposer
- abstract def forceInsertStatementFor[TT, C[_]](compiledQuery: CompiledStreamingExecutable[Query[TT, U, C], _, _]): String
Get the SQL statement for inserting data produced by another query
- abstract def forceInsertStatementFor[TT, C[_]](query: Query[TT, U, C]): String
Get the SQL statement for inserting data produced by another query
- 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
- 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
- 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
- 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
- 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
Concrete Value Members
- final def !=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def ##: Int
- Definition Classes
- AnyRef → Any
- 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
- def ->[B](y: B): (JdbcProfile.InsertActionComposer[U], B)
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toArrowAssoc[JdbcProfile.InsertActionComposer[U]] performed by method ArrowAssoc in scala.Predef.
- Definition Classes
- ArrowAssoc
- Annotations
- @inline()
- final def ==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @native() @HotSpotIntrinsicCandidate()
- def ensuring(cond: (JdbcProfile.InsertActionComposer[U]) => Boolean, msg: => Any): JdbcProfile.InsertActionComposer[U]
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toEnsuring[JdbcProfile.InsertActionComposer[U]] performed by method Ensuring in scala.Predef.
- Definition Classes
- Ensuring
- def ensuring(cond: (JdbcProfile.InsertActionComposer[U]) => Boolean): JdbcProfile.InsertActionComposer[U]
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toEnsuring[JdbcProfile.InsertActionComposer[U]] performed by method Ensuring in scala.Predef.
- Definition Classes
- Ensuring
- def ensuring(cond: Boolean, msg: => Any): JdbcProfile.InsertActionComposer[U]
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toEnsuring[JdbcProfile.InsertActionComposer[U]] performed by method Ensuring in scala.Predef.
- Definition Classes
- Ensuring
- def ensuring(cond: Boolean): JdbcProfile.InsertActionComposer[U]
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toEnsuring[JdbcProfile.InsertActionComposer[U]] performed by method Ensuring in scala.Predef.
- Definition Classes
- Ensuring
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def toString(): String
- Definition Classes
- AnyRef → Any
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
Deprecated Value Members
- def finalize(): Unit
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.Throwable]) @Deprecated
- Deprecated
- def formatted(fmtstr: String): String
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toStringFormat[JdbcProfile.InsertActionComposer[U]] performed by method StringFormat in scala.Predef.
- Definition Classes
- StringFormat
- Annotations
- @deprecated @inline()
- Deprecated
(Since version 2.12.16) Use
formatString.format(value)instead ofvalue.formatted(formatString), or use thef""string interpolator. In Java 15 and later,formattedresolves to the new method in String which has reversed parameters.
- def →[B](y: B): (JdbcProfile.InsertActionComposer[U], B)
- Implicit
- This member is added by an implicit conversion from JdbcProfile.InsertActionComposer[U] toArrowAssoc[JdbcProfile.InsertActionComposer[U]] performed by method ArrowAssoc in scala.Predef.
- Definition Classes
- ArrowAssoc
- Annotations
- @deprecated
- Deprecated
(Since version 2.13.0) Use
->instead. If you still wish to display it as one character, consider using a font with programming ligatures such as Fira Code.
edit this text on github
Scala Language-Integrated Connection Kit
This is the API documentation for the Slick database library. It should be used as an additional resource to the user manual.
Further documentation for Slick can be found on the documentation pages.
To the slick package list...