Page Comparison

...

1. Checkout Datical project from your source control (Git, TFS, SVN)
2. Run "hammer removeLabels" command. This command takes two arguments:
   1. lookupChangesets - This is the script name which you want to abandon, e.g., "abandoned,temp_table.sql". The "temp_table.sql" will be the FIRST user provided argument.
   2. labels - This is the label you want to remove from your changesets, e.g., "abandoned"
      1. Once you agree on what naming convention to use to abandon changes, this argument can be programmatic (e.g., "q4-2017-abandonedabandoned/1.0.0") or hard-coded (e.g., "abandoned").
3. Run "hammer addLabels" command. This command takes two arguments:
   1. lookupChangesets - This is the script name which you unabandon, e.g., "temp_table.sql". The "temp_table.sql" is the FIRST user provided argument.
   2. labels - This is the new release label you want to give to your changesets, e.g., "release/2.0.0". The "release/2.0.0" is the SECOND user provided argument.
4. Commit and push Datical project back into source control
5. Publish a new artifact version

Here is the complete sample script with some additional code for before and after status:

...

echo -------------------------------
set PATH=%PATH%;C:\apps\Datical\repl

git clone http://user@bitbucket.datical.net/scm/bbu/ddb.git
cd ddb

git branch --set-upstream-to=origin/master master 
git status

call
hammer findChangeSets --lookupChangesets="abandoned,%lookupChangesets%"
echo
call hammer removeLabels --lookupChangesets="abandoned,%lookupChangesets%" --labels="abandoned"
echo
call hammer addLabels --lookupChangesets="%lookupChangesets%" --labels="%newReleaseLabel%"
echo
call hammer findChangeSets --lookupChangesets="%lookupChangesets%,%newReleaseLabel%"

REM add steps to commit Datical project into Git.
echo commit new changes back into Bitbucket
call
git add -A
call git commit -m "Automations:UnabandonScript-%lookupChangesets% - build number=%BUILD_NUMBER%"
call
git push -u origin master
echo -------------------------------

...

Here is how the abandoned changeset looks like in Datical GUI:

Now that the "abandoned" label has been added, you want to make removed, make sure to create a new artifact version.

1. When you use your deployment automation tool you will use your newly created versioned artifact to deploy database changes.

Make sure that you alway deploy using "!abandoned" label (notice the "!") with your deploy automation tool. Here is a sample deploy command you would use:

1. 1. hammer deploy STAGE --labels "release/2.0.0 AND !abandoned"
   2. hammer deploy PROD --labels "release/2.0.0 AND !abandoned"

Related articles

...