yahoo-eng-team team mailing list archive

[junbo <junbo4242@xxxxxxxxx>]

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