OpenStack Study: 018_add_image_locations_table.py

**** CubicPower OpenStack Study ****

def upgrade(migrate_engine):

    meta = sqlalchemy.schema.MetaData(migrate_engine)

    #NOTE(bcwaldon): load the images table for the ForeignKey below

    sqlalchemy.Table('images', meta, autoload=True)

    image_locations_table = sqlalchemy.Table(

        'image_locations', meta,

        sqlalchemy.Column('id',

                          schema.Integer(),

                          primary_key=True,

                          nullable=False),

        sqlalchemy.Column('image_id',

                          schema.String(36),

                          sqlalchemy.ForeignKey('images.id'),

                          nullable=False,

                          index=True),

        sqlalchemy.Column('value',

                          schema.Text(),

                          nullable=False),

        sqlalchemy.Column('created_at',

                          schema.DateTime(),

                          nullable=False),

        sqlalchemy.Column('updated_at',

                          schema.DateTime()),

        sqlalchemy.Column('deleted_at',

                          schema.DateTime()),

        sqlalchemy.Column('deleted',

                          schema.Boolean(),

                          nullable=False,

                          default=False,

                          index=True),

    )

    schema.create_tables([image_locations_table])

**** CubicPower OpenStack Study ****

def downgrade(migrate_engine):

    meta = sqlalchemy.schema.MetaData(migrate_engine)

    image_locations_table = sqlalchemy.Table('image_locations', meta,

                                             autoload=True)

    schema.drop_tables([image_locations_table])