yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1188959] Re: lbaas. Adding column level constraints to table definition

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 17 Jul 2013 12:00:03 -0000
Reply-to: Bug 1188959 <1188959@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: neutron
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1188959

Title:
  lbaas. Adding column level constraints to table definition

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  In https://github.com/openstack/quantum/blob/master/quantum/db/loadbalancer/loadbalancer_db.py the lbaas model is defined.
  There are fields the needs extra constraint definition.
  Examples:
  - All fields in PoolStatistics can not be negative.
  - Weight field in Member can not be negative.
  - Delay field in HealthMonitor  can not be negative.

  Those constraints can be added using:
  http://docs.sqlalchemy.org/en/rel_0_8/core/schema.html?highlight=checkconstraint#sqlalchemy.schema.CheckConstraint
  See here for example:
  http://stackoverflow.com/questions/14225998/flask-sqlalchemy-column-constraint-for-positive-integer

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1188959/+subscriptions