def test_update_non_autocommit(shared_instance, dbapi_database):
    setup_rows = "\nINSERT INTO contacts (contact_id, first_name, last_name, email)\nVALUES\n(1, 'first-name', 'last-name', 'example@example.com'),\n(2, 'first-name', 'last-name', 'example@example.com'),\n(3, 'first-name', 'last-name', 'example@example.com')\n    "
    conn = Connection(shared_instance, dbapi_database)
    cursor = conn.cursor()
    cursor.execute(setup_rows)
    conn.commit()
    cursor.execute("UPDATE contacts SET first_name='changed' WHERE email='example@example.com'")
    conn.commit()
    assert (cursor.rowcount == 2)
def test_update_non_autocommit(shared_instance, dbapi_database):
    setup_rows = "\nINSERT INTO contacts (contact_id, first_name, last_name, email)\nVALUES\n(1, 'first-name', 'last-name', 'example@example.com'),\n(2, 'first-name', 'last-name', 'example@example.com'),\n(3, 'first-name', 'last-name', 'example@example.com')\n    "
    conn = Connection(shared_instance, dbapi_database)
    cursor = conn.cursor()
    cursor.execute(setup_rows)
    conn.commit()
    cursor.execute("UPDATE contacts SET first_name='changed' WHERE email='example@example.com'")
    conn.commit()
    assert (cursor.rowcount == 2)