اتصال به دیتابیس MSSQL در برنامه‌های Django

pip install mssql-django

# other codes ...
import os
DATABASES = {   
    'default': {
        'ENGINE': 'mssql',
        'NAME':     os.getenv("MSSQL_DB_NAME"),
        'USER':     os.getenv("MSSQL_DB_USER"),
        'PASSWORD': os.getenv("MSSQL_DB_PASS"),
        'HOST':     os.getenv("MSSQL_DB_HOST"),
        'PORT':     os.getenv("MSSQL_DB_PORT"),
        'OPTIONS': {
            'driver': 'ODBC Driver 18 for SQL Server',
            'extra_params': 'Encrypt=no;',
        }
    }
}
# other codes ...

MSSQL_DB_HOST=bromo.liara.cloud
MSSQL_DB_PORT=34119
MSSQL_DB_USER=sa
MSSQL_DB_PASS=8qLDc1Xco1Q4X0lqgjy4HWc2
MSSQL_DB_NAME=db

pip freeze > requirements.txt

python manage.py startapp mssql_app

# Application definition

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

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

def check_mssql_connection(request):
    try:
        connection = connections['mssql']
        connection.ensure_connection()
        return HttpResponse("MSSQL connection successful")
    except Exception as e:
        return HttpResponse(f"MSSQL connection failed: {e}")

from django.urls import path
from .views import check_postgresql_connection

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

from django.urls import include, path

urlpatterns = [
    path('mssql/', include('mssql_app.urls')),
]

DATABASES = {   
    'default': {
        'ENGINE': 'mssql',
        'NAME':     os.getenv("MSSQL_DB_NAME"),
        'USER':     os.getenv("MSSQL_DB_USER"),
        'PASSWORD': os.getenv("MSSQL_DB_PASS"),
        'HOST':     os.getenv("MSSQL_DB_HOST"),
        'PORT':     os.getenv("MSSQL_DB_PORT"),
        'OPTIONS': {
            'driver': 'ODBC Driver 18 for SQL Server',
            'extra_params': 'Encrypt=no;',
        }
    }
}

DATABASE_CONNECTION_POOLING = True # add this

# other codes ...
import os
DATABASES = {   
    'default': {
        'ENGINE': 'mssql',
        'NAME':     os.getenv("MSSQL_DB_NAME"),
        'USER':     os.getenv("MSSQL_DB_USER"),
        'PASSWORD': os.getenv("MSSQL_DB_PASS"),
        'HOST':     os.getenv("MSSQL_DB_HOST"),
        'PORT':     os.getenv("MSSQL_DB_PORT"),
        'OPTIONS': {
            'driver': 'ODBC Driver 18 for SQL Server',
            'extra_params': 'Encrypt=no;',
            'MARS_Connection': True,
            'Connection Timeout': 30,
            'pool_options': {
                'min': 5,   
                'max': 20,  
                'increment': 5
            },
        }
    }
}

DATABASE_CONNECTION_POOLING = True
# other codes ...