cybertec-postgresql / pgwatch / 19360779365

74%

push

github

[*] fix maintenance task to delete entries of dropped tables (#1020)

* introduce `--maintenance-interval` flag

* modify `--retention` to accept PostgreSQL interval string.

* Use new flags to control deletion and maintenance tasks.

* Test `MaintainUniqueSources()` and `DeleteOldPartitions()`

* update docs reference page to mention new flag.

* run `DeleteOldPartitions()` with `retentionInterval` not `maintenanceInterval`

* Rename test

* Capitalize `set` in flag description.

* Fix typo in comment

* Update maintenance task to remove entries of dropped metric tables from listing table.

* Test removing entries of dropped tables from the listing table.

* Add empty line at end of file

* Ensure there is no error dropping table

* Use `!=` operator instead of `NOT ... = ...`

* Preserve `public.` prefix in `sqlDistinct` query

* substitue `break` with `continue` to avoid breaking
the loop without trimming all elements in `allDistinctMetricTables`

* this is more informative in the logs also.

10 of 13 new or added lines in 1 file covered. (76.92%)

3679 of 4988 relevant lines covered (73.76%)

0.84 hits per line