oslo.db tests mock database connection

[Viktor Serhieiev]

A lot of tests in oslo.db uses mocks and doesn't work with the real databases.
oslo.db provides for OpenStack project different tools for work with database, so we should guarantee, that they work properly and check all these functionality with the real databases instead of mocks (which can be wrong, sometimes). For this we should use real DB connection in tests instated of mocks, where it is possible.

See also discussion at the first patch sets in patch https://review.openstack.org/#/c/116324/

[Doug Hellmann (doug-hellmann)]

There may be some value in supporting the mock tests, but I agree we should look into adding functional testing against real databases for kilo.

[Mike Bayer (zzzeek)]

to be fair, both mocks and real DB tests have their place. can you be more specific about where you're not confident in something being tested? it's possible that some of the mocks in oslo.db are built against behavioral contracts in SQLAlchemy, which are confirmed against real DB backends in our own (SQLAlchemy's) testing.

[Launchpad Janitor (janitor)]

[Expired for oslo.db because there has been no activity for 60 days.]