Copyright | (c) Eitan Chatav 2019 |
---|---|
Maintainer | eitan@morphism.tech |
Stability | experimental |
Safe Haskell | None |
Language | Haskell2010 |
delete statements
Synopsis
- deleteFrom :: (SListI row, Has sch db schema, Has tab schema (Table table)) => QualifiedAlias sch tab -> UsingClause with db params from -> Condition Ungrouped '[] with db params ((tab ::: TableToRow table) ': from) -> ReturningClause with db params '[tab ::: TableToRow table] row -> Manipulation with db params row
- deleteFrom_ :: (Has sch db schema, Has tab schema (Table table)) => QualifiedAlias sch tab -> Condition Ungrouped '[] with db params '[tab ::: TableToRow table] -> Manipulation with db params '[]
- data UsingClause with db params from where
- NoUsing :: UsingClause with db params '[]
- Using :: FromClause '[] with db params from -> UsingClause with db params from
Delete
:: (SListI row, Has sch db schema, Has tab schema (Table table)) | |
=> QualifiedAlias sch tab | table to delete from |
-> UsingClause with db params from | |
-> Condition Ungrouped '[] with db params ((tab ::: TableToRow table) ': from) | condition under which to delete a row |
-> ReturningClause with db params '[tab ::: TableToRow table] row | results to return |
-> Manipulation with db params row |
Delete rows from a table.
:: (Has sch db schema, Has tab schema (Table table)) | |
=> QualifiedAlias sch tab | table to delete from |
-> Condition Ungrouped '[] with db params '[tab ::: TableToRow table] | condition under which to delete a row |
-> Manipulation with db params '[] |
Delete rows returning Nil
.
data UsingClause with db params from where Source #
Specify additional tables with Using
an also
list of table expressions, allowing columns
from other tables to appear in the WHERE condition.
This is similar to the list of tables that can be specified
in the FROM Clause of a SELECT statement;
for example, an alias for the table name can be specified.
Do not repeat the target table in the Using
list,
unless you wish to set up a self-join.
NoUsing
if no additional tables are to be used.
NoUsing :: UsingClause with db params '[] | |
Using | |
|