.. _aiopg-examples:

========================
Examples of aiopg usage
========================

Below is a list of examples from `aiopg/examples
<https://github.com/aio-libs/aiopg/tree/master/examples>`_

Every example is a correct tiny python program.

.. _aiopg-examples-simple:

Low-level API
-------------

.. literalinclude:: ../examples/simple.py


.. _aiopg-examples-notify:

Usage of LISTEN/NOTIFY commands
-------------------------------

.. literalinclude:: ../examples/notify.py


.. _aiopg-examples-sa-simple:

Simple sqlalchemy usage
-----------------------

.. literalinclude:: ../examples/simple_sa.py


.. _aiopg-examples-sa-default-field:

Default value field sqlalchemy usage
------------------------------------

.. literalinclude:: ../examples/default_field_sa.py


.. _aiopg-examples-sa-types-field:

Types field sqlalchemy usage
----------------------------

.. literalinclude:: ../examples/types_field_sa.py


.. _aiopg-examples-sa-named-field:

Named field sqlalchemy usage
----------------------------

.. literalinclude:: ../examples/named_field_sa.py


.. _aiopg-examples-sa-complex:

Complex sqlalchemy queries
---------------------------

.. literalinclude:: ../examples/sa.py


.. _aiopg-examples-sa-simple-transaction:

Simple transaction in sqlalchemy
--------------------------------

.. literalinclude:: ../examples/simple_sa_transaction.py


.. _aiopg-examples-sa-isolation-transaction:

Isolation transaction in sqlalchemy
-----------------------------------

.. literalinclude:: ../examples/isolation_sa_transaction.py