Search code examples
svnreverse-lookup

Mapping .svn/pristine file back to file in svn (reverse lookup)

So I found a file inside .svn folder which has filename like this.

.svn/pristine/fa/faa0544abc11c14647e18c2ee1283b445a1fa1e1.svn-base

Now by looking at contents of this file I want to figure out which filename it had in SVN tree. It has been deleted now from tree. So how do I reverse look up this file in history?

Solution

  • In the .svn folder of your repository you will find a file wc.db. This is a sqlite db.

    The filename in the pristine folder is actually its sha1 checksum.

    So you can try something like this:

    SELECT local_relpath  FROM `NODES` WHERE checksum=`$sha1$faa0544abc11c14647e18c2ee1283b445a1fa1e1`

    or

    SELECT repos_path FROM `NODES` WHERE checksum=`$sha1$faa0544abc11c14647e18c2ee1283b445a1fa1e1`