exemplo sqlite com with em python, fecha recursos de forma automática

daoQuery.py

from contextlib import closing
import sqlite3
# db from - https://github.com/google-developer-training/basic-android-kotlin-compose-training-bus-schedule-app/blob/main/app/src/main/assets/database/bus_schedule.db
# source - https://www.digitalocean.com/community/tutorials/how-to-use-the-sqlite3-module-in-python-3

with closing(sqlite3.connect("bus_schedule.db")) as connection:
    with closing(connection.cursor()) as cursor:
        rows = cursor.execute("SELECT * FROM Schedule").fetchall()
        print(rows)