source: peerreviewplugin/trunk/codereview/upgrades/db_peerreview_3.py

from trac.db import Table, Column

def do_upgrade(env, ver, db_backend, db):
    """

    """
    cursor = db.cursor()

    realm = 'peerreview'

    status_update = [["new", "Open for review"],
                     ["reviewed", "Reviewed"],
                     ["closed", "Closed"],
                     ["forinclusion", "Ready for inclusion"]]

    for status in status_update:
        cursor.execute("UPDATE peer_review SET status=%s WHERE status=%s", status)

    cursor.execute("CREATE TEMPORARY TABLE peerreview_old AS SELECT * FROM peer_review")
    cursor.execute("DROP TABLE peer_review")

    table_metadata = Table('peerreview', key='review_id')[
                              Column('review_id', auto_increment=True, type='int'),
                              Column('owner'),
                              Column('status'),
                              Column('created', type='int'),
                              Column('name'),
                              Column('notes'),
                              Column('parent_id', type='int'),
                              Column('project'),
                              Column('keywords')
                              ]

    env.log.info("Updating table for class %s" % realm)
    for stmt in db_backend.to_sql(table_metadata):
        env.log.debug(stmt)
        cursor.execute(stmt)

    cursor = db.cursor()

    cursor.execute("INSERT INTO peerreview (review_id,owner,status,created,name,notes,parent_id,keywords) "
                   "SELECT review_id,owner,status,created,name,notes,parent_id,keywords FROM peerreview_old")

    cursor.execute("DROP TABLE peerreview_old")

    # Add default workflow

    wf_data = [['approve', 'reviewed -> approved'],
               ['approve.name', 'Approve the review'],
               ['close', 'new, reviewed, in-review -> closed'],
               ['close.name', 'Close review'],
               ['disapprove', 'reviewed -> disapproved'],
               ['disapprove.name', 'Deny this review'],
               ['reopen', 'closed, reviewed, approved, disapproved -> new'],
               ['reopen.permissions', 'CODE_REVIEW_MGR'],
               ['review-done', 'in-review -> reviewed'],
               ['review-done.name', 'Mark as reviewed'],
               ['reviewing', 'new -> in-review'],
               ['reviewing.default', '5'],
               ['reviewing.name', 'Start review'],
               ['change_owner','* -> *'],
               ['change_owner.name','Change Owner to'],
               ['change_owner.operations','set_review_owner'],
               ['change_owner.permissions','CODE_REVIEW_MGR'],
               ['change_owner.default','-1'],
               ]
    wf_section = 'peerreview-resource_workflow'

    if wf_section not in env.config.sections():
        print "Adding default workflow for 'peerreview' to config."
        for item in wf_data:
            env.config.set(wf_section, item[0], item[1])
        env.config.save()