Feature Request: Show Git repository report

[olblak]

Is your feature request related to a problem?

Udash is now capable of showing pipeline information, but I am interested to show all informations available for a specific git repository. The database already contained a lot of information based on report, so we would need two additionnal endpoints

• /api/scm/reports/ : List all scm repository
• /api/scm/reports/id: List all latest targets for a specific scm repository

Solution you'd like

No response

Alternatives you've considered

No response

Anything else?

I experimentated a bit with with various sql queries such as

Retrieve all targets

SELECT created_at, updated_at, targets -> 'ID', targets FROM
    (SELECT DISTINCT ON ( targets -> 'ID') created_at, updated_at, targets FROM 
       (SELECT created_at, updated_at, jsonb_path_query(data::jsonb, '$.Targets[*].*') as targets FROM pipelineReports) t ORDER BY targets -> 'ID', updated_at DESC) id;

Retrieve target for a specific repository/branch

SELECT j.targets ->> 'ID', j.targets FROM (SELECT jsonb_path_query(data::jsonb, '$.Targets[*].* ? (@.Scm.URL  == "https://github.com/updatecli/updatecli.git" && @.Scm.Branch.Target == "main")')  as targets from pipelineReports group by 1 ) j;

While experimenting with various SQL queries, I realized that once again I am blocked by updatecli/updatecli#1395

I don't have an way to identify a uniq target without pollution like temporary working branch that change over time

Before making progress on this issue in Udash I may have to improve the situation in Updatecli first.
This discussion may provide some interesting hint https://stackoverflow.com/questions/34638717/golang-marshal-unmarshal-json-with-a-custom-tag