[Python] Python not automatically closing a connection to sqlite3 after exiting WITH statement?

Here's a piece of code running on Python 3.10.5 -

with sqlite3.connect("test.db") as db:
cursor = db.cursor()
cursor.execute("""CREATE TABLE IF NOT EXISTS testtable(id integer PRIMARY KEY, name text);""")
cursor.execute("""INSERT INTO testtable(id, name) VALUES (1, "XYZ")""")
db.commit()


cursor.execute("select * from testtable")
for x in cursor.fetchall():
print(x)


Now, as per my understanding of the way WITH statement works, the connection to the database will be automatically closed at the end of the code block without me needing to explicitly call db.close(), similar to how file I/O operations are handled. This would mean the next cursor.execute() fails, since it's outside the statement and hence, invalid.

However, it still runs! I'm able to see the contents of the table. What is happening here?

Continue reading...