Combine sweep and device manager records in devices_mv #1755

Merged

mfreeman451 merged 1 commit from refs/pull/1755/head into 849-update-devices_mv-materialized-view-to-include-relationship-metadata

2025-06-19 05:49:12 +00:00

mfreeman451 commented

2025-06-19 05:46:01 +00:00

(Migrated from github.com)

Owner

Imported from GitHub pull request.

Original GitHub pull request: #980
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/pull/980
Original created: 2025-06-19T05:46:01Z
Original updated: 2025-06-19T05:49:16Z
Original head: carverauto/serviceradar:codex/update-devices_mv-to-include-new-devices-table
Original base: 849-update-devices_mv-materialized-view-to-include-relationship-metadata
Original merged: 2025-06-19T05:49:12Z by @mfreeman451

Summary

replace live view with materialized view that aggregates devices and sweep results
add unified_devices versioned KV stream and its MV
drop obsolete live view migration
map SRQL devices entity to unified_devices
fix SRQL translator unit tests

Testing

make test (fails: missing call(s) to mock GetResults)

https://chatgpt.com/codex/tasks/task_e_68538a9f742883208d53955555393b46

Imported from GitHub pull request. Original GitHub pull request: #980 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/pull/980 Original created: 2025-06-19T05:46:01Z Original updated: 2025-06-19T05:49:16Z Original head: carverauto/serviceradar:codex/update-devices_mv-to-include-new-devices-table Original base: 849-update-devices_mv-materialized-view-to-include-relationship-metadata Original merged: 2025-06-19T05:49:12Z by @mfreeman451 --- ## Summary - replace live view with materialized view that aggregates devices and sweep results - add `unified_devices` versioned KV stream and its MV - drop obsolete live view migration - map SRQL `devices` entity to `unified_devices` - fix SRQL translator unit tests ## Testing - `make test` *(fails: missing call(s) to mock GetResults)* ------ https://chatgpt.com/codex/tasks/task_e_68538a9f742883208d53955555393b46

Rows
Columns