On 02/23/2016 12:26 PM, Mike Bayer wrote: <snip> >> 2 thoughts on that: >> >> 1) Being able to do a grant with a prefix like >> >> GRANT all on 'openstack_ci%'.* to openstack_citest >> >> Then using that prefix in the random db generation. That would at least >> limit scope. That seems the easiest to do with the existing >> infrastructure. > > a prefix would be very easy, and I almost wonder if we should just have > an identifiable prefix on the username in all cases anyway. However, > the wildcard scheme here is only useful on MySQL. Other backends don't > support such a liberal setting.
I think that's ok. We don't need lowest common denominator here. Mysql (and mysql varients) are the top used db in openstack by far. Making it easy to build tests for specific bugs / behavior there is a near term goal. We've got 2 open API bugs in Nova that can't be reproduced on SQLite in tests, but can with mysql. And prefixing in all cases would at least make it more clear in case something failed to cleanup. [1] - https://www.openstack.org/assets/survey/Public-User-Survey-Report.pdf - pg 28 -Sean -- Sean Dague http://dague.net __________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
