SQLInsertBuilder

Topics

Initializers

• init(_:on:)
  Creates a new SQLInsertBuilder.

Instance Properties

• database
  Connection to execute query on.
• insert
  The SQLInsert query this builder builds.
• query
  Query being built.
• returning
  The specification of what the query should return, if any.
• tableExpressionGroup
  An optional group of common table expressions to include in the query under construction.

Instance Methods

• columns(_:)
  Specify mutiple columns to be included in the list of columns for the query.
• ignoringConflicts(with:)
  Specify that constraint violations for the key over the given column should cause the conflicting row(s) to be ignored.
• model(_:prefix:keyEncodingStrategy:nilEncodingStrategy:userInfo:)
  Use an Encodable value to generate a row to insert and add that row to the query.
• model(_:with:)
  Use an Encodable value to generate a row to insert and add that row to the query.
• models(_:prefix:keyEncodingStrategy:nilEncodingStrategy:userInfo:)
  Use an array of Encodable values to generate rows to insert and add those rows to the query.
• models(_:with:)
  Use an array of Encodable values to generate rows to insert and add those rows to the query.
• onConflict(with:do:)
  Specify that constraint violations for the key over the given column should cause the conflicting row(s) to be updated as specified instead. See SQLConflictUpdateBuilder.
• rows(_:)
  Add multiple sequences of values each inserted as a separate row.
• select(_:)
  Specify a SELECT query to generate rows to insert.
• values(_:)
  Add a set of values to be inserted as a single row.