-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy path.travis.yml
115 lines (84 loc) · 5.6 KB
/
.travis.yml
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
105
106
107
108
109
110
111
112
113
114
115
sudo: required
services:
- docker
env:
global:
- DOCKER_VERSION=1.11.1-0~trusty
- DOCKER_COMPOSE_VERSION=1.7.0
before_install:
# list docker-engine versions
- apt-cache madison docker-engine
# upgrade docker-engine to specific version
- sudo apt-get -o Dpkg::Options::="--force-confnew" install -y docker-engine=${DOCKER_VERSION}
# reinstall docker-compose at specific version
- sudo rm /usr/local/bin/docker-compose
- curl -L https://github.com/docker/compose/releases/download/${DOCKER_COMPOSE_VERSION}/docker-compose-`uname -s`-`uname -m` > docker-compose
- chmod +x docker-compose
- sudo mv docker-compose /usr/local/bin
script:
- docker version
- docker-compose version
- ls -lah
# Build image
- docker-compose up -d
# List running containers
- docker ps -a
# Wait to databases start
- sleep 20
## DEV
# Chech the initial state
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;"
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | wc -l
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | wc -l | grep -q 1
# Run Version 1 - on Database dev (related to contexts)
- docker exec -it liquibase.global bash -c 'java -jar liquibase-3.4.2.jar --defaultsFile=r_dev_v1.properties update'
# Check the modifications
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;"
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | grep -q DATABASECHANGELOG
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | grep -q DATABASECHANGELOGLOCK
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | grep -q person
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | wc -l | grep -q 8
# Run Version 2 - on Database dev (related to contexts)
- docker exec -it liquibase.global bash -c 'java -jar liquibase-3.4.2.jar --defaultsFile=r_dev_v2.properties update'
# Check the modifications
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;"
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | grep -q state
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'state';"
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'state';" | wc -l
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | wc -l | grep -q 9
# Run Version 3 - on Database dev (related to contexts)
- docker exec -it liquibase.global bash -c 'java -jar liquibase-3.4.2.jar --defaultsFile=r_dev_v3.properties update'
# Check the modifications
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;"
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "show tables;" | wc -l | grep -q 9
- docker exec -it mysql.dev mysql -u theuser -pthepw devdb -e "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'state';"
## PRD
# Chech the initial state
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;"
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | wc -l
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | wc -l | grep -q 1
# Run Version 1 - on Database prd (related to contexts)
- docker exec -it liquibase.global bash -c 'java -jar liquibase-3.4.2.jar --defaultsFile=r_prd_v1.properties update'
# Check the modifications
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;"
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | grep -q DATABASECHANGELOG
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | grep -q DATABASECHANGELOGLOCK
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | wc -l | grep -q 7
# Run Version 2 - on Database prd (related to contexts)
- docker exec -it liquibase.global bash -c 'java -jar liquibase-3.4.2.jar --defaultsFile=r_prd_v2.properties update'
# Check the modifications
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;"
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | grep -q state
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'state';"
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'state';" | wc -l
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | wc -l | grep -q 8
# Run Version 3 - on Database prd (related to contexts)
- docker exec -it liquibase.global bash -c 'java -jar liquibase-3.4.2.jar --defaultsFile=r_prd_v3.properties update'
# Check the modifications
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;"
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "show tables;" | wc -l | grep -q 8
- docker exec -it mysql.prd mysql -u theuser -pthepw prddb -e "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'state';"
# Test PhpMyAdmin on Database dev
- curl http://127.0.0.1:33081/ | grep -q devdb
# Test PhpMyAdmin on Database prd
- curl http://127.0.0.1:33082/ | grep -q prddb