Changeset - 3cb5a35a319d
[Not reviewed]
default
0 2 1
Marcin Kuzminski - 12 years ago 2013-06-11 14:22:54
marcin@python-works.com
added migrations for column change for gists expiration date
3 files changed with 47 insertions and 1 deletions:
0 comments (0 inline, 0 general)
rhodecode/__init__.py
Show inline comments
 
@@ -51,7 +51,7 @@ except ImportError:
 

	
 
__version__ = ('.'.join((str(each) for each in VERSION[:3])) +
 
               '.'.join(VERSION[3:]))
 
__dbversion__ = 13  # defines current db version for migrations
 
__dbversion__ = 14  # defines current db version for migrations
 
__platform__ = platform.system()
 
__license__ = 'GPLv3'
 
__py_version__ = sys.version_info
rhodecode/lib/db_manage.py
Show inline comments
 
@@ -30,6 +30,7 @@ import time
 
import uuid
 
import logging
 
from os.path import dirname as dn, join as jn
 
import datetime
 

	
 
from rhodecode import __dbversion__, __py_version__
 

	
 
@@ -216,6 +217,13 @@ class UpgradeSteps(object):
 
    def step_13(self):
 
        pass
 

	
 
    def step_14(self):
 
        # fix nullable columns on last_update
 
        for r in RepoModel().get_all():
 
            if r.updated_on is None:
 
                r.updated_on = datetime.datetime.fromtimestamp(0)
 
                Session().add(r)
 
        Session().commit()
 

	
 
class DbManage(object):
 
    def __init__(self, log_sql, dbconf, root, tests=False, cli_args={}):
rhodecode/lib/dbmigrate/versions/014_version_1_7_1.py
Show inline comments
 
new file 100644
 
import logging
 
import datetime
 

	
 
from sqlalchemy import *
 
from sqlalchemy.exc import DatabaseError
 
from sqlalchemy.orm import relation, backref, class_mapper, joinedload
 
from sqlalchemy.orm.session import Session
 
from sqlalchemy.ext.declarative import declarative_base
 

	
 
from rhodecode.lib.dbmigrate.migrate import *
 
from rhodecode.lib.dbmigrate.migrate.changeset import *
 

	
 
from rhodecode.model.meta import Base
 
from rhodecode.model import meta
 
from rhodecode.lib.dbmigrate.versions import _reset_base
 

	
 
log = logging.getLogger(__name__)
 

	
 

	
 
def upgrade(migrate_engine):
 
    """
 
    Upgrade operations go here.
 
    Don't create your own engine; bind migrate_engine to your metadata
 
    """
 
    _reset_base(migrate_engine)
 

	
 
    #==========================================================================
 
    # Gist
 
    #==========================================================================
 
    from rhodecode.lib.dbmigrate.schema.db_1_7_0 import Gist
 
    tbl = Gist.__table__
 
    user_id = tbl.columns.gist_expires
 
    user_id.alter(type=Float(53))
 

	
 

	
 
def downgrade(migrate_engine):
 
    meta = MetaData()
 
    meta.bind = migrate_engine
0 comments (0 inline, 0 general)