##// 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
016_version_2_0_0.py
69 lines | 2.0 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, notify
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_2_0_0
tbl = db_2_0_0.User.__table__
extern_type = Column("extern_type",
String(255, convert_unicode=False, ),
nullable=True, unique=None, default=None)
extern_type.create(table=tbl)
extern_name = Column("extern_name", String(255, convert_unicode=False),
nullable=True, unique=None, default=None)
extern_name.create(table=tbl)
created_on = Column('created_on', DateTime(timezone=False),
nullable=True, default=datetime.datetime.now)
created_on.create(table=tbl)
# issue fixups
fixups(db_2_0_0, meta.Session)
def downgrade(migrate_engine):
meta = MetaData()
meta.bind = migrate_engine
def fixups(models, _SESSION):
notify('Fixing default created on')
for usr in models.User.get_all():
usr.created_on = datetime.datetime.now()
_SESSION().add(usr)
_SESSION().commit()
notify('Migrating LDAP attribute to extern')
for usr in models.User.get_all():
ldap_dn = usr.ldap_dn
if ldap_dn:
usr.extern_name = ldap_dn
usr.extern_type = 'ldap'
else:
usr.extern_name = 'rhodecode'
usr.extern_type = 'rhodecode'
_SESSION().add(usr)
_SESSION().commit()