Participer au site avec un Tip
Rechercher
 

Améliorations / Corrections

Vous avez des améliorations (ou des corrections) à proposer pour ce document : je vous remerçie par avance de m'en faire part, cela m'aide à améliorer le site.

Emplacement :

Description des améliorations :

Vous êtes un professionnel et vous avez besoin d'une formation ? Programmation Python
Les compléments
Voir le programme détaillé
Classe « Connection »

Méthode sqlalchemy.Connection.get_isolation_level

Signature de la méthode get_isolation_level

def get_isolation_level(self) -> 'IsolationLevel' 

Description

help(Connection.get_isolation_level)

Return the current **actual** isolation level that's present on
the database within the scope of this connection.

This attribute will perform a live SQL operation against the database
in order to procure the current isolation level, so the value returned
is the actual level on the underlying DBAPI connection regardless of
how this state was set. This will be one of the four actual isolation
modes ``READ UNCOMMITTED``, ``READ COMMITTED``, ``REPEATABLE READ``,
``SERIALIZABLE``. It will **not** include the ``AUTOCOMMIT`` isolation
level setting. Third party dialects may also feature additional
isolation level settings.

.. note::  This method **will not report** on the ``AUTOCOMMIT``
  isolation level, which is a separate :term:`dbapi` setting that's
  independent of **actual** isolation level.  When ``AUTOCOMMIT`` is
  in use, the database connection still has a "traditional" isolation
  mode in effect, that is typically one of the four values
  ``READ UNCOMMITTED``, ``READ COMMITTED``, ``REPEATABLE READ``,
  ``SERIALIZABLE``.

Compare to the :attr:`_engine.Connection.default_isolation_level`
accessor which returns the isolation level that is present on the
database at initial connection time.

.. seealso::

    :attr:`_engine.Connection.default_isolation_level`
    - view default level

    :paramref:`_sa.create_engine.isolation_level`
    - set per :class:`_engine.Engine` isolation level

    :paramref:`.Connection.execution_options.isolation_level`
    - set per :class:`_engine.Connection` isolation level



Vous êtes un professionnel et vous avez besoin d'une formation ? Sensibilisation à
l'Intelligence Artificielle
Voir le programme détaillé