Skip to content

Instantly share code, notes, and snippets.

@renatocron
Created July 27, 2015 18:59
Show Gist options
  • Save renatocron/027e914a6e62a6ff2cf6 to your computer and use it in GitHub Desktop.
Save renatocron/027e914a6e62a6ff2cf6 to your computer and use it in GitHub Desktop.
bash.rc with sqitch deploy helpers
deploydb_last_version () {
perl -e 'my $last = [ sort { $b <=> $a } grep {/^\d{1,4}-/} @ARGV]->[0]; $last =~ s/\.sql$//; print "$last"' `ls deploy_db/deploy/`
}
deploydb_next_version () {
perl -e 'my $name = shift @ARGV; my $last = [ sort { $b <=> $a } grep {/^\d{1,4}-/} @ARGV]->[0]; $last =~ s/\.sql$//; $last =~ s/^(\d+)-.+/sprintf(q{%04d}, $1+1)/e; print "$last-$name"' $1 `ls deploy_db/deploy/`
}
new_deploy (){
sqitch add `deploydb_next_version $1` --requires `deploydb_last_version` -n "${*:2}"
$EDITOR deploy_db/deploy/`deploydb_last_version`.sql
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment