diff options
| author | Jenkins <jenkins@review.openstack.org> | 2013-02-28 18:54:15 +0000 |
|---|---|---|
| committer | Gerrit Code Review <review@openstack.org> | 2013-02-28 18:54:15 +0000 |
| commit | d99752b50dfd10ae290e41565fc2035f3e7d85b2 (patch) | |
| tree | c5f76b3979ce04cb22375208bda766e5b332b8e8 /nova/db/sqlalchemy/models.py | |
| parent | 5c602f221315bc645f10ff4597cdcd4ddd0d35d2 (diff) | |
| parent | ce23d6c1d679355bafede816bca39ea1eb24073c (diff) | |
| download | nova-d99752b50dfd10ae290e41565fc2035f3e7d85b2.tar.gz nova-d99752b50dfd10ae290e41565fc2035f3e7d85b2.tar.xz nova-d99752b50dfd10ae290e41565fc2035f3e7d85b2.zip | |
Merge "Shrink size of aggregate_metadata_get_by_host sql query"
Diffstat (limited to 'nova/db/sqlalchemy/models.py')
| -rw-r--r-- | nova/db/sqlalchemy/models.py | 23 |
1 files changed, 5 insertions, 18 deletions
diff --git a/nova/db/sqlalchemy/models.py b/nova/db/sqlalchemy/models.py index 3ad0db116..a675357df 100644 --- a/nova/db/sqlalchemy/models.py +++ b/nova/db/sqlalchemy/models.py @@ -835,29 +835,16 @@ class Aggregate(BASE, NovaBase): id = Column(Integer, primary_key=True, autoincrement=True) name = Column(String(255)) _hosts = relationship(AggregateHost, - lazy="joined", - secondary="aggregate_hosts", primaryjoin='and_(' - 'Aggregate.id == AggregateHost.aggregate_id,' - 'AggregateHost.deleted == 0,' - 'Aggregate.deleted == 0)', - secondaryjoin='and_(' - 'AggregateHost.aggregate_id == Aggregate.id, ' - 'AggregateHost.deleted == 0,' - 'Aggregate.deleted == 0)', - backref='aggregates') + 'Aggregate.id == AggregateHost.aggregate_id,' + 'AggregateHost.deleted == 0,' + 'Aggregate.deleted == 0)') _metadata = relationship(AggregateMetadata, - secondary="aggregate_metadata", - primaryjoin='and_(' + primaryjoin='and_(' 'Aggregate.id == AggregateMetadata.aggregate_id,' 'AggregateMetadata.deleted == 0,' - 'Aggregate.deleted == 0)', - secondaryjoin='and_(' - 'AggregateMetadata.aggregate_id == Aggregate.id, ' - 'AggregateMetadata.deleted == 0,' - 'Aggregate.deleted == 0)', - backref='aggregates') + 'Aggregate.deleted == 0)') def _extra_keys(self): return ['hosts', 'metadetails', 'availability_zone'] |