Mailing List Archive

Hi,

in order to update on the live server the files updated during a
ticket resolution, I'd like to get the list of files changed in a list
of revisions.

Is that possible with a SQL Query ? If yes how ?

If you could just direct me to the relevant documentation section I'd
be more than happy. Or just tell me if it's not possible :)

Thanks in advance,

--
Best regards,
Katana mailto:katana@katana-inc.com

You can get this information from the node_change table, e.g.:

select name, change from node_change where rev in (567, 568)

or similar.

However, this is just a cache of the information in the subversion =
repository, and is only updated when you hit a relevant page in Trac.

For the purpose of updating your live server, you would probably be =
better off using svn diff e.g.:

svn diff -r567:568 and applying the diff to your live server, or =
grepping the output to get a file list.

Hope this helps.

Ian.

-----Original Message-----
From: trac-bounces@lists.edgewall.com =
[mailto:trac-bounces@lists.edgewall.com] On Behalf Of Katana
Sent: 03 September 2004 09:23
To: trac@lists.edgewall.com
Subject: [Trac] List all files changed in a list of Changesets ?


Hi,

in order to update on the live server the files updated during a ticket =
resolution, I'd like to get the list of files changed in a list of =
revisions.

Is that possible with a SQL Query ? If yes how ?

If you could just direct me to the relevant documentation section I'd be =
more than happy. Or just tell me if it's not possible :)

Thanks in advance,

--=20
Best regards,
Katana mailto:katana@katana-inc.com

_______________________________________________
Trac mailing list
Trac@lists.edgewall.com http://lists.edgewall.com/mailman/listinfo/trac

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.752 / Virus Database: 503 - Release Date: 03/09/2004
=20