$ pythonPython 3.10.0 (default, Nov  5 2021, 17:23:47) [GCC 11.2.1 20210728 (Red Hat 11.2.1-1)] on linuxType "help", "copyright", "credits" or "license" for more information.>>> import sqlite3>>> sqlite3.sqlite_version'3.36.0'

importosimportsqlite3defgo():"""function creates a new table, runs INSERT/UPDATE, drops table,    commits connection.    """# create tablecursor=conn.cursor()cursor.execute("""CREATE TABLE some_table (        id INTEGER NOT NULL,        value VARCHAR(40) NOT NULL,        PRIMARY KEY (id)    )    """    )cursor.close()conn.commit()# run operationcursor=conn.cursor()cursor.execute("INSERT INTO some_table (id, value) VALUES (1, 'v1')"    )ident=1cursor.execute("UPDATE some_table SET value='v2' ""WHERE id=? RETURNING id",        (ident,),    )new_ident=cursor.fetchone()[0]assertident==new_identassertcursor.rowcount==1,cursor.rowcountcursor.close()# drop tablecursor=conn.cursor()cursor.execute("DROP TABLE some_table")cursor.close()conn.commit()ifos.path.exists("file.db"):os.unlink("file.db")# passesconn=sqlite3.connect("file.db")go()# run again w/ new connection (same DB), passesconn=sqlite3.connect("file.db")go()print("FAILURE NOW OCCURS")# run again w/ same connection, failsgo()

$  python test3.py FAILURE NOW OCCURSTraceback (most recent call last):  File "/home/classic/dev/sqlalchemy/test3.py", line 62, in <module>    go()  File "/home/classic/dev/sqlalchemy/test3.py", line 39, in go    assert cursor.rowcount == 1, cursor.rowcountAssertionError: 0