[IR-P2][WS2] Phase 2 Shadow runtime dual-run (epic)

[0x054]

Problem statement

Phase 2 needs a controlling epic to coordinate deliverables, acceptance criteria, and traceability for Shadow runtime dual-run.

Intended invariant

Run IR-derived runtime planning in shadow mode and compare semantics against current runtime path.

Scope boundaries

• Coordinates Phase 2 roadmap scope only
• Tracks delivery issues and phase exit gate evidence
• Defers unrelated feature expansion outside IR roadmap scope

Deliverable checklist

• Sub-issues for all phase deliverables are opened and linked
• Phase deliverables are implemented and verified
• Exit gate evidence is linked in roadmap and issues
• Migration and docs impact fields are kept synchronized

Validation plan

Phase 2 closes only when linked sub-issues are complete and roadmap phase exit gates are satisfied with evidence.

Rollback/failure mode

If scope expands or deliverables split, create follow-up issues and update roadmap + issue links in the same work session.

Roadmap reference

Roadmap reference: docs/plans/2026-06-19-001-ir-first-roadmap.md (Phase 2)

Migration impact

none - phase-level impact estimate; refine on each sub-issue.

Documentation impact

update-existing - phase requires synchronized docs updates with implementation.

Sync status

Synced with roadmap: 2026-06-19

[0x054]

Phase sub-issues:

• [IR-P2][WS2] Add shadow planner behind internal flag #81 Add shadow planner behind internal flag
• [IR-P2][WS2] Build semantic diff harness #82 Build semantic diff harness
• [IR-P2][WS2] Add backend matrix shadow reports #83 Add backend matrix shadow reports

[0x054]

Phase 2 status update: branch implementation is complete for #81/#82/#83 on (commit ae60662).\n\nExit-gate evidence (current branch):\n- Shadow planner internal flag + dual-run compare hooks: , , , , , .\n- Semantic diff/test harness: + .\n- Stable backend reports + CI touched-path gate: , .\n- Migration/docs synchronization: , .\n\nValidation run:\n- ============================= test session starts ==============================
platform darwin -- Python 3.14.5, pytest-9.0.2, pluggy-1.6.0 -- /Users/taylor/github/syn54x/ferro-orm/.venv/bin/python3
cachedir: .pytest_cache
rootdir: /Users/taylor/github/syn54x/ferro-orm
configfile: pyproject.toml
plugins: anyio-4.12.1, xdist-3.8.0, asyncio-1.3.0, examples-0.0.18, postgresql-8.0.0, cov-7.0.0
asyncio: mode=Mode.STRICT, debug=False, asyncio_default_fixture_loop_scope=None, asyncio_default_test_loop_scope=function
collecting ... collected 798 items / 353 deselected / 445 selected

tests/test_aggregation.py::test_count_operation[sqlite] PASSED [ 0%]
tests/test_aggregation.py::test_count_operation[postgres] SKIPPED (p...) [ 0%]
tests/test_aggregation.py::test_order_by_operation[sqlite] PASSED [ 0%]
tests/test_aggregation.py::test_order_by_operation[postgres] SKIPPED [ 0%]
tests/test_alembic_bridge.py::test_explicit_foreign_key_shadow_id_auto_migrate_roundtrip[sqlite] PASSED [ 1%]
tests/test_alembic_bridge.py::test_explicit_foreign_key_shadow_id_auto_migrate_roundtrip[postgres] SKIPPED [ 1%]
tests/test_auto_migrate.py::test_connect_with_auto_migrate[sqlite] PASSED [ 1%]
tests/test_auto_migrate.py::test_connect_with_auto_migrate[postgres] SKIPPED [ 1%]
tests/test_auto_migrate.py::test_connect_without_auto_migrate[sqlite] PASSED [ 2%]
tests/test_auto_migrate.py::test_connect_without_auto_migrate[postgres] SKIPPED [ 2%]
tests/test_auto_migrate.py::test_m2m_join_table_created_during_auto_migrate[sqlite] PASSED [ 2%]
tests/test_auto_migrate.py::test_m2m_join_table_created_during_auto_migrate[postgres] SKIPPED [ 2%]
tests/test_auto_migrate.py::test_uuid_m2m_join_table_columns_inherit_pk_type_and_nullability[sqlite] PASSED [ 2%]
tests/test_auto_migrate.py::test_uuid_m2m_relationship_query_serializes_source_id[sqlite] PASSED [ 3%]
tests/test_auto_migrate.py::test_uuid_m2m_relationship_query_serializes_source_id[postgres] SKIPPED [ 3%]
tests/test_auto_migrate.py::test_migrate_updates_adds_missing_columns_and_hydrates[sqlite] PASSED [ 3%]
tests/test_auto_migrate.py::test_migrate_updates_adds_missing_columns_and_hydrates[postgres] SKIPPED [ 3%]
tests/test_auto_migrate.py::test_manual_migrate_on_live_pool_refreshes_cached_statements[sqlite] PASSED [ 4%]
tests/test_auto_migrate.py::test_manual_migrate_on_live_pool_refreshes_cached_statements[postgres] SKIPPED [ 4%]
tests/test_auto_migrate.py::test_migrate_updates_not_null_without_default_fails_loudly[sqlite] PASSED [ 4%]
tests/test_auto_migrate.py::test_sqlite_type_drift_warns_and_leaves_column_untouched[sqlite] PASSED [ 4%]
tests/test_auto_migrate.py::test_migrate_destructive_drops_removed_columns[sqlite] PASSED [ 4%]
tests/test_auto_migrate.py::test_migrate_destructive_drops_removed_columns[postgres] SKIPPED [ 5%]
tests/test_auto_migrate.py::test_destructive_drop_of_indexed_column_drops_index_first[sqlite] PASSED [ 5%]
tests/test_auto_migrate.py::test_destructive_refuses_unique_constraint_column_on_sqlite[sqlite] PASSED [ 5%]
tests/test_auto_migrate.py::test_added_indexed_and_unique_columns_get_their_indexes[sqlite] PASSED [ 5%]
tests/test_auto_migrate.py::test_postgres_type_and_nullability_reconciliation[postgres] SKIPPED [ 6%]
tests/test_bulk_update.py::test_bulk_update_operation[sqlite] PASSED [ 6%]
tests/test_bulk_update.py::test_bulk_update_operation[postgres] SKIPPED [ 6%]
tests/test_bulk_update.py::test_bulk_update_evicts_identity_map[sqlite] PASSED [ 6%]
tests/test_bulk_update.py::test_bulk_update_evicts_identity_map[postgres] SKIPPED [ 6%]
tests/test_composite_index.py::test_composite_index_unknown_column_raises PASSED [ 7%]
tests/test_composite_index.py::test_single_column_composite_index_raises_with_guidance PASSED [ 7%]
tests/test_composite_index.py::test_empty_inner_tuple_raises PASSED [ 7%]
tests/test_composite_index.py::test_non_string_column_entry_raises PASSED [ 7%]
tests/test_composite_index.py::test_outer_not_a_tuple_raises PASSED [ 8%]
tests/test_composite_index.py::test_inner_not_a_tuple_raises PASSED [ 8%]
tests/test_composite_index.py::test_empty_default_is_noop PASSED [ 8%]
tests/test_composite_index.py::test_duplicate_ordered_tuple_dedupes_silently PASSED [ 8%]
tests/test_composite_index.py::test_three_column_composite_index PASSED [ 8%]
tests/test_composite_index.py::test_schema_json_uses_lists_not_tuples PASSED [ 9%]
tests/test_composite_index.py::test_overlap_with_unique_warns_and_drops PASSED [ 9%]
tests/test_composite_index.py::test_overlap_reordered_does_not_warn PASSED [ 9%]
tests/test_composite_index.py::test_overlap_with_unique_partial_match_does_not_warn PASSED [ 9%]
tests/test_composite_index.py::test_alembic_metadata_has_index_objects PASSED [ 10%]
tests/test_composite_index.py::test_alembic_metadata_index_column_order_matches_declaration PASSED [ 10%]
tests/test_composite_index.py::test_composite_index_multiple_groups PASSED [ 10%]
tests/test_composite_index.py::test_composite_index_order_matters_two_separate_indexes PASSED [ 10%]
tests/test_composite_index.py::test_uniques_and_indexes_coexist PASSED [ 11%]
tests/test_composite_index.py::test_coexists_with_single_column_field_index PASSED [ 11%]
tests/test_composite_index.py::test_build_sa_table_warns_on_invalid_composite_index_group PASSED [ 11%]
tests/test_composite_index.py::test_composite_index_name_python_matches_naming_convention PASSED [ 11%]
tests/test_composite_index.py::test_composite_index_exists_in_sqlite[sqlite] PASSED [ 11%]
tests/test_composite_index.py::test_composite_index_column_order_in_sqlite_indexdef[sqlite] PASSED [ 12%]
tests/test_composite_index.py::test_composite_index_truncated_name_matches_alembic_and_sqlite[sqlite] PASSED [ 12%]
tests/test_composite_index.py::test_composite_index_exists_in_postgres[postgres] SKIPPED [ 12%]
tests/test_composite_index.py::test_composite_index_column_order_in_postgres_indexdef[postgres] SKIPPED [ 12%]
tests/test_composite_index.py::test_composite_index_truncated_name_matches_postgres_catalog[postgres] SKIPPED [ 13%]
tests/test_composite_index.py::test_composite_index_works_with_uuid_columns[sqlite] PASSED [ 13%]
tests/test_composite_index.py::test_composite_index_works_with_uuid_columns[postgres] SKIPPED [ 13%]
tests/test_composite_index.py::test_composite_index_works_with_enum_column[sqlite] PASSED [ 13%]
tests/test_composite_index.py::test_composite_index_works_with_enum_column[postgres] SKIPPED [ 13%]
tests/test_composite_index.py::test_autogen_idempotent_after_first_apply[sqlite] PASSED [ 14%]
tests/test_composite_index.py::test_use_case_m2m_reverse_query[sqlite] PASSED [ 14%]
tests/test_composite_index.py::test_use_case_m2m_reverse_query[postgres] SKIPPED [ 14%]
tests/test_composite_index.py::test_use_case_polymorphic_lookup_index[sqlite] PASSED [ 14%]
tests/test_composite_index.py::test_use_case_polymorphic_lookup_index[postgres] SKIPPED [ 15%]
tests/test_composite_unique.py::test_composite_unique_unknown_column_raises PASSED [ 15%]
tests/test_composite_unique.py::test_composite_unique_enforced_on_user_model[sqlite] PASSED [ 15%]
tests/test_composite_unique.py::test_composite_unique_enforced_on_user_model[postgres] SKIPPED [ 15%]
tests/test_composite_unique.py::test_m2m_duplicate_link_rejected[sqlite] PASSED [ 15%]
tests/test_composite_unique.py::test_m2m_duplicate_link_rejected[postgres] SKIPPED [ 16%]
tests/test_composite_unique.py::test_alembic_metadata_has_unique_constraints PASSED [ 16%]
tests/test_composite_unique.py::test_composite_unique_index_exists_in_sqlite[sqlite] PASSED [ 16%]
tests/test_composite_unique.py::test_composite_unique_truncated_name_matches_alembic_and_sqlite[sqlite] PASSED [ 16%]
tests/test_composite_unique.py::test_composite_unique_truncated_name_matches_postgres_catalog[postgres] SKIPPED [ 17%]
tests/test_composite_unique.py::test_composite_unique_multiple_groups_in_metadata_and_sqlite PASSED [ 17%]
tests/test_composite_unique.py::test_composite_unique_order_matters_two_separate_constraints PASSED [ 17%]
tests/test_composite_unique.py::test_build_sa_table_warns_on_invalid_composite_unique_group PASSED [ 17%]
tests/test_composite_unique.py::test_single_column_composite_unique_raises_with_guidance PASSED [ 17%]
tests/test_composite_unique.py::test_m2m_reverse_index_default_on PASSED [ 18%]
tests/test_composite_unique.py::test_m2m_reverse_index_opt_out PASSED [ 18%]
tests/test_composite_unique.py::test_m2m_reverse_index_lives_on_forward_side PASSED [ 18%]
tests/test_composite_unique.py::test_m2m_reverse_index_in_sqlite_catalog[sqlite] PASSED [ 18%]
tests/test_composite_unique.py::test_m2m_reverse_index_in_postgres_catalog[postgres] SKIPPED [ 19%]
tests/test_composite_unique.py::test_m2m_reverse_index_with_custom_through_name PASSED [ 19%]
tests/test_composite_unique.py::test_m2m_self_referential_reverse_index PASSED [ 19%]
tests/test_composite_unique.py::test_m2m_reverse_index_attribute_preserved_on_relation PASSED [ 19%]
tests/test_connection.py::test_connection_smoke[sqlite] PASSED [ 20%]
tests/test_connection.py::test_connection_smoke[postgres] SKIPPED (p...) [ 20%]
tests/test_connection.py::test_named_connection_rejects_duplicate_name PASSED [ 20%]
tests/test_connection.py::test_set_default_connection_routes_unqualified_operations PASSED [ 20%]
tests/test_connection.py::test_raw_execute_using_routes_to_named_connection PASSED [ 20%]
tests/test_connection.py::test_create_tables_using_routes_schema_to_named_connection PASSED [ 21%]
tests/test_connection.py::test_model_using_routes_create_and_query_to_named_connection PASSED [ 21%]
tests/test_connection.py::test_model_using_routes_query_mutations_to_named_connection PASSED [ 21%]
tests/test_connection.py::test_model_using_routes_helper_writes_to_named_connection PASSED [ 21%]
tests/test_connection.py::test_identity_map_is_scoped_by_named_connection PASSED [ 22%]
tests/test_connection.py::test_service_loaded_instance_save_uses_origin_connection PASSED [ 22%]
tests/test_connection.py::test_service_loaded_instance_delete_uses_origin_connection PASSED [ 22%]
tests/test_connection.py::test_service_loaded_instance_refresh_uses_origin_connection PASSED [ 22%]
tests/test_connection.py::test_backref_query_inherits_source_instance_origin PASSED [ 22%]
tests/test_connection.py::test_forward_fk_load_inherits_source_instance_origin PASSED [ 23%]
tests/test_connection.py::test_m2m_relation_writes_inherit_source_instance_origin PASSED [ 23%]
tests/test_connection.py::test_pool_config_rejects_min_connections_above_max PASSED [ 23%]
tests/test_connection.py::test_connect_passes_pool_config_to_core PASSED [ 23%]
tests/test_connection.py::test_unqualified_operation_requires_default_connection PASSED [ 24%]
tests/test_connection.py::test_invalid_connection_string PASSED [ 24%]
tests/test_connection.py::test_unsupported_database_scheme_is_rejected_before_connect_attempt PASSED [ 24%]
tests/test_connection.py::test_postgres_connection[postgres] SKIPPED [ 24%]
tests/test_constraints.py::test_unique_constraint[sqlite] PASSED [ 24%]
tests/test_constraints.py::test_unique_constraint[postgres] SKIPPED [ 25%]
tests/test_constraints.py::test_index_creation[sqlite] PASSED [ 25%]
tests/test_constraints.py::test_index_creation_in_postgres[postgres] SKIPPED [ 25%]
tests/test_cross_emitter_parity.py::test_alembic_autogen_against_rust_migrated_db_is_idempotent[sqlite] PASSED [ 25%]
tests/test_cross_emitter_parity.py::test_alembic_autogen_after_migrate_updates_is_idempotent[sqlite] PASSED [ 26%]
tests/test_crud.py::test_model_save_new_record[sqlite] PASSED [ 26%]
tests/test_crud.py::test_model_save_new_record[postgres] SKIPPED (py...) [ 26%]
tests/test_crud.py::test_model_save_update_record[sqlite] PASSED [ 26%]
tests/test_crud.py::test_model_save_update_record[postgres] SKIPPED [ 26%]
tests/test_crud.py::test_model_all_fetching[sqlite] PASSED [ 27%]
tests/test_crud.py::test_model_all_fetching[postgres] SKIPPED (pytes...) [ 27%]
tests/test_crud.py::test_upsert_does_not_duplicate[sqlite] PASSED [ 27%]
tests/test_crud.py::test_upsert_does_not_duplicate[postgres] SKIPPED [ 27%]
tests/test_crud.py::test_identity_map_consistency[sqlite] PASSED [ 28%]
tests/test_crud.py::test_identity_map_consistency[postgres] SKIPPED [ 28%]
tests/test_crud.py::test_identity_map_disabled_returns_distinct_instances[sqlite] PASSED [ 28%]
tests/test_crud.py::test_identity_map_disabled_returns_distinct_instances[postgres] SKIPPED [ 28%]
tests/test_crud.py::test_model_get_operation[sqlite] PASSED [ 28%]
tests/test_crud.py::test_model_get_operation[postgres] SKIPPED (pyte...) [ 29%]
tests/test_crud.py::test_model_get_invalid_usage[sqlite] PASSED [ 29%]
tests/test_crud.py::test_model_get_invalid_usage[postgres] SKIPPED (...) [ 29%]
tests/test_crud.py::test_model_get_not_found[sqlite] PASSED [ 29%]
tests/test_crud.py::test_model_get_not_found[postgres] SKIPPED (pyte...) [ 30%]
tests/test_db_type_integration.py::test_strenum_db_type_text_runtime_ddl_sqlite[sqlite] PASSED [ 30%]
tests/test_db_type_integration.py::test_strenum_db_type_text_runtime_ddl_postgres[postgres] SKIPPED [ 30%]
tests/test_db_type_integration.py::test_db_check_constraint_exists_after_auto_migrate[postgres] SKIPPED [ 30%]
tests/test_db_type_integration.py::test_db_check_not_emitted_on_sqlite_runtime_ddl[sqlite] PASSED [ 31%]
tests/test_db_type_integration.py::test_bigint_db_type_runtime_ddl_sqlite[sqlite] PASSED [ 31%]
tests/test_db_type_integration.py::test_bigint_db_type_runtime_ddl_postgres[postgres] SKIPPED [ 31%]
tests/test_db_type_integration.py::test_strenum_text_storage_round_trip[sqlite] PASSED [ 31%]
tests/test_db_type_integration.py::test_strenum_text_storage_round_trip[postgres] SKIPPED [ 31%]
tests/test_db_type_integration.py::test_bigint_value_round_trip[sqlite] PASSED [ 32%]
tests/test_db_type_integration.py::test_bigint_value_round_trip[postgres] SKIPPED [ 32%]
tests/test_db_type_integration.py::test_uuid_stored_as_text_round_trip[sqlite] PASSED [ 32%]
tests/test_db_type_integration.py::test_uuid_stored_as_text_round_trip[postgres] SKIPPED [ 32%]
tests/test_db_type_integration.py::test_varchar_helper_round_trip[sqlite] PASSED [ 33%]
tests/test_db_type_integration.py::test_varchar_helper_round_trip[postgres] SKIPPED [ 33%]
tests/test_db_type_integration.py::test_db_check_rejects_invalid_value_on_insert[postgres] SKIPPED [ 33%]
tests/test_db_type_integration.py::test_default_strenum_without_db_type_runtime_ddl_and_round_trip[postgres] SKIPPED [ 33%]
tests/test_deletion.py::test_instance_delete[sqlite] PASSED [ 33%]
tests/test_deletion.py::test_instance_delete[postgres] SKIPPED (pyte...) [ 34%]
tests/test_deletion.py::test_query_delete[sqlite] PASSED [ 34%]
tests/test_deletion.py::test_query_delete[postgres] SKIPPED (pytest-...) [ 34%]
tests/test_deletion.py::test_delete_evicts_identity_map[sqlite] PASSED [ 34%]
tests/test_deletion.py::test_delete_evicts_identity_map[postgres] SKIPPED [ 35%]
tests/test_documentation_features.py::test_basic_model_definition[sqlite] PASSED [ 35%]
tests/test_documentation_features.py::test_basic_model_definition[postgres] SKIPPED [ 35%]
tests/test_documentation_features.py::test_field_types[sqlite] PASSED [ 35%]
tests/test_documentation_features.py::test_field_types[postgres] SKIPPED [ 35%]
tests/test_documentation_features.py::test_enum_field_type[sqlite] PASSED [ 36%]
tests/test_documentation_features.py::test_enum_field_type[postgres] SKIPPED [ 36%]
tests/test_documentation_features.py::test_field_constraints_pydantic_style[sqlite] PASSED [ 36%]
tests/test_documentation_features.py::test_field_constraints_pydantic_style[postgres] SKIPPED [ 36%]
tests/test_documentation_features.py::test_field_constraints_annotated_style[sqlite] PASSED [ 37%]
tests/test_documentation_features.py::test_field_constraints_annotated_style[postgres] SKIPPED [ 37%]
tests/test_documentation_features.py::test_create_method[sqlite] PASSED [ 37%]
tests/test_documentation_features.py::test_create_method[postgres] SKIPPED [ 37%]
tests/test_documentation_features.py::test_get_method[sqlite] PASSED [ 37%]
tests/test_documentation_features.py::test_get_method[postgres] SKIPPED [ 38%]
tests/test_documentation_features.py::test_all_method[sqlite] PASSED [ 38%]
tests/test_documentation_features.py::test_all_method[postgres] SKIPPED [ 38%]
tests/test_documentation_features.py::test_save_method[sqlite] PASSED [ 38%]
tests/test_documentation_features.py::test_save_method[postgres] SKIPPED [ 39%]
tests/test_documentation_features.py::test_delete_method[sqlite] PASSED [ 39%]
tests/test_documentation_features.py::test_delete_method[postgres] SKIPPED [ 39%]
tests/test_documentation_features.py::test_refresh_method[sqlite] PASSED [ 39%]
tests/test_documentation_features.py::test_refresh_method[postgres] SKIPPED [ 40%]
tests/test_documentation_features.py::test_bulk_create[sqlite] PASSED [ 40%]
tests/test_documentation_features.py::test_bulk_create[postgres] SKIPPED [ 40%]
tests/test_documentation_features.py::test_get_or_create[sqlite] PASSED [ 40%]
tests/test_documentation_features.py::test_get_or_create[postgres] SKIPPED [ 40%]
tests/test_documentation_features.py::test_update_or_create[sqlite] PASSED [ 41%]
tests/test_documentation_features.py::test_update_or_create[postgres] SKIPPED [ 41%]
tests/test_documentation_features.py::test_where_equality[sqlite] PASSED [ 41%]
tests/test_documentation_features.py::test_where_equality[postgres] SKIPPED [ 41%]
tests/test_documentation_features.py::test_where_comparison_operators[sqlite] PASSED [ 42%]
tests/test_documentation_features.py::test_where_comparison_operators[postgres] SKIPPED [ 42%]
tests/test_documentation_features.py::test_where_like_operator[sqlite] PASSED [ 42%]
tests/test_documentation_features.py::test_where_like_operator[postgres] SKIPPED [ 42%]
tests/test_documentation_features.py::test_where_in_operator[sqlite] PASSED [ 42%]
tests/test_documentation_features.py::test_where_in_operator[postgres] SKIPPED [ 43%]
tests/test_documentation_features.py::test_logical_and_operator[sqlite] PASSED [ 43%]
tests/test_documentation_features.py::test_logical_and_operator[postgres] SKIPPED [ 43%]
tests/test_documentation_features.py::test_logical_or_operator[sqlite] PASSED [ 43%]
tests/test_documentation_features.py::test_logical_or_operator[postgres] SKIPPED [ 44%]
tests/test_documentation_features.py::test_order_by[sqlite] PASSED [ 44%]
tests/test_documentation_features.py::test_order_by[postgres] SKIPPED [ 44%]
tests/test_documentation_features.py::test_limit_and_offset[sqlite] PASSED [ 44%]
tests/test_documentation_features.py::test_limit_and_offset[postgres] SKIPPED [ 44%]
tests/test_documentation_features.py::test_query_first[sqlite] PASSED [ 45%]
tests/test_documentation_features.py::test_query_first[postgres] SKIPPED [ 45%]
tests/test_documentation_features.py::test_query_count[sqlite] PASSED [ 45%]
tests/test_documentation_features.py::test_query_count[postgres] SKIPPED [ 45%]
tests/test_documentation_features.py::test_query_exists[sqlite] PASSED [ 46%]
tests/test_documentation_features.py::test_query_exists[postgres] SKIPPED [ 46%]
tests/test_documentation_features.py::test_query_update[sqlite] PASSED [ 46%]
tests/test_documentation_features.py::test_query_update[postgres] SKIPPED [ 46%]
tests/test_documentation_features.py::test_query_delete[sqlite] PASSED [ 46%]
tests/test_documentation_features.py::test_query_delete[postgres] SKIPPED [ 47%]
tests/test_documentation_features.py::test_foreign_key_creation[sqlite] PASSED [ 47%]
tests/test_documentation_features.py::test_foreign_key_creation[postgres] SKIPPED [ 47%]
tests/test_documentation_features.py::test_foreign_key_forward_relation[sqlite] PASSED [ 47%]
tests/test_documentation_features.py::test_foreign_key_forward_relation[postgres] SKIPPED [ 48%]
tests/test_documentation_features.py::test_foreign_key_reverse_relation[sqlite] PASSED [ 48%]
tests/test_documentation_features.py::test_foreign_key_reverse_relation[postgres] SKIPPED [ 48%]
tests/test_documentation_features.py::test_reverse_relation_filtering[sqlite] PASSED [ 48%]
tests/test_documentation_features.py::test_reverse_relation_filtering[postgres] SKIPPED [ 48%]
tests/test_documentation_features.py::test_shadow_field_access[sqlite] PASSED [ 49%]
tests/test_documentation_features.py::test_shadow_field_access[postgres] SKIPPED [ 49%]
tests/test_documentation_features.py::test_many_to_many_add[sqlite] SKIPPED [ 49%]
tests/test_documentation_features.py::test_many_to_many_add[postgres] SKIPPED [ 49%]
tests/test_documentation_features.py::test_many_to_many_remove[sqlite] SKIPPED [ 50%]
tests/test_documentation_features.py::test_many_to_many_remove[postgres] SKIPPED [ 50%]
tests/test_documentation_features.py::test_many_to_many_clear[sqlite] SKIPPED [ 50%]
tests/test_documentation_features.py::test_many_to_many_clear[postgres] SKIPPED [ 50%]
tests/test_documentation_features.py::test_many_to_many_reverse[sqlite] SKIPPED [ 51%]
tests/test_documentation_features.py::test_many_to_many_reverse[postgres] SKIPPED [ 51%]
tests/test_documentation_features.py::test_transaction_commit[sqlite] PASSED [ 51%]
tests/test_documentation_features.py::test_transaction_commit[postgres] SKIPPED [ 51%]
tests/test_documentation_features.py::test_transaction_rollback[sqlite] PASSED [ 51%]
tests/test_documentation_features.py::test_transaction_rollback[postgres] SKIPPED [ 52%]
tests/test_documentation_features.py::test_transaction_isolation[sqlite] PASSED [ 52%]
tests/test_documentation_features.py::test_transaction_isolation[postgres] SKIPPED [ 52%]
tests/test_documentation_features.py::test_tutorial_blog_example[sqlite] PASSED [ 52%]
tests/test_documentation_features.py::test_tutorial_blog_example[postgres] SKIPPED [ 53%]
tests/test_enum_cold_hydration.py::test_enum_fields_populated_for_deferred_annotations PASSED [ 53%]
tests/test_enum_cold_hydration.py::test_enum_type_name_unchanged_for_deferred_annotated_strenum PASSED [ 53%]
tests/test_enum_cold_hydration.py::test_annotated_strenum_text_cold_fetch_after_reset_engine[sqlite] PASSED [ 53%]
tests/test_enum_cold_hydration.py::test_annotated_strenum_text_cold_fetch_after_reset_engine[postgres] SKIPPED [ 53%]
tests/test_field_wrapper.py::test_ferro_field_wrapper_sets_metadata_and_pydantic_schema[sqlite] PASSED [ 54%]
tests/test_field_wrapper.py::test_ferro_field_wrapper_sets_metadata_and_pydantic_schema[postgres] SKIPPED [ 54%]
tests/test_field_wrapper.py::test_assignment_and_annotation_field_patterns_equivalent_ferro_metadata PASSED [ 54%]
tests/test_field_wrapper.py::test_annotation_field_pattern_persists_like_assignment[sqlite] PASSED [ 54%]
tests/test_field_wrapper.py::test_annotation_field_pattern_persists_like_assignment[postgres] SKIPPED [ 55%]
tests/test_field_wrapper.py::test_optional_patterned_string_roundtrip[sqlite] PASSED [ 55%]
tests/test_field_wrapper.py::test_optional_patterned_string_roundtrip[postgres] SKIPPED [ 55%]
tests/test_field_wrapper.py::test_annotated_and_wrapped_ferro_field_conflict_raises PASSED [ 55%]
tests/test_helpers.py::test_create_helper[sqlite] PASSED [ 55%]
tests/test_helpers.py::test_create_helper[postgres] SKIPPED (pytest-...) [ 56%]
tests/test_helpers.py::test_exists_helper[sqlite] PASSED [ 56%]
tests/test_helpers.py::test_exists_helper[postgres] SKIPPED (pytest-...) [ 56%]
tests/test_helpers.py::test_bulk_create_helper[sqlite] PASSED [ 56%]
tests/test_helpers.py::test_bulk_create_helper[postgres] SKIPPED (py...) [ 57%]
tests/test_helpers.py::test_get_or_create[sqlite] PASSED [ 57%]
tests/test_helpers.py::test_get_or_create[postgres] SKIPPED (pytest-...) [ 57%]
tests/test_helpers.py::test_update_or_create[sqlite] PASSED [ 57%]
tests/test_helpers.py::test_update_or_create[postgres] SKIPPED (pyte...) [ 57%]
tests/test_hydration.py::test_direct_injection_bypasses_init[sqlite] PASSED [ 58%]
tests/test_hydration.py::test_direct_injection_bypasses_init[postgres] SKIPPED [ 58%]
tests/test_hydration.py::test_hydrated_row_initializes_pydantic_slots[sqlite] PASSED [ 58%]
tests/test_hydration.py::test_hydrated_row_initializes_pydantic_slots[postgres] SKIPPED [ 58%]
tests/test_hydration.py::test_hydrated_extra_allow_starts_with_empty_extra_dict[sqlite] PASSED [ 59%]
tests/test_hydration.py::test_hydrated_extra_allow_starts_with_empty_extra_dict[postgres] SKIPPED [ 59%]
tests/test_metadata.py::test_autoincrement_id_retrieval[sqlite] PASSED [ 59%]
tests/test_metadata.py::test_autoincrement_id_retrieval[postgres] SKIPPED [ 59%]
tests/test_metadata.py::test_manual_id_no_autoincrement[sqlite] PASSED [ 60%]
tests/test_metadata.py::test_manual_id_no_autoincrement[postgres] SKIPPED [ 60%]
tests/test_metadata.py::test_string_primary_key[sqlite] PASSED [ 60%]
tests/test_metadata.py::test_string_primary_key[postgres] SKIPPED (p...) [ 60%]
tests/test_named_connections_integration.py::test_named_connection_registration_and_transaction_inheritance[sqlite] PASSED [ 60%]
tests/test_named_connections_integration.py::test_named_connection_registration_and_transaction_inheritance[postgres] SKIPPED [ 61%]
tests/test_one_to_one.py::test_one_to_one_relationship[sqlite] PASSED [ 61%]
tests/test_one_to_one.py::test_one_to_one_relationship[postgres] SKIPPED [ 61%]
tests/test_one_to_one.py::test_one_to_one_unique_index_in_sqlite[sqlite] PASSED [ 61%]
tests/test_one_to_one.py::test_one_to_one_unique_index_in_postgres[postgres] SKIPPED [ 62%]
tests/test_query_builder.py::test_serialize_query_value_normalizes_non_json_native_values PASSED [ 62%]
tests/test_query_builder.py::test_query_def_to_json_serializes_m2m_context_without_mutating_query_state PASSED [ 62%]
tests/test_query_builder.py::test_query_node_to_dict_serializes_uuid_values_inside_in_filters PASSED [ 62%]
tests/test_query_builder.py::test_field_proxy_operator_overloading PASSED [ 62%]
tests/test_query_builder.py::test_model_where_clause PASSED [ 63%]
tests/test_query_builder.py::test_query_chaining_placeholders PASSED [ 63%]
tests/test_query_builder.py::test_in_operator_lshift PASSED [ 63%]
tests/test_query_builder.py::test_query_execution[sqlite] PASSED [ 63%]
tests/test_query_builder.py::test_query_execution[postgres] SKIPPED [ 64%]
tests/test_query_builder.py::test_query_first[sqlite] PASSED [ 64%]
tests/test_query_builder.py::test_query_first[postgres] SKIPPED (pyt...) [ 64%]
tests/test_query_builder.py::test_sql_injection_protection[sqlite] PASSED [ 64%]
tests/test_query_builder.py::test_sql_injection_protection[postgres] SKIPPED [ 64%]
tests/test_query_builder.py::test_query_bitwise_logic[sqlite] PASSED [ 65%]
tests/test_query_builder.py::test_query_bitwise_logic[postgres] SKIPPED [ 65%]
tests/test_query_builder.py::test_query_bitwise_multiple_where[sqlite] PASSED [ 65%]
tests/test_query_builder.py::test_query_bitwise_multiple_where[postgres] SKIPPED [ 65%]
tests/test_raw_sql.py::test_raw_execute_ffi_smoke[sqlite] PASSED [ 66%]
tests/test_raw_sql.py::test_raw_execute_ffi_smoke[postgres] SKIPPED [ 66%]
tests/test_raw_sql.py::test_top_level_execute_outside_tx_creates_table[sqlite] PASSED [ 66%]
tests/test_raw_sql.py::test_top_level_execute_outside_tx_creates_table[postgres] SKIPPED [ 66%]
tests/test_raw_sql.py::test_top_level_execute_returns_rows_affected[sqlite] PASSED [ 66%]
tests/test_raw_sql.py::test_top_level_execute_returns_rows_affected[postgres] SKIPPED [ 67%]
tests/test_raw_sql.py::test_top_level_execute_binds_scalars[sqlite] PASSED [ 67%]
tests/test_raw_sql.py::test_top_level_execute_binds_scalars[postgres] SKIPPED [ 67%]
tests/test_raw_sql.py::test_empty_sql_raises_valueerror[sqlite] PASSED [ 67%]
tests/test_raw_sql.py::test_empty_sql_raises_valueerror[postgres] SKIPPED [ 68%]
tests/test_raw_sql.py::test_unsupported_bind_type_raises_typeerror[sqlite] PASSED [ 68%]
tests/test_raw_sql.py::test_unsupported_bind_type_raises_typeerror[postgres] SKIPPED [ 68%]
tests/test_raw_sql.py::test_top_level_execute_picks_up_active_tx_commit[sqlite] PASSED [ 68%]
tests/test_raw_sql.py::test_top_level_execute_picks_up_active_tx_commit[postgres] SKIPPED [ 68%]
tests/test_raw_sql.py::test_top_level_execute_rolls_back_on_exception[sqlite] PASSED [ 69%]
tests/test_raw_sql.py::test_top_level_execute_rolls_back_on_exception[postgres] SKIPPED [ 69%]
tests/test_raw_sql.py::test_tx_execute_runs_on_tx_connection[sqlite] PASSED [ 69%]
tests/test_raw_sql.py::test_tx_execute_runs_on_tx_connection[postgres] SKIPPED [ 69%]
tests/test_raw_sql.py::test_tx_handle_after_exit_raises[sqlite] PASSED [ 70%]
tests/test_raw_sql.py::test_tx_handle_after_exit_raises[postgres] SKIPPED [ 70%]
tests/test_raw_sql.py::test_transaction_yields_transaction_handle[sqlite] PASSED [ 70%]
tests/test_raw_sql.py::test_transaction_yields_transaction_handle[postgres] SKIPPED [ 70%]
tests/test_raw_sql.py::test_transaction_without_as_clause_still_works[sqlite] PASSED [ 71%]
tests/test_raw_sql.py::test_transaction_without_as_clause_still_works[postgres] SKIPPED [ 71%]
tests/test_raw_sql.py::test_fetch_all_returns_list_of_dicts[sqlite] PASSED [ 71%]
tests/test_raw_sql.py::test_fetch_all_returns_list_of_dicts[postgres] SKIPPED [ 71%]
tests/test_raw_sql.py::test_fetch_one_returns_none_when_empty[sqlite] PASSED [ 71%]
tests/test_raw_sql.py::test_fetch_one_returns_none_when_empty[postgres] SKIPPED [ 72%]
tests/test_raw_sql.py::test_fetch_one_returns_first_row_when_multiple[sqlite] PASSED [ 72%]
tests/test_raw_sql.py::test_fetch_one_returns_first_row_when_multiple[postgres] SKIPPED [ 72%]
tests/test_raw_sql.py::test_fetch_inside_tx_sees_uncommitted_writes[sqlite] PASSED [ 72%]
tests/test_raw_sql.py::test_fetch_inside_tx_sees_uncommitted_writes[postgres] SKIPPED [ 73%]
tests/test_raw_sql.py::test_marshal_uuid[sqlite] PASSED [ 73%]
tests/test_raw_sql.py::test_marshal_uuid[postgres] SKIPPED (pytest-p...) [ 73%]
tests/test_raw_sql.py::test_marshal_datetime[sqlite] PASSED [ 73%]
tests/test_raw_sql.py::test_marshal_datetime[postgres] SKIPPED (pyte...) [ 73%]
tests/test_raw_sql.py::test_marshal_date[sqlite] PASSED [ 74%]
tests/test_raw_sql.py::test_marshal_date[postgres] SKIPPED (pytest-p...) [ 74%]
tests/test_raw_sql.py::test_marshal_time[sqlite] PASSED [ 74%]
tests/test_raw_sql.py::test_marshal_time[postgres] SKIPPED (pytest-p...) [ 74%]
tests/test_raw_sql.py::test_marshal_decimal[sqlite] PASSED [ 75%]
tests/test_raw_sql.py::test_marshal_decimal[postgres] SKIPPED (pytes...) [ 75%]
tests/test_raw_sql.py::test_marshal_enum_str[sqlite] PASSED [ 75%]
tests/test_raw_sql.py::test_marshal_enum_str[postgres] SKIPPED (pyte...) [ 75%]
tests/test_raw_sql.py::test_marshal_enum_int[sqlite] PASSED [ 75%]
tests/test_raw_sql.py::test_marshal_enum_int[postgres] SKIPPED (pyte...) [ 76%]
tests/test_raw_sql.py::test_marshal_dict_to_jsonb[postgres] SKIPPED [ 76%]
tests/test_raw_sql.py::test_marshal_bool_before_int_order[sqlite] PASSED [ 76%]
tests/test_raw_sql.py::test_marshal_bool_before_int_order[postgres] SKIPPED [ 76%]
tests/test_raw_sql.py::test_invalid_sql_raises_runtimeerror_with_db_message[sqlite] PASSED [ 77%]
tests/test_raw_sql.py::test_invalid_sql_raises_runtimeerror_with_db_message[postgres] SKIPPED [ 77%]
tests/test_raw_sql.py::test_savepoint_rollback_preserves_outer_writes[sqlite] PASSED [ 77%]
tests/test_raw_sql.py::test_savepoint_rollback_preserves_outer_writes[postgres] SKIPPED [ 77%]
tests/test_raw_sql.py::test_set_config_then_current_setting_inside_tx[postgres] SKIPPED [ 77%]
tests/test_refresh.py::test_instance_refresh[sqlite] PASSED [ 78%]
tests/test_refresh.py::test_instance_refresh[postgres] SKIPPED (pyte...) [ 78%]
tests/test_refresh.py::test_refresh_not_found[sqlite] PASSED [ 78%]
tests/test_refresh.py::test_refresh_not_found[postgres] SKIPPED (pyt...) [ 78%]
tests/test_schema.py::test_create_tables_success[sqlite] PASSED [ 79%]
tests/test_schema.py::test_create_tables_success[postgres] SKIPPED (...) [ 79%]
tests/test_schema.py::test_create_tables_no_connection PASSED [ 79%]
tests/test_schema.py::test_auto_migrate_runtime_ddl_infers_required_field_not_null[sqlite] PASSED [ 79%]
tests/test_schema.py::test_auto_migrate_runtime_ddl_preserves_ref_field_nullability[sqlite] PASSED [ 80%]
tests/test_schema.py::test_auto_migrate_runtime_ddl_uses_logical_decimal_and_json_types[sqlite] PASSED [ 80%]
tests/test_schema_constraints.py::test_runtime_create_tables_respects_explicit_nullable_override[sqlite] PASSED [ 80%]
tests/test_schema_constraints.py::test_foreign_key_constraint_exists[sqlite] PASSED [ 80%]
tests/test_schema_constraints.py::test_foreign_key_constraint_exists_in_postgres[postgres] SKIPPED [ 80%]
tests/test_schema_constraints.py::test_foreign_key_index_runtime_ddl_parity[sqlite] PASSED [ 81%]
tests/test_schema_constraints.py::test_foreign_key_index_runtime_ddl_parity_postgres[postgres] SKIPPED [ 81%]
tests/test_shadow_fk_types.py::test_pk_python_type_for_model_uuid PASSED [ 81%]
tests/test_shadow_fk_types.py::test_shadow_annotation_for_pk_wraps_required_uuid PASSED [ 81%]
tests/test_shadow_fk_types.py::test_is_fallback_shadow_annotation PASSED [ 82%]
tests/test_shadow_fk_types.py::test_shadow_annotation_for_foreign_key_concrete PASSED [ 82%]
tests/test_shadow_fk_types.py::test_shadow_annotation_for_foreign_key_unresolved_string PASSED [ 82%]
tests/test_shadow_fk_types.py::test_reconcile_upgrades_forward_ref_shadow PASSED [ 82%]
tests/test_shadow_fk_types.py::test_uuid_fk_create_get_dump[sqlite] PASSED [ 82%]
tests/test_shadow_fk_types.py::test_uuid_fk_create_get_dump[postgres] SKIPPED [ 83%]
tests/test_shadow_fk_types.py::test_uuid_fk_forward_ref_child_declared_first[sqlite] PASSED [ 83%]
tests/test_shadow_fk_types.py::test_uuid_fk_forward_ref_child_declared_first[postgres] SKIPPED [ 83%]
tests/test_shadow_fk_types.py::test_uuid_child_model_validate_accepts_string_parent_id PASSED [ 83%]
tests/test_shadow_fk_types.py::test_nullable_fk_annotation_does_not_crash PASSED [ 84%]
tests/test_shadow_fk_types.py::test_uuid_fk_save_after_reparenting[sqlite] PASSED [ 84%]
tests/test_shadow_fk_types.py::test_uuid_fk_save_after_reparenting[postgres] SKIPPED [ 84%]
tests/test_shadow_fk_types.py::test_uuid_fk_bulk_create[sqlite] PASSED [ 84%]
tests/test_shadow_fk_types.py::test_uuid_fk_bulk_create[postgres] SKIPPED [ 84%]
tests/test_shadow_reports.py::test_shadow_report_fixture_stable[sqlite] PASSED [ 85%]
tests/test_shadow_reports.py::test_shadow_report_fixture_stable[postgres] SKIPPED [ 85%]
tests/test_shadow_reports.py::test_shadow_runtime_strict_has_no_mismatch[sqlite] PASSED [ 85%]
tests/test_shadow_reports.py::test_shadow_runtime_strict_has_no_mismatch[postgres] SKIPPED [ 85%]
tests/test_string_search.py::test_like_search[sqlite] PASSED [ 86%]
tests/test_string_search.py::test_like_search[postgres] SKIPPED (pyt...) [ 86%]
tests/test_string_search.py::test_in_helper[sqlite] PASSED [ 86%]
tests/test_string_search.py::test_in_helper[postgres] SKIPPED (pytes...) [ 86%]
tests/test_structural_types.py::test_structural_types_roundtrip[sqlite] PASSED [ 86%]
tests/test_structural_types.py::test_structural_types_roundtrip[postgres] SKIPPED [ 87%]
tests/test_structural_types.py::test_json_column_list_of_nested_pydantic_models_roundtrip[sqlite] PASSED [ 87%]
tests/test_structural_types.py::test_json_column_list_of_nested_pydantic_models_roundtrip[postgres] SKIPPED [ 87%]
tests/test_structural_types.py::test_structural_filtering[sqlite] PASSED [ 87%]
tests/test_structural_types.py::test_structural_filtering[postgres] SKIPPED [ 88%]
tests/test_structural_types.py::test_uuid_in_filter_serializes_collection_values[sqlite] PASSED [ 88%]
tests/test_structural_types.py::test_uuid_in_filter_serializes_collection_values[postgres] SKIPPED [ 88%]
tests/test_structural_types.py::test_uuid_filter_serializes_for_update_and_delete_queries[sqlite] PASSED [ 88%]
tests/test_structural_types.py::test_uuid_filter_serializes_for_update_and_delete_queries[postgres] SKIPPED [ 88%]
tests/test_structural_types.py::test_postgres_json_and_decimal_updates_keep_typed_hydration[postgres] SKIPPED [ 89%]
tests/test_structural_types.py::test_native_postgres_enum_column_decodes_via_text_cast[postgres] SKIPPED [ 89%]
tests/test_structural_types.py::test_native_postgres_enum_where_lambda_count[postgres] SKIPPED [ 89%]
tests/test_structural_types.py::test_native_postgres_enum_plain_str_column[postgres] SKIPPED [ 89%]
tests/test_structural_types.py::test_native_uuid_null_inserts[postgres] SKIPPED [ 90%]
tests/test_structural_types.py::test_native_timestamp_without_time_zone_null_and_value[postgres] SKIPPED [ 90%]
tests/test_temporal_types.py::test_temporal_types_roundtrip[sqlite] PASSED [ 90%]
tests/test_temporal_types.py::test_temporal_types_roundtrip[postgres] SKIPPED [ 90%]
tests/test_temporal_types.py::test_temporal_filtering[sqlite] PASSED [ 91%]
tests/test_temporal_types.py::test_temporal_filtering[postgres] SKIPPED [ 91%]
tests/test_transactions.py::test_transaction_using_routes_unqualified_raw_sql PASSED [ 91%]
tests/test_transactions.py::test_relationships_loaded_inside_transaction_inherit_transaction[sqlite] PASSED [ 91%]
tests/test_transactions.py::test_relationships_loaded_inside_transaction_inherit_transaction[postgres] SKIPPED [ 91%]
tests/test_transactions.py::test_instance_methods_loaded_inside_transaction_inherit_transaction[sqlite] PASSED [ 92%]
tests/test_transactions.py::test_instance_methods_loaded_inside_transaction_inherit_transaction[postgres] SKIPPED [ 92%]
tests/test_transactions.py::test_instance_methods_loaded_inside_named_transaction_keep_identity_scope PASSED [ 92%]
tests/test_transactions.py::test_matching_explicit_using_inside_named_transaction_is_allowed PASSED [ 92%]
tests/test_transactions.py::test_transaction_commit[sqlite] PASSED [ 93%]
tests/test_transactions.py::test_transaction_commit[postgres] SKIPPED [ 93%]
tests/test_transactions.py::test_transaction_rollback[sqlite] PASSED [ 93%]
tests/test_transactions.py::test_transaction_rollback[postgres] SKIPPED [ 93%]
tests/test_transactions.py::test_transaction_atomicity[sqlite] PASSED [ 93%]
tests/test_transactions.py::test_transaction_atomicity[postgres] SKIPPED [ 94%]
tests/test_transactions.py::test_nested_transaction_rolls_back_with_outer[sqlite] PASSED [ 94%]
tests/test_transactions.py::test_nested_transaction_rolls_back_with_outer[postgres] SKIPPED [ 94%]
tests/test_transactions.py::test_bulk_create_participates_in_transaction[sqlite] PASSED [ 94%]
tests/test_transactions.py::test_bulk_create_participates_in_transaction[postgres] SKIPPED [ 95%]
tests/test_transactions.py::test_nested_transaction_inner_rollback_allows_outer_commit[sqlite] PASSED [ 95%]
tests/test_transactions.py::test_nested_transaction_inner_rollback_allows_outer_commit[postgres] SKIPPED [ 95%]
tests/test_typed_null_binds.py::test_insert_with_none_for_each_nullable_primitive[sqlite] PASSED [ 95%]
tests/test_typed_null_binds.py::test_insert_with_none_for_each_nullable_primitive[postgres] SKIPPED [ 95%]
tests/test_typed_null_binds.py::test_insert_with_value_round_trips_for_each_type[sqlite] PASSED [ 96%]
tests/test_typed_null_binds.py::test_insert_with_value_round_trips_for_each_type[postgres] SKIPPED [ 96%]
tests/test_typed_null_binds.py::test_insert_with_none_for_uuid[sqlite] PASSED [ 96%]
tests/test_typed_null_binds.py::test_insert_with_none_for_uuid[postgres] SKIPPED [ 96%]
tests/test_typed_null_binds.py::test_uuid_pk_round_trips_through_bind_layer[postgres] SKIPPED [ 97%]
tests/test_typed_null_binds.py::test_uuid_pk_filter_by_string_does_not_send_text[postgres] SKIPPED [ 97%]
tests/test_typed_null_binds.py::test_insert_with_none_for_decimal[sqlite] PASSED [ 97%]
tests/test_typed_null_binds.py::test_insert_with_none_for_decimal[postgres] SKIPPED [ 97%]
tests/test_typed_null_binds.py::test_issue_38_exact_regression[postgres] SKIPPED [ 97%]
tests/test_typed_null_binds.py::test_update_to_none_succeeds_on_postgres[postgres] SKIPPED [ 98%]
tests/test_typed_null_binds.py::test_update_to_none_executes_without_error[sqlite] PASSED [ 98%]
tests/test_typed_null_binds.py::test_update_to_none_executes_without_error[postgres] SKIPPED [ 98%]
tests/test_typed_null_binds.py::test_filter_by_none_does_not_reproduce_38[sqlite] PASSED [ 98%]
tests/test_typed_null_binds.py::test_filter_by_none_does_not_reproduce_38[postgres] SKIPPED [ 99%]
tests/test_typed_null_binds.py::test_lambda_predicate_null_filter_datetime_and_json[sqlite] PASSED [ 99%]
tests/test_typed_null_binds.py::test_lambda_predicate_null_filter_datetime_and_json[postgres] SKIPPED [ 99%]
tests/test_typed_null_binds.py::test_invalid_uuid_raises_pyvalueerror_or_pydantic_error[sqlite] PASSED [ 99%]
tests/test_typed_null_binds.py::test_invalid_uuid_raises_pyvalueerror_or_pydantic_error[postgres] SKIPPED [100%]

=============================== warnings summary ===============================
tests/test_documentation_features.py::test_query_exists[sqlite]
/Users/taylor/github/syn54x/ferro-orm/.venv/lib/python3.14/site-packages/pydantic/json_schema.py:565: ResourceWarning: unclosed database in <sqlite3.Connection object at 0x10d9e3970>
current_handler = _schema_generation_shared.GenerateJsonSchemaHandler(self, new_handler_func)
Enable tracemalloc to get traceback where the object was allocated.
See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info.

-- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html
================================ tests coverage ================================
_______________ coverage: platform darwin, python 3.14.5-final-0 _______________

Name Stmts Miss Cover

src/ferro/init.py 33 0 100%
src/ferro/_annotation_utils.py 108 28 74%
src/ferro/_shadow_fk_types.py 121 22 82%
src/ferro/base.py 58 9 84%
src/ferro/composite_indexes.py 69 1 99%
src/ferro/composite_uniques.py 52 5 90%
src/ferro/exceptions.py 6 0 100%
src/ferro/fields.py 58 4 93%
src/ferro/ir/init.py 2 0 100%
src/ferro/ir/compiler.py 171 18 89%
src/ferro/metaclass.py 288 46 84%
src/ferro/migrations/init.py 2 0 100%
src/ferro/migrations/alembic.py 211 70 67%
src/ferro/models.py 279 19 93%
src/ferro/query/init.py 3 0 100%
src/ferro/query/builder.py 132 14 89%
src/ferro/query/nodes.py 75 9 88%
src/ferro/raw.py 73 7 90%
src/ferro/relations/init.py 48 4 92%
src/ferro/relations/descriptors.py 67 4 94%
src/ferro/schema_metadata.py 109 11 90%
src/ferro/state.py 11 0 100%

TOTAL 1976 271 86%
========= 255 passed, 190 skipped, 353 deselected, 1 warning in 3.30s ==========\n-
running 120 tests
test backend::tests::classifies_postgres_urls ... ok
test backend::tests::classifies_sqlite_urls ... ok
test backend::tests::engine_bind_value_carries_null_kind ... ok
test backend::tests::engine_bind_value_null_debug_output_includes_kind ... ok
test backend::tests::engine_value_converts_integer_like_values_to_i64 ... ok
test backend::tests::null_kind_equality_is_reflexive ... ok
test backend::tests::null_kind_variants_are_distinct ... ok
test backend::tests::rejects_unsupported_schemes ... ok
test backend::tests::engine_handle_preserves_typed_sqlite_pool ... ok
test backend::tests::refresh_pool_fails_loudly_for_externally_built_pools ... ok
test connection::tests::connect_engine_handle_supports_sqlite_runtime_execution ... ok
test backend::tests::engine_handle_preserves_typed_postgres_pool ... ok
test connection::tests::connect_engine_handle_uses_typed_sqlite_backend ... ok
test migrate::tests::add_column_reuses_create_table_type_spelling ... ok
test migrate::tests::adds_missing_nullable_column_on_both_backends ... ok
test introspect::tests::live_table_columns_returns_none_for_missing_table ... ok
test backend::tests::engine_handle_execute_result_includes_sqlite_last_insert_id ... ok
test migrate::tests::fk_shadow_column_add_handles_backend_capabilities ... ok
test migrate::tests::ladder_implies_updates_from_destructive ... ok
test migrate::tests::indexed_column_add_emits_index_sql ... ok
test migrate::tests::missing_not_null_column_with_literal_default_backfills ... ok
test backend::tests::engine_handle_rolls_back_sqlite_transaction_connection ... ok
test migrate::tests::no_updates_flag_produces_empty_plan ... ok
test backend::tests::engine_handle_executes_sqlite_sql_with_bound_values ... ok
test migrate::tests::pg_enum_udt_columns_are_never_type_reconciled ... ok
test backend::tests::engine_handle_commits_sqlite_transaction_connection ... ok
test migrate::tests::pg_nullability_mismatch_emits_set_and_drop_not_null ... ok
test migrate::tests::pg_type_mismatch_emits_alter_with_using_cast ... ok
test migrate::tests::sqlite_nullability_drift_warns ... ok
test migrate::tests::render_helper_outputs_drop_statements ... ok
test migrate::tests::sqlite_type_classes_group_storage_equivalent_spellings ... ok
test operations::engine_bind_tests::falls_back_to_untyped_for_unmapped_variant ... ok
test migrate::tests::sqlite_type_drift_warns_only_on_storage_class_change ... ok
test migrate::tests::unique_column_add_strips_inline_unique_on_sqlite ... ok
test operations::engine_bind_tests::maps_typed_none_to_matching_null_kind ... ok
test operations::engine_bind_tests::maps_typed_uuid_some_to_engine_uuid ... ok
test backend::tests::engine_handle_fetches_sqlite_rows_with_bound_values ... ok
test operations::engine_bind_tests::sea_query_preserves_typed_none_through_build ... ok
test operations::engine_value_to_rust_value_tests::bool_column_maps_integer_and_bool ... ok
test operations::engine_value_to_rust_value_tests::binary_column_maps_bytes_and_text ... ok
test backend::tests::refresh_pool_preserves_in_memory_database ... ok
test operations::engine_value_to_rust_value_tests::datetime_column_only_accepts_string_engine_values ... ok
test operations::engine_value_to_rust_value_tests::decimal_column_maps_real_and_text ... ok
test operations::engine_value_to_rust_value_tests::decimal_column_maps_sqlite_integer_affinity_to_decimal ... ok
test operations::engine_value_to_rust_value_tests::json_column_parses_string_payload ... ok
test operations::m2m_value_tests::backend_column_value_expr_emits_typed_uuid_on_postgres_no_cast ... ok
test backend::tests::engine_handle_fetches_sqlite_non_null_zero_integer ... ok
test operations::m2m_value_tests::backend_column_value_expr_falls_back_to_text_cast_on_unparseable_uuid ... ok
test operations::m2m_value_tests::backend_column_value_expr_passthrough_for_non_uuid_column ... ok
test operations::m2m_value_tests::backend_column_value_expr_passthrough_on_sqlite ... ok
test backend::tests::engine_handle_executes_sqlite_sql_without_legacy_pool ... ok
test introspect::tests::live_table_columns_reads_sqlite_structure ... ok
test backend::tests::engine_handle_fetches_sqlite_null_columns_as_null_not_zero ... ok
test introspect::tests::sqlite_indexes_covering_column_distinguishes_origin ... ok
test backend::tests::refresh_pool_survives_alter_table_on_file_backed_sqlite ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_bool_column ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_bytes_column ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_decimal_column ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_float_column ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_int_column ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_str_column ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_uuid_column_via_format ... ok
test operations::schema_value_expr_tests::emits_typed_null_for_uuid_column_via_introspection_set ... ok
test operations::schema_value_expr_tests::emits_typed_uuid_value_via_format ... ok
test operations::raw_sql_tests::extracts_string ... ok
test operations::raw_sql_tests::extracts_true_as_bool_not_int ... ok
test operations::raw_sql_tests::extracts_bytes ... ok
test operations::raw_sql_tests::extracts_false_as_bool_not_int ... ok
test operations::schema_value_expr_tests::rejects_invalid_uuid_with_pyvalueerror ... ok
test operations::raw_sql_tests::extracts_none_as_null ... ok
test operations::schema_value_expr_tests::sqlite_uuid_passthrough_unchanged ... ok
test operations::raw_sql_tests::extracts_float ... ok
test operations::schema_value_expr_tests::temporal_null_keeps_cast_for_now ... ok
test operations::m2m_value_tests::python_to_sea_value_routes_bool_before_int ... ok
test query::tests::binary_rhs_emits_typed_bytes_no_cast ... ok
test query::tests::decimal_rhs_keeps_numeric_cast_for_now ... ok
test operations::raw_sql_tests::rejects_unsupported_type ... ok
test query::tests::enum_rhs_emits_cast_to_schema_enum_type_on_postgres ... ok
test operations::raw_sql_tests::extracts_int ... ok
test query::tests::enum_rhs_skips_cast_without_native_enum_column ... ok
test operations::m2m_value_tests::python_to_sea_value_rejects_none ... ok
test query::tests::json_null_deserializes_to_option_none_for_query_node_value ... ok
test query::tests::null_rhs_emits_typed_bool_null_for_bool_column ... ok
test migrate::tests::missing_primary_key_column_fails_loudly ... ok
test query::tests::null_rhs_emits_typed_int_null_for_int_column ... ok
test migrate::tests::missing_not_null_column_without_default_fails_loudly ... ok
test migrate::tests::destructive_collects_removed_columns_and_protects_pk ... ok
test query::tests::null_rhs_emits_typed_uuid_null_for_uuid_column ... ok
test query::tests::uuid_rhs_emits_typed_uuid_bind_on_postgres_no_cast ... ok
test query::tests::query_ir_roundtrip_preserves_semantics_signature ... ok
test query::tests::uuid_rhs_passes_through_as_text_on_sqlite ... ok
test query::tests::where_rhs_none_emits_is_not_null_for_ne_sqlite ... ok
test query::tests::where_rhs_none_emits_is_null_for_eq_sqlite ... ok
test schema::tests::test_append_composite_index_sqls_no_groups_is_noop ... ok
test schema::tests::test_append_composite_index_sqls_emits_non_unique ... ok
test schema::tests::test_append_composite_index_sqls_preserves_column_order ... ok
test schema::tests::test_composite_index_name_at_63_chars ... ok
test schema::tests::test_composite_index_and_unique_can_share_table ... ok
test schema::tests::test_composite_index_name_short ... ok
test schema::tests::test_composite_index_name_truncation_above_63 ... ok
test schema::tests::test_composite_index_name_unicode_safe ... ok
test schema::tests::test_db_check_constraint_name_short ... ok
test schema::tests::test_db_check_constraint_name_truncates_above_63 ... ok
test schema::tests::test_db_check_off_emits_no_constraint ... ok
test schema::tests::test_db_check_emits_named_constraint ... ok
test schema::tests::test_db_check_skipped_on_sqlite ... ok
test schema::tests::test_db_check_with_int_values_unquoted ... ok
test schema::tests::test_db_type_bigint_postgres_emits_bigint ... ok
test schema::tests::test_db_type_bigint_sqlite_emits_bigint_keyword ... ok
test schema::tests::test_db_type_overrides_json_format_branch ... ok
test schema::tests::test_db_type_smallint_postgres_emits_smallint ... ok
test schema::tests::test_db_type_smallint_sqlite_emits_smallint_keyword ... ok
test schema::tests::test_db_type_timestamp_emits_plain_timestamp ... ok
test schema::tests::test_db_type_text_emits_text_column ... ok
test schema::tests::test_db_type_unknown_token_maps_to_none ... ok
test schema::tests::test_db_type_timestamptz_emits_with_time_zone ... ok
test schema::tests::test_db_type_varchar_n_emits_varchar_with_length ... ok
test schema::tests::test_parse_varchar_token_rejects_zero_and_garbage ... ok
test schema::tests::test_unknown_db_type_token_falls_back_to_json_cascade ... ok
test schema::tests::test_foreign_key_column_with_index_flag_emits_create_index ... ok

test result: ok. 120 passed; 0 failed; 0 ignored; 0 measured; 0 filtered out; finished in 0.01s\n\nRoadmap reference maintained: docs/plans/2026-06-19-001-ir-first-roadmap.md (Phase 2).

[0x054]

Superseding prior comment with shell-safe formatting.

Phase 2 status update: branch implementation is complete for #81/#82/#83 on feat/ir-p2-shadow-dual-run (commit ae60662).

Exit-gate evidence (current branch):

• Shadow planner internal flag + dual-run compare hooks: src/backend.rs, src/connection.rs, src/operations.rs, src/query.rs, src/schema.rs, src/migrate.rs.
• Semantic diff/test harness: _shadow_compare_query_plan_for_test + tests/test_shadow_reports.py.
• Stable backend reports + CI touched-path gate: tests/fixtures/shadow_reports/*, .github/workflows/ci.yml.
• Migration/docs synchronization: docs/plans/ir-first-migration-guide.md, docs/plans/2026-06-19-001-ir-first-roadmap.md.

Validation run:

• uv run pytest -v -m "backend_matrix or postgres_only" --db-backends=sqlite,postgres
• cargo test --no-default-features --features testing

Roadmap reference maintained: docs/plans/2026-06-19-001-ir-first-roadmap.md (Phase 2).

[0x054]

Phase 2 epic completed by #105 with #81/#82/#83 closed and roadmap synchronized.