How to Create a New Database and Run Migrations Dynamically in Django?

I have an application where I need to create a new database and run migrations to create tables. Here is my current implementation:

def create_database(db_name):
    with connection.cursor() as cursor:
        try:
            cursor.execute(f"CREATE DATABASE IF NOT EXISTS {db_name}")
            return True
        except Exception as e:
            print(f"Error creating database {db_name}: {str(e)}")
            return False

The code above successfully creates the database.

def run_migrations(db_name, app_names):
  
    new_db_settings = copy.deepcopy(settings.DATABASES['default'])
    new_db_settings.update({
        'NAME': db_name,
    })

    settings.DATABASES['default'] = new_db_settings

    try:
 

        with TemporaryOverrideSettings({'default': new_db_settings}):
            call_command('makemigrations', app_names) 
            call_command('migrate', app_names, database=db_name)
    except Exception as e:  # Handle potential errors gracefully
        print(f"Error encountered while checking migrations: {e}")

The run_migrations function is intended to run the migrations. The makemigrations command runs successfully, but the migrate command does not work for the new database.

My requirement is to always create the database and run migrations on each request. However, since there might not be new changes, the migrations might not need to run every time.

Issue:

The migrate command does not work as expected for the new database after running makemigrations.

Questions:

How can I ensure that the migrate command runs correctly on the new database? Is there a better approach to handle dynamic database creation and migrations in Django? Any help or suggestions would be greatly appreciated. Thanks!

The migrate command does not work as expected for the new database after running makemigrations.