src/scripts/thirdpartytest/docker-compose/sqoop-thirdpartytest-db-services.yml

# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

version: '3'
services:
  mysql:
    image: mysql:5.7.19
    container_name: sqoop_mysql_container
    environment:
      COMPOSE_HTTP_TIMEOUT: 200
      MYSQL_ROOT_PASSWORD: sqoop
      MYSQL_USER: sqoop
      MYSQL_PASSWORD: Sqoop12345
      MYSQL_DATABASE: sqoop
    ports:
      - 13306:3306
    command:
      mysqld --sql_mode="ANSI_QUOTES"
    healthcheck:
      test: ["CMD", "mysqladmin" ,"ping", "-h", "localhost"]
      interval: 30s
      timeout: 10s
      retries: 10
  postgresql:
    image: postgres:9.6.4
    container_name: sqoop_postgresql_container
    environment:
      COMPOSE_HTTP_TIMEOUT: 200
      POSTGRES_DB: sqoop
      POSTGRES_USER: sqoop
      POSTGRES_PASSWORD: Sqoop12345
    ports:
      - 15432:5432
    healthcheck:
      test: ["CMD", "pg_isready"]
      interval: 30s
      timeout: 10s
      retries: 10
  mssql:
    image: microsoft/mssql-server-linux:2017-GA
    container_name: sqoop_mssql_container
    environment:
      COMPOSE_HTTP_TIMEOUT: 200
      ACCEPT_EULA: Y
      SA_PASSWORD: Sqoop12345
    ports:
      - 1433:1433
    healthcheck:
      test: ["CMD", "/opt/mssql-tools/bin/sqlcmd", "-S", "localhost", "-U", "sa", "-P", "Sqoop12345", "-Q" , "SELECT 1"]
      interval: 30s
      timeout: 10s
      retries: 10
  cubrid:
    image: cubrid/cubrid:10.0
    container_name: sqoop_cubrid_container
    environment:
      COMPOSE_HTTP_TIMEOUT: 200
      CUBRID_DB: sqoop
      CUBRID_USER: sqoop
      CUBRID_PASSWORD: Sqoop12345
    ports:
      - 33000:33000
    healthcheck:
      test: ["CMD", "csql", "sqoop", "-c", "SELECT 1"]
      interval: 30s
      timeout: 10s
      retries: 10
  oracle-ee:
    image: oracle/database:12.2.0.1-ee
    container_name: sqoop_oracle-ee_container
    environment:
      COMPOSE_HTTP_TIMEOUT: 200
      ORACLE_SID: sqoop
      ORACLE_PWD: Sqoop12345
    ports:
      - 1522:1521
    volumes:
      - ./oraclescripts:/opt/oracle/scripts
    healthcheck:
      test: ["CMD", "/opt/oracle/scripts/ee-healthcheck.sh"]
      interval: 30s
      timeout: 10s
      retries: 60
  oracle:
      image: acktsw/oracle-xe-11g
      container_name: sqoop_oracle_container
      environment:
        COMPOSE_HTTP_TIMEOUT: 200
        DEFAULT_SYS_PASS: oracle
      ports:
        - 1521:1521
      volumes:
        - ./oraclescripts:/opt/oracle/scripts
        - ./oraclescripts/startup:/docker-entrypoint-initdb.d
      healthcheck:
        test: ["CMD", "/opt/oracle/scripts/healthcheck.sh"]
        interval: 5s
        timeout: 5s
        retries: 50
  db2:
    image: ibmcom/db2:11.5.0.0a
    container_name: sqoop_db2_container
    privileged: true
    environment:
      COMPOSE_HTTP_TIMEOUT: 200
      DB2INST1_PASSWORD: Sqoop12345
      DBNAME: SQOOP
      LICENSE: accept
    ports:
      - 50000:50000
    healthcheck:
      test: ["CMD", "/home/db2inst1/sqllib/bin/db2", "CONNECT", "TO", "SQOOP"]
      interval: 30s
      timeout: 10s
      retries: 20
  mainframe:
    image: cntroversycubed/sqoopgdg:42e6c3a1229a6cdf346eb3976bd7298091ea11e2
    container_name: sqoop_mainframe_gdg_container
    ports:
      - 2121:2121
      - 60000-60009:60000-60009
    healthcheck:
      test: ["CMD", "nc", "-z", "localhost", "2121"]
      interval: 30s
      timeout: 10s
      retries: 20