On 9/9/2010 11:32 AM, Geoff Hoffman wrote:
I was wondering if anyone knows of a database schema that exists, preferably
for MySQL, which would support all or most of subversion repository metadata?
Specifically I was thinking of the current difficulty we have in knowing things
like:
- how many commits has user U done over the past month
- what trees did user U work on last week
- which trees have a deploy tag
- which trees are tagged with svn:external to path x/y
- what files changed inside a subtree from -r A:B
The only way I know of to get this information is svn log --verbose | grep
some-keyword, however walking a large repository tree takes a lot of time and
this requires advanced SVN knowledge.
I was thinking of making a cron script, or a post-commit hook, which would add
svn metadata to a mysql db so we can make searches against the svn metadata
database instantaneous, and create a search UI for non-technical people to
perform searches without command line svn experience.
I figured a project like this would exist, but I searched both tigris.org
projects and the archives and came up empty handed.
I don't know if you are interested in a commercial product, but fisheye
(http://www.atlassian.com/software/fisheye/) collates a bunch of that
data as well as providing full-text search over the repository.
--
Les Mikesell
lesmikes...@gmail.com