「スマホでも使いやすいようにVeu.jsを導入、ついでにコンテナ化 その③ バックエンド」わたしのWebサービス開発日記 #15

$ tree -L 3
.
├── db
│   ├── Dockerfile
│   ├── dml
│   │   └── sightseeing.csv
│   ├── init.sql
│   └── my.cnf
├── django
│   ├── Dockerfile
│   ├── django_project
│   │   ├── ・・・【略】・・・
│   ├── entrypoint.sh
│   └── requirements.txt
├── docker-compose.yml
├── nginx
│   ├── conf.d
│   │   └── default.conf
│   └── dist
│       └── index.html
└── vue
    ├── Dockerfile
    └── frontend
        ├── README.md
        ├── babel.config.js
        ├── jsconfig.json
        ├── node_modules
        ├── package-lock.json
        ├── package.json
        ├── public
        ├── src
        └── vue.config.js

version: '3.8'
 
services:
  nginx:
    image: nginx:latest
    container_name: nginx-container
    restart: always
    ports:
      - "80:80"
      - "443:443"
    environment:
      TZ: "Asia/Tokyo"
    volumes:
      - ./nginx/conf.d/default.conf:/etc/nginx/conf.d/default.conf
    depends_on:
      - frontend
      - backend

  frontend:
    container_name: frontend-container
    build:
      context: ./vue
      dockerfile: ./Dockerfile
    ports:
      - 8080:8080
    volumes:
      - ./vue/frontend:/app
    working_dir: /app
    tty: true
    command: sh -c "HOST=0.0.0.0 npm run serve"
    depends_on:
      - backend

  backend:
    container_name: backend-container
    build:
      context: ./django
      dockerfile: ./Dockerfile
    restart: always
    ports:
      - "8000:8000"
    command: sh -c "/code/entrypoint.sh"
    volumes:
      - ./django/entrypoint.sh:/code/entrypoint.sh
      - ./django/django_project:/code
    depends_on:
      db:
        condition: service_healthy

  db:
    container_name: db-container
    build:
      context: ./db
      dockerfile: ./Dockerfile
    restart: always
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=test_db
      - MYSQL_USER=test_user
      - MYSQL_PASSWORD=test_passwd
      - ALLOWED_HOSTS=localhost 127.0.0.1 [::1]
      - DEBUG=True
    ports:
      - 3306:3306
    volumes:
      - ./db/dml:/tmp/dml
    healthcheck:
      test: mysqladmin ping -h 127.0.0.1 -u$$MYSQL_USER -p$$MYSQL_PASSWORD
      interval: 10s
      timeout: 10s
      retries: 4
      # ヘルスチェックが失敗しても無視する時間は30秒
      start_period: 30s

FROM python:3.8
# PYTHONDONTWRITEBYTECODEとPYTHONUNBUFFEREDはオプション
# pycファイル(および__pycache__)の生成を行わないようにする
ENV PYTHONDONTWRITEBYTECODE=1
# 標準出力・標準エラーのストリームのバッファリングを行わない
ENV PYTHONUNBUFFERED=1

WORKDIR /code

COPY ./requirements.txt /code/

RUN apt-get update && apt-get install -y tzdata \
    libgdal-dev

RUN pip install --upgrade pip

RUN pip install -r requirements.txt
RUN pip install GDAL==$(gdal-config --version) --global-option=build_ext --global-option="-I/usr/include/gdal"

COPY ./django_project/code/
COPY ./entrypoint.sh /code/

RUN chmod 755 entrypoint.sh

#!/bin/sh
python manage.py makemigrations --noinput
python manage.py migrate --noinput
python manage.py collectstatic --noinput
gunicorn --bind 0.0.0.0:8000 django_project.wsgi

Django==4.1.4
django-hosts==5.1
django-leaflet==0.28.3
mysql-connector-python==8.0.29
mysqlclient==2.1.1
gunicorn==20.1.0
fontawesomefree==6.3.0
djangorestframework==3.14.0
requests==2.31.0
whitenoise==6.6.0
django-cors-headers==4.3.1

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'test_db',
        'USER': 'test_user',
        'PASSWORD': 'test_passwd',
        'HOST': 'db',
        'OPTIONS': {
            'charset': 'utf8mb4',
        },
    }
}

FROM mysql:8.0.35

COPY ./my.cnf /etc/mysql/conf.d/my.cnf
COPY ./init.sql /docker-entrypoint-initdb.d

[mysqld]
character_set_server=utf8mb4
collation_server=utf8mb4_bin
local-infile=1

socket=/run/mysqld/mysqld.sock
default_time_zone=SYSTEM
log_timestamps=SYSTEM
# MySQL8.0以上用のデフォルト認証プラグインの設定
default_authentication_plugin=caching_sha2_password

[mysql]
default_character_set=utf8mb4
local-infile=1

# mysqlクライアントツールの設定
[client]
default_character_set=utf8mb4

GRANT all ON *.* TO test_user@'%';
uSE django_db;
SET GLOBAL local_infile = 1;
SHOW VARIABLES LIKE 'local_infile';
CREATE TABLE `my_table` (【略】);
LOAD DATA LOCAL INFILE '/tmp/dml/sightseeing.csv' INTO TABLE `my_table` FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 LINES;

[mysqld]
character_set_server=utf8mb4
collation_server=utf8mb4_bin
local-infile=1

・・・【略】・・・

[mysql]
default_character_set=utf8mb4
local-infile=1

・・・【略】・・・

・・・【略】・・・
SET GLOBAL local_infile = 1;
・・・【略】・・・