opentelemetry_dbapi_instrumentation_sqlite3_auto_tracing_quickstart.py

1import sqlite3
2from opentelemetry.instrumentation.dbapi import DatabaseApiIntegration
3
4# Initialize the DBAPI instrumentation for the sqlite3 module
5db_integration = DatabaseApiIntegration(
6    name="sqlite",
7    module=sqlite3,
8    connect_method_name="connect",
9)
10db_integration.instrument()
11
12# Use the database module as usual; queries will now be automatically instrumented
13connection = sqlite3.connect(":memory:")
14cursor = connection.cursor()
15
16# This execute call will generate an OpenTelemetry span
17cursor.execute("CREATE TABLE test (id INTEGER)")
18cursor.execute("INSERT INTO test VALUES (1)")
19cursor.execute("SELECT * FROM test")
20
21cursor.close()
22connection.close()