I'm having difficulty with an update statement for MySQL in Python I've created a class for executing queries, all my other queries work but an update I could use a fresh pair of eyes.

```
database_handler.sql_post_query_with_args_performed_successfully("UPDATE members SET email ='test@test.ie' WHERE id= '%s'",id) 

```

The function sql\_post\_query\_with\_args\_performed\_successfully returns true when it performs the query. As it stands this code is returning true but not updating the field of the table code for that is here:
 def sql\_post\_query\_with\_args\_performed\_successfully(self, query, args):
 with UseDatabase(self.MYSQL\_DETAILS) as cursor:
 try:
 cursor.execute(query, args)
 return True
 except mysql.connector.errors.IntegrityError:
 return False

this function makes use of "UseDatabase" another class whichs handles the connection and execution of the queries, here id the code for that:

```
import mysql.connector

class UseDatabase:
    def __init__(self, configuration:dict):
        self.config = configuration

    def __enter__(self) -> 'cursor':
        """Connect to database and create a DB cursor. 

        Return the database cursor to the context manager.
        """        
        self.conn = mysql.connector.connect(**self.config)
        self.cursor = self.conn.cursor()
        return self.cursor

    def __exit__(self, exc_type, exc_value, exc_traceback):
        self.cursor.close()
        self.conn.commit()
        self.conn.close()

```