[MacPorts] #46111: PortIndex2MySQL.tcl: atomic renames, transactions

[MacPorts]

#46111: PortIndex2MySQL.tcl: atomic renames, transactions
-------------------------+--------------------
 Reporter:  snc@…        |      Owner:  jmpp@…
     Type:  enhancement  |     Status:  new
 Priority:  Normal       |  Milestone:
Component:  website      |    Version:
 Keywords:               |       Port:
-------------------------+--------------------
 I'd like to made two changes to PortIndex2MySQL.tcl.

 Each run should populate new tables which are atomically renamed into
 place. This avoids significant lock time during the run.

 Secondly, each port is wrapped with a transaction. This prevents the
 insertion process from terminating on first error. This also assumes we're
 using an engine that supports transactions.

 Do these seem reasonable? foresee any issues?

-- 
Ticket URL: <https://trac.macports.org/ticket/46111>
MacPorts <https://www.macports.org/>
Ports system for OS X