Skip to content
Snippets Groups Projects

Release TeraFlowSDN 4.0

Merged Lluis Gifre Renom requested to merge develop into master
+ 5
19
@@ -153,25 +153,14 @@ function crdb_undeploy_single() {
@@ -153,25 +153,14 @@ function crdb_undeploy_single() {
function crdb_drop_databases_single() {
function crdb_drop_databases_single() {
echo "Drop TFS databases, if exist"
echo "Drop TFS databases, if exist"
#if [[ -z "${GITLAB_CI}" ]]; then
CRDB_PORT=$(kubectl --namespace ${CRDB_NAMESPACE} get service cockroachdb-public -o 'jsonpath={.spec.ports[?(@.name=="sql")].port}')
# #kubectl --namespace ${CRDB_NAMESPACE} get service cockroachdb-public -o yaml
CRDB_CLIENT_URL="postgresql://${CRDB_USERNAME}:${CRDB_PASSWORD}@cockroachdb-0:${CRDB_PORT}/defaultdb?sslmode=require"
# CRDB_HOST=$(kubectl --namespace ${CRDB_NAMESPACE} get service cockroachdb-public -o 'jsonpath={.spec.clusterIP}')
echo "CRDB_CLIENT_URL=${CRDB_CLIENT_URL}"
# CRDB_PORT=$(kubectl --namespace ${CRDB_NAMESPACE} get service cockroachdb-public -o 'jsonpath={.spec.ports[?(@.name=="sql")].port}')
#else
# CRDB_HOST="127.0.0.1"
# CRDB_PORT=${CRDB_EXT_PORT_SQL}
#fi
#CRDB_CLIENT_URL="postgresql://${CRDB_USERNAME}:${CRDB_PASSWORD}@${CRDB_HOST}:${CRDB_PORT}/defaultdb?sslmode=require"
#echo "CRDB_CLIENT_URL=${CRDB_CLIENT_URL}"
DATABASES=$(
DATABASES=$(
kubectl exec -i --namespace ${CRDB_NAMESPACE} cockroachdb-0 -- \
kubectl exec -i --namespace ${CRDB_NAMESPACE} cockroachdb-0 -- \
./cockroach sql --certs-dir=/cockroach/cockroach-certs --host=cockroachdb-public \
./cockroach sql --certs-dir=/cockroach/cockroach-certs --url=${CRDB_CLIENT_URL} \
--execute "SHOW DATABASES;" --format=tsv | awk '{print $1}' | grep "^tfs"
--execute "SHOW DATABASES;" --format=tsv | awk '{print $1}' | grep "^tfs"
#kubectl exec -i --namespace ${CRDB_NAMESPACE} cockroachdb-0 -- \
# ./cockroach sql --certs-dir=/cockroach/cockroach-certs --url=${CRDB_CLIENT_URL} \
# --execute "SHOW DATABASES;" --format=tsv | awk '{print $1}' | grep "^tfs"
)
)
echo "Found TFS databases: ${DATABASES}" | tr '\n' ' '
echo "Found TFS databases: ${DATABASES}" | tr '\n' ' '
echo
echo
@@ -179,11 +168,8 @@ function crdb_drop_databases_single() {
@@ -179,11 +168,8 @@ function crdb_drop_databases_single() {
for DB_NAME in $DATABASES; do
for DB_NAME in $DATABASES; do
echo "Dropping TFS database: $DB_NAME"
echo "Dropping TFS database: $DB_NAME"
kubectl exec -i --namespace ${CRDB_NAMESPACE} cockroachdb-0 -- \
kubectl exec -i --namespace ${CRDB_NAMESPACE} cockroachdb-0 -- \
./cockroach sql --certs-dir=/cockroach/cockroach-certs --host=cockroachdb-public \
./cockroach sql --certs-dir=/cockroach/cockroach-certs --url=${CRDB_CLIENT_URL} \
--execute="DROP DATABASE IF EXISTS $DB_NAME CASCADE;"
--execute="DROP DATABASE IF EXISTS $DB_NAME CASCADE;"
#kubectl exec -i --namespace ${CRDB_NAMESPACE} cockroachdb-0 -- \
# ./cockroach sql --certs-dir=/cockroach/cockroach-certs --url=${CRDB_CLIENT_URL} \
# --execute="DROP DATABASE IF EXISTS $DB_NAME CASCADE;"
done
done
echo
echo
}
}
Loading