FROM python:3
ENV PYTHONUNBUFFERED 1
RUN mkdir /code
WORKDIR /code
ADD requirements.txt /code/
RUN pip install -r requirements.txt
ADD . /code/

Django==3.2
mysqlclient
pylint-django

version: '3'

services:
  db:
    image: mysql:5.7
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_USER: 'django'
      MYSQL_PASSWORD: 'django'
      MYSQL_DATABASE: 'django'
    ports:
      - 3306:3307
    volumes:
      - mysql:/var/lib/mysql
  web:
    build: .
    command: python3 manage.py runserver 0.0.0.0:8000
    volumes:
      - .:/code
    ports:
      - "8000:8000"
    links:
      - db

volumes:
  mysql:
    driver: local

docker-compose run web django-admin.py startproject composeexample .

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'django',
        'USER': 'django',
        'PASSWORD': 'django',
        'HOST': 'db',
        'PORT': 3306,
    }
}

docker-compose up

LANGUAGE_CODE = 'ja'

TIME_ZONE = 'Asia/Tokyo'

docker-compose -f docker-compose.yml up -d

docker exec -it django-mysql-docker-test_web_1 bash

python manage.py startapp polls

python manage.py makemigrations
python manage.py migrate

name: GitHub Actions Demo
on: [push]
jobs:
  Explore-GitHub-Actions:
    runs-on: ubuntu-latest
    steps:
      - run: echo "🎉 The job was automatically triggered by a ${{ github.event_name }} event."
      - run: echo "🐧 This job is now running on a ${{ runner.os }} server hosted by GitHub!"
      - run: echo "🔎 The name of your branch is ${{ github.ref }} and your repository is ${{ github.repository }}."
      - name: Check out repository code
        uses: actions/checkout@v3
      - run: echo "💡 The ${{ github.repository }} repository has been cloned to the runner."
      - run: echo "🖥️ The workflow is now ready to test your code on the runner."
      - name: List files in the repository
        run: |
          ls ${{ github.workspace }}
      - run: echo "🍏 This job's status is ${{ job.status }}."

version: '3'

services:
  db:
    image: mysql:5.7
    container_name: test-mysql
    environment:
      MYSQL_HOST: 'mysqlhost'
      MYSQL_ROOT_PASSWORD: root
      MYSQL_USER: 'django'
      MYSQL_PASSWORD: 'django'
      MYSQL_DATABASE: 'django'
    ports:
      - 3307:3306
    volumes:
      - mysql:/var/lib/mysql
  web:
    container_name: test-django
    build: .
    command: python3 manage.py runserver 0.0.0.0:8000
    volumes:
      - .:/code
    ports:
      - "8000:8000"
    links:
      - db
  schemaspy:
    container_name: schemaspy
    image: schemaspy/schemaspy:6.1.0
    volumes:
      - ./schemaspy/output:/output
      - ./schemaspy/meta:/meta
    # image: schemaspy/schemaspy:snapshot
    # tty: true
    # volumes:
    #   - ./.dev/schemaspy/output:/output
    depends_on:
      - db
    command: >
      java -jar schemaspy.jar
      -t mysql
      -host db
      -port 3306
      -db django
      -u django
      -p django
      -s django
      -connprops useSSL\\=false

volumes:
  mysql:
    driver: local

name: GitHub Shemaspy test
on: [push]
jobs:
  schemaspy:
    runs-on: ubuntu-latest
    services:
        mysql:
          image: mysql:5.7
          options: >-
            --health-cmd "mysqladmin ping -h localhost"
            --health-interval 20s
            --health-timeout 10s
            --health-retries 10
          env:
            MYSQL_USER: django
            MYSQL_PASSWORD: django
          ports:
            - 3306
    steps:
        - uses: actions/checkout@v2
        - name: compose-run
        shell: bash
        run: |
          docker-compose up -d

name: GitHub Shemaspy test
on: [push]
jobs:
  schemaspy:
    runs-on: ubuntu-latest
    steps:
        - uses: actions/checkout@v2
        - name: compose-run
          shell: bash
          run: |
            docker-compose up -d

name: GitHub Shemaspy test
on: [push]
jobs:
  schemaspy:
    runs-on: ubuntu-latest
    steps:
        - uses: actions/checkout@v2
        - name: file-check-init
          shell: bash
          run: |
            sudo mkdir -p schemaspy
            sudo mkdir -p schemaspy/output
            sudo chmod 777 schemaspy
            sudo chmod 777 schemaspy/output
            ls
        - name: compose-run
          shell: bash
          run: |
            docker-compose up -d
            sleep 60s
        - name: migrate
          shell: bash
          run: |
            docker exec -t test-django python manage.py migrate
            sleep 60s
        - name: compose-schemaspy
          shell: bash
          run: |
            docker-compose -f docker-compose.yml up --build schemaspy
            sleep 60s
        - name: file-check-1
          shell: bash
          run: |
            ls -a
        - name: file-check-2
          shell: bash
          run: |
            ls -a schemaspy/
            ls -a schemaspy/output/
        - name: file-check-3
          shell: bash
          run: |
            ls -a schemaspy/output/

version: '3'

services:
  db:
    image: mysql:5.7
    container_name: test-mysql
    environment:
      MYSQL_HOST: 'mysqlhost'
      MYSQL_ROOT_PASSWORD: root
      MYSQL_USER: 'django'
      MYSQL_PASSWORD: 'django'
      MYSQL_DATABASE: 'django'
    ports:
      - 3307:3306
    volumes:
      - mysql:/var/lib/mysql
  web:
    container_name: test-django
    build: .
    command: python3 manage.py runserver 0.0.0.0:8000
    volumes:
      - .:/code
    ports:
      - "8000:8000"
    links:
      - db
  schemaspy:
    container_name: schemaspy
    image: schemaspy/schemaspy:6.1.0
    volumes:
      - ./schemaspy/output:/output
      - ./schemaspy/meta:/meta
    # image: schemaspy/schemaspy:snapshot
    # tty: true
    # volumes:
    #   - ./.dev/schemaspy/output:/output
    depends_on:
      - db
    command: >
      java -jar schemaspy.jar
      -t mysql
      -host db
      -port 3306
      -db django
      -u django
      -p django
      -s django
      -connprops useSSL\\=false

volumes:
  mysql:
    driver: local
  
  

- uses: montudor/action-zip@v0.1.1
  with:
    args: zip -qq -r schemaspy/output.zip schemaspy/output

- name: Upload to slack channel
  uses: adrey/slack-file-upload-action@master
    with:
      token: ${{ secrets.SLACK_TOKEN }}
      path: schemaspy/output.zip
      channel: github-actions-test