transaction.atomic() problem with DATABASE_ROUTERS

[asr-systify]

Hi,

I use this library in a project with DATABASE_ROUTERS.
As soon as django_apscheduler is not in the 'default' database, I get the following error message:
"select_for_update cannot be used outside of a transaction".

django-apscheduler/django_apscheduler/models.py

Line 165 in a792c1a

with transaction.atomic():

Which in my opinion is also conclusive, because atomic points to the 'default' db without parameters.
The following sample change fixes my problem:

DATABASE_APPS_MAPPING = {
'django_apscheduler': 'test',
}

with transaction.atomic(using='test'):

Is there another approach to this problem case? I couldn't find any other solution when django_apscheduler is not in my 'default' db.

version:
Django==3.2.9
django-apscheduler==0.6.2

[rizkyarlin]

+1
I also ran into same problem. But I can confirm that django_apscheduler is in my default DB.

[icewisb]

@asr-systify
I have a clumsy method, without modifying the source code.

## router.py
class DBRouter(object):
    def db_for_read(self, model, **hints):
        return settings.DB_MAPPING.get(model._meta.app_label, "another_default")

    def db_for_write(self, model, **hints):
        return settings.DB_MAPPING.get(model._meta.app_label, "another_default")

## settings.py
DB_MAPPING = {
    "app_label1": "db_alias1",
     ...
}

DATABASES = {
    "default": {},  # which that "apscheduler" is using
    "another_default": {},  # rename "old" default to "another_default"
}