b4cf488639de5bf49da7beea424c4e9da669d964
[sqoop.git] / src / scripts / thirdpartytest / docker-compose / sqoop-thirdpartytest-db-services.yml
1 # Licensed to the Apache Software Foundation (ASF) under one or more
2 # contributor license agreements.  See the NOTICE file distributed with
3 # this work for additional information regarding copyright ownership.
4 # The ASF licenses this file to You under the Apache License, Version 2.0
5 # (the "License"); you may not use this file except in compliance with
6 # the License.  You may obtain a copy of the License at
7 #
8 #     http://www.apache.org/licenses/LICENSE-2.0
9 #
10 # Unless required by applicable law or agreed to in writing, software
11 # distributed under the License is distributed on an "AS IS" BASIS,
12 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 # See the License for the specific language governing permissions and
14 # limitations under the License.
15
16 version: '3'
17 services:
18   mysql:
19     image: mysql:5.7.19
20     container_name: sqoop_mysql_container
21     environment:
22       COMPOSE_HTTP_TIMEOUT: 200
23       MYSQL_ROOT_PASSWORD: sqoop
24       MYSQL_USER: sqoop
25       MYSQL_PASSWORD: Sqoop12345
26       MYSQL_DATABASE: sqoop
27     ports:
28       - 3306:3306
29     command:
30       mysqld --sql_mode="ANSI_QUOTES"
31     healthcheck:
32       test: ["CMD", "mysqladmin" ,"ping", "-h", "localhost"]
33       interval: 30s
34       timeout: 10s
35       retries: 10
36   postgresql:
37     image: postgres:9.6.4
38     container_name: sqoop_postgresql_container
39     environment:
40       COMPOSE_HTTP_TIMEOUT: 200
41       POSTGRES_DB: sqoop
42       POSTGRES_USER: sqoop
43       POSTGRES_PASSWORD: Sqoop12345
44     ports:
45       - 5432:5432
46     healthcheck:
47       test: ["CMD", "pg_isready"]
48       interval: 30s
49       timeout: 10s
50       retries: 10
51   mssql:
52     image: microsoft/mssql-server-linux:2017-GA
53     container_name: sqoop_mssql_container
54     environment:
55       COMPOSE_HTTP_TIMEOUT: 200
56       ACCEPT_EULA: Y
57       SA_PASSWORD: Sqoop12345
58     ports:
59       - 1433:1433
60     healthcheck:
61       test: ["CMD", "/opt/mssql-tools/bin/sqlcmd", "-S", "localhost", "-U", "sa", "-P", "Sqoop12345", "-Q" , "SELECT 1"]
62       interval: 30s
63       timeout: 10s
64       retries: 10
65   cubrid:
66     image: cubrid/cubrid:10.0
67     container_name: sqoop_cubrid_container
68     environment:
69       COMPOSE_HTTP_TIMEOUT: 200
70       CUBRID_DB: sqoop
71       CUBRID_USER: sqoop
72       CUBRID_PASSWORD: Sqoop12345
73     ports:
74       - 33000:33000
75     healthcheck:
76       test: ["CMD", "csql", "sqoop", "-c", "SELECT 1"]
77       interval: 30s
78       timeout: 10s
79       retries: 10
80   oracle:
81     image: oracle/database:12.2.0.1-ee
82     container_name: sqoop_oracle_container
83     environment:
84       COMPOSE_HTTP_TIMEOUT: 200
85       ORACLE_SID: sqoop
86       ORACLE_PWD: Sqoop12345
87     ports:
88       - 1521:1521
89     volumes:
90       - ./oraclescripts:/opt/oracle/scripts
91     healthcheck:
92       test: ["CMD", "/opt/oracle/scripts/healthcheck.sh"]
93       interval: 30s
94       timeout: 10s
95       retries: 60
96   db2:
97     image: ibmcom/db2express-c:10.5.0.5-3.10.0
98     container_name: sqoop_db2_container
99     environment:
100       COMPOSE_HTTP_TIMEOUT: 200
101       DB2INST1_PASSWORD: Sqoop12345
102       LICENSE: accept
103     ports:
104       - 50000:50000
105     volumes:
106       - ./db2scripts:/home/db2inst1/db2scripts
107     entrypoint:
108         /home/db2inst1/db2scripts/db2entrypoint.sh
109     healthcheck:
110       test: ["CMD", "/home/db2inst1/sqllib/bin/db2", "CONNECT", "TO", "SQOOP"]
111       interval: 30s
112       timeout: 10s
113       retries: 20
114   mainframe:
115     image: cntroversycubed/sqoopgdg:42e6c3a1229a6cdf346eb3976bd7298091ea11e2
116     container_name: sqoop_mainframe_gdg_container
117     ports:
118       - 2121:2121
119       - 60000-60009:60000-60009
120     healthcheck:
121       test: ["CMD", "nc", "-z", "localhost", "2121"]
122       interval: 30s
123       timeout: 10s
124       retries: 20