R2-HTML-DB/docker-compose.yml at main · Aksel911/R2-HTML-DB · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
version: '3.8'

services:
  db:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: sqlserver
    environment:
      ACCEPT_EULA: "Y"
      MSSQL_SA_PASSWORD: "SqlServer2025!"
      MSSQL_PID: "Express"
    volumes:
      - db_data:/var/opt/mssql
      - ./docker_database:/var/opt/mssql/backup:ro
    ports:
      - "1433:1433"
    healthcheck:
      test: /opt/mssql/bin/sqlservr --version || exit 1
      interval: 10s
      timeout: 5s
      retries: 10
      start_period: 60s
    networks:
      - db_net
    restart: unless-stopped

  db_restore:
    image: mcr.microsoft.com/mssql-tools:latest
    container_name: db_restore
    volumes:
      - ./docker_database:/var/opt/mssql/backup:ro
      - ./docker_database/restore.sql:/restore.sql:ro
    command: >
      bash -c '
      echo "Waiting for SQL Server to start..." &&
      /opt/mssql-tools/bin/sqlcmd -S db -U sa -P "SqlServer2025!" -i /restore.sql'
    depends_on:
      - db
    networks:
      - db_net

  app:
    build: .
    container_name: r2wiki_flask
    ports:
      - "5000:5000"
    environment:
      DB_DRIVER: "ODBC Driver 17 for SQL Server"
      DB_SERVER: "db"
      DB_NAME: "FNLParm"
      DB_USER: "sa"
      DB_PASSWORD: "SqlServer2025!"
      GITHUB_URL: "https://raw.githubusercontent.com/Aksel911/R2-HTML-DB/main/static/"
      PYTHONPATH: "/app"
    command: >
      bash -c '
      echo "Waiting for db_restore to finish..." &&
      sleep 10 &&
      python -m flask run --host=0.0.0.0'
    depends_on:
      - db_restore
    networks:
      - db_net
    restart: unless-stopped

networks:
  db_net:
    name: db_net

volumes:
  db_data: