okfn/webstore — Issue #44: Attempt to add new column during write of multiple rows in a single transaction fails
Author: rgrp
Created: 2011-11-04 10:31:00+00:00
State: open

Attempt this sort of thing:

import webstore.client
db, table = webstore.client.URL('http://localhost:5001/test/test/data')
rows = [
{ 'a': '1' },
{ 'b': '1' }
]
table.writerows(rows)

It will fail with:

webstore.client.WebstoreClientException: (OperationalError) database is locked u'\nALTER TABLE data ADD b TEXT' ()