version: '3.3'

services:
  tomato:
    image: jessopb/zeppitomato:${ZEPPITOMATO_VERSION}
    ports:
      - 3000:3000
    build:
      context: ./
      dockerfile: Dockerfile
    volumes:
      - ./:/usr/src/app
      - /usr/src/app/node_modules
      - /usr/src/app/.next
  db:
    image: ${DB_IMAGE}
    volumes:
      - mysqldata:/var/lib/mysql
    environment:
      MYSQL_DATABASE: mydb
      MYSQL_USER: myuser
      MYSQL_ROOT_PASSWORD_FILE: /run/secrets/db_password
      MYSQL_PASSWORD_FILE: /run/secrets/db_password
    secrets:
      - db_password      
  backup:
    image: woolfg/mysql-backup-sidecar:${VERSION_TAG}
    volumes:
      - mysqldata:/var/lib/mysql
      - backup:/backup
    environment:
      CRON_SCHEDULE: "5 3 * * *"
      INCREMENTAL: "true"
      COMPRESS_THREADS: 1
      BACKUP_DIR: /backup
      DIR_DATE_PATTERN: "%Y%m%d"
      
      FULL_BACKUP_DATE_FORMAT: "%a"
      FULL_BACKUP_DATE_RESULT: "Sun"

      ROTATION1_DAYS: 6
      ROTATION1_DATE_FORMAT: "%a"
      ROTATION1_DATE_RESULT: "Sun"

      ROTATION2_DAYS: 30
      ROTATION2_DATE_FORMAT: "%d"
      ROTATION2_DATE_RESULT: "<8"

      ROTATION3_DAYS: 365
      ROTATION3_DATE_FORMAT: "%m"
      ROTATION3_DATE_RESULT: "01"

      MYSQL_USER: root
      MYSQL_PASSWORD_FILE: /run/secrets/db_password
    secrets:
      - db_password

volumes:
  mysqldata:
  backup:
    
secrets:
  db_password:
    file: db_secret