Python modify_foreign_keys_constraint Examples

Example #1

File: f958f58e5daa_uuid_consistency.py Project: openstack/tacker

def upgrade(active_plugins=None, options=None):

    pk_id_tables = ('vims', 'vimauths', 'devices', 'deviceattributes',
                  'servicetypes', 'devicetemplates',
                  'devicetemplateattributes')
    for table in pk_id_tables:
        with migration.modify_foreign_keys_constraint(FK_MAP.get(table, [])):
                op.alter_column(table, 'id', type_=types.Uuid,
                nullable=False)

    fk_template_id_tables = ('devices', 'servicetypes',
                             'devicetemplateattributes')
    for table in fk_template_id_tables:
        with migration.modify_foreign_keys_constraint(fk_template_id_tables):
            op.alter_column(table, 'template_id', type_=types.Uuid,
                            nullable=False)

    fk_vim_id_tables = ('devices', 'vimauths')
    for table in fk_vim_id_tables:
        with migration.modify_foreign_keys_constraint(fk_vim_id_tables):
            op.alter_column(table, 'vim_id', type_=types.Uuid,
                            nullable=False)

    fk_device_id_tables = ('deviceattributes', 'proxymgmtports')
    for table in fk_device_id_tables:
        with migration.modify_foreign_keys_constraint(fk_device_id_tables):
            op.alter_column(table, 'device_id', type_=types.Uuid,
                            nullable=False)

Example #2

File: f958f58e5daa_uuid_consistency.py Project: vutuong/tacker

def upgrade(active_plugins=None, options=None):

    pk_id_tables = ('vims', 'vimauths', 'devices', 'deviceattributes',
                  'servicetypes', 'devicetemplates',
                  'devicetemplateattributes')
    for table in pk_id_tables:
        with migration.modify_foreign_keys_constraint(FK_MAP.get(table, [])):
            op.alter_column(table, 'id', type_=types.Uuid,
                            nullable=False)

    fk_template_id_tables = ('devices', 'servicetypes',
                             'devicetemplateattributes')
    for table in fk_template_id_tables:
        with migration.modify_foreign_keys_constraint(fk_template_id_tables):
            op.alter_column(table, 'template_id', type_=types.Uuid,
                            nullable=False)

    fk_vim_id_tables = ('devices', 'vimauths')
    for table in fk_vim_id_tables:
        with migration.modify_foreign_keys_constraint(fk_vim_id_tables):
            op.alter_column(table, 'vim_id', type_=types.Uuid,
                            nullable=False)

    fk_device_id_tables = ('deviceattributes', 'proxymgmtports')
    for table in fk_device_id_tables:
        with migration.modify_foreign_keys_constraint(fk_device_id_tables):
            op.alter_column(table, 'device_id', type_=types.Uuid,
                            nullable=False)

Example #3

File: 12a57080b278_alter_devices.py Project: K-OpenNet/OPNFV-StateMon

def upgrade(active_plugins=None, options=None):
    # commands auto generated by Alembic - please adjust! #
    fk_constraint = ('deviceattributes', )
    with migration.modify_foreign_keys_constraint(fk_constraint):
        op.alter_column(u'deviceattributes', 'device_id',
                        existing_type=mysql.VARCHAR(length=255),
                        nullable=False)
    op.alter_column(u'devices', 'status', existing_type=mysql.VARCHAR(
        length=255), nullable=False)

Example #4

def upgrade(active_plugins=None, options=None):
    # commands auto generated by Alembic - please adjust! #
    fk_constraint = ('deviceattributes', )
    with migration.modify_foreign_keys_constraint(fk_constraint):
        op.alter_column(u'deviceattributes', 'device_id',
                        existing_type=mysql.VARCHAR(length=255),
                        nullable=False)
    op.alter_column(u'devices', 'status', existing_type=mysql.VARCHAR(
        length=255), nullable=False)