Python skip_based_on_legacy_engine_versionの例

コード例 #1

ファイル: 023_87fdd05f0744_add_harvesting.py プロジェクト: PublicaMundi/ckan

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')
        ),
    )

コード例 #2

ファイル: 077_51171a04d86d_add_revisions_to_system_info.py プロジェクト: PublicaMundi/ckan

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')

コード例 #3

ファイル: 002_86fdd8c54775_add_author_and_maintainer.py プロジェクト: PublicaMundi/ckan

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))

コード例 #4

ファイル: 030_b16cbf164c8a_additional_user_attributes.py プロジェクト: PublicaMundi/ckan

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))

コード例 #5

ファイル: 032_d89e0731422d_add_extra_info_field_to_resources.py プロジェクト: PublicaMundi/ckan

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)
    )

コード例 #6

ファイル: 019_b2eb6f34a638_pkg_relationships_state.py プロジェクト: PublicaMundi/ckan

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)
    )

コード例 #7

ファイル: 048_4a7011172b3f_add_activity_streams_tables.py プロジェクト: PublicaMundi/ckan

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']
    )

コード例 #8

ファイル: 061_338d460bc460_add_follower_group_table.py プロジェクト: PublicaMundi/ckan

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'
    )

コード例 #9

ファイル: 049_e0c06c2177b5_add_group_approval_status.py プロジェクト: PublicaMundi/ckan

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)
    )

コード例 #10

ファイル: 033_6da92ef2df15_auth_group_user_id_add_conditional.py プロジェクト: PublicaMundi/ckan

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']
    )

コード例 #11

ファイル: 068_e33a5f2b2a84_add_package_extras_index.py プロジェクト: PublicaMundi/ckan

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']
    )

コード例 #12

ファイル: 038_fd6622e3d964_delete_migration_tables.py プロジェクト: PublicaMundi/ckan

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')

コード例 #13

ファイル: 056_11af3215ae89_add_related_table.py プロジェクト: PublicaMundi/ckan

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']
    )

コード例 #14

ファイル: 012_e5ca33a5d445_add_resources.py プロジェクト: PublicaMundi/ckan

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')

コード例 #15

ファイル: 018_05a0778051ca_adjust_licenses.py プロジェクト: PublicaMundi/ckan

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')

コード例 #16

ファイル: 060_31ad11c518fc_add_system_info_table.py プロジェクト: PublicaMundi/ckan

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')
        ),
    )

コード例 #17

ファイル: 063_8b633852cb7a_org_changes.py プロジェクト: PublicaMundi/ckan

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')
    )

コード例 #18

ファイル: 015_6d8ffebcaf54_remove_state_object.py プロジェクト: PublicaMundi/ckan

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')

コード例 #19

ファイル: 078_ae821876532a_remove_old_authz_model.py プロジェクト: PublicaMundi/ckan

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')

コード例 #20

ファイル: 071_c16f081ef73a_add_state_column_to_user_table.py プロジェクト: PublicaMundi/ckan

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'
        )
    )

コード例 #21

ファイル: 050_01a6b058cb7f_term_translation_table.py プロジェクト: PublicaMundi/ckan

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'])

コード例 #22

ファイル: 003_f22b4f5241a5_add_user_object.py プロジェクト: PublicaMundi/ckan

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')

コード例 #23

ファイル: 083_f98d8fa2a7f7_remove_related_items.py プロジェクト: PublicaMundi/ckan

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')

コード例 #24

ファイル: 024_12981fe12484_add_harvested_document.py プロジェクト: PublicaMundi/ckan

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),
    )

コード例 #25

ファイル: 065_1fab0bc6439e_add_email_notifications_preference.py プロジェクト: PublicaMundi/ckan

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'
        )
    )

コード例 #26

ファイル: 011_866f6370b4ac_add_package_search_vector.py プロジェクト: PublicaMundi/ckan

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)
    )

コード例 #27

ファイル: 064_4f8becd4919a_add_email_last_sent_column.py プロジェクト: PublicaMundi/ckan

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()
        )
    )

コード例 #28

ファイル: 007_1928d4af1cda_add_system_roles.py プロジェクト: PublicaMundi/ckan

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
        ),
    )

コード例 #29

ファイル: 025_b581622ad327_add_authorization_groups.py プロジェクト: PublicaMundi/ckan

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
        )
    )

コード例 #30

ファイル: 042_da65e2877034_user_revision_indexes.py プロジェクト: PublicaMundi/ckan

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)'
            )
        ]
    )

コード例 #31

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')),
    )

コード例 #32

ファイル: 056_11af3215ae89_add_related_table.py プロジェクト: anhlt2710/OpenData_ckan

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'])

コード例 #33

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.add_column('user', sa.Column('about', sa.Text))

コード例 #34

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.add_column(
        'package_resource_revision', sa.Column('hash', sa.UnicodeText)
    )

コード例 #35

ファイル: 021_765143af2ba3_postgresql_upgrade_sql.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    for name, table, columns in indexes:
        op.create_index(name, table, columns)

コード例 #36

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.drop_table('package_search')

コード例 #37

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)

コード例 #38

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    pass

コード例 #39

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')),
    )

コード例 #40

ファイル: 086_19663581b3bb_drop_openid_column.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.drop_column('user', 'openid')

コード例 #41

ファイル: 046_b69e9b80396f_drop_changesets.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.drop_table('change')
    op.drop_table('changemask')
    op.drop_table('changeset')

コード例 #42

ファイル: 005_ddbfb0dc008d_remove_migrate_version_permanently.py プロジェクト: marsdd/ckanext-marsavin

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.drop_table('migrate_version')
    pass

コード例 #43

ファイル: 068_e33a5f2b2a84_add_package_extras_index.py プロジェクト: anhlt2710/OpenData_ckan

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'])

コード例 #44

ファイル: 045_54e3f155d945_user_name_unique.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.create_unique_constraint('user_name_key', 'user', ['name'])

コード例 #45

ファイル: 079_e0177a15d2c9_resource_revision_index.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.create_index(
        'idx_resource_continuity_id', 'resource_revision', ['continuity_id']
    )

コード例 #46

ファイル: 028_cdd68fe9ba21_drop_harvest_source_status.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.alter_column('harvest_source', 'status', nullable=False)

コード例 #47

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))

コード例 #48

ファイル: 054_da21b38da4db_add_resource_created_date.py プロジェクト: anhlt2710/OpenData_ckan

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))

コード例 #49

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.create_index('idx_package_creator_user_id', 'package',
                    ['creator_user_id'])

コード例 #50

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))

コード例 #51

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))

コード例 #52

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))

コード例 #53

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.add_column('user', sa.Column('reset_key', sa.UnicodeText))

コード例 #54

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'])

コード例 #55

ファイル: 087_ff1b303cab77_remove_old_authorization_tables.py プロジェクト: anhlt2710/OpenData_ckan

def upgrade():
    if skip_based_on_legacy_engine_version(op, __name__):
        return
    op.drop_table('authorization_group_user')
    op.drop_table('authorization_group')