Mocking of execute definition in sqlite3 with python


To mock the sqlite3.connect(), sqlite3.Connection.execute() and perform CRUD operations. The original functionality of the sqlite3.connect() and the sqlite3.Connection.execute() has to be mocked.

I’m able to mock the connect definition but blocked at mocking the execute function.

I’m able to mock connect definition by the below line
@mock.patch(‘sqlite3.connect’, side_effect = stub_sqlite3_connect)”

The execute function is present inside the Connection class in the file which is the sqlite3 package.

The following are the different ways which we tried to mock the execute function:

  1. “from sqlite3 import Connection

  2. “import sqlite3

  3. “import sqlite3
    conn = sqlite3.connect(‘database.db’)
    @mock.patch(‘conn.execute’, side_effect = stub_sqlite3_execute_select)”

  4. “import sqlite3
    connection_object = sqlite3.Connection()
    @mock.patch(‘connection_object.execute’, side_effect = stub_sqlite3_execute_select)”

For all the above different ways of mocking im facing the below error statement.

The error statement is:
TypeError: can’t set attributes of built-in/extension type ‘sqlite3.Connection’;

Any ideas/suggestions to achieve mocking of execute definition in sqlite3 with python.