Public bug reported:
hi all:
here lost primary_key in both column,
neutron_fwaas/db/migration/alembic_migrations/versions/newton/expand/d6a12e637e28_neutron_fwaas_v2_0.py
op.create_table(
'firewall_group_port_associations_v2',
sa.Column('firewall_group_id', sa.String(length=36),
sa.ForeignKey('firewall_groups_v2.id', ondelete='CASCADE')),
sa.Column('port_id', sa.String(length=36),
sa.ForeignKey('ports.id', ondelete='CASCADE'))
)
the model of this table have the primary_key
neutron_fwaas/db/firewall/v2/firewall_db_v2.py
class FirewallGroupPortAssociation(model_base.BASEV2):
__tablename__ = 'firewall_group_port_associations_v2'
firewall_group_id = sa.Column(sa.String(db_constants.UUID_FIELD_SIZE),
sa.ForeignKey('firewall_groups_v2.id',
ondelete="CASCADE"),
primary_key=True)
port_id = sa.Column(sa.String(db_constants.UUID_FIELD_SIZE),
sa.ForeignKey('ports.id', ondelete="CASCADE"),
unique=True,
primary_key=True)
** Affects: neutron
Importance: Undecided
Assignee: junbo (junbo)
Status: In Progress
** Changed in: neutron
Assignee: (unassigned) => junbo (junbo)
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1740068
Title:
lost composite primary key in firewall_group_port_associations_v2
Status in neutron:
In Progress
Bug description:
hi all:
here lost primary_key in both column,
neutron_fwaas/db/migration/alembic_migrations/versions/newton/expand/d6a12e637e28_neutron_fwaas_v2_0.py
op.create_table(
'firewall_group_port_associations_v2',
sa.Column('firewall_group_id', sa.String(length=36),
sa.ForeignKey('firewall_groups_v2.id', ondelete='CASCADE')),
sa.Column('port_id', sa.String(length=36),
sa.ForeignKey('ports.id', ondelete='CASCADE'))
)
the model of this table have the primary_key
neutron_fwaas/db/firewall/v2/firewall_db_v2.py
class FirewallGroupPortAssociation(model_base.BASEV2):
__tablename__ = 'firewall_group_port_associations_v2'
firewall_group_id = sa.Column(sa.String(db_constants.UUID_FIELD_SIZE),
sa.ForeignKey('firewall_groups_v2.id',
ondelete="CASCADE"),
primary_key=True)
port_id = sa.Column(sa.String(db_constants.UUID_FIELD_SIZE),
sa.ForeignKey('ports.id', ondelete="CASCADE"),
unique=True,
primary_key=True)
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1740068/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
