added current db version into rhodecode,

added auto versioning of newly created databases

rhodecode/__init__.py

@@ -29,6 +29,7 b''
 
 VERSION = (1, 1, 0, 'beta')
 __version__ = '.'.join((str(each) for each in VERSION[:4]))
+__dbversion__ = 1 #defines current db version for migrations
 
 from rhodecode.lib.utils import get_current_revision
 _rev = get_current_revision()

rhodecode/lib/db_manage.py

@@ -80,6 +80,23 b' class DbManage(object):'
         meta.Base.metadata.create_all(checkfirst=checkfirst)
         log.info('Created tables for %s', self.dbname)
 
+
+
+    def set_db_version(self):
+        from rhodecode import __dbversion__
+        from rhodecode.model.db import DbMigrateVersion
+        try:
+            ver = DbMigrateVersion()
+            ver.version = __dbversion__
+            ver.repository_id = 'rhodecode_db_migrations'
+            ver.repository_path = 'versions'
+            self.sa.add(ver)
+            self.sa.commit()
+        except:
+            self.sa.rollback()
+            raise
+        log.info('db version set to: %s', __dbversion__)
+
     def admin_prompt(self, second=False):
         if not self.tests:
             import getpass

rhodecode/model/db.py

@@ -3,7 +3,8 b''
     rhodecode.model.db
     ~~~~~~~~~~~~~~~~~~
     
-    Database Models for RhodeCode    
+    Database Models for RhodeCode
+    
     :created_on: Apr 08, 2010
     :author: marcink
     :copyright: (C) 2009-2010 Marcin Kuzminski <[e-mail]>    
@@ -246,3 +247,11 b' class CacheInvalidation(Base, BaseModel)'
 
     def __repr__(self):
         return "<CacheInvalidation('%s:%s')>" % (self.cache_id, self.cache_key)
+
+class DbMigrateVersion(Base, BaseModel):
+    __tablename__ = 'db_migrate_version'
+    __table_args__ = {'useexisting':True}
+    repository_id = Column('repository_id', String(250), primary_key=True)
+    repository_path = Column('repository_path', Text)
+    version = Column('version', Integer)
+

rhodecode/websetup.py

@@ -11,6 +11,7 b' def setup_app(command, conf, vars):'
     dbconf = conf['sqlalchemy.db1.url']
     dbmanage = DbManage(log_sql=True, dbconf=dbconf, root=conf['here'], tests=False)
     dbmanage.create_tables(override=True)
+    dbmanage.set_db_version()
     dbmanage.config_prompt(None)
     dbmanage.create_default_user()
     dbmanage.admin_prompt()