Subversion Keywords (Revision,Author,URL,Date,ID)

It is useful if every (touched) DB-Object contains in the future the following lines:

Procedures/Functions must contain in the Header-Comment:

/*** URL: $URL$ */
/*** Revision: $Rev$ */
/*** Author: $Author$ */
/*** Date: $Date$ */
/*** ID: $Id$ */

Table-Create-Statements have to be enhanced with the following statement:

COMMENT ON TABLE IS ‘
URL: $URL$
Revision: $Rev$
Author: $Author$
Date: $Date$
ID: $Id$
‘;

—————————————————————————————————————————-

Explanation:

These variables will be replaced by every SVN-Checkin (Subversion-VersionsControll-System) with their pendants.
Example:
$URL$ => $URL: http://…/branches/SDLCV11726/svn-test.txt $
$Rev$ => $Rev: 13558 $
$Author$ => $Author: herzogg $
$Date$ => $Date: 2012-09-13 15:58:28 +0200 (Do, 13 Sep 2012) $
$Id$ => $Id: svn-test.txt 13558 2012-09-13 13:58:28Z herzogg $

So it is possible to see in the Database which version is the Table/Function/Procedure and so on,
what is very helpful.

—————————————————————————————————————————-
Configuration of Tortoise SVN

To activate this feature in SVN please open SVN-Settings ([context-menu]->[TortoiseSVN]->[Settings]
Then Click [EDIT] on the Subversion Configuration File on the General – Tab:

Add or uncomment the following line in this config-file in the [miscellany] – Section

enable-auto-props=yes

Add following lines in this config-file in the [auto-props] – Section
(Add new file-endings if you are using different…)
*.sql = svn:keywords=URL Rev Author Date Id
*.fnc = svn:keywords=URL Rev Author Date Id
*.prc = svn:keywords=URL Rev Author Date Id
*.pks = svn:keywords=URL Rev Author Date Id
*.pkb = svn:keywords=URL Rev Author Date Id
*.txt = svn:keywords=URL Rev Author Date Id

How to set these properties for existing files in a already running Project.

One thought on “Subversion Keywords (Revision,Author,URL,Date,ID)”

Comments are closed.