fast-liquibase-manual

get artifactory token from IAD2_Utility at /root/token/artifactory.token

ssh into IAD2_Jump_Tools_PCI

ssh into stgk8smaster-pci-01 or stgk8smaster-nonpci-01

1
sudo kubectl exec -it -n ${namespace} ${podname} -- bash

fetch target file url from artifactory

version is liquibase version on the CM table

url is inside script test-infra-jenkins/liquibase-deploy/mysql-deploy.sh

1
2
3
4
5
6
7
8
v="551.0.xxxxx"
t="artifactory_token"
tarfile="liquibase.data-${v}.tar.gz"
urlPrefix="https://artifactory.citools.ea.com/artifactory/releases/com/ea"
urlSuffix="liquibase.data/${v}/${tarfile}"
url="${urlPrefix}/nucleus/${urlSuffix}"

curl -v -H "Authorization: Bearer ${t}" "${url}" -o ${tarfile}
1
2
mkdir -p liquibase.data
tar -zxf xxx.tar.gz -C liquibase.data
1
./my-liquibase.py ${component} staging status 551

Check db.conf inside each repo to confirm which db it uses.

Repo Version
Citadel 551
Venice 550
Code-Redeption 546
Paragon 551
nucleusConfig 2021

version is at liquibase.data/changelogs/${repo}

repo names are at liquibase.data/conf/${repo}