Re: [sqlalchemy] Rolling back an ALTER TABLE in sqlite3?

On May 29, 2010, at 2:37 PM, jgarbers wrote: > I'm trying to do an in-place database "upgrade" -- if I detect that a > column is missing, I use ALTER TABLE to add the column and then > compute values for the new column for each row. I'd like this to all > happen within a transaction, so the colu

[sqlalchemy] Rolling back an ALTER TABLE in sqlite3?

I'm trying to do an in-place database "upgrade" -- if I detect that a column is missing, I use ALTER TABLE to add the column and then compute values for the new column for each row. I'd like this to all happen within a transaction, so the column doesn't get added unless the new values are successf