:tocdepth: 3

:py:mod:`gws.base.database.connection`
======================================

.. py:module:: gws.base.database.connection


**Source code:** :source:`gws.base.database.connection<gws/base/database/connection.py>`



Module Contents
---------------



.. py:class:: Object(db: gws.DatabaseProvider, conn: gws.lib.sa.Connection)


   Bases: :py:obj:`gws.DatabaseConnection`

   Database connection.

   Extends ``sqlalchemy.Connection`` and provides some convenience methods.

   .. py:attribute:: db
      :type:  gws.DatabaseProvider

   .. py:attribute:: saConn
      :type:  gws.lib.sa.Connection

   .. py:method:: close()

   .. py:method:: commit()

   .. py:method:: exec(sql, **params)

   .. py:method:: exec_commit(sql, **params)

   .. py:method:: exec_rollback(sql, **params)

   .. py:method:: execute(stmt, params=None, execution_options=None)

   .. py:method:: fetch_all(stmt, **params)

   .. py:method:: fetch_first(stmt, **params)

   .. py:method:: fetch_int(stmt, **params)

   .. py:method:: fetch_ints(stmt, **params)

   .. py:method:: fetch_scalar(stmt, **params)

   .. py:method:: fetch_scalars(stmt, **params)

   .. py:method:: fetch_string(stmt, **params)

   .. py:method:: fetch_strings(stmt, **params)

   .. py:method:: rollback()