Python index_exists_on_columns Exemples

Exemple #1

def ensure_indexed(migrate_engine, table_name, index_name, columns):
    if utils.index_exists_on_columns(migrate_engine, table_name, columns):
        LOG.info(
            _LI('Skipped adding %s because an equivalent index'
                ' already exists.'), index_name)
    else:
        utils.add_index(migrate_engine, table_name, index_name, columns)

Exemple #2

Fichier : 105_add_backup_metadata.py Projet : runzexia/openstack-daocloud-px

def upgrade(migrate_engine):
    """Add backup_metadata table."""

    meta = MetaData()
    meta.bind = migrate_engine

    Table('backups', meta, autoload=True)

    backup_metadata = Table(
        'backup_metadata', meta,
        Column('created_at', DateTime(timezone=False)),
        Column('updated_at', DateTime(timezone=False)),
        Column('deleted_at', DateTime(timezone=False)),
        Column('deleted', Boolean(), default=False),
        Column('id', Integer, primary_key=True, nullable=False),
        Column('backup_id', String(36),
               ForeignKey('backups.id'),
               nullable=False),
        Column('key', String(255)),
        Column('value', String(255)),
        mysql_engine='InnoDB',
        mysql_charset='utf8'
    )

    backup_metadata.create()

    if not utils.index_exists_on_columns(migrate_engine,
                                         'backup_metadata',
                                         ['backup_id']):
        utils.add_index(migrate_engine,
                        'backup_metadata',
                        'backup_metadata_backup_id_idx',
                        ['backup_id'])

Exemple #3

Fichier : 113_add_reservation_deleted_uuid_index.py Projet : zjjfeng111/cinder

def upgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine

    index_name = 'reservations_deleted_uuid_idx'
    columns = ['deleted', 'uuid']
    if utils.index_exists_on_columns(migrate_engine, 'reservations', columns):
        return

    utils.add_index(migrate_engine, 'reservations', index_name, columns)

Exemple #4

def upgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine
    index_name = 'quota_usage_project_resource_idx'
    columns = ['project_id', 'resource']
    if utils.index_exists_on_columns(migrate_engine, 'quota_usages', columns):
        LOG.info(
            'Skipped adding %s because an equivalent index already exists.',
            index_name)
    else:
        utils.add_index(migrate_engine, 'quota_usages', index_name, columns)

Exemple #5

def ensure_index_exists(migrate_engine, table_name, column):
    index_name = table_name + '_' + column + '_idx'
    columns = [column]

    if utils.index_exists_on_columns(migrate_engine, table_name, columns):
        LOG.info(
            'Skipped adding %s because an equivalent index already exists.',
            index_name
        )
    else:
        utils.add_index(migrate_engine, table_name, index_name, columns)

Exemple #6

Fichier : 111_add_project_resource_idx_for_quota_usage.py Projet : ebalduf/cinder-backports

def upgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine
    index_name = 'quota_usage_project_resource_idx'
    columns = ['project_id', 'resource']
    if utils.index_exists_on_columns(migrate_engine, 'quota_usages', columns):
        LOG.info(
            'Skipped adding %s because an equivalent index already exists.',
            index_name
        )
    else:
        utils.add_index(migrate_engine, 'quota_usages', index_name, columns)

Exemple #7

 def _check_111(self, engine, data):
     self.assertTrue(db_utils.index_exists_on_columns(
         engine, 'quota_usages', ['project_id', 'resource']))

Exemple #8

Fichier : test_migrations.py Projet : j-griffith/cinder

 def _check_111(self, engine, data):
     self.assertTrue(db_utils.index_exists_on_columns(
         engine, 'quota_usages', ['project_id', 'resource']))

Exemple #9

def upgrade(migrate_engine):
    if not utils.index_exists_on_columns(migrate_engine, 'messages',
                                         ['expires_at']):
        utils.add_index(migrate_engine, 'messages', 'messages_expire_at_idx',
                        ['expires_at'])

Exemple #10

Fichier : 098_message_add_expire_at_index.py Projet : ebalduf/cinder-backports

def upgrade(migrate_engine):
    if not utils.index_exists_on_columns(
            migrate_engine, 'messages', ['expires_at']):
        utils.add_index(migrate_engine, 'messages',
                        'messages_expire_at_idx', ['expires_at'])