Repository navigation
Expand file tree
/
Copy path.gitlab-ci.yml
More file actions
94 lines (90 loc) · 2.99 KB
/
Copy path.gitlab-ci.yml
File metadata and controls
94 lines (90 loc) · 2.99 KB
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
default:
tags:
- k8s
stages:
- build
- run
build-job:
stage: build
allow_failure: true
image:
name: moby/buildkit:latest
entrypoint: [""]
variables:
GIT_FETCH_EXTRA_FLAGS: none
GIT_STRATEGY: "clone"
IMAGE_NAME: "database-manager"
IMAGE_VERSION: ""
before_script:
- apk add --no-cache jq moreutils
script:
- /bin/sh build.sh
rules:
- if: $CI_PIPELINE_SOURCE == "push" && $CI_COMMIT_BRANCH == $CI_DEFAULT_BRANCH && $CI_COMMIT_TAG == null
when: manual
- if: $CI_PIPELINE_SOURCE == "schedule"
when: never
run_script:postgresql:
stage: run
allow_failure: true
image: $CI_REGISTRY_IMAGE/database-manager:latest
variables:
ACTION: ""
SWAP: ""
VERBOSE: ""
script:
- cd app
- |
echo "[backup]" > psql.config
echo "host=$BACKUP_HOST" >> psql.config
echo "port=$BACKUP_PORT" >> psql.config
echo "user=$BACKUP_USER" >> psql.config
echo "password=$BACKUP_PASSWORD" >> psql.config
echo "db=$BACKUP_DB" >> psql.config
- |
echo "[restore]" >> psql.config
echo "host=$RESTORE_HOST" >> psql.config
echo "port=$RESTORE_PORT" >> psql.config
echo "user=$RESTORE_USER" >> psql.config
echo "password=$RESTORE_PASSWORD" >> psql.config
echo "user_new=$RESTORE_USER_NEW" >> psql.config
echo "password_new=$RESTORE_PASSWORD_NEW" >> psql.config
echo "db_new=$RESTORE_DB_NEW" >> psql.config
- python postgres-database-manager.py --configfile=psql.config --action=$ACTION ${SWAP:+--swap} ${VERBOSE:+--verbose}
rules:
- if: $CI_PIPELINE_SOURCE == "trigger" && $JOB_NAME == "run_script:postgresql"
when: always
- if: $CI_PIPELINE_SOURCE == "push" && $CI_COMMIT_BRANCH == $CI_DEFAULT_BRANCH && $CI_COMMIT_TAG == null
when: manual
run_script:mysql:
stage: run
allow_failure: true
image: $CI_REGISTRY_IMAGE/database-manager:latest
variables:
ACTION: ""
SWAP: ""
VERBOSE: ""
script:
- cd app
- |
echo "[backup]" > mysql.config
echo "host=$BACKUP_HOST" >> mysql.config
echo "port=$BACKUP_PORT" >> mysql.config
echo "user=$BACKUP_USER" >> mysql.config
echo "password=$BACKUP_PASSWORD" >> mysql.config
echo "db=$BACKUP_DB" >> mysql.config
- |
echo "[restore]" >> mysql.config
echo "host=$RESTORE_HOST" >> mysql.config
echo "port=$RESTORE_PORT" >> mysql.config
echo "user=$RESTORE_USER" >> mysql.config
echo "password=$RESTORE_PASSWORD" >> mysql.config
echo "user_new=$RESTORE_USER_NEW" >> mysql.config
echo "password_new=$RESTORE_PASSWORD_NEW" >> mysql.config
echo "db_new=$RESTORE_DB_NEW" >> mysql.config
- python mysql-database-manager.py --configfile=mysql.config --action=$ACTION ${SWAP:+--swap} ${VERBOSE:+--verbose}
rules:
- if: $CI_PIPELINE_SOURCE == "trigger" && $JOB_NAME == "run_script:mysql"
when: always
- if: $CI_PIPELINE_SOURCE == "push" && $CI_COMMIT_BRANCH == $CI_DEFAULT_BRANCH && $CI_COMMIT_TAG == null
when: manual