pio run -t compiledb does not generate compilation database for tests

[UtkarshVerma]

What kind of issue is this?

• Question.
  This issue tracker is not the place for questions. If you want to ask how to do something,
  or to understand why something isn't working the way you expect it to,
  use Community Forums or Premium Support

• PlatformIO IDE.
  All issues related to PlatformIO IDE should be reported to the
  PlatformIO IDE for VSCode repository

• Development Platform or Board.
  All issues (building, uploading, adding new boards, etc.) related to PlatformIO development platforms
  should be reported to appropriate repository related to your hardware
  https://github.com/topics/platformio-platform

• Feature Request.
  Start by telling us what problem you’re trying to solve. Often a solution
  already exists! Don’t send pull requests to implement new features without first getting our
  support. Sometimes we leave features out on purpose to keep the project small.

• PlatformIO Core.
  If you’ve found a bug, please provide an information below.

You can erase any parts of this template not applicable to your Issue.

---

Configuration

Operating system: Arch Linux

PlatformIO Version (platformio --version): PlatformIO Core, version 6.1.14

Description of problem

I use pio run -t compiledb to generate a compilation database that clangd can utilise. However, I noticed that the generated database does not include the path to unity.h and hence I get linter errors in my editor (neovim) whenever I try to include unity.h.

Steps to Reproduce

1. pio run -t compiledb

Actual Results

Compilation database only generated for project root.

Expected Results

Compilation database should also be generated for tests.

[ivankravets]

Could try to add Unity to lib_deps as described here https://registry.platformio.org/libraries/throwtheswitch/Unity/installation ?