On 07/16/2013 12:09 PM, Dolph Mathews wrote:
On Tue, Jul 16, 2013 at 10:51 AM, Roman Podolyaka <rpodoly...@mirantis.com <mailto:rpodoly...@mirantis.com>> wrote:
We are going to implement ALTER support in Alembic for SQLite in the next few weeks. I'm a little lost on this ... sqlite doesn't support ALTER, so what exactly is being added to alembic? Is the alembic community receptive or interested?
There is some code in Nova (on its way into Oslo) to work around not being able to alter tables in SQLite. It deletes the old table and adds the modified version as a new table. That's the best you can do without modifying SQLite itself.
The Alembic README specifically mentions this SQLite issue and says "we will support these features provided someone takes the initiative to implement and test". So, yeah, he'll take these patches. Means we'll need to use the future version of Alembic with this feature, though.
-- David Ripton Red Hat drip...@redhat.com _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev