Delete¶
This deletes any matching rows from the table.
>>> await Band.delete().where(Band.name == 'Rustaceans')
[]
force¶
Piccolo won’t let you run a delete query without a where clause, unless you explicitly tell it to do so. This is to help prevent accidentally deleting all the data from a table.
>>> await Band.delete()
Raises: DeletionError
# Works fine:
>>> await Band.delete(force=True)
[]
Query clauses¶
returning¶
See returning.
where¶
See where