pr_deployed_date field in project_pr_metrics table

[boraer]

Hello everyone,

I have been trying to create the DORA dasboards but they are always empty, I have realized that time_filter is done by pr_deployed_date field in project_pr_metrics table but this field is not documented. How is the pr_deployed_date field is populated?

Thanks

[dosubot[bot]]

Hello @boraer! I'm Dosu, a bot here to help you solve bugs, answer questions, and become a contributor. I'm ready to assist you while we wait for a human maintainer. How can I help you today?

The pr_deployed_date field in the project_pr_metrics table is populated by retrieving deployment information for a pull request and calculating the PR deploy time. Specifically, the pr_deployed_date is set to deployment.FinishedDate if a deployment is found and its FinishedDate is not nil. Here's a snippet of the relevant code:

// Get the deployment for the PR
deployment, err := getDeploymentCommit(pr.MergeCommitSha, data.Options.ProjectName, db)
if err != nil {
    return nil, err
}

// Calculate PR deploy time
if deployment != nil && deployment.FinishedDate != nil {
    projectPrMetric.PrDeployTime = computeTimeSpan(pr.MergedDate, deployment.FinishedDate)
    projectPrMetric.DeploymentCommitId = deployment.Id
    projectPrMetric.PrDeployedDate = deployment.FinishedDate
}

This process involves associating pull requests with deployments, which are collected from various sources like GitHub, GitLab, Jenkins, etc. The calculation of PR deploy time is done by subtracting a PR's merged_date from its deployed_date ^[1][2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}