adbc_driver_manager_sqlite_in_memory_query_quickstart.py

1import adbc_driver_manager
2import adbc_driver_sqlite.dbapi
3
4# The driver manager can be used to connect to a database using a driver 
5# that is already loaded, or by providing the path to a shared library.
6# Here, we use the adbc_driver_sqlite helper to get a connection.
7
8with adbc_driver_sqlite.dbapi.connect() as conn:
9    with conn.cursor() as cur:
10        cur.execute("SELECT 1")
11        print(cur.fetchone())
12
13# To use the low-level Driver Manager API directly:
14# (Note: This requires the path to a compiled ADBC driver library)
15# 
16# import adbc_driver_manager
17# 
18# with adbc_driver_manager.AdbcDatabase(driver="adbc_driver_sqlite", entrypoint="AdbcSqliteDriverInit") as db:
19#     with adbc_driver_manager.AdbcConnection(db) as conn:
20#         with adbc_driver_manager.AdbcStatement(conn) as stmt:
21#             stmt.set_sql_query("SELECT 1")
22#             stream, _ = stmt.execute_query()
23#             print(stream.read_all())