supabase / wrappers / 26933770501

81%

push

github

feat(mongodb): [WRA-22] add MongoDB foreign data wrapper (#606)

* feat(mongodb_fdw): add cargo feature and dependencies

* ci(mongodb_fdw): add mongo:7 service to native docker-compose

* feat(mongodb_fdw): scaffold module, error type, README

* feat(mongodb_fdw): implement BSON to Cell type mapping

* feat(mongodb_fdw): implement Cell to BSON write-path mapping

* feat(mongodb_fdw): qual/sort/limit/projection deparse helpers

* feat(mongodb_fdw): implement begin_scan, iter_scan, re_scan

* test(mongodb_fdw): smoketest covering count, lookup, missing field

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

* test(mongodb_fdw): pushdown operators, sort, limit

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

* test(mongodb_fdw): _doc jsonb column reads full document

* feat(mongodb_fdw): implement begin_modify, insert

Add write-path support: begin_modify captures the target database/collection
and rowid_column from table options; insert builds a BSON Document from the
Row (skipping _doc and null fields) and calls insert_one; end_modify clears
the modify target. Includes a pg_test that seeds a collection, inserts a new
document via SQL INSERT, and verifies it is readable.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

* feat(mongodb_fdw): implement update and delete

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

* test(mongodb_fdw): ObjectId hex round-trip on read and qual

* docs(mongodb_fdw): add catalog page

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

* chore(mongodb_fdw): cargo fmt

* fix(mongodb_fdw): use per-test collection names to avoid parallel-test races

* fix(docker-compose): rename mongo service to mongodb for consistency

* test(mongodb_fdw): add comprehensive type conversion tests

Add mongodb_types_read and mongodb_types_write pg_tests covering all
bson_to_cell and cell_to_bson conversion paths: int2/4/8, float4/8,
numeric (Decimal128/Double/Int64), text, ObjectId,... (continued)

355 of 441 new or added lines in 2 files covered. (80.5%)

9469 of 11692 relevant lines covered (80.99%)

70.22 hits per line