yahoo-eng-team team mailing list archive

[Rodolfo Alonso <1740068@xxxxxxxxxxxxxxxxxx>]

Bug closed due to lack of activity, please feel free to reopen if
needed.

** Changed in: neutron
       Status: In Progress => Won't Fix

-- 
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:
  Won't Fix

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