dbt-autofix: Skill for Claude Code

Add Integration Test

Create a new integration test for dbt-autofix. Integration tests verify that the refactor tool correctly transforms dbt projects.

Philosophy: Test-Driven Development

Integration tests document DESIRED behavior, not current behavior.

• For bug fixes: Create a test that reproduces the bug, with expected output showing the correct behavior
• For feature requests: Create a test that specifies what the feature should do
• Tests should FAIL initially, then PASS once the fix/feature is implemented

This approach:

1. Serves as a specification for the work
2. Prevents regressions
3. Automatically validates when the implementation is complete

Using GOLDIE_UPDATE: Run with GOLDIE_UPDATE=1 to understand current behavior, but don't blindly accept it as the expected output. Manually craft the _expected files to reflect what the behavior should be.

Arguments

• $ARGUMENTS - The test project name (e.g., config_quoted_strings)

Running a single test:

uv run pytest "tests/integration_tests/test_full_dbt_projects.py::test_project_refactor[project_<name>]" -v

Example for a project named config_quoted_strings:

uv run pytest "tests/integration_tests/test_full_dbt_projects.py::test_project_refactor[project_config_quoted_strings]" -v

Naming guidance: Use descriptive names that explain what the test covers, not issue numbers. For example:

• config_quoted_strings (not issue_221)
• python_model_meta_config (not issue_220)
• jinja_unmatched_endif

The name becomes project_<name> in the test projects directory.

Test Structure

Each integration test requires 3 artifacts in tests/integration_tests/dbt_projects/:

1. project_<name>/ - Input dbt project (before refactor)

   • Minimum: dbt_project.yml + model files in models/

2. project_<name>_expected/ - Expected output (after refactor)

   • Mirror of input with the DESIRED transformations applied

3. project_<name>_expected.stdout - Expected JSON log output

   • One JSON object per line documenting refactors that SHOULD be applied