webservice/docker-compose.yml at dev · trakli/webservice · 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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
name: trakli

services:
    app:
        image: ghcr.io/whilesmartphp/laravel-dev:8.2
        ports:
            - '${APP_PORT:-8000}:80'
        tty: true
        volumes:
            - '.:/var/www/html'
        networks:
            - trakli
        depends_on:
            - mysql

    mysql:
        image: 'mysql:8.0'
        ports:
            - '${FORWARD_DB_PORT:-3306}:3306'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_DATABASE: '${DB_DATABASE}'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
        volumes:
            - 'trakli_mysql:/var/lib/mysql'
        networks:
            - trakli
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
            retries: 3
            timeout: 5s

    mysql-test:
        image: 'mysql:8.0'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_DATABASE: 'trakli_test'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
        volumes:
            - 'trakli_test_mysql:/var/lib/mysql'
        networks:
            - trakli
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
            retries: 3
            timeout: 5s

    phpmyadmin:
        image: 'phpmyadmin/phpmyadmin:latest'
        ports:
            - '${PMA_PORT:-8080}:80'
        environment:
            PMA_HOST: mysql
            PMA_USER: '${DB_USERNAME}'
            PMA_PASSWORD: '${DB_PASSWORD}'
        depends_on:
            - mysql
        networks:
            - trakli

    mailhog:
        image: 'mailhog/mailhog:latest'
        ports:
            - '${MAILHOG_SMTP_PORT:-1025}:1025'
            - '${MAILHOG_UI_PORT:-8025}:8025'
        networks:
            - trakli

    smartql:
        image: 'ghcr.io/smartql/smartql:latest'
        ports:
            - '${SMARTQL_PORT:-5000}:8000'
        environment:
            SMARTQL_CONFIG: /app/smartql.yml
            DB_HOST: mysql
            DB_PORT: 3306
            DB_DATABASE: '${DB_DATABASE}'
            DB_USERNAME: '${DB_USERNAME}'
            DB_PASSWORD: '${DB_PASSWORD}'
            LLM_PROVIDER: '${LLM_PROVIDER:-gemini}'
            LLM_MODEL: '${LLM_MODEL:-gemini-2.0-flash}'
            GEMINI_API_KEY: '${GEMINI_API_KEY:?GEMINI_API_KEY must be set for SmartQL}'
            LLM_TEMPERATURE: '${LLM_TEMPERATURE:-0.1}'
            LLM_RETRIES: '${LLM_RETRIES:-3}'
        volumes:
            - './smartql.yml:/app/smartql.yml:ro'
        depends_on:
            - mysql
        networks:
            - trakli
        command: ["smartql", "serve", "-c", "/app/smartql.yml", "--host", "0.0.0.0", "--port", "8000"]

networks:
    trakli:
        driver: bridge
volumes:
    trakli_mysql:
        driver: local
    trakli_test_mysql:
        driver: local