Gitlab + Liqubase [英] Gitlab + liqubase

问题描述

问题很简单在gitlab管道中执行liquibase迁移的最佳方法是什么

The question is very straightforward What is the best way to execute liquibase migration in gitlab pipelines

我到目前为止有什么但是gitlab服务似乎立即执行 docker run ，并且docker run已经需要数据库迁移参数

what i have so far but seems gitlab services immediately executes docker run, and docker run already requires db migration parameters

image: docker:19.03.1
stages:
  - build
  - db-migration
  - deploy
services:
  - docker:19.03.1-dind
  - liquibase/liquibase:latest
variables:
  DOCKER_TLS_CERTDIR: "/certs"
  AWS_ACCESS_KEY_ID: $AWS_ACCESS_KEY_ID
  AWS_SECRET_ACCESS_KEY: $AWS_SECRET_ACCESS_KEY
  AWS_IMAGE_PATH: $AWS_ACCOUNT_ID.dkr.ecr.$AWS_REGION.amazonaws.com

before_script:
  - apk add --update python python-dev py-pip
  - pip install awscli --upgrade
  - $(aws ecr get-login --no-include-email --region $AWS_REGION | tr -d '\r')

build:
  stage: build
  script:
    - docker build --tag $AWS_IMAGE_PATH/$CI_PROJECT_NAME:$CI_COMMIT_SHA --tag $AWS_IMAGE_PATH/$CI_PROJECT_NAME:latest .
    - docker push $AWS_IMAGE_PATH/$CI_PROJECT_NAME:$CI_COMMIT_SHA
    - docker push $AWS_IMAGE_PATH/$CI_PROJECT_NAME:latest

db-migration:
  stage: db-migration
  script:
    - liquibase --changeLogFile=/src/main/resources/db/changelog/psql/changelog.yaml
        --url="jdbc:postgresql://host:5432/db"
        --username username --password $DB_PASSWORD update
deploy:
  stage: deploy
  script:
    - echo "Deployed"

推荐答案

db-migration:
  image: openjdk:8-jre-alpine
  stage: db-migration
  script:
    - INIT_PATH=`pwd`
    - apk add bash
    - mkdir /liquibase
    - mkdir /Downloads
    - cd /Downloads
    - wget "https://github.com/liquibase/liquibase/releases/download/liquibase-parent-3.7.0/liquibase-3.7.0-bin.zip"
    - wget "https://repo1.maven.org/maven2/org/postgresql/postgresql/42.2.8/postgresql-42.2.8.jar"
    - unzip liquibase-3.7.0-bin.zip -d /liquibase -q
    - mv postgresql-42.2.8.jar /liquibase/lib/
    - export PATH=$PATH:/liquibase
    - liquibase --changeLogFile=$INIT_PATH/src/main/resources/db/changelog/psql/changelog.yaml
        --url="jdbc:postgresql://host:port/db"
        --username username --password $DB_PASSWORD update
  only:
    - master

这篇关于Gitlab + Liqubase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！