How to get SVN revision number using the SVN 1.7 database

As easy as:

[root@web ~]# sqlite3 /var/www/wordpress/.svn/wc.db
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT "changed_revision" FROM "NODES" ORDER BY changed_revision DESC LIMIT 1;
[root@web ~]#

Leave a Reply

Your email address will not be published. Required fields are marked *