##// END OF EJS Templates
Added tag v4.27.1 for changeset 1e0ab770108a
Added tag v4.27.1 for changeset 1e0ab770108a

File last commit:

r1:854a839a default
r4784:d07c3d05 stable
Show More
014_version_1_7_1.py
50 lines | 1.4 KiB | text/x-python | PythonLexer
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)
from rhodecode.lib.dbmigrate.schema import db_1_7_0
#==========================================================================
# Gist
#==========================================================================
tbl = db_1_7_0.Gist.__table__
user_id = tbl.columns.gist_expires
user_id.alter(type=Float(53))
# issue fixups
fixups(db_1_7_0, meta.Session)
def downgrade(migrate_engine):
meta = MetaData()
meta.bind = migrate_engine
def fixups(models, _SESSION):
# fix nullable columns on last_update
for r in models.Repository().get_all():
if r.updated_on is None:
r.updated_on = datetime.datetime.fromtimestamp(0)
_SESSION().add(r)
_SESSION().commit()