Bug: MySQL is not working for custom delegation

[kairoaraujo]

What happened?

As required by MySQL, we need to review when we do commit() and make sure that the commits go in all async tasks.

See here a case:

repository-service-tuf-worker/repository_service_tuf_worker/repository.py

Lines 583 to 588 in 83d8937

	# If using MySQL/MariaDB, we need to commit the transaction in the
	# subtask to see the changes in the main task.
	# https://stackoverflow.com/questions/58212462/db-changes-made-in-a-celery-task-not-visible-in-the-main-thread # noqa
	if "mysql" in self._db.bind.url.drivername:
	self._db.commit()

The tests are failing

https://github.com/repository-service-tuf/repository-service-tuf-worker/actions/runs/10851053429/job/30113908168

What steps did you take?

Run RSTUF Worker using MySQL

What behavior did you expect?

No response

Relevant log output

https://github.com/repository-service-tuf/repository-service-tuf-worker/actions/runs/10851053429/job/30113908168

Code of Conduct

• I agree to follow this project's Code of Conduct