docker-compose.yml

version: "3.5"
services:
  db:
    container_name: "${PG_CONTAINER_NAME}"
    # will change to postgres:12.16-bullseye
    image: timescale/timescaledb:latest-pg14
    environment:
      POSTGRES_PASSWORD: "smae"
      POSTGRES_USER: "smae"
      POSTGRES_DB: smae_dev_persistent
    networks:
      - postgres
    volumes:
      - pgdata:/var/lib/postgresql/data
    ports:
      - "${BIND_INTERFACE}${PG_DB_LISTEN}:5432"
    logging:
      driver: "json-file"
      options:
        max-file: "2"
        max-size: 100MB
    restart: unless-stopped

  # RAM ~ 1.5gb max
  metabase:
    image: metabase/metabase:latest
    container_name: "${API_CONTAINER_NAME}_metabase"
    restart: unless-stopped
    hostname: metabase
    volumes:
      - /dev/urandom:/dev/random:ro
    ports:
      - "${BIND_INTERFACE}${METADB_LISTEN}:3000"
    environment:
      MB_DB_TYPE: postgres
      MB_DB_DBNAME: metabase
      MB_DB_PORT: 5432
      MB_DB_USER: postgres
      MB_DB_PASS: password
      MB_DB_HOST: metadb_postgres
      MB_SITE_URL: "${MB_SITE_URL}"
    networks:
      - postgres
      - metadb_web
      - metadb_postgres
    healthcheck:
      test: curl --fail -I http://localhost:3000/api/health || exit 1
      interval: 15s
      timeout: 5s
      retries: 5

  metadb_postgres:
    image: postgres:latest
    restart: unless-stopped
    container_name: "${API_CONTAINER_NAME}_metadb_postgres"
    hostname: postgres
    environment:
      POSTGRES_USER: postgres
      POSTGRES_DB: metabase
      POSTGRES_PASSWORD: password
    networks:
      - metadb_postgres
  # RAM ~ 4.0gb max
  smae_api:
    container_name: "${API_CONTAINER_NAME}"
    build:
      context: ./backend/
      dockerfile: Dockerfile
    restart: unless-stopped
    ports:
      - "${BIND_INTERFACE}${SMAE_API_LISTEN}:3001"
    environment:
      DATABASE_URL: "${DATABASE_URL}"
      SESSION_JWT_SECRET: "${SESSION_JWT_SECRET}"
      MAX_QTDE_SENHA_INVALIDA_PARA_BLOCK: "3"
      URL_LOGIN_SMAE: "${URL_LOGIN_SMAE}"
      S3_ACCESS_KEY: "${S3_ACCESS_KEY}"
      S3_SECRET_KEY: "${S3_SECRET_KEY}"
      S3_BUCKET: "${S3_BUCKET}"
      S3_HOST: "${S3_HOST}"
      CPF_OBRIGATORIO_SEM_RF: "${CPF_OBRIGATORIO_SEM_RF}"
      MATCH_EMAIL_RF_OBRIGATORIO: "${MATCH_EMAIL_RF_OBRIGATORIO}"
      SOF_API_PREFIX: "${SOF_API_PREFIX}"
      HEALTH_CHECK_TOKEN: "${HEALTH_CHECK_TOKEN}"
      PRISMA_FIELD_ENCRYPTION_KEY: "${PRISMA_FIELD_ENCRYPTION_KEY}"
      PRISMA_FIELD_DECRYPTION_KEYS: "${PRISMA_FIELD_DECRYPTION_KEYS}"
      LOG_REQ_ON_DB: "${LOG_REQ_ON_DB}"
      LOG_DB_SKIP_URL_LIST: "${LOG_DB_SKIP_URL_LIST}"
    networks:
      - postgres
      - minio
      - api
      - api_orcamento
      - api_sei
    depends_on:
      - db
      - minio
      - smae_orcamento
    logging:
      driver: "json-file"
      options:
        max-file: "2"
        max-size: 100MB
  # RAM ~ 4.0gb max
  smae_orcamento:
    container_name: "${API_CONTAINER_NAME}_orcamento"
    build:
      context: ./backend-orcamento/
      dockerfile: Dockerfile
    restart: unless-stopped
    environment:
      SOF_API_TOKEN: "${SOF_API_TOKEN}"
      SOF_API_HOST: "gateway.apilib.prefeitura.sp.gov.br/sf/sof/"
      SOF_API_VERSION: "v4"
      PORT: 80
    networks:
      - api_orcamento
    logging:
      driver: "json-file"
      options:
        max-file: "2"
        max-size: 100MB

#  smae_sei:
#    container_name: "${API_CONTAINER_NAME}_sei"
#    build:
#      context: ./backend-sei/
#      dockerfile: Dockerfile
#    restart: unless-stopped
#    environment:
#      SEI_API_TOKEN: "${SEI_API_TOKEN}"
#      PORT: 80
#    networks:
#      - api_sei
#    logging:
#      driver: "json-file"
#      options:
#        max-file: "2"
#        max-size: 100MB

  # RAM 250mb RAM max
  email_service:
    container_name: "${EMAILDB_CONTAINER_NAME}"
    build:
      context: ./email-service/
      dockerfile: Dockerfile
    restart: unless-stopped
    environment:
      VARIABLES_JSON_IS_UTF8: "1"
      EMAILDB_DB_HOST: "db"
      EMAILDB_DB_PASS: "smae"
      EMAILDB_DB_NAME: "smae_dev_persistent"
      EMAILDB_DB_USER: "smae"
      EMAILDB_DB_PORT: "5432"
      EMAILDB_MAX_WORKERS: "1"
      EMAILDB_FETCH_ROWS: "100"
    volumes:
      - email_data:/data/
    depends_on:
      - db
    networks:
      - smtp
      - postgres
    logging:
      driver: "json-file"
      options:
        max-file: "2"
        max-size: 100MB
  # 150 MB RAM max
  smtp_web:
    container_name: "${EMAILDB_CONTAINER_NAME}_smtp_web"
    restart: unless-stopped
    image: rnwood/smtp4dev:latest
    ports:
      - "${BIND_INTERFACE}${SMTP_WEB_LISTEN}:80"
    networks:
      - api
      - smtp
    logging:
      driver: "json-file"
      options:
        max-file: "2"
        max-size: 100MB

  # 1500 MB RAM max
  minio:
    container_name: "${MINIO_CONTAINER_NAME}"
    image: minio/minio:RELEASE.2023-08-29T23-07-35Z
    hostname: minio
    command: server --console-address ":9001" /data1
    restart: unless-stopped
    environment:
      MINIO_ROOT_USER: "${MINIO_ROOT_USER}"
      MINIO_ROOT_PASSWORD: "${MINIO_ROOT_PASSWORD}"
    networks:
      - minio
    ports:
      - "${BIND_INTERFACE}${MINIO_S3_LISTEN}:9000"
      - "${BIND_INTERFACE}${MINIO_CONSOLE_LISTEN}:9001"
    volumes:
      - minio_data:/data1
    logging:
      driver: "json-file"
      options:
        max-file: '100'
        max-size: 1m

  # 50 mb RAM max
  web:
    container_name: "${WEB_CONTAINER_NAME}"
    build:
      context: ./
      dockerfile: frontend/Dockerfile
    networks:
      - api
      - metadb_web
    depends_on:
      - smae_api
      - metabase
    restart: unless-stopped
    environment:
      VITE_API_URL: "${VITE_API_URL}"
    ports:
      - "${BIND_INTERFACE}${SMAE_WEB_LISTEN}:80"
    logging:
      driver: "json-file"
      options:
        max-file: "2"
        max-size: 1MB

  pgbackups:
    image: prodrigestivill/postgres-backup-local
    restart: unless-stopped
    volumes:
      - backup_smae_pg:/backups
    networks:
      - postgres
    depends_on:
      - db
    environment:
      - POSTGRES_HOST=db
      - POSTGRES_DB=smae_dev_persistent
      - POSTGRES_USER=smae
      - POSTGRES_PASSWORD=smae
      - POSTGRES_EXTRA_OPTS=-Z6 --schema=public --blobs
      - SCHEDULE=@hourly
      - BACKUP_KEEP_MINS=1440
      - BACKUP_KEEP_DAYS=7
      - BACKUP_KEEP_WEEKS=4
      - BACKUP_KEEP_MONTHS=6
      - HEALTHCHECK_PORT=8080


  metabase_pgbackups:
    image: prodrigestivill/postgres-backup-local
    restart: unless-stopped
    volumes:
      - backup_metabase_pg:/backups
    networks:
      - postgres
    depends_on:
      - db
    environment:
      - POSTGRES_HOST=metadb_postgres
      - POSTGRES_DB=metabase
      - POSTGRES_USER=metabase
      - POSTGRES_PASSWORD=password
      - POSTGRES_EXTRA_OPTS=-Z6 --schema=public --blobs
      - SCHEDULE=@daily
      - BACKUP_KEEP_DAYS=7
      - BACKUP_KEEP_WEEKS=4
      - BACKUP_KEEP_MONTHS=12
      - HEALTHCHECK_PORT=8080


networks:
  postgres:
  minio:
  api:
  api_orcamento:
  smtp:
  metadb_postgres:
  metadb_web:
  api_sei:

volumes:
  pgdata:
    name: "${DATA_PREFIX}smae_pg_data"

  email_data:
    name: "${DATA_PREFIX}smae_email_data"

  minio_data:
    name: "${DATA_PREFIX}smae_minio_data"

  backup_smae_pg:
    name: "${DATA_PREFIX}smae_backup_smae_pg"

  backup_metabase_pg:
    name: "${DATA_PREFIX}smae_backup_metabase_pg"