[openstack-dev] [Keystone] How to write unit tests for db methods?

Adam Young ayoung at redhat.com
Thu Jul 11 14:29:27 UTC 2013


On 07/11/2013 05:23 AM, Akshat Kakkar wrote:
>
> The methods of read/write/update/delete of records in the tables are 
> written using SQLalchemy only and no direct sql is used.
>
> I have implemented the things on the lines of trusts only.  Similar to 
> trusts, I am also having RESTful APIs and unit tests for them are 
> succesfully written. In test_backend_sql.py, it is seen that no unit 
> tests are defined for trusts. So, it's confusing for me to implement 
> the unit test for my backend sql code.

Yeah, trusts themselves are pretty simple as far as REST, and they are 
exercised via the Token backend code as well as test_auth.py and 
test_v3_auth.py.

Look at the tests for identity and catalog, those should be a better 
example to follow.


>
> I know I am confusing the things and I apologise for that, but I am 
> asking because of that confusion only!
>
> ------------------------------------------------------------------------
> *From:* Adam Young <ayoung at redhat.com>
> *To:* openstack-dev at lists.openstack.org
> *Sent:* Thursday, 11 July 2013 4:28 AM
> *Subject:* Re: [openstack-dev] [Keystone] How to write unit tests for 
> db methods?
>
> On 07/10/2013 06:56 AM, Akshat Kakkar wrote:
>> I have added 2 tables to keystone.
>
> This should be done in a migration, and should be tested using the 
> test_db_update.py file.
>
>> I have methods which do the read/write/update/delete of records in 
>> these tables.
> PLease explain.  We are not doing direct sql, but rather using SQLalchemy.
>
>
>> I want to write unit test for all this. These methods of mine inherit 
>> from keystone.common.sql and hence any call that these methods will 
>> make will go to the db returned by keystone.common.sql when creating 
>> a session. For writing a unit test this db should be a test db and 
>> not the production db. So, how can I have a session of test db? or is 
>> there altogether a different way of writing the unit test.
> See test_backend_sql.py
>>
>>
>> ------------------------------------------------------------------------
>> *From:* Dolph Mathews <dolph.mathews at gmail.com> 
>> <mailto:dolph.mathews at gmail.com>
>> *To:* Akshat Kakkar <the_akshat at yahoo.co.in> 
>> <mailto:the_akshat at yahoo.co.in>; OpenStack Development Mailing List 
>> <openstack-dev at lists.openstack.org> 
>> <mailto:openstack-dev at lists.openstack.org>see 
>> <mailto:openstack-dev at lists.openstack.org>
>> *Sent:* Tuesday, 9 July 2013 7:39 PM
>> *Subject:* Re: [openstack-dev] [Keystone] How to write unit tests for 
>> db methods?
>>
>> I'm assuming you're referring to testing backend drivers as opposed 
>> to database migrations (tests/test_sql_upgrade.py).
>>
>> Backend agnostic tests land in tests/test_backend.py. 
>> Backend-specific tests, overrides, etc belong in 
>> tests/test_backend_sql.py, tests/test_backend_kvs.py, etc.
>>
>> Generally, you can't assume that keystone is backed by a database, 
>> however, as it's entirely possible to deploy without one.
>>
>>
>> On Tue, Jul 9, 2013 at 10:55 AM, Akshat Kakkar 
>> <the_akshat at yahoo.co.in <mailto:the_akshat at yahoo.co.in>> wrote:
>>
>>     How to write unit tests in keystone for the methods which are
>>     directly calling the backend db? I understand that for testing
>>     purpose it should be a *fake db*, but how to do that in keystone?
>>
>>     _______________________________________________
>>     OpenStack-dev mailing list
>>     OpenStack-dev at lists.openstack.org
>>     <mailto:OpenStack-dev at lists.openstack.org>
>>     http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>>
>>
>>
>>
>> -- 
>>
>> -Dolph
>>
>>
>>
>>
>> _______________________________________________
>> OpenStack-dev mailing list
>> OpenStack-dev at lists.openstack.org  <mailto:OpenStack-dev at lists.openstack.org>
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org 
> <mailto:OpenStack-dev at lists.openstack.org>
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20130711/2b4b4654/attachment.html>


More information about the OpenStack-dev mailing list