اتصال به دیتابیس MySQL/MariaDB در برنامه‌های Django

pip install mysqlclient

# other codes ...
import os
DATABASES = {
    'default': {
        'ENGINE':   'django.db.backends.mysql', 
        'NAME':     os.getenv("MYSQL_DB_NAME"), 
        'USER':     os.getenv("MYSQL_DB_USER"),
        'PASSWORD': os.getenv("MYSQL_DB_PASS"),
        'HOST':     os.getenv("MYSQL_DB_HOST"),
        'PORT':     os.getenv("MYSQL_DB_PORT"),
    },
}
# other codes ...

MYSQL_DB_HOST=bromo.liara.cloud
MYSQL_DB_PORT=33035
MYSQL_DB_USER=root
MYSQL_DB_PASS=gIg1uXioTrGDZOESQf0YXE87
MYSQL_DB_NAME=compassionate_heisenberg

pip freeze > requirements.txt

python manage.py startapp mysql_app

# Application definition

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'mysql_app', # add this
]

from django.shortcuts import HttpResponse
from django.db import connections

def check_mysql_connection(request):
    try:
        with connections['default'].cursor() as cursor:
            cursor.execute("SELECT 1")
            result = cursor.fetchone()
        if result:
            return HttpResponse("MySQL connection successful")
        else:
            return HttpResponse("MySQL connection failed")
    except Exception as e:
        return HttpResponse(f"MySQL connection failed: {e}")

from django.urls import path
from .views import check_mysql_connection

urlpatterns = [
    path('', check_mysql_connection, name='check_mysql_connection'),
]

from django.urls import include, path

urlpatterns = [
    path('mysql/', include('mysql_app.urls')),
    
]

pip install django-db-connection-pool[mysql]

# other codes ...
import os
DATABASES = {
    'default': {
        'ENGINE':   'dj_db_conn_pool.backends.mysql', 
        'NAME':     os.getenv("MYSQL_DB_NAME"), 
        'USER':     os.getenv("MYSQL_DB_USER"),
        'PASSWORD': os.getenv("MYSQL_DB_PASS"),
        'HOST':     os.getenv("MYSQL_DB_HOST"),
        'PORT':     os.getenv("MYSQL_DB_PORT"),
    },
}
# other codes ...

# other codes ...
import os
DATABASES = {
    'default': {
        'ENGINE':   'dj_db_conn_pool.backends.mysql', 
        'NAME':     os.getenv("MYSQL_DB_NAME"), 
        'USER':     os.getenv("MYSQL_DB_USER"),
        'PASSWORD': os.getenv("MYSQL_DB_PASS"),
        'HOST':     os.getenv("MYSQL_DB_HOST"),
        'PORT':     os.getenv("MYSQL_DB_PORT"),
        'POOL_OPTIONS': {
            'POOL_SIZE': 10,
            'MAX_OVERFLOW': 10,
            'RECYCLE': 24 * 60 * 60
        }
    },
}
# other codes ...

pip freeze > requirements.txt