AzureにDjangoで作ったwebアプリのContainerをデプロイしてみる

poetry add django

poetry run django-admin startproject sampleProject .

poetry run python manage.py startapp sample

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

from django.http import HttpResponse

def index(request):
    return HttpResponse('Hello Sample')

from django.contrib import admin
from django.urls import path, include

urlpatterns = [
    path('admin/', admin.site.urls),
    path('sample/', include('sample.urls')) # add
]

from django.urls import path

from . import views

urlpatterns = [
    path('', views.index),
]

poetry run python manage.py migrate

poetry run python manage.py runserver

FROM python:3.8-slim-buster

ENV PYTHONUNBUFFERED=1
EXPOSE 8000

WORKDIR /app
COPY . .

RUN pip install poetry
RUN poetry config virtualenvs.create false
RUN poetry update
RUN python manage.py migrate
RUN chmod 744 ./startup.sh

ENTRYPOINT ["./startup.sh"]

#!/bin/bash
python manage.py runserver 0.0.0.0:8000

docker build -t sample-django .
docker run -p 8000:8000 sample-django

poetry add uvicorn gunicorn

#!/bin/bash
#python manage.py runserver 0.0.0.0:8000
gunicorn sampleProject.asgi:application -w 2 -k uvicorn.workers.UvicornWorker --bind 0.0.0.0:8000

ALLOWED_HOSTS = ['*.azurewebsites.net']

ALLOWED_HOSTS = ['*']

poetry add python-dotenv

import os
from dotenv import load_dotenv
load_dotenv(verbose=True)

SECRET_KEY = os.getenv('SECRET_KEY')

ALLOWED_HOSTS = ['(WebApps名).azurewebsites.net']

version: "3"

services:
  db:
    platform: linux/x86_64
    image: mcr.microsoft.com/mssql/server:2019-latest
    environment:
      ACCEPT_EULA: Y
      MSSQL_SA_PASSWORD: P@ssw0rd
      TZ: "Asia/Tokyo"
    volumes:
      - ./volumes/db/data:/var/opt/mssql
    ports:
      - 1433:1433

% poetry add aldjemy
Using version ^2.6 for aldjemy

Updating dependencies
Resolving dependencies... (6.0s)

Writing lock file

Package operations: 3 installs, 0 updates, 0 removals

  - Installing greenlet (1.1.2)
  - Installing sqlalchemy (1.4.34)
  - Installing aldjemy (2.6)

% poetry add mssql-django
Using version ^1.1.2 for mssql-django

Updating dependencies
Resolving dependencies... (0.9s)

Writing lock file

Package operations: 3 installs, 0 updates, 0 removals

  - Installing pyodbc (4.0.32)
  - Installing pytz (2022.1)
  - Installing mssql-django (1.1.2)

ALDJEMY_ENGINES = {
    "mssql": 'mssql+pyodbc'
}
DATABASES = {
    "default": {
        "ENGINE": "mssql",
        "NAME": os.getenv('MS_DB_NAME', ''),
        "USER": os.getenv('MS_DB_USER', ''),
        "PASSWORD": os.getenv('MS_DB_PASSWORD', ''),
        "HOST": os.getenv('MS_DB_HOST', 'localhost'),
        "PORT": os.getenv('MS_DB_PORT', '1433'),
        "OPTIONS": {
            "driver": os.getenv('MS_DB_DRIVER', 'ODBC Driver 18 for SQL Server'),
        },
    },
}

class User(models.Model):
    id = models.IntegerField(primary_key=True)
    username = models.CharField(max_length=16)
    email = models.EmailField(max_length=254)
    password = models.CharField(max_length=128)

from sample.models import User

User.sa.query().all()

users = [{k: v for k, v in u.__dict__.items() if k != "_sa_instance_state"}
         for u in User.sa.query().all()]

django.db.utils.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate] (-1) (SQLDriverConnect)')

ALDJEMY_ENGINES = {
    "mssql": 'mssql+pyodbc'
}
DATABASES = {
    "default": {
        "ENGINE": "mssql",
        "NAME": os.getenv('MS_DB_NAME', ''),
        "USER": os.getenv('MS_DB_USER', ''),
        "PASSWORD": os.getenv('MS_DB_PASSWORD', ''),
        "HOST": os.getenv('MS_DB_HOST', 'localhost'),
        "PORT": os.getenv('MS_DB_PORT', '1433'),
        "OPTIONS": {
            "driver": os.getenv('MS_DB_DRIVER', 'ODBC Driver 18 for SQL Server'),
            "extra_params": "TrustServerCertificate=yes",
        },
    },
}