pre-commit hook for sqlinter

pre-commit.bash

if [[ ! $(which gem) ]]; then
        echo "You don't have gem installed. Go install it."
        exit 1
fi

if [[ ! $(which sqlint) ]]; then
        gem install sqlint
fi

git diff --cached --name-status | xargs -0 | while read st file; do
        # skip deleted files
        if [ "$st" == 'D' ]; then continue; fi
        # do a check only on the sql files
        if [[ ! $file =~ .sql$ ]]; then continue; fi
        res=$(sqlint $file)
        exitCode=$?
        if [[ exitCode != 0 ]]; then
                echo $res
                exit 1
        fi
done