Steps to deep clean pymssql repository

README.md

In response to pymssql/pymssql#496 I just forked and deep cleaned the pymssql repository in my fork.

Note that the procedure re-writes new commit SHA hashes .. which may be a reason for not doing this in the pymssql repository

All commands were copied bluntly from http://stevelorek.com/how-to-shrink-a-git-repository.html

step1_checkout.sh

#!/bin/bash
git clone https://github.com/shadiakiki1986/pymssql pymssql-shadi
cd pymssql-shadi

step2_remotes.sh

#!/bin/bash
for branch in `git branch -a | grep remotes | grep -v HEAD | grep -v master`; do
    git branch --track ${branch##*/} $branch
done

step3_listlarge.sh

#!/bin/bash
#set -x 

# Shows you the largest objects in your repo's pack file.
# Written for osx.
#
# @see http://stubbisms.wordpress.com/2009/07/10/git-script-to-show-largest-pack-objects-and-trim-your-waist-line/
# @author Antony Stubbs

# set the internal field spereator to line break, so that we can iterate easily over the verify-pack output
IFS=$'\n';

# list all objects including their size, sort by size, take top 10
objects=`git verify-pack -v .git/objects/pack/pack-*.idx | grep -v chain | sort -k3nr | head`

echo "All sizes are in kB. The pack column is the size of the object, compressed, inside the pack file."

output="size,pack,SHA,location"
for y in $objects
do
	# extract the size in bytes
	size=$((`echo $y | cut -f 5 -d ' '`/1024))
	# extract the compressed size in bytes
	compressedSize=$((`echo $y | cut -f 6 -d ' '`/1024))
	# extract the SHA
	sha=`echo $y | cut -f 1 -d ' '`
	# find the objects location in the repository tree
	other=`git rev-list --all --objects | grep $sha`
	#lineBreak=`echo -e "\n"`
	output="${output}\n${size},${compressedSize},${other}"
done

echo -e $output | column -t -s ', '

step4_filterbranch.sh

#!/bin/bash
# Note the list of filenames was obtained with
# bash step3_listlarge.sh|awk '{print $4}'|sort|uniq

git filter-branch --tag-name-filter cat --index-filter \
  'git rm -r --cached --ignore-unmatch freetds/nix_32/lib/libsybdb.a freetds/nix_64/lib/libsybdb.a freetds/vs2008_32/lib/db-lib.lib freetds/vs2008_32/lib/tds.lib win32/freetds.zip ntwdblib.dll src/_mssql.pyx win32/freetds/lib/dblib.lib win32/freetds/lib/libTDS.lib' \
  --prune-empty -f -- --all

step5_reclaim.sh

#!/bin/bash

rm -rf .git/refs/original/
git reflog expire --expire=now --all
git gc --prune=now
git gc --aggressive --prune=now

step6_push.sh

git push origin --force --all
git push origin --force --tags