docker-compose.yml

version: '2.1'
services:
    redis:
        image: 'redis:5.0.5'
        # command: redis-server --requirepass redispass

    postgres:
        image: postgres:9.6
        environment:
            - POSTGRES_USER=airflow
            - POSTGRES_PASSWORD=airflow
            - POSTGRES_DB=airflow
            - PGDATA=/var/lib/postgresql/data/pgdata
        volumes:
            - ./pgdata:/var/lib/postgresql/data/pgdata
        ports:
            - "5432:5432"

    sqlserver:
        image: mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
        environment:
            - ACCEPT_EULA=Y
            - SA_PASSWORD=@123admin
        ports:
            - "1433:1433"

    webserver:
        #image: docker_airflow:latest
        build:
            context: .
            dockerfile: Dockerfile-airflow
        restart: always
        depends_on:
            - postgres
            - redis
        environment:
            - LOAD_EX=n
            - FERNET_KEY=46BKJoQYlPPOexq0OhDZnIlNepKFf87WFwLbfzqDDho=
            - EXECUTOR=Celery
            # - POSTGRES_USER=airflow
            # - POSTGRES_PASSWORD=airflow
            # - POSTGRES_DB=airflow
            # - REDIS_PASSWORD=redispass
        volumes:
            - ./dags:/usr/local/airflow/dags
            - ./sql:/usr/local/airflow/sql
            # Uncomment to include custom plugins
            - ./plugins:/usr/local/airflow/plugins
            - ./config:/usr/local/airflow
            # Selenium scripts 
            - ./selenium_scripts:/usr/local/airflow/selenium_scripts
            - ./sqlalchemy_teiid:/usr/local/airflow/sqlalchemy_teiid
            # Selenium downloads
            - downloads:/usr/local/airflow/downloads
        ports:
            - "8080:8080"
        command: webserver
        healthcheck:
            test: ["CMD-SHELL", "[ -f /usr/local/airflow/airflow-webserver.pid ]"]
            interval: 30s
            timeout: 30s
            retries: 3

    flower:
        #image: docker_airflow:latest
        build:
            context: .
            dockerfile: Dockerfile-airflow
        restart: always
        depends_on:
            - redis
        environment:
            - EXECUTOR=Celery
            # - REDIS_PASSWORD=redispass
        ports:
            - "5555:5555"
        command: flower

    scheduler:
        #image: docker_airflow:latest
        build:
            context: .
            dockerfile: Dockerfile-airflow
        restart: always
        depends_on:
            - webserver
        volumes:
            - ./dags:/usr/local/airflow/dags
            # Uncomment to include custom plugins
            - ./plugins:/usr/local/airflow/plugins
            # Selenium scripts 
            - ./selenium_scripts:/usr/local/airflow/selenium_scripts
            # Selenium downloads
            - downloads:/usr/local/airflow/downloads
        environment:
            - LOAD_EX=n
            - FERNET_KEY=46BKJoQYlPPOexq0OhDZnIlNepKFf87WFwLbfzqDDho=
            - EXECUTOR=Celery
            # - POSTGRES_USER=airflow
            # - POSTGRES_PASSWORD=airflow
            # - POSTGRES_DB=airflow
            # - REDIS_PASSWORD=redispass
        command: scheduler

    worker:
        #image: docker_airflow:latest
        build:
            context: .
            dockerfile: Dockerfile-airflow
        restart: always
        depends_on:
            - scheduler
        volumes:
            - ./dags:/usr/local/airflow/dags
            # Mount the host docker socket on the worker container  
            - /var/run/docker.sock:/var/run/docker.sock
            # Uncomment to include custom plugins
            - ./plugins:/usr/local/airflow/plugins
            # Selenium scripts 
            - ./selenium_scripts:/usr/local/airflow/selenium_scripts
            # Selenium downloads
            - downloads:/usr/local/airflow/downloads
        environment:
            - FERNET_KEY=46BKJoQYlPPOexq0OhDZnIlNepKFf87WFwLbfzqDDho=
            - EXECUTOR=Celery
            - LAKE_HOST=sqlserver
            - LAKE_PORT=1433
            - CEPIM_DATABASE=DATABASE
            - CEIS_DATABASE=DATABASE
            - CNEP_DATABASE=DATABASE
            - INIDONEOS_DATABASE=DATABASE
            - INADIMPLENTES_DATABASE=DATABASE
            - LENIENCIA_DATABASE=DATABASE
            - POLITICOS_DATABASE=DATABASE
            - PAINEL_DATABASE=seges_cgial_fornecedor
            - LAKE_USER=SA
            - LAKE_PASS=@123admin
            - TEIID_USER=USER
            - TEIID_PASS=PASS
            # - POSTGRES_USER=airflow
            # - POSTGRES_PASSWORD=airflow
            # - POSTGRES_DB=airflow
            # - REDIS_PASSWORD=redispass
        networks:
            - default  
            - container_bridge
        command: worker

networks:
   default:

   container_bridge:
      external:
        name: container_bridge

volumes:
   downloads:
      external: true