Trac SVN change reports

[G Srinivas]

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

Thanks in advance

[Steffen Hoffmann]

-----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-----

[RjOllos]

On Friday, September 7, 2012 7:44:25 AM UTC-7, Srinivas G wrote:

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?

You may want to look closely at the following plugins:

 * http://trac-hacks.org/wiki/TracTicketChangesetsPlugin 

 * http://trac-hacks.org/wiki/TicketModifiedFilesPlugin 

TracTicketChangesetsPlugin probably fits your needs more closely, as I understand them.

[G Srinivas]

Thank you Steve amd RjOllos for your timely inputs.

We managed to write an automated script using Phing and PHP to auto deploy files to our apache server for given ticket or tickets.

Here is the high level path we have taken

1. phing get-files command takes ticket number or ticket numbers as CSV as parameter and executes a PHP file which queries the Trac database and generates an xml file for input to Phing
2. phing deploy which reads input xml file and checks out those files with specific revision to a temporary area and copies those files to destination

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.

To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/7WHIXQLVSc8J.

To post to this group, send email to trac-...@googlegroups.com.
To unsubscribe from this group, send email to trac-users+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.