Show More
111_version_4_23_0.py
53 lines
| 1.2 KiB
| text/x-python
|
PythonLexer
r4540 | # -*- coding: utf-8 -*- | |||
import logging | ||||
from sqlalchemy import * | ||||
from alembic.migration import MigrationContext | ||||
from alembic.operations import Operations | ||||
from rhodecode.lib.dbmigrate.versions import _reset_base | ||||
from rhodecode.model import meta, init_model_encryption | ||||
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_4_20_0_0 as db | ||||
init_model_encryption(db) | ||||
context = MigrationContext.configure(migrate_engine.connect()) | ||||
op = Operations(context) | ||||
table = db.ChangesetComment.__table__ | ||||
with op.batch_alter_table(table.name) as batch_op: | ||||
new_column = Column('draft', Boolean(), nullable=True) | ||||
batch_op.add_column(new_column) | ||||
_set_default_as_non_draft(op, meta.Session) | ||||
def downgrade(migrate_engine): | ||||
meta = MetaData() | ||||
meta.bind = migrate_engine | ||||
def fixups(models, _SESSION): | ||||
pass | ||||
def _set_default_as_non_draft(op, session): | ||||
params = {'draft': False} | ||||
query = text( | ||||
'UPDATE changeset_comments SET draft = :draft' | ||||
).bindparams(**params) | ||||
op.execute(query) | ||||
session().commit() | ||||