mediagoblin/media_types/image/migrations/a98c1a320e88_image_media_type_initial.py

   1 """Image media type initial migration
   2
   3 Revision ID: a98c1a320e88
   4 Revises: 52bf0ccbedc1
   5 Create Date: 2016-03-12 21:10:10.155623
   6 """
   7
   8 # revision identifiers, used by Alembic.
   9 revision = 'a98c1a320e88'
  10 down_revision = '52bf0ccbedc1'
  11 branch_labels = ('image_media_type',)
  12 depends_on = None
  13
  14 from alembic import op
  15 import sqlalchemy as sa
  16
  17
  18 def upgrade():
  19     if op.get_bind().engine.has_table("image__mediadata"):
  20         # Skip; this has already been instantiated
  21         # (probably via sqlalchemy-migrate)
  22         return
  23
  24     op.create_table(
  25         'image__mediadata',
  26         sa.Column('media_entry', sa.Integer(), nullable=False),
  27         sa.Column('width', sa.Integer(), nullable=True),
  28         sa.Column('height', sa.Integer(), nullable=True),
  29         sa.Column('exif_all', sa.UnicodeText(), nullable=True),
  30         sa.ForeignKeyConstraint(['media_entry'], ['core__media_entries.id'], ),
  31         sa.PrimaryKeyConstraint('media_entry'))
  32
  33
  34 def downgrade():
  35     # @@: Is this safe?
  36     op.drop_table('image__mediadata')