We are currently solving the following issue within our repository. Here is the issue text:
--- BEGIN ISSUE ---
Demo mode results in 5XX
## Description
<!-- A clear and concise description of what the bug is. -->

Mathesar is broken (as of 0.1.4) for Demo Mode. It doesn't load, and just says "Server Error (500)" instead.

## Expected behavior
<!-- A clear and concise description of what you expected to happen. -->

Demo mode should work.

## To Reproduce
<!-- How can we recreate this bug? Please try to provide a Minimal, Complete, and Verifiable (http://stackoverflow.com/help/mcve) example if code-related. -->

Change the `.env` file according to the comment to use the demo mode settings, try to build and start mathesar (dev environment is fine)

--- END ISSUE ---

Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
--- BEGIN FILES ---
Path: `mathesar/install.py`
Content:
```
1 """
2 This script installs functions and types for Mathesar onto the configured DB.
3 """
4 import getopt
5 import os
6 import sys
7 
8 import django
9 from django.core import management
10 from decouple import config as decouple_config
11 from django.conf import settings
12 from django.db.utils import IntegrityError
13 from sqlalchemy.exc import OperationalError
14 from db import install
15 
16 
17 def main(skip_static_collection=False):
18     # skip_confirm is temporarily enabled by default as we don't have any use
19     # for interactive prompts with docker only deployments
20     skip_confirm = True
21     (opts, _) = getopt.getopt(sys.argv[1:], ":s", ["skip-confirm"])
22     for (opt, value) in opts:
23         if (opt == "-s") or (opt == "--skip-confirm"):
24             skip_confirm = True
25     os.environ.setdefault("DJANGO_SETTINGS_MODULE", "config.settings.production")
26     django.setup()
27     management.call_command('migrate')
28     debug_mode = decouple_config('DEBUG', default=False, cast=bool)
29     #
30     if not debug_mode and not skip_static_collection:
31         management.call_command('collectstatic', '--noinput', '--clear')
32     print("------------Setting up User Databases------------")
33     django_db_key = decouple_config('DJANGO_DATABASE_KEY', default="default")
34     user_databases = [key for key in settings.DATABASES if key != django_db_key]
35     for database_key in user_databases:
36         try:
37             install_on_db_with_key(database_key, skip_confirm)
38         except IntegrityError:
39             continue
40 
41 
42 def install_on_db_with_key(database_key, skip_confirm):
43     from mathesar.models.base import Database
44     db_model = Database.create_from_settings_key(database_key)
45     db_model.save()
46     try:
47         install.install_mathesar(
48             database_name=db_model.db_name,
49             hostname=db_model.host,
50             username=db_model.username,
51             password=db_model.password,
52             port=db_model.port,
53             skip_confirm=skip_confirm
54         )
55     except OperationalError as e:
56         db_model.delete()
57         raise e
58 
59 
60 if __name__ == "__main__":
61     main()
62
```

Path: `demo/settings.py`
Content:
```
1 from config.settings.production import *  # noqa
2 from config.settings import *  # noqa
3 from decouple import config as decouple_config
4 
5 INSTALLED_APPS += [  # noqa
6     "demo"
7 ]
8 
9 MIDDLEWARE += [  # noqa
10     "demo.middleware.LiveDemoModeMiddleware",
11 ]
12 
13 MATHESAR_LIVE_DEMO = True
14 MATHESAR_LIVE_DEMO_USERNAME = decouple_config('MATHESAR_LIVE_DEMO_USERNAME', default=None)
15 MATHESAR_LIVE_DEMO_PASSWORD = decouple_config('MATHESAR_LIVE_DEMO_PASSWORD', default=None)
16 
17 MATHESAR_DEMO_TEMPLATE = 'mathesar_demo_template'
18 MATHESAR_DEMO_ARXIV_LOG_PATH = decouple_config(
19     'MATHESAR_DEMO_ARXIV_LOG_PATH',
20     default='/var/lib/mathesar/demo/arxiv_db_schema_log'
21 )
22 BASE_TEMPLATE_ADDITIONAL_SCRIPT_TEMPLATES += ['demo/analytics.html'] # noqa
23 ROOT_URLCONF = "demo.urls"
24
```

Path: `demo/management/commands/setup_demo_template_db.py`
Content:
```
1 from sqlalchemy import text
2 from sqlalchemy.exc import OperationalError
3 from django.conf import settings
4 from django.core.management import BaseCommand
5 
6 from db.install import install_mathesar
7 from demo.install.datasets import load_datasets
8 from mathesar.database.base import create_mathesar_engine
9 from mathesar.models.base import Database
10 
11 
12 class Command(BaseCommand):
13     help = 'Initialize the demo template database.'
14 
15     def handle(self, *args, **options):
16         _setup_demo_template_db()
17 
18 
19 def _setup_demo_template_db():
20     print("Initializing demo template database...")
21 
22     template_db_name = settings.MATHESAR_DEMO_TEMPLATE
23     django_model = Database.current_objects.get(name=settings.DATABASES["default"]["NAME"])
24     root_engine = create_mathesar_engine(django_model)
25     with root_engine.connect() as conn:
26         conn.execution_options(isolation_level="AUTOCOMMIT")
27         conn.execute(text(f"DROP DATABASE IF EXISTS {template_db_name} WITH (FORCE)"))
28     root_engine.dispose()
29     db_model, _ = Database.current_objects.get_or_create(
30         name=template_db_name,
31         defaults={
32             'db_name': template_db_name,
33             'username': django_model.username,
34             'password': django_model.password,
35             'host': django_model.host,
36             'port': django_model.port
37         }
38     )
39     try:
40         install_mathesar(
41             database_name=template_db_name,
42             hostname=db_model.host,
43             username=db_model.username,
44             password=db_model.password,
45             port=db_model.port,
46             skip_confirm=True
47         )
48     except OperationalError as e:
49         db_model.delete()
50         raise e
51     user_engine = create_mathesar_engine(db_model)
52     load_datasets(user_engine)
53     user_engine.dispose()
54
```
--- END FILES ---

Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.

Here is an example:

```diff
diff --git a/examples/server_async.py b/examples/server_async.py
--- a/examples/server_async.py
+++ b/examples/server_async.py
@@ -313,4 +313,4 @@
 
 
 if __name__ == "__main__":
-    asyncio.run(run_async_server("."), debug=True)
+    asyncio.run(run_async_server(), debug=True)
diff --git a/examples/server_sync.py b/examples/server_sync.py
--- a/examples/server_sync.py
+++ b/examples/server_sync.py
@@ -313,5 +313,5 @@
 
 
 if __name__ == "__main__":
-    server = run_sync_server(".")
+    server = run_sync_server()
     server.shutdown()

```

diff --git a/demo/management/commands/setup_demo_template_db.py b/demo/management/commands/setup_demo_template_db.py
--- a/demo/management/commands/setup_demo_template_db.py
+++ b/demo/management/commands/setup_demo_template_db.py
@@ -20,7 +20,7 @@
     print("Initializing demo template database...")
 
     template_db_name = settings.MATHESAR_DEMO_TEMPLATE
-    django_model = Database.current_objects.get(name=settings.DATABASES["default"]["NAME"])
+    django_model = Database.create_from_settings_key("default")
     root_engine = create_mathesar_engine(django_model)
     with root_engine.connect() as conn:
         conn.execution_options(isolation_level="AUTOCOMMIT")
diff --git a/demo/settings.py b/demo/settings.py
--- a/demo/settings.py
+++ b/demo/settings.py
@@ -1,5 +1,4 @@
-from config.settings.production import *  # noqa
-from config.settings import *  # noqa
+from config.settings.common_settings import *  # noqa
 from decouple import config as decouple_config
 
 INSTALLED_APPS += [  # noqa
@@ -10,6 +9,7 @@
     "demo.middleware.LiveDemoModeMiddleware",
 ]
 
+MATHESAR_MODE = 'PRODUCTION'
 MATHESAR_LIVE_DEMO = True
 MATHESAR_LIVE_DEMO_USERNAME = decouple_config('MATHESAR_LIVE_DEMO_USERNAME', default=None)
 MATHESAR_LIVE_DEMO_PASSWORD = decouple_config('MATHESAR_LIVE_DEMO_PASSWORD', default=None)
diff --git a/mathesar/install.py b/mathesar/install.py
--- a/mathesar/install.py
+++ b/mathesar/install.py
@@ -37,6 +37,14 @@
             install_on_db_with_key(database_key, skip_confirm)
         except IntegrityError:
             continue
+    if getattr(settings, 'MATHESAR_LIVE_DEMO', False) is True:
+        management.call_command(
+            'createsuperuser',
+            '--no-input',
+            '--username', 'demo',
+            '--email', 'admin@example.com',
+        )
+        management.call_command('setup_demo_template_db')
 
 
 def install_on_db_with_key(database_key, skip_confirm):

{"golden_diff": "diff --git a/demo/management/commands/setup_demo_template_db.py b/demo/management/commands/setup_demo_template_db.py\n--- a/demo/management/commands/setup_demo_template_db.py\n+++ b/demo/management/commands/setup_demo_template_db.py\n@@ -20,7 +20,7 @@\n     print(\"Initializing demo template database...\")\n \n     template_db_name = settings.MATHESAR_DEMO_TEMPLATE\n-    django_model = Database.current_objects.get(name=settings.DATABASES[\"default\"][\"NAME\"])\n+    django_model = Database.create_from_settings_key(\"default\")\n     root_engine = create_mathesar_engine(django_model)\n     with root_engine.connect() as conn:\n         conn.execution_options(isolation_level=\"AUTOCOMMIT\")\ndiff --git a/demo/settings.py b/demo/settings.py\n--- a/demo/settings.py\n+++ b/demo/settings.py\n@@ -1,5 +1,4 @@\n-from config.settings.production import *  # noqa\n-from config.settings import *  # noqa\n+from config.settings.common_settings import *  # noqa\n from decouple import config as decouple_config\n \n INSTALLED_APPS += [  # noqa\n@@ -10,6 +9,7 @@\n     \"demo.middleware.LiveDemoModeMiddleware\",\n ]\n \n+MATHESAR_MODE = 'PRODUCTION'\n MATHESAR_LIVE_DEMO = True\n MATHESAR_LIVE_DEMO_USERNAME = decouple_config('MATHESAR_LIVE_DEMO_USERNAME', default=None)\n MATHESAR_LIVE_DEMO_PASSWORD = decouple_config('MATHESAR_LIVE_DEMO_PASSWORD', default=None)\ndiff --git a/mathesar/install.py b/mathesar/install.py\n--- a/mathesar/install.py\n+++ b/mathesar/install.py\n@@ -37,6 +37,14 @@\n             install_on_db_with_key(database_key, skip_confirm)\n         except IntegrityError:\n             continue\n+    if getattr(settings, 'MATHESAR_LIVE_DEMO', False) is True:\n+        management.call_command(\n+            'createsuperuser',\n+            '--no-input',\n+            '--username', 'demo',\n+            '--email', 'admin@example.com',\n+        )\n+        management.call_command('setup_demo_template_db')\n \n \n def install_on_db_with_key(database_key, skip_confirm):\n", "issue": "Demo mode results in 5XX\n## Description\r\n<!-- A clear and concise description of what the bug is. -->\r\n\r\nMathesar is broken (as of 0.1.4) for Demo Mode. It doesn't load, and just says \"Server Error (500)\" instead.\r\n\r\n## Expected behavior\r\n<!-- A clear and concise description of what you expected to happen. -->\r\n\r\nDemo mode should work.\r\n\r\n## To Reproduce\r\n<!-- How can we recreate this bug? Please try to provide a Minimal, Complete, and Verifiable (http://stackoverflow.com/help/mcve) example if code-related. -->\r\n\r\nChange the `.env` file according to the comment to use the demo mode settings, try to build and start mathesar (dev environment is fine)\n", "before_files": [{"content": "\"\"\"\nThis script installs functions and types for Mathesar onto the configured DB.\n\"\"\"\nimport getopt\nimport os\nimport sys\n\nimport django\nfrom django.core import management\nfrom decouple import config as decouple_config\nfrom django.conf import settings\nfrom django.db.utils import IntegrityError\nfrom sqlalchemy.exc import OperationalError\nfrom db import install\n\n\ndef main(skip_static_collection=False):\n    # skip_confirm is temporarily enabled by default as we don't have any use\n    # for interactive prompts with docker only deployments\n    skip_confirm = True\n    (opts, _) = getopt.getopt(sys.argv[1:], \":s\", [\"skip-confirm\"])\n    for (opt, value) in opts:\n        if (opt == \"-s\") or (opt == \"--skip-confirm\"):\n            skip_confirm = True\n    os.environ.setdefault(\"DJANGO_SETTINGS_MODULE\", \"config.settings.production\")\n    django.setup()\n    management.call_command('migrate')\n    debug_mode = decouple_config('DEBUG', default=False, cast=bool)\n    #\n    if not debug_mode and not skip_static_collection:\n        management.call_command('collectstatic', '--noinput', '--clear')\n    print(\"------------Setting up User Databases------------\")\n    django_db_key = decouple_config('DJANGO_DATABASE_KEY', default=\"default\")\n    user_databases = [key for key in settings.DATABASES if key != django_db_key]\n    for database_key in user_databases:\n        try:\n            install_on_db_with_key(database_key, skip_confirm)\n        except IntegrityError:\n            continue\n\n\ndef install_on_db_with_key(database_key, skip_confirm):\n    from mathesar.models.base import Database\n    db_model = Database.create_from_settings_key(database_key)\n    db_model.save()\n    try:\n        install.install_mathesar(\n            database_name=db_model.db_name,\n            hostname=db_model.host,\n            username=db_model.username,\n            password=db_model.password,\n            port=db_model.port,\n            skip_confirm=skip_confirm\n        )\n    except OperationalError as e:\n        db_model.delete()\n        raise e\n\n\nif __name__ == \"__main__\":\n    main()\n", "path": "mathesar/install.py"}, {"content": "from config.settings.production import *  # noqa\nfrom config.settings import *  # noqa\nfrom decouple import config as decouple_config\n\nINSTALLED_APPS += [  # noqa\n    \"demo\"\n]\n\nMIDDLEWARE += [  # noqa\n    \"demo.middleware.LiveDemoModeMiddleware\",\n]\n\nMATHESAR_LIVE_DEMO = True\nMATHESAR_LIVE_DEMO_USERNAME = decouple_config('MATHESAR_LIVE_DEMO_USERNAME', default=None)\nMATHESAR_LIVE_DEMO_PASSWORD = decouple_config('MATHESAR_LIVE_DEMO_PASSWORD', default=None)\n\nMATHESAR_DEMO_TEMPLATE = 'mathesar_demo_template'\nMATHESAR_DEMO_ARXIV_LOG_PATH = decouple_config(\n    'MATHESAR_DEMO_ARXIV_LOG_PATH',\n    default='/var/lib/mathesar/demo/arxiv_db_schema_log'\n)\nBASE_TEMPLATE_ADDITIONAL_SCRIPT_TEMPLATES += ['demo/analytics.html'] # noqa\nROOT_URLCONF = \"demo.urls\"\n", "path": "demo/settings.py"}, {"content": "from sqlalchemy import text\nfrom sqlalchemy.exc import OperationalError\nfrom django.conf import settings\nfrom django.core.management import BaseCommand\n\nfrom db.install import install_mathesar\nfrom demo.install.datasets import load_datasets\nfrom mathesar.database.base import create_mathesar_engine\nfrom mathesar.models.base import Database\n\n\nclass Command(BaseCommand):\n    help = 'Initialize the demo template database.'\n\n    def handle(self, *args, **options):\n        _setup_demo_template_db()\n\n\ndef _setup_demo_template_db():\n    print(\"Initializing demo template database...\")\n\n    template_db_name = settings.MATHESAR_DEMO_TEMPLATE\n    django_model = Database.current_objects.get(name=settings.DATABASES[\"default\"][\"NAME\"])\n    root_engine = create_mathesar_engine(django_model)\n    with root_engine.connect() as conn:\n        conn.execution_options(isolation_level=\"AUTOCOMMIT\")\n        conn.execute(text(f\"DROP DATABASE IF EXISTS {template_db_name} WITH (FORCE)\"))\n    root_engine.dispose()\n    db_model, _ = Database.current_objects.get_or_create(\n        name=template_db_name,\n        defaults={\n            'db_name': template_db_name,\n            'username': django_model.username,\n            'password': django_model.password,\n            'host': django_model.host,\n            'port': django_model.port\n        }\n    )\n    try:\n        install_mathesar(\n            database_name=template_db_name,\n            hostname=db_model.host,\n            username=db_model.username,\n            password=db_model.password,\n            port=db_model.port,\n            skip_confirm=True\n        )\n    except OperationalError as e:\n        db_model.delete()\n        raise e\n    user_engine = create_mathesar_engine(db_model)\n    load_datasets(user_engine)\n    user_engine.dispose()\n", "path": "demo/management/commands/setup_demo_template_db.py"}], "after_files": [{"content": "\"\"\"\nThis script installs functions and types for Mathesar onto the configured DB.\n\"\"\"\nimport getopt\nimport os\nimport sys\n\nimport django\nfrom django.core import management\nfrom decouple import config as decouple_config\nfrom django.conf import settings\nfrom django.db.utils import IntegrityError\nfrom sqlalchemy.exc import OperationalError\nfrom db import install\n\n\ndef main(skip_static_collection=False):\n    # skip_confirm is temporarily enabled by default as we don't have any use\n    # for interactive prompts with docker only deployments\n    skip_confirm = True\n    (opts, _) = getopt.getopt(sys.argv[1:], \":s\", [\"skip-confirm\"])\n    for (opt, value) in opts:\n        if (opt == \"-s\") or (opt == \"--skip-confirm\"):\n            skip_confirm = True\n    os.environ.setdefault(\"DJANGO_SETTINGS_MODULE\", \"config.settings.production\")\n    django.setup()\n    management.call_command('migrate')\n    debug_mode = decouple_config('DEBUG', default=False, cast=bool)\n    #\n    if not debug_mode and not skip_static_collection:\n        management.call_command('collectstatic', '--noinput', '--clear')\n    print(\"------------Setting up User Databases------------\")\n    django_db_key = decouple_config('DJANGO_DATABASE_KEY', default=\"default\")\n    user_databases = [key for key in settings.DATABASES if key != django_db_key]\n    for database_key in user_databases:\n        try:\n            install_on_db_with_key(database_key, skip_confirm)\n        except IntegrityError:\n            continue\n    if getattr(settings, 'MATHESAR_LIVE_DEMO', False) is True:\n        management.call_command(\n            'createsuperuser',\n            '--no-input',\n            '--username', 'demo',\n            '--email', 'admin@example.com',\n        )\n        management.call_command('setup_demo_template_db')\n\n\ndef install_on_db_with_key(database_key, skip_confirm):\n    from mathesar.models.base import Database\n    db_model = Database.create_from_settings_key(database_key)\n    db_model.save()\n    try:\n        install.install_mathesar(\n            database_name=db_model.db_name,\n            hostname=db_model.host,\n            username=db_model.username,\n            password=db_model.password,\n            port=db_model.port,\n            skip_confirm=skip_confirm\n        )\n    except OperationalError as e:\n        db_model.delete()\n        raise e\n\n\nif __name__ == \"__main__\":\n    main()\n", "path": "mathesar/install.py"}, {"content": "from config.settings.common_settings import *  # noqa\nfrom decouple import config as decouple_config\n\nINSTALLED_APPS += [  # noqa\n    \"demo\"\n]\n\nMIDDLEWARE += [  # noqa\n    \"demo.middleware.LiveDemoModeMiddleware\",\n]\n\nMATHESAR_MODE = 'PRODUCTION'\nMATHESAR_LIVE_DEMO = True\nMATHESAR_LIVE_DEMO_USERNAME = decouple_config('MATHESAR_LIVE_DEMO_USERNAME', default=None)\nMATHESAR_LIVE_DEMO_PASSWORD = decouple_config('MATHESAR_LIVE_DEMO_PASSWORD', default=None)\n\nMATHESAR_DEMO_TEMPLATE = 'mathesar_demo_template'\nMATHESAR_DEMO_ARXIV_LOG_PATH = decouple_config(\n    'MATHESAR_DEMO_ARXIV_LOG_PATH',\n    default='/var/lib/mathesar/demo/arxiv_db_schema_log'\n)\nBASE_TEMPLATE_ADDITIONAL_SCRIPT_TEMPLATES += ['demo/analytics.html'] # noqa\nROOT_URLCONF = \"demo.urls\"\n", "path": "demo/settings.py"}, {"content": "from sqlalchemy import text\nfrom sqlalchemy.exc import OperationalError\nfrom django.conf import settings\nfrom django.core.management import BaseCommand\n\nfrom db.install import install_mathesar\nfrom demo.install.datasets import load_datasets\nfrom mathesar.database.base import create_mathesar_engine\nfrom mathesar.models.base import Database\n\n\nclass Command(BaseCommand):\n    help = 'Initialize the demo template database.'\n\n    def handle(self, *args, **options):\n        _setup_demo_template_db()\n\n\ndef _setup_demo_template_db():\n    print(\"Initializing demo template database...\")\n\n    template_db_name = settings.MATHESAR_DEMO_TEMPLATE\n    django_model = Database.create_from_settings_key(\"default\")\n    root_engine = create_mathesar_engine(django_model)\n    with root_engine.connect() as conn:\n        conn.execution_options(isolation_level=\"AUTOCOMMIT\")\n        conn.execute(text(f\"DROP DATABASE IF EXISTS {template_db_name} WITH (FORCE)\"))\n    root_engine.dispose()\n    db_model, _ = Database.current_objects.get_or_create(\n        name=template_db_name,\n        defaults={\n            'db_name': template_db_name,\n            'username': django_model.username,\n            'password': django_model.password,\n            'host': django_model.host,\n            'port': django_model.port\n        }\n    )\n    try:\n        install_mathesar(\n            database_name=template_db_name,\n            hostname=db_model.host,\n            username=db_model.username,\n            password=db_model.password,\n            port=db_model.port,\n            skip_confirm=True\n        )\n    except OperationalError as e:\n        db_model.delete()\n        raise e\n    user_engine = create_mathesar_engine(db_model)\n    load_datasets(user_engine)\n    user_engine.dispose()\n", "path": "demo/management/commands/setup_demo_template_db.py"}]}