
from alembic import op


# revision identifiers, used by Alembic.
revision = '2d503b5034b7'
down_revision = '2a0313a8a7d6'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('rpms', new_column_name='artifacts')


def downgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('artifacts', new_column_name='rpms')


from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '2d503b5034b7'
down_revision = '2a0313a8a7d6'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('rpms', existing_type=sa.Text(),
                              new_column_name='artifacts')


def downgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('artifacts', existing_type=sa.Text(),
                              new_column_name='rpms')

Fix alembic migration for rpms->artifacts rename
Fix alembic migration for rpms->artifacts rename

The migration does not work on MySQL-based engines, because it
requires setting the existing_type parameter [1]. It worked fine
on SQLite, though.

[1] - https://alembic.sqlalchemy.org/en/latest/ops.html#alembic.operations.Operations.alter_column

Change-Id: If0cc05af843e3db5f4b2e501caa8f4f773b24509

  
  from alembic import op
+ import sqlalchemy as sa
  
  
  # revision identifiers, used by Alembic.
  revision = '2d503b5034b7'
  down_revision = '2a0313a8a7d6'
  branch_labels = None
  depends_on = None
  
  
  def upgrade():
      with op.batch_alter_table("commits") as batch_op:
-         batch_op.alter_column('rpms', new_column_name='artifacts')
+         batch_op.alter_column('rpms', existing_type=sa.Text(),
+                               new_column_name='artifacts')
  
  
  def downgrade():
      with op.batch_alter_table("commits") as batch_op:
-         batch_op.alter_column('artifacts', new_column_name='rpms')
+         batch_op.alter_column('artifacts', existing_type=sa.Text(),
+                               new_column_name='rpms')
  
Fix alembic migration for rpms->artifacts rename
## Code Before:

from alembic import op


# revision identifiers, used by Alembic.
revision = '2d503b5034b7'
down_revision = '2a0313a8a7d6'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('rpms', new_column_name='artifacts')


def downgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('artifacts', new_column_name='rpms')

## Instruction:
Fix alembic migration for rpms->artifacts rename
## Code After:

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '2d503b5034b7'
down_revision = '2a0313a8a7d6'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('rpms', existing_type=sa.Text(),
                              new_column_name='artifacts')


def downgrade():
    with op.batch_alter_table("commits") as batch_op:
        batch_op.alter_column('artifacts', existing_type=sa.Text(),
                              new_column_name='rpms')
