[Buildbot-commits] [Buildbot] #2221: wrap db upgrade scripts in a transaction

[Buildbot]

#2221: wrap db upgrade scripts in a transaction
------------------------+----------------------
Reporter:  dustin       |       Owner:
    Type:  enhancement  |      Status:  closed
Priority:  major        |   Milestone:  0.8.6
 Version:  0.8.5        |  Resolution:  wontfix
Keywords:  database     |
------------------------+----------------------
Changes (by dustin):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 Now I remember why I didn't do this before!

 Upgrade scripts take engines, not connections.  Connections are the tie-in
 for transactions, so there's not a comfortable way to wrap each upgrade
 step in a transaction.

 More to the point, sqlite doesn't support schema modifications as part of
 transactions, and MySQL just doesn't (really) support transactions, so
 this would only work for Postgres, anyway.

-- 
Ticket URL: <http://trac.buildbot.net/ticket/2221#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation