-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07.09.2012 16:44, G Srinivas wrote: > Hi All, > > We have integrated SVN and Post Commit hook in our Trac install. > > As we have a big project, we are trying to find an automated report that > can list all *modified files* for a given ticket or set of tickets > > Has anyone done this or is there an existing plugin that we can add? > > If not, we can write our custom report but not able to find much details > on the database structure
Maybe you didn't query the large knowledge base of TracWiki at trac.edgewall.org? I.e. I know there is some database explanation [1], and always there's the source, if you're willing to dig into and read it [2]. However, the link between tickets and files is not obvious, and certainly not easy to catch by SQL queries, at least in the default configuration. The common pattern is a well-formatted, verbose commit message, that has one or more ticket references by ticket id in it. Wikification of this '#<ticket_nr>' yields a direct link from ticket to changeset, and vice versa. But just form text content, not directly from a dedicated db field. In short: If you find changesets in ticket comments, than you'll easily get files for that changesets too. Hope, that this will get you started. Sincerely, Steffen Hoffmann [1] http://trac.edgewall.org/wiki/TracDev/DatabaseSchema [2] http://trac.edgewall.org/browser/tags/trac-0.12.3/trac/db_default.py -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlBKFIQACgkQ31DJeiZFuHcj5ACgscaNJDtsMtC2oyszhXcpoyD0 BiwAn0H9qQO0F9dtOOaZ6t3Y3KWFOVpl =32D7 -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
