def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'harvest_source', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('status', sa.UnicodeText, server_default=u'New'), sa.Column('url', sa.UnicodeText, unique=True, nullable=False), sa.Column('description', sa.UnicodeText, default=u''), sa.Column('user_ref', sa.UnicodeText, default=u''), sa.Column('publisher_ref', sa.UnicodeText, default=u''), sa.Column( 'created', sa.DateTime, server_default=sa.func.current_timestamp() ), ) op.create_table( 'harvesting_job', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('status', sa.UnicodeText, default=u'', nullable=False), sa.Column( 'created', sa.DateTime, server_default=sa.func.current_timestamp() ), sa.Column('user_ref', sa.UnicodeText, nullable=False), sa.Column('report', sa.UnicodeText, default=u''), sa.Column( 'source_id', sa.UnicodeText, sa.ForeignKey('harvest_source.id') ), )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column( 'system_info', sa.Column( 'state', sa.UnicodeText, nullable=False, server_default='active' ) ) op.add_column( 'system_info_revision', sa.Column( 'state', sa.UnicodeText, nullable=False, server_default='active' ) ) op.add_column( 'system_info_revision', sa.Column('expired_id', sa.UnicodeText) ) op.add_column( 'system_info_revision', sa.Column('revision_timestamp', sa.TIMESTAMP) ) op.add_column( 'system_info_revision', sa.Column('expired_timestamp', sa.TIMESTAMP) ) op.add_column('system_info_revision', sa.Column('current', sa.Boolean)) op.drop_constraint('system_info_revision_key_key', 'system_info_revision')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return for column in _columns: op.add_column('package', sa.Column(column, sa.UnicodeText)) op.add_column('package_revision', sa.Column(column, sa.UnicodeText))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('user', sa.Column('openid', sa.UnicodeText)) op.add_column('user', sa.Column('password', sa.UnicodeText)) op.add_column('user', sa.Column('fullname', sa.UnicodeText)) op.add_column('user', sa.Column('email', sa.UnicodeText))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('package_resource', sa.Column('extras', sa.UnicodeText)) op.add_column( 'package_resource_revision', sa.Column('extras', sa.UnicodeText) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('package_relationship', sa.Column('state', sa.UnicodeText)) op.add_column( 'package_relationship_revision', sa.Column('state', sa.UnicodeText) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'activity', sa.Column('id', sa.UnicodeText, nullable=False), sa.Column('timestamp', sa.TIMESTAMP), sa.Column('user_id', sa.UnicodeText), sa.Column('object_id', sa.UnicodeText), sa.Column('revision_id', sa.UnicodeText), sa.Column('activity_type', sa.UnicodeText), sa.Column('data', sa.UnicodeText), ) op.create_table( 'activity_detail', sa.Column('id', sa.UnicodeText, nullable=False), sa.Column('activity_id', sa.UnicodeText, nullable=False), sa.Column('object_id', sa.UnicodeText), sa.Column('object_type', sa.UnicodeText), sa.Column('activity_type', sa.UnicodeText), sa.Column('data', sa.UnicodeText), ) op.create_primary_key('activity_pkey', 'activity', ['id']) op.create_primary_key('activity_detail_pkey', 'activity_detail', ['id']) op.create_foreign_key( 'activity_detail_activity_id_fkey', 'activity_detail', 'activity', ['activity_id'], ['id'] )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'user_following_group', sa.Column('follower_id', sa.UnicodeText, nullable=False), sa.Column('object_id', sa.UnicodeText, nullable=False), sa.Column('datetime', sa.TIMESTAMP, nullable=False) ) op.create_primary_key( 'user_following_group_pkey', 'user_following_group', ['follower_id', 'object_id'] ) op.create_foreign_key( 'user_following_group_user_id_fkey', 'user_following_group', 'user', ['follower_id'], ['id'], onupdate='CASCADE', ondelete='CASCADE' ) op.create_foreign_key( 'user_following_group_group_id_fkey', 'user_following_group', 'group', ['object_id'], ['id'], onupdate='CASCADE', ondelete='CASCADE' )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('group', sa.Column('approval_status', sa.UnicodeText)) op.add_column( 'group_revision', sa.Column('approval_status', sa.UnicodeText) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('authorization_group_user', sa.Column('id', sa.UnicodeText)) op.create_primary_key( 'authorization_group_user_pkey', 'authorization_group_user', ['id'] )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_index( 'idx_package_extra_package_id', 'package_extra_revision', ['package_id', 'current'] )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_table('harvested_document_revision') op.drop_table('harvested_document') op.drop_table('harvesting_job') op.drop_table('harvest_source')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'related', sa.Column('id', sa.UnicodeText, nullable=False), sa.Column('type', sa.UnicodeText, nullable=False), sa.Column('title', sa.UnicodeText), sa.Column('description', sa.UnicodeText), sa.Column('image_url', sa.UnicodeText), sa.Column('url', sa.UnicodeText), sa.Column('created', sa.TIMESTAMP), sa.Column('owner_id', sa.UnicodeText) ) op.create_table( 'related_dataset', sa.Column('id', sa.UnicodeText, nullable=False), sa.Column('dataset_id', sa.UnicodeText, nullable=False), sa.Column('related_id', sa.UnicodeText, nullable=False), sa.Column('status', sa.UnicodeText) ) op.create_primary_key('related_pkey', 'related', ['id']) op.create_primary_key('related_dataset_pkey', 'related_dataset', ['id']) op.create_foreign_key( 'related_dataset_dataset_id_fkey', 'related_dataset', 'package', ['dataset_id'], ['id'] ) op.create_foreign_key( 'related_dataset_related_id_fkey', 'related_dataset', 'related', ['related_id'], ['id'] )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'package_resource', sa.Column('id', sa.Integer, primary_key=True), sa.Column('package_id', sa.Integer, sa.ForeignKey('package.id')), sa.Column('url', sa.UnicodeText, nullable=False), sa.Column('format', sa.UnicodeText), sa.Column('description', sa.UnicodeText), sa.Column('position', sa.Integer), sa.Column('state_id', sa.Integer), sa.Column('revision_id', sa.UnicodeText, sa.ForeignKey('revision.id')) ) op.create_table( 'package_resource_revision', sa.Column('id', sa.Integer, primary_key=True), sa.Column('package_id', sa.Integer, sa.ForeignKey('package.id')), sa.Column('url', sa.UnicodeText, nullable=False), sa.Column('format', sa.UnicodeText), sa.Column('description', sa.UnicodeText), sa.Column('position', sa.Integer), sa.Column('state_id', sa.Integer), sa.Column( 'revision_id', sa.UnicodeText, sa.ForeignKey('revision.id'), primary_key=True ), sa.Column( 'continuity_id', sa.Integer, sa.ForeignKey('package_resource.id') ) ) op.drop_column('package', 'download_url') op.drop_column('package_revision', 'download_url')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return for table in tables: op.drop_column(table, 'license_id') op.add_column(table, sa.Column('license_id', sa.UnicodeText)) op.drop_table('license')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'system_info', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('key', sa.Unicode(100), unique=True, nullable=False), sa.Column('value', sa.UnicodeText), sa.Column('revision_id', sa.UnicodeText, sa.ForeignKey('revision.id')) ) op.create_table( 'system_info_revision', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('key', sa.Unicode(100), unique=True, nullable=False), sa.Column('value', sa.UnicodeText), sa.Column( 'revision_id', sa.UnicodeText, sa.ForeignKey('revision.id'), primary_key=True ), sa.Column( 'continuity_id', sa.Integer, sa.ForeignKey('system_info.id') ), )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column( 'user', sa.Column('sysadmin', sa.Boolean, server_default='FALSE') ) op.add_column('package', sa.Column('owner_org', sa.UnicodeText)) op.add_column( 'package', sa.Column('private', sa.Boolean, server_default='FALSE') ) op.add_column('package_revision', sa.Column('owner_org', sa.UnicodeText)) op.add_column( 'package_revision', sa.Column('private', sa.Boolean, server_default='FALSE') ) op.add_column( 'group', sa.Column('is_organization', sa.Boolean, server_default='FALSE') ) op.add_column( 'group_revision', sa.Column('is_organization', sa.Boolean, server_default='FALSE') )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return for table_name in stateful_tables: op.add_column(table_name, sa.Column('state', sa.UnicodeText)) op.drop_column(table_name, 'state_id') op.drop_table('state')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_table('role_action') op.drop_table('package_role') op.drop_table('group_role') op.drop_table('system_role') op.drop_table('authorization_group_role') op.drop_table('user_object_role')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column( 'user', sa.Column( 'state', sa.UnicodeText, nullable=False, server_default='active' ) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'term_translation', sa.Column('term', sa.UnicodeText, nullable=False), sa.Column('term_translation', sa.UnicodeText, nullable=False), sa.Column('lang_code', sa.UnicodeText, nullable=False) ) op.create_index('term_lang', 'term_translation', ['term', 'lang_code']) op.create_index('term', 'term_translation', ['term'])
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'user', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('name', sa.UnicodeText), sa.Column('apikey', sa.UnicodeText) ) op.drop_table('apikey')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return conn = op.get_bind() existing = conn.execute("SELECT COUNT(*) FROM related;").fetchone() if existing[0] > 0: print(WARNING) return op.drop_table('related_dataset') op.drop_table('related')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'harvested_document', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('created', sa.DateTime), sa.Column('url', sa.UnicodeText, nullable=False), sa.Column('content', sa.UnicodeText, nullable=False), )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column( 'user', sa.Column( 'activity_streams_email_notifications', sa.Boolean, server_default='FALSE' ) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'package_search', sa.Column( 'package_id', sa.Integer, sa.ForeignKey('package.id'), primary_key=True ), sa.Column('search_vector', sa.dialects.postgresql.TSVECTOR) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column( 'dashboard', sa.Column( 'email_last_sent', sa.TIMESTAMP, nullable=False, server_default=sa.func.localtimestamp() ) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'system_role', sa.Column( 'user_object_role_id', sa.UnicodeText, sa.ForeignKey('user_object_role.id'), primary_key=True ), )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'authorization_group', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('name', sa.UnicodeText), sa.Column( 'created', sa.DateTime, server_default=sa.func.current_timestamp() ), ) op.create_table( 'authorization_group_user', sa.Column( 'authorization_group_id', sa.UnicodeText, sa.ForeignKey('authorization_group.id'), nullable=False ), sa.Column( 'user_id', sa.UnicodeText, sa.ForeignKey('user.id'), nullable=False ) ) # make user nullable: op.alter_column('user_object_role', 'user_id', nullable=True) op.create_table( 'authorization_group_role', sa.Column( 'user_object_role_id', sa.UnicodeText, sa.ForeignKey('user_object_role.id'), primary_key=True ), sa.Column( 'authorization_group_id', sa.UnicodeText, sa.ForeignKey('authorization_group.id') ), ) op.add_column( 'user_object_role', sa.Column( 'authorized_group_id', sa.UnicodeText, sa.ForeignKey('authorization_group.id'), nullable=True ) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_index('idx_revision_author', 'revision', ['author']) op.create_index('idx_openid', 'user', ['openid']) op.create_index( 'idx_user_name_index', 'user', [ sa.text( '(CASE WHEN ' '("user".fullname IS NULL OR "user".fullname = \'\') ' 'THEN "user".name ELSE "user".fullname END)' ) ] )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'system_info', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('key', sa.Unicode(100), unique=True, nullable=False), sa.Column('value', sa.UnicodeText), sa.Column('revision_id', sa.UnicodeText, sa.ForeignKey('revision.id'))) op.create_table( 'system_info_revision', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('key', sa.Unicode(100), unique=True, nullable=False), sa.Column('value', sa.UnicodeText), sa.Column('revision_id', sa.UnicodeText, sa.ForeignKey('revision.id'), primary_key=True), sa.Column('continuity_id', sa.Integer, sa.ForeignKey('system_info.id')), )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table('related', sa.Column('id', sa.UnicodeText, nullable=False), sa.Column('type', sa.UnicodeText, nullable=False), sa.Column('title', sa.UnicodeText), sa.Column('description', sa.UnicodeText), sa.Column('image_url', sa.UnicodeText), sa.Column('url', sa.UnicodeText), sa.Column('created', sa.TIMESTAMP), sa.Column('owner_id', sa.UnicodeText)) op.create_table('related_dataset', sa.Column('id', sa.UnicodeText, nullable=False), sa.Column('dataset_id', sa.UnicodeText, nullable=False), sa.Column('related_id', sa.UnicodeText, nullable=False), sa.Column('status', sa.UnicodeText)) op.create_primary_key('related_pkey', 'related', ['id']) op.create_primary_key('related_dataset_pkey', 'related_dataset', ['id']) op.create_foreign_key('related_dataset_dataset_id_fkey', 'related_dataset', 'package', ['dataset_id'], ['id']) op.create_foreign_key('related_dataset_related_id_fkey', 'related_dataset', 'related', ['related_id'], ['id'])
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('user', sa.Column('about', sa.Text))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column( 'package_resource_revision', sa.Column('hash', sa.UnicodeText) )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return for name, table, columns in indexes: op.create_index(name, table, columns)
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_table('package_search')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.alter_column('activity_detail', 'activity_id', nullable=True) op.alter_column('user', 'name', nullable=False)
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return pass
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'state', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('name', sa.Unicode(100)), ) op.create_table( 'revision', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('timestamp', sa.DateTime(timezone=False)), sa.Column('author', sa.Unicode(200)), sa.Column('message', sa.UnicodeText()), sa.Column('state_id', sa.Integer), ) op.create_table( 'apikey', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('name', sa.UnicodeText()), sa.Column('key', sa.UnicodeText()), ) op.create_table( 'license', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('name', sa.Unicode(100)), sa.Column('state_id', sa.Integer)) op.create_table( 'package', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('name', sa.Unicode(100), nullable=False, unique=True), sa.Column('title', sa.UnicodeText()), sa.Column('version', sa.Unicode(100)), sa.Column('url', sa.UnicodeText()), sa.Column('download_url', sa.UnicodeText()), sa.Column('notes', sa.UnicodeText()), sa.Column('license_id', sa.Integer, sa.ForeignKey('license.id')), sa.Column('state_id', sa.Integer, sa.ForeignKey('state.id')), sa.Column('revision_id', sa.Integer, sa.ForeignKey('revision.id')), sa.Column('data_type', sa.UnicodeText()), ) op.create_table( 'package_revision', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('name', sa.Unicode(100), nullable=False), sa.Column('title', sa.UnicodeText()), sa.Column('version', sa.Unicode(100)), sa.Column('url', sa.UnicodeText()), sa.Column('download_url', sa.UnicodeText()), sa.Column('notes', sa.UnicodeText()), sa.Column('license_id', sa.Integer, sa.ForeignKey('license.id')), sa.Column('state_id', sa.Integer, sa.ForeignKey('state.id')), sa.Column('revision_id', sa.Integer, sa.ForeignKey('revision.id'), primary_key=True), sa.Column('continuity_id', sa.Integer, sa.ForeignKey('package.id')), ) op.create_table( 'tag', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('name', sa.Unicode(100), nullable=False, unique=True), ) op.create_table( 'package_tag', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('package_id', sa.Integer, sa.ForeignKey('package.id')), sa.Column('tag_id', sa.Integer, sa.ForeignKey('tag.id')), sa.Column('state_id', sa.Integer, sa.ForeignKey('state.id')), sa.Column('revision_id', sa.Integer, sa.ForeignKey('revision.id')), ) op.create_table( 'package_tag_revision', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('package_id', sa.Integer, sa.ForeignKey('package.id')), sa.Column('tag_id', sa.Integer, sa.ForeignKey('tag.id')), sa.Column('state_id', sa.Integer, sa.ForeignKey('state.id')), sa.Column('revision_id', sa.Integer, sa.ForeignKey('revision.id'), primary_key=True), sa.Column('continuity_id', sa.Integer, sa.ForeignKey('package_tag.id')), ) op.create_table( 'package_extra', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('package_id', sa.Integer, sa.ForeignKey('package.id')), sa.Column('key', sa.UnicodeText()), sa.Column('value', sa.UnicodeText()), sa.Column('state_id', sa.Integer, sa.ForeignKey('state.id')), sa.Column('revision_id', sa.Integer, sa.ForeignKey('revision.id')), ) op.create_table( 'package_extra_revision', sa.Column('id', sa.Integer, primary_key=True, nullable=False), sa.Column('package_id', sa.Integer, sa.ForeignKey('package.id')), sa.Column('key', sa.UnicodeText()), sa.Column('value', sa.UnicodeText()), sa.Column('state_id', sa.Integer, sa.ForeignKey('state.id')), sa.Column('revision_id', sa.Integer, sa.ForeignKey('revision.id'), primary_key=True), sa.Column('continuity_id', sa.Integer, sa.ForeignKey('package_extra.id')), )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_column('user', 'openid')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_table('change') op.drop_table('changemask') op.drop_table('changeset')
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_table('migrate_version') pass
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_index('idx_package_extra_package_id', 'package_extra_revision', ['package_id', 'current'])
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_unique_constraint('user_name_key', 'user', ['name'])
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_index( 'idx_resource_continuity_id', 'resource_revision', ['continuity_id'] )
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.alter_column('harvest_source', 'status', nullable=False)
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return for table in domain_obj_names: op.add_column(table, sa.Column('created', sa.TIMESTAMP))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('resource', sa.Column('created', sa.TIMESTAMP)) op.add_column('resource_revision', sa.Column('created', sa.TIMESTAMP))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_index('idx_package_creator_user_id', 'package', ['creator_user_id'])
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('group', sa.Column('image_url', sa.UnicodeText)) op.add_column('group_revision', sa.Column('image_url', sa.UnicodeText))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('package_relationship', sa.Column('state', sa.UnicodeText)) op.add_column('package_relationship_revision', sa.Column('state', sa.UnicodeText))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.rename_table('package_group', 'member') op.rename_table('package_group_revision', 'member_revision') op.alter_column('member', 'package_id', new_column_name='table_id', nullable=False) op.alter_column('member_revision', 'package_id', new_column_name='table_id', nullable=False) op.drop_constraint('package_group_revision_pkey', 'member_revision') op.drop_constraint('package_group_revision_continuity_id_fkey', 'member_revision') op.drop_constraint('package_group_revision_group_id_fkey', 'member_revision') op.drop_constraint('package_group_revision_package_id_fkey', 'member_revision') op.drop_constraint('package_group_revision_revision_id_fkey', 'member_revision') op.drop_constraint('package_group_pkey', 'member') op.drop_constraint('package_group_group_id_fkey', 'member') op.drop_constraint('package_group_package_id_fkey', 'member') op.drop_constraint('package_group_revision_id_fkey', 'member') op.add_column('member', sa.Column('table_name', sa.UnicodeText, nullable=False)) op.add_column('member', sa.Column('capacity', sa.UnicodeText, nullable=False)) op.add_column('member_revision', sa.Column('table_name', sa.UnicodeText, nullable=False)) op.add_column('member_revision', sa.Column('capacity', sa.UnicodeText, nullable=False)) op.create_primary_key('member_pkey', 'member', ['id']) op.create_primary_key('member_revision_pkey', 'member_revision', ['id', 'revision_id']) op.create_foreign_key('member_group_id_fkey', 'member', 'group', ['group_id'], ['id']) op.create_foreign_key('member_revision_id_fkey', 'member', 'revision', ['revision_id'], ['id']) op.create_foreign_key('member_revision_continuity_id_fkey', 'member_revision', 'member', ['continuity_id'], ['id']) op.create_foreign_key('member_revision_group_id_fkey', 'member_revision', 'group', ['group_id'], ['id']) op.create_foreign_key('member_revision_revision_id_fkey', 'member_revision', 'revision', ['revision_id'], ['id']) op.add_column('group', sa.Column('type', sa.UnicodeText, nullable=False)) op.add_column('group_revision', sa.Column('type', sa.UnicodeText, nullable=False)) op.add_column('package', sa.Column('type', sa.UnicodeText)) op.add_column('package_revision', sa.Column('type', sa.UnicodeText))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.add_column('user', sa.Column('reset_key', sa.UnicodeText))
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.create_table( 'resource_group', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('package_id', sa.UnicodeText, sa.ForeignKey('package.id')), sa.Column('label', sa.UnicodeText), sa.Column('sort_order', sa.UnicodeText), sa.Column('extras', sa.UnicodeText), sa.Column('state', sa.UnicodeText), sa.Column('revision_id', sa.UnicodeText, sa.ForeignKey('revision.id')), ) op.create_table( 'resource_group_revision', sa.Column('id', sa.UnicodeText, primary_key=True), sa.Column('package_id', sa.UnicodeText, sa.ForeignKey('package.id')), sa.Column('label', sa.UnicodeText), sa.Column('sort_order', sa.UnicodeText), sa.Column('extras', sa.UnicodeText), sa.Column('state', sa.UnicodeText), sa.Column('revision_id', sa.UnicodeText, sa.ForeignKey('revision.id'), primary_key=True), sa.Column('continuity_id', sa.UnicodeText, sa.ForeignKey('resource_group.id'))) op.alter_column('package_resource', 'package_id', new_column_name='resource_group_id') op.alter_column('package_resource_revision', 'package_id', new_column_name='resource_group_id') op.rename_table('package_resource', 'resource') op.rename_table('package_resource_revision', 'resource_revision') op.execute('ALTER INDEX package_resource_pkey RENAME TO resource_pkey') op.execute('ALTER INDEX package_resource_revision_pkey ' 'RENAME TO resource_revision_pkey') op.drop_constraint('package_resource_revision_continuity_id_fkey', 'resource_revision') op.drop_constraint('package_resource_revision_package_id_fkey', 'resource_revision') op.drop_constraint('package_resource_revision_revision_id_fkey', 'resource_revision') op.drop_constraint('package_resource_revision_id_fkey', 'resource') op.drop_constraint('package_resource_package_id_fkey', 'resource') op.create_foreign_key('resource_resource_group_id_fkey', 'resource', 'resource_group', ['resource_group_id'], ['id']) op.create_foreign_key('resource_revision_id_fkey', 'resource', 'revision', ['revision_id'], ['id']) op.create_foreign_key('resource_revision_continuity_id_fkey', 'resource_revision', 'resource', ['continuity_id'], ['id']) op.create_foreign_key('resource_revision_resource_group_id_fkey', 'resource_revision', 'resource_group', ['resource_group_id'], ['id']) op.create_foreign_key('resource_revision_revision_id_fkey', 'resource_revision', 'revision', ['revision_id'], ['id'])
def upgrade(): if skip_based_on_legacy_engine_version(op, __name__): return op.drop_table('authorization_group_user') op.drop_table('authorization_group')