One execute Stored Procedure causes multiple calls to store procedure in the database

Environment

Python: Python 3.10.6
pyodbc: 4.0.34
OS: Windows 10
DB: SQL Server
driver: ODBC Driver 13 for SQL Server

Issue

I made the following script to handle the connection to the database and to be able to execute stored procedures.

Procedures that simply return data behave correctly.

In stored procedures that perform inserts, it was found that even if .execute is only called once, executing the stored procedure call multiple times will result in multiple inserts. I know that it is called several times because with the getdate() that I insert I can see that there are multiple equal inserts with dates very close together.

I don't know how I can fix or control this. I haven't found anyone that has.

Thanks.

CODE

import pyodbc

class SQLManagmentConnection:

#Constructor
def __init__(self, server, database, user, password, driver):

    self.server = server; 
    self.database = database
    self.username = user
    self.password = password
    self.driver = driver

def connect(self):

    #print ('Connecting to database...')
    self.cnxn = pyodbc.connect('DRIVER={'+ self.driver +'};SERVER='+self.server+';DATABASE='+self.database+';UID='+self.username+';PWD='+ self.password, autocommit=True)
    self.cursor = self.cnxn.cursor()
    #print ('Connected database')

def close(self):
    self.cursor.close() 
    self.cnxn.close()

def execute(self, procedure, parameters, parametersName):

    parametersName_comma_separated = "=?, @".join(parametersName)

    if parametersName_comma_separated == "":
        sql = """\
        DECLARE @return_value int;
        EXEC    @return_value = """ + procedure +""";  
        SELECT  'Return Value' = @return_value;
        """
        crsr = self.cnxn.execute(sql)

    else:

        sql = """\
        EXEC """ + procedure + """ @"""+ parametersName_comma_separated +"""=?
        """
        crsr = self.cnxn.execute(sql, parameters)

    data = crsr.fetchall()
    #crsr.commit()

    return data

mkleehammer / pyodbc