[openstack-dev] [keystone] sqlite doesn't support migrations

Michael Still mikal at stillhq.com
Tue Jul 16 07:55:42 UTC 2013


On Tue, Jul 16, 2013 at 4:17 PM, Thomas Goirand <zigo at debian.org> wrote:

> Could you explain a bit more what could be done to fix it in an easy
> way, even if it's not efficient? I understand that ALTER doesn't work
> well. Though would we have the possibility to just create a new
> temporary table with the correct fields, and copy the existing content
> in it, then rename the temp table so that it replaces the original one?

There are a bunch of nova migrations that already work that way...
Checkout the *sqlite* files in
nova/db/sqlalchemy/migrate_repo/versions/

Cheers,
Michael

--
Rackspace Australia



More information about the OpenStack-dev mailing list