cybertec-postgresql / pgwatch / 20718256627

75%

push

github

[!] add schema migration support for PostgreSQL sinks, closes #1110 (#1111)

- Add `admin.migration` table and migration infrastructure to sink
- Implement `Migrate()` and `NeedsMigration()` for `PostgresWriter` and
`MultiWriter`
- Add migration checks during sink initialization with error messages
- Extend `config init/upgrade` commands to support sink migrations
- `NewWriterFromPostgresConn` now returns nil writer on errors
- Add comprehensive test coverage for migration happy/unhappy paths
- Update docs to document sink database migration support

Migration pattern follows existing metrics database approach, ensuring
both config and sink databases can be upgraded independently using the
same `pgwatch config upgrade` command.

99 of 124 new or added lines in 5 files covered. (79.84%)

3971 of 5325 relevant lines covered (74.57%)

0.85 hits per line