Psycopg3 Instrumentation

[TimPansino]

Overview

• Adds instrumentation for Psycopg3
  • Includes both Connection and AsyncConnection instrumentation.
  • Adds new database_dbapi2_async.py file which implements the DBAPI2 interface with async functions.
• Add test suite for Psycopg3
  • Includes tests for Python 3.8+, and PyPy
  • Tests pure python implementation, precompiled binary, and the locally built C extensions recommended for production by psycopg
  • Does NOT test:
  • Python 2 or 3.7 as they are unsupported.
  • psycopg v3.0, as pip for some reason refuses to believe those versions exist despite being available on PyPi.
• Update pytest to get rid of Python 3.12 warnings

[github-actions[bot]]

🦙 MegaLinter status: ✅ SUCCESS

Descriptor	Linter	Files	Fixed	Errors	Elapsed time
✅ PYTHON	bandit	4		0	5.53s
✅ PYTHON	black	20	0	0	2.5s
✅ PYTHON	flake8	20		0	1.14s
✅ PYTHON	isort	20	0	0	0.39s
✅ PYTHON	pylint	20		0	8.69s
✅ YAML	prettier	1	0	0	1.41s
✅ YAML	v8r	1		0	2.91s
✅ YAML	yamllint	1		0	0.5s

See detailed report in MegaLinter reports _Set VALIDATE_ALL_CODEBASE: true in mega-linter.yml to validate all sources, not only the diff_

_MegaLinter is graciously provided by _

[codecov-commenter]

Codecov Report

Attention: Patch coverage is 89.27445% with 34 lines in your changes missing coverage. Please review.

Project coverage is 81.63%. Comparing base (60c5549) to head (38bada0).

Files	Patch %	Lines
newrelic/hooks/database_dbapi2_async.py	77.77%	15 Missing and 1 partial :warning:
newrelic/hooks/database_psycopg.py	93.42%	5 Missing and 10 partials :warning:
newrelic/hooks/database_dbapi2.py	80.00%	3 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #1155 +/- ## ========================================== + Coverage 81.39% 81.63% +0.24% ========================================== Files 193 195 +2 Lines 21341 21639 +298 Branches 3721 3777 +56 ========================================== + Hits 17370 17666 +296 + Misses 2877 2871 -6 - Partials 1094 1102 +8 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[TimPansino]

I definitely feel like a few of the lines of missed coverage are being run, maybe they're not picked up due to something in coverage. I'll check that out on Monday.