Make sure sqlite3 instrumentation follows semantic conventions

[srikanthccv]

No description provided.

[Anu-MT]

Hi,
I would like to work on the issue. Would you assign this to me?Any guidance will be greatly appreciated.

[baravkareknath]

Hi srikanthccv and Anu-MT,
I think I am able to resolve this issue as below-

from opentelemetry import trace
from opentelemetry.instrumentation.dbapi import trace_integration
import sqlite3

Initialize tracer

tracer = tracer.get_tracer(name)

Instrument sqlite3

tracer_integration(sqlite3, "connect", "sqlite3")

Connect to database

conn = sqlite3.connect("example.db")

Create cursor

cur = conn.cursor()

Example db operation with instrumentation

with tracer.start_as_current_span("example-database-operation") as span:
cur.execute("select * from example_table")

    # Add sematic attributes
    span.set_attribute("db.system", "sqlite")
    span.set_attribute("db.name", "example.db")
    span.set_attribute("db.statement", "select * from example_table")
  
    # fetch results
    results = cur.fetchall()

close connection

conn.close()

Like this is it correct way to resolve this issue.
And please guide me in that because I am first time contributor.
If is it correct way, please let me know where this code part implements in the repository.
Thanks in advance.