=======
execute
=======

.. py:method:: execute(self, sql) 

**domain**: server

**language**: python

**class** :doc:`Task class </refs/server/task_api>`

Description
===========

Use ``execute`` to execute an SQL query (except SELECT queries) using 
multiprocessing connection pool. For SELECT queries use the
:doc:`execute_select <m_execute_select>`
method.

The ``sql`` parameter can be a query string, a list of query strings, a list of
lists and so on.

All queries are executed in one transaction and if execution succeeds the ``COMMIT``
command is called, otherwise ``ROLLBACK`` command is executed.


Examples
========


See also
========

:doc:`execute_select <m_execute_select>`