Module « sqlalchemy »

Fonction delete - module sqlalchemy

Signature de la fonction delete

def delete(table, whereclause=None, bind=None, returning=None, prefixes=None, **dialect_kw) 

Description

delete.__doc__

Construct :class:`_expression.Delete` object.

        E.g.::

            from sqlalchemy import delete

            stmt = (
                delete(user_table).
                where(user_table.c.id == 5)
            )

        Similar functionality is available via the
        :meth:`_expression.TableClause.delete` method on
        :class:`_schema.Table`.

        .. seealso::

            :ref:`inserts_and_updates` - in the
            :ref:`1.x tutorial <sqlexpression_toplevel>`

            :ref:`tutorial_core_update_delete` - in the :ref:`unified_tutorial`


        :param table: The table to delete rows from.

        :param whereclause: Optional SQL expression describing the ``WHERE``
         condition of the ``DELETE`` statement; is equivalent to using the
         more modern :meth:`~Delete.where()` method to specify the ``WHERE``
         clause.

         .. deprecated:: 1.4 The :paramref:`_expression.delete.whereclause` parameter will be removed in SQLAlchemy 2.0.  Please refer to the :meth:`_expression.Delete.where` method.



        .. seealso::

            :ref:`deletes` - SQL Expression Tutorial