Mercurial and Oracle Apps version control (lot's of DDL)

[Greg Ward]

On Mon, Nov 15, 2010 at 11:19 PM, Joe Ferr <jferr at brocade.com> wrote:
> I think that using hg status --rev X:Y would work if there wasn't a better option.  I would need to parse the output of this command to figure out which files I'd need to copy/execute.

See Matt's response: you can use "hg status" to stitch together
everything you need.

> What I'm ideally looking for...it would be great if I could get this both from the command line and from hgweb...is a way to get all of these files in one command.  E.g. an export command which would let me pass two identifiers (tags or revs) and a directory name and mercurial would retrieve all files changed or added between these two tags/revs.

That's not the Mercurial way, because it's not the Unix way.
Mercurial and Unix provide all the tools you need to do this.  Put 'em
together in a little shell script and you're done.  Here's one
possible approach:

  # X is the changeset of the previous run
  # Y is the  new changeset containing new/changed scripts
  hg update Y
  files=`hg status -nma --rev X:Y`
  tmpdir=`mktemp -d`
  tar -cf - $files | (cd $tmpdir && tar -xf -)
  cd $tmpdir
  for script in $files;
      run $script
  done

That make a couple of assumptions:
  * no spaces in filenames or directory names
  * all modified files are valid database scripts -- you might need to
pass some filters to "hg status" to ensure that

Completely untested, of course.  YMMV.

Greg