cinder/cinder/common
wangxiyuan 6c01699023 Don't use None value for sql query.
Cinder now will raise 500 error if users list resources with
"--sort_key=name" and "--marker=resource_id"(the marker resource's
name should be None here).

This patch add sql "case" sentence to avoid use None value direcetly.

Most of the code is copied from glance[1]

Oslo.db now have the same paginate_query function and the problem
has been solved in a recent patch[2] as well. But it still has some
bugs: with the oslo.db' code,  when the maker resource is not None,
the return value doesn't contain resouces which names are None.

So it's not the time to use oslo.db here. Just fix this bug in Cinder
first.

[1]:
I2187c41a3fab8b5813ba3a5e0f3249ee5dd981ed
Ib3b5f3f57be3683ba274f0122e6314978a79e75f

[2]:
Iea2cd0bb2556b0b15a0baaa76ef522a3097f9928

Co-authored-by: Stuart McLaren<stuart.mclaren@hpe.com>
Closes-bug: #1657331
Change-Id: Ia1052be567de63083cc6c28a2e5b38a7b8470615
2017-02-04 09:31:27 +08:00
..
__init__.py Empty files shouldn't contain copyright nor license 2013-12-26 22:45:17 -06:00
config.py Remove empty debug_opts 2016-11-29 15:08:17 +02:00
constants.py Removed RPC topic config options 2016-08-29 11:16:53 +05:30
sqlalchemyutils.py Don't use None value for sql query. 2017-02-04 09:31:27 +08:00