Show More
109_version_4_21_1.py
52 lines
| 1.2 KiB
| text/x-python
|
PythonLexer
r5042 | ||||
r4481 | ||||
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.PullRequestReviewers.__table__ | ||||
with op.batch_alter_table(table.name) as batch_op: | ||||
new_column = Column('role', Unicode(255), nullable=True) | ||||
batch_op.add_column(new_column) | ||||
_fill_reviewers_role(db, op, meta.Session) | ||||
def downgrade(migrate_engine): | ||||
meta = MetaData() | ||||
meta.bind = migrate_engine | ||||
def fixups(models, _SESSION): | ||||
pass | ||||
def _fill_reviewers_role(models, op, session): | ||||
params = {'role': 'reviewer'} | ||||
query = text( | ||||
'UPDATE pull_request_reviewers SET role = :role' | ||||
).bindparams(**params) | ||||
op.execute(query) | ||||
session().commit() | ||||