第七章：数据持久存储与交换-sqlite3:嵌入式关系数据库-事务-丢弃变更

7.4.9.2 丢弃变更
还可以使用rollback()完全丢弃未提交的变更。commit()和rollback()方法通常在同一个try:except块的不同部分调用，有错误就会触发回滚。

import sqlite3

db_filename = 'todo.db'

def show_projects(conn):
    cursor = conn.cursor()
    cursor.execute('select name,description from project')
    for name,desc in cursor.fetchall():
        print('  ',name)

with sqlite3.connect(db_filename) as conn:
    print('Before changes:')
    show_projects(conn)

    try:
        # Insert
        cursor = conn.cursor()
        cursor.execute("""delete from project
                    where name = 'virtualenvwrapper'
                    """)

        # Show the settings.
        print('\nAfter delete:')
        show_projects(conn)

        # Pretend the processing caused an error.
        raise RuntimeError('simulated error')

    except Exception as err:
        # Discard the changes.
        print('ERROR:',err)
        conn.rollback()

    else:
        # Save the changes.
        conn.commit()

    # Show the results.
    print('\nAfter rollback:')
    show_projects(conn)