post-checkout Toggle source code

#!/bin/sh
#exec powershell.exe -NoProfile -ExecutionPolicy Bypass -File "<TODO_RELATIVE_PATH>\clone.sh"
 
 
exec  "<TODO_RELATIVE_PATH>\clone.sh"
 
exit

clone.sh Toggle source code

#!/bin/bash
DATA_IMAGE="<TODO_IMAGE_NAME>"
FW_KEY="<TODO_LICENSE_KEY>"
BRANCH_NAME="$(git rev-parse --symbolic-full-name --abbrev-ref HEAD)"
CONTAINER_NAME="<TODO_PROJECT_NAME>.$BRANCH_NAME.$USERNAME"
STANDBY_NAME="<TODO_PROJECT_NAME>.standby"
DEV_PORT="10000"
 
# Timing the total operation
totalStartTime=$(date +%s)
 
# In case the proxy isn't running/working, we kill it here and reinstate it later
echo "Kill any rgclone proxy that may be running"
tskill rgclone
 
if ! rgclone.exe get data-container "$CONTAINER_NAME" &> /dev/null ; 
then
    
    echo "No data container for the current branch - will try to provision one"
    if ! rgclone.exe get dc $STANDBY_NAME &> /dev/null ; 
    then
        echo "No standby found - please wait a couple of minutes while we create a new clone (and a standby for future use)"
 
        startTime=$(date +%s)
 
        sh $PWD/clone-standby.sh
 
        # Now we have an up-to-date migrated standby we can rename immediately for our branch
        rgclone.exe update dc $STANDBY_NAME -n "$CONTAINER_NAME" --lifetime 30m
        echo "Standby data container has been renamed to $CONTAINER_NAME"
        endTime=$(date +%s)
        echo ""
        echo "######## DATA CONTAINER CREATED ###############"
        echo "Time taken: $(expr $endTime - $startTime) seconds"  
 
    else
        echo "We have found a standby that we can update and rename for our new branch!" 
        # Update the standby in case pending migrations have been created since it was created
        echo "Running Flyway migrate on standby"
        CLONE_PASSWORD="$(rgclone.exe get data-container $STANDBY_NAME -o json | jq .password -j)"
        PORT="$(rgclone.exe get data-container $STANDBY_NAME -o json | jq .port -j)"
        HOST="$(rgclone.exe get data-container $STANDBY_NAME -o json | jq .host -j)"
        URL="jdbc:sqlserver://$HOST:$PORT;databaseName=StackOverflow;encrypt=true;trustServerCertificate=true;"
 
        echo "Running Flyway info migrate: $URL port $PORT host $HOST pass $CLONE_PASSWORD"
        flyway info migrate -url=$URL -user=sa -password=$CLONE_PASSWORD info -licenseKey=$FW_KEY
        
        rgclone.exe update dc $STANDBY_NAME -n "$CONTAINER_NAME" --lifetime 30m
        echo "Standby data container has been renamed to $CONTAINER_NAME"
    fi   
 
    # need to update the state from the schema model
    # We have to restart the proxy to use flyway-dev as this pulls the connection details from flyway-dev.json
    echo "Now we start the proxy on port $DEV_PORT"
    rgclone.exe proxy dc $CONTAINER_NAME --port $DEV_PORT &
    
    echo "Updating the schema state (this will overwrite any changes you haven't committed)" 
    flyway-dev diff --project $PWD --from SchemaModel --to Dev --i-agree-to-the-eula --artifact changes.zip 
    echo "Running Take and piping to Apply (through less as I can't get it working without this)"
    flyway-dev take --artifact changes.zip --project $PWD --i-agree-to-the-eula | less | flyway-dev apply --artifact changes.zip --project $PWD --i-agree-to-the-eula
    rm changes.zip
    echo "#####################################################"
    echo ""
    echo "###### DEV DB up to date and ready to use! ##########"
    echo ""
    echo "## (although a new standby will be kicked off now) ##"
    echo "#####################################################"
    # Now we should create a new standby for the next branch/person
    sh $PWD/clone-standby.sh &> /dev/null
 
else
    echo ""
    echo "A data container already exists for the branch $CONTAINER_NAME"
    echo ""
    echo "We reset the lifetime of the container to 30m"
    rgclone update dc $CONTAINER_NAME --lifetime 30m
 
    echo "Now we start the proxy on port $DEV_PORT"
    rgclone.exe proxy dc $CONTAINER_NAME --port $DEV_PORT &
fi
 
totalEndTime=$(date +%s)
 
echo "###########################################"
echo ""
echo "######## ALL DONE !!! #####################"
echo "Time taken: $(expr $totalEndTime - $totalStartTime) seconds"
echo "###########################################"

clone-standby.sh Toggle source code

#!/bin/bash
IMAGE="<TODO_IMAGE_NAME>"
KEY="<TODO_LICENSE_kEY>"
BRANCH_NAME="$(git rev-parse --symbolic-full-name --abbrev-ref HEAD)"
CONTAINER_NAME="<TODO_PROJECT_NAME>.$BRANCH_NAME.$USERNAME"
DEV_PORT="10000"
LIFETIME="240m"
CONTAINER="<TODO_PROJECT_NAME>.standby"
 
echo ""
echo "Creating a brand new data container based on $IMAGE"
echo ""
echo "######## Data Container CREATED ###############"
 
rgclone.exe create dc --name "$CONTAINER" --image "$IMAGE" --lifetime $LIFETIME
 
CLONE_PASSWORD="$(rgclone.exe get data-container $CONTAINER -o json | jq .password -j)"
PORT="$(rgclone.exe get data-container $CONTAINER -o json | jq .port -j)"
HOST="$(rgclone.exe get data-container $CONTAINER -o json | jq .host -j)"
#Ideally all in the following section are pre-configured in the data image
# TODO - try to combine these to make this part faster
URL="jdbc:sqlserver://$HOST:$PORT;databaseName=StackOverflow;encrypt=true;trustServerCertificate=true;"
echo "URL is: $URL"
flyway -initSql="EXEC sp_addrolemember 'db_owner', 'Dev1'" -url=$URL -user=sa -password=$CLONE_PASSWORD info -licenseKey=$KEY -connectRetries=7
 
echo "Updating Server adding Dev1 to sysadmin role - required for tSQLt" 
echo "Enabling CLR - required for tSQLt" 
echo "Enabling Advanced options so strict security can be disabled - required for tSQLt" 
echo "Disabling strict security - required for tSQLt" 
URL="jdbc:sqlserver://$HOST:$PORT;databaseName=Master;encrypt=true;trustServerCertificate=true;"
flyway -initSql="ALTER SERVER ROLE [sysadmin] ADD MEMBER [Dev1];EXEC sp_configure 'clr enabled', 1; EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'clr strict security', 0; RECONFIGURE;" -url=$URL -user=sa -password=$CLONE_PASSWORD info -licenseKey=$KEY
 
echo "Baselining dev DB" 
echo "Migrating dev DB to the most recent version" 
URL="jdbc:sqlserver://$HOST:$PORT;databaseName=StackOverflow;encrypt=true;trustServerCertificate=true;"
flyway baseline migrate -url=$URL -user=sa -password=$CLONE_PASSWORD info -licenseKey=$KEY 
 
# need to update the state from the schema model
# but can't as this only works when the proxy is on, as this uses the flyway-dev.json dev connection string
#flyway-dev diff --project $PWD --from SchemaModel --to Dev --i-agree-to-the-eula --artifact changes.zip 
#echo "Running Take and piping to Apply (through less)"
#flyway-dev take --artifact changes.zip --project $PWD --i-agree-to-the-eula | less | flyway-dev apply --artifact changes.zip --project $PWD --i-agree-to-the-eula
#rm changes.zip
 
#################################################
 
echo "Updating Shadow DB"
URL="jdbc:sqlserver://$HOST:$PORT;databaseName=StackOverflow_Shadow;encrypt=true;trustServerCertificate=true;"
flyway -initSql="EXEC sp_addrolemember 'db_owner', 'Dev1'" -url=$URL -user=sa -password=$CLONE_PASSWORD info -licenseKey=$KEY