Complex reporting on subversion (possibly Export Subversion log into database for reporting)

Posted by James A. N. Stauffer on Stack Overflow See other posts from Stack Overflow or by James A. N. Stauffer
Published on 2010-04-01T16:38:02Z Indexed on 2010/04/01 16:43 UTC
Read the original article Hit count: 510

Filed under:

What is the best way to do complex reporting on subversion logs like the following for each file? file, directory, last revision date, previous revision date(where revision date is at least 30 older than last), days diff(between revision dates)

Since Subversion allows on revision to change multiple files I assume svn log needs to be run against each file individually.

Ideas (that don't seem very good):

Shell scripting to produce a csv file to be imported to a DB. The following is a start but doesn't show the filename: find . -name "." -print | xargs -l svn log -l 2

Shell scripting to produce XML and then use XSLT to create CSV to import to a DB. It might use a similar command to above but would still have some of the same limitation.

Write a program to just parse the log on the whole directory tree, make one insert to DB per revision/file combination, and then query the DB.

© Stack Overflow or respective owner

Related posts about svn