I will open with “You should not edit settings at runtime”. Having said that, I have exactly this same issue, where I want to create a unique database for each user. The reason for doing this is I am offering the ability for the user to save/access to/from a database not stored on my server, … Read more
You can’t specify a database for a model, but you can define it in a custom DB router class. # app/models.py class SomeModel(models.Model): … # app/dbrouters.py from app.models import SomeModel … class MyDBRouter(object): def db_for_read(self, model, **hints): “”” reading SomeModel from otherdb “”” if model == SomeModel: return ‘otherdb’ return None def db_for_write(self, model, **hints): … Read more
Merge the following snippet with the LOGGING field in your settings.py: LOGGING = { ‘version’: 1, ‘filters’: { ‘require_debug_true’: { ‘()’: ‘django.utils.log.RequireDebugTrue’, } }, ‘handlers’: { ‘console’: { ‘level’: ‘DEBUG’, ‘filters’: [‘require_debug_true’], ‘class’: ‘logging.StreamHandler’, } }, ‘loggers’: { ‘django.db.backends’: { ‘level’: ‘DEBUG’, ‘handlers’: [‘console’], } } } Tweaked from @acardenas89 answer
See the docs FAQ: “How can I see the raw SQL queries Django is running?” django.db.connection.queries contains a list of the SQL queries: from django.db import connection print(connection.queries) Querysets also have a query attribute containing the query to be executed: print(MyModel.objects.filter(name=”my name”).query) Note that the output of the query is not valid SQL, because: “Django … Read more