Bug: missing dependency on "psycopg[binary,pool]"

[Virtlink]

Description

I did a clean checkout of the repository, then invoked make install. When running make test, I got this error:

ImportError: Error importing plugin "pytest_databases.docker.postgres": no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found

According to this Stackoverflow post the project needs a dependency on psycopg[binary,pool]. And indeed, after the following command make test worked fine:

uv add "psycopg[binary,pool]"

ℹ Running test cases... 🧪
Test session starts (platform: darwin, Python 3.13.2, pytest 8.3.5, pytest-sugar 1.0.0)
rootdir: /Users/daniel/git/litestar-org/litestar-fullstack
configfile: pyproject.toml
plugins: cov-6.0.0, sugar-1.0.0, anyio-4.8.0, databases-0.11.1, Faker-37.0.0, mock-3.14.0, xdist-3.6.1
bringing up nodes...

 tests/integration/test_access.py ✓✓✓✓✓✓✓                                                                                                                                                                                                                                                                                                               20% ██
 tests/integration/test_account_role.py ✓                                                                                                                                                                                                                                                                                                               13% █▍
 tests/integration/test_accounts.py ✓✓✓✓✓✓✓                                                                                                                                                                                                                                                                                                             42% ████▎
 tests/integration/test_teams.py ✓✓✓✓✓✓✓✓                                                                                                                                                                                                                                                                                                               96% █████████▋
 tests/integration/test_health.py x                                                                                                                                                                                                                                                                                                                     47% ████▋
 tests/integration/test_tags.py ✓                                                                                                                                                                                                                                                                                                                       51% █████▎
 tests/unit/lib/test_cache.py ✓                                                                                                                                                                                                                                                                                                                         53% █████▍
 tests/unit/lib/test_crypt.py ✓✓✓✓✓✓✓✓                                                                                                                                                                                                                                                                                                                  71% ███████▎
 tests/unit/lib/test_exceptions.py ✓✓✓✓✓✓✓✓                                                                                                                                                                                                                                                                                                             89% ████████▉
 tests/unit/lib/test_settings.py ✓                                                                                                                                                                                                                                                                                                                      91% █████████▎
 tests/integration/test_tests.py ✓✓                                                                                                                                                                                                                                                                                                                    100% ██████████
========================================================================================================================================================================== warnings summary ==========================================================================================================================================================================
tests/integration/test_teams.py::test_teams_add_remove_member
  <sys>:0: SAWarning: Object of type <Team> not in session, add operation along 'Tag.teams' won't proceed (This warning originated from the Session 'autoflush' process, which was invoked automatically in response to a user-initiated operation. Consider using ``no_autoflush`` context manager if this warning happended while initializing objects.)

-- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html
====================================================================================================================================================================== short test summary info =======================================================================================================================================================================
xfail tests/integration/test_health.py::test_health - Flakey connection to service sometimes causes failures.

Results (43.59s):
      44 passed
✓ Tests passed ✨

Steps to reproduce

1. Clone the project.

   git clone --recurse-submodules --remote-submodules -j8 git@github.com:litestar-org/litestar-fullstack.git

2. Install UV.

   make install-uv

3. Install dependencies.

   make install

4. Start Docker.

5. Run:

   make test

   The error appears.

Version

Commit 0996536 2025-04-24

Platform

• Linux
• Mac
• Windows
• Other (Please specify in the description above)