workerbrian/be-api repository overview

version: '3.8'

services:
  api:
    image: workerbrian/be-api:v2.0.0
    container_name: fastapi_backend_prod
    restart: unless-stopped
    ports:
      - "8000:8000"
    environment:
      - MSSQL_USER=sa
      - MSSQL_SA_PASSWORD=DosenUmy2026!
      - DB_NAME=profil_dosen
      - DATABASE_URL=mssql+aioodbc://sa:DosenUmy2026!@db:1433/profil_dosen?driver=ODBC+Driver+17+for+SQL+Server&TrustServerCertificate=yes
    depends_on:
      db:
        condition: service_started
      db-init:
        condition: service_completed_successfully
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:8000/health"]
      interval: 30s
      timeout: 10s
      retries: 3
      start_period: 15s

  db:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: sql_server_prod
    restart: unless-stopped
    ports:
      - "1433:1433"
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=DosenUmy2026!
    volumes:
      - mssql_data:/var/opt/mssql

  db-init:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: sql_server_init_prod
    depends_on:
      - db
    volumes:
      - ./init.sql:/app/init.sql
    environment:
      - DB_PASS=DosenUmy2026!
      - DB_NAME=profil_dosen
    command: >
      /bin/bash -c "
      echo 'Menunggu SQL Server siap...';
      until /opt/mssql-tools18/bin/sqlcmd -S db -U sa -P \"$$DB_PASS\" -C -Q 'SELECT 1' > /dev/null 2>&1; do
        sleep 2;
      done;
      echo 'SQL Server menyala. Membuat database '$$DB_NAME'...';
      /opt/mssql-tools18/bin/sqlcmd -S db -U sa -P \"$$DB_PASS\" -C -Q \"IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = '$$DB_NAME') CREATE DATABASE [$$DB_NAME]\";
      echo 'Mengeksekusi skrip init.sql...';
      /opt/mssql-tools18/bin/sqlcmd -S db -U sa -P \"$$DB_PASS\" -d \"$$DB_NAME\" -C -i /app/init.sql;
      echo 'Inisialisasi database selesai!';
      "

volumes:
  mssql_data:

docker compose up -d

docker run -d \
  --name profile_dosen_api \
  -p 8000:8000 \
  -e DATABASE_URL="mssql+aioodbc://sa:YourPassword@your-db-host:1433/profil_dosen?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes&Encrypt=no" \
  workerbrian/be-api:v2.0.0