Implement migration plan for selected instrumentations

[lzchen]

A followup of #2351

Tracking issue to track progress of semantic convention stability migration for the below instrumentations.

Finished:

opentelemetry-instrumentation-requests #2002
opentelemetry-instrumentation-wsgi #2425
opentelemetry-instrumentation-flask #2454
opentelemetry-instrumentation-asgi #2610
opentelemetry-instrumentation-httpx #2631
opentelemetry-instrumentation-fastapi #2682
opentelemetry-instrumentation-aiohttp-client #2675
opentelemetry-instrumentation-django #2714
opentelemetry-instrumentation-urllib3 #2681
opentelemetry-instrumentation-urllib #2680
opentelemetry-instrumentation-falcon #2680

WIP:

Remaining:

opentelemetry-instrumentation-dbapi #2929
opentelemetry-instrumentation-sqlalchemy #2679
opentelemetry-instrumentation-redis #2930
opentelemetry-instrumentation-mysql #2931
opentelemetry-instrumentation-mysqlclient #2932
opentelemetry-instrumentation-psycopg #2928
opentelemetry-instrumentation-psycopg2 #2678
opentelemetry-instrumentation-pymysql #2933
opentelemetry-instrumentation-sqlite3 #2934

[zhihali]

Hey, @lzchen

I'm a beginner contributor, just fixed some bugs and would love to contribute more to the community. After discussing with @emdneto, we believe maybe I could try to contribute this one.

I would like to contribute to the opentelemetry-instrumentation-httplib. I read through the previous issues #2351 and #791, and read through your previous PRs: #2002, #2425, and #2454. They are really complex for me, so I think the steps to update httplib are like:

1. __init__.py under util/opentelemetry-util-http/src/opentelemetry/util/http:
   Introduce Environment Variable: Add logic to check OTEL_SEMCONV_STABILITY_OPT_IN.
   Update Attributes: Replace old attributes with new semantic conventions.
   Conditional Logic: Implement conditional logic to emit old and new attributes based on the environment variable.

2. Instrumentation File (httplib.py):
   Introduce Environment Variable: Similar to init.py.
   Update Span Attributes: Use new semantic conventions.
   Conditional Logic: Add logic to conditionally emit attributes.

3. Test Files:
   Update Tests: Add tests to ensure both old and new conventions are correctly handled based on the environment variable.

I think my next step is to completely understand the httplib instrumentation, as I'm not really familiar with this one yet. May I ask if my steps are correct? Any other resources that could be helpful during my development?

Thank you!

[lzchen]

@zhihali

Thanks a lot of taking an interest in this! The steps you've outlined above sound like a great template! Another thing is to mark the package.py file to indicate the package has been migrated like here.