Create DB function to get all checkpoint data of a partitioning

[benedeki]

Background

We need to be able to read saved checkpoint data of a given partitioning.

Feature

Create a DB function that will return all checkpoint and its measurements for the given partitioning.

Proposed Solution

Function signature

CREATE OR REPLACE FUNCTION runs.get_partitioning_checkpoints(
    IN  i_partitioning     JSONB,
    OUT status             INTEGER,
    OUT status_text        TEXT,
    OUT id_checkpoint      UUID,
    OUT checkpoint_name    TEXT,
    OUT measure_name       TEXT,
    OUT measure_columns    TEXT[],
    OUT measurement_value  JSONB,
    OUT checkpoint_time    TIMESTAMP WITH TIME ZONE
) RETURNS SETOF record AS

for output order by checkpoint_time and id_checkpoint

Depends on #178

[benedeki]

This item depends on:

• AbsaOSS/atum-service#178 By Dependent Issues.

[benedeki]

This item depends on:

• AbsaOSS/atum-service#178 By Dependent Issues.