Migrating to psycopg3

Similar to !198 (closed) with a few extra things

• swapped the if branch around to be similar to what the storage do
• directly using the existing connection in swh_db_version, it is more efficient and prevent dealing the complication as db.conn.info.dsn does not contains the password information and they would need to be re-injected.
• add some typing information that help mypy to catch bug.

mentioned in merge request !198 (closed)

Jenkins job DPROV/gitlab-builds #217 succeeded in 2 min 46 sec.
See Console Output, Blue Ocean and Coverage Report for more details.

added 1 commit

• 12aee21f - Migrating to psycopg3

Compare with previous version

Jenkins job DPROV/gitlab-builds #218 succeeded in 2 min 48 sec.
See Console Output, Blue Ocean and Coverage Report for more details.

changed the description

added 1 commit

• 252f4999 - Migrating to psycopg3

Compare with previous version

Jenkins job DPROV/gitlab-builds #219 succeeded in 3 min 8 sec.
See Console Output, Blue Ocean and Coverage Report for more details.

added 2 commits

• e018852b - 1 commit from branch swh/devel:main
• 2ae14b96 - Migrating to psycopg3

Compare with previous version

merged

Jenkins job DPROV/gitlab-builds #225 succeeded in 3 min 17 sec.
See Console Output, Blue Ocean and Coverage Report for more details.