Squeal.PostgreSQL.Manipulation.Insert

insert statements

Insert

insertInto

Arguments

:: (Has sch db schema, Has tab schema (Table table), SListI (TableToColumns table), SListI row)

=> QualifiedAlias sch tab

table

-> QueryClause with db params (TableToColumns table)

what to insert

-> ConflictClause tab with db params table

what to do in case of conflict

-> ReturningClause with db params '[tab ::: TableToRow table] row

what to return

-> Manipulation with db params row

When a table is created, it contains no data. The first thing to do before a database can be of much use is to insert data. Data is conceptually inserted one row at a time. Of course you can also insert more than one row, but there is no way to insert less than one row. Even if you know only some column values, a complete row must be created.

insertInto_

Arguments

:: (Has sch db schema, Has tab schema (Table table), SListI (TableToColumns table))

=> QualifiedAlias sch tab

table

-> QueryClause with db params (TableToColumns table)

what to insert

-> Manipulation with db params '[]

Like insertInto but with OnConflictDoRaise and no ReturningClause.

Clauses

data QueryClause with db params columns where

A QueryClause describes what to insertInto a table.

Constructors

Values

Fields

• :: SListI columns
• => NP (Aliased (Optional (Expression Ungrouped '[] with db params '[]))) columns

  row of values

• -> [NP (Aliased (Optional (Expression Ungrouped '[] with db params '[]))) columns]

  additional rows of values

• -> QueryClause with db params columns

Select

Fields

• :: SListI columns
• => NP (Aliased (Optional (Expression grp '[] with db params from))) columns

  row of values

• -> TableExpression grp '[] with db params from

  from a table expression

• -> QueryClause with db params columns

Subquery

Fields

• :: ColumnsToRow columns ~ row
• => Query '[] with db params row

  subquery to insert

• -> QueryClause with db params columns

Instances

RenderSQL (QueryClause with db params columns)

Defined in Squeal.PostgreSQL.Manipulation.Insert

Methods

renderSQL :: QueryClause with db params columns -> ByteString

pattern Values_

Arguments

:: SListI columns

=> NP (Aliased (Optional (Expression Ungrouped '[] with db params '[]))) columns

row of values

-> QueryClause with db params columns

Values_ describes a single NP list of Aliased Optional Expressions whose ColumnsType must match the tables'.

inlineValues

Arguments

:: (IsRecord hask xs, AllZip InlineColumn xs columns)

=> hask

record

-> [hask]

more

-> QueryClause with db params columns

inlineValues Haskell records in insertInto.

inlineValues_

Arguments

:: (IsRecord hask xs, AllZip InlineColumn xs columns)

=> hask

record

-> QueryClause with db params columns

inlineValues_ a Haskell record in insertInto.

data ConflictClause tab with db params table where

A ConflictClause specifies an action to perform upon a constraint violation. OnConflictDoRaise will raise an error. OnConflict DoNothing simply avoids inserting a row. OnConflict DoUpdate updates the existing row that conflicts with the row proposed for insertion.

Constructors

OnConflictDoRaise :: ConflictClause tab with db params table

OnConflict

Fields

• :: ConflictTarget table

  conflict target

• -> ConflictAction tab with db params table

  conflict action

• -> ConflictClause tab with db params table

Instances

SListI (TableToColumns table) => RenderSQL (ConflictClause tab with db params table)

Render a ConflictClause.

Defined in Squeal.PostgreSQL.Manipulation.Insert

Methods

renderSQL :: ConflictClause tab with db params table -> ByteString

data ConflictTarget table where

A ConflictTarget specifies the constraint violation that triggers a ConflictAction.

Constructors

OnConstraint :: Has con constraints constraint => Alias con -> ConflictTarget (constraints :=> columns)

Instances

RenderSQL (ConflictTarget constraints)

Render a ConflictTarget

Defined in Squeal.PostgreSQL.Manipulation.Insert

Methods

renderSQL :: ConflictTarget constraints -> ByteString

data ConflictAction tab with db params table where

ConflictAction specifies an alternative OnConflict action. It can be either DoNothing, or a DoUpdate clause specifying the exact details of the update action to be performed in case of a conflict. The Set and WHERE Conditions in OnConflict DoUpdate have access to the existing row using the table's name, and to rows proposed for insertion using the special #excluded row. OnConflict DoNothing simply avoids inserting a row as its alternative action. OnConflict DoUpdate updates the existing row that conflicts with the row proposed for insertion as its alternative action.

Constructors

DoNothing :: ConflictAction tab with db params table

DoUpdate

Fields

• :: (row ~ TableToRow table, from ~ '[tab ::: row, "excluded" ::: row], Updatable table updates)
• => NP (Aliased (Optional (Expression Ungrouped '[] with db params from))) updates
• -> [Condition Ungrouped '[] with db params from]

  WHERE Conditions

• -> ConflictAction tab with db params table

Instances

RenderSQL (ConflictAction tab with db params table)

Defined in Squeal.PostgreSQL.Manipulation.Insert

Methods

renderSQL :: ConflictAction tab with db params table -> ByteString