Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Feature][PR metrics] Add key timestamps to the project_pr_metrics table #7775

Closed
2 of 8 tasks
Startrekzky opened this issue Jul 23, 2024 · 0 comments · Fixed by #7799 or #7815
Closed
2 of 8 tasks

[Feature][PR metrics] Add key timestamps to the project_pr_metrics table #7775

Startrekzky opened this issue Jul 23, 2024 · 0 comments · Fixed by #7799 or #7815
Assignees
@abeizn
Labels
improvement type/feature-request This issue is a proposal for something new
Milestone
v1.1

Comments

@Startrekzky
Copy link
Contributor

Search before asking

  • I had searched in the issues and found no similar feature requirement.

Use case

I can easily get pr_coding_time, pr_pick_time and other metrics in the project_pr_metrics. However, when I want to:

  • debug these metrics
  • OR customize metrics such as first_comment_time - first_commit_authored_date, or deploy_time - last_comment_date
    it'll be hard for us to do so.

Description

To do:

Add the following timestamp fields to the project_pr_metrics table:

  • first_commit_authored_date
  • pr_created_date (ignore if it already exists)
  • first_comment_date
  • pr_merged_date (ignore if it already exists)
  • pr_deployed_date

Please order the fields in the table according to the PR lifecycle.

Related issues

No response

Are you willing to submit a PR?

  • Yes I am willing to submit a PR!

Code of Conduct
@Startrekzky Startrekzky added the type/feature-request This issue is a proposal for something new label Jul 23, 2024
@Startrekzky Startrekzky changed the title [Feature][PR metrics] Add key timestamp to the project_pr_metrics table [Feature][PR metrics] Add key timestamps to the project_pr_metrics table Jul 23, 2024
@Startrekzky Startrekzky added this to the v1.1 milestone Jul 23, 2024
@dosubot dosubot bot added improvement pr-type/feature-development This PR is to develop a new feature labels Jul 23, 2024
@Startrekzky Startrekzky removed the pr-type/feature-development This PR is to develop a new feature label Jul 24, 2024
@klesh klesh mentioned this issue Jul 31, 2024
Merged
klesh added a commit that referenced this issue Aug 1, 2024
@klesh
chore: adjust fields order for #7775
6eeee49
@klesh klesh mentioned this issue Aug 1, 2024
Merged
Startrekzky pushed a commit that referenced this issue Aug 1, 2024
@klesh
chore: adjust fields order for #7775 (#7815)
982427b
github-actions bot pushed a commit that referenced this issue Aug 1, 2024
@klesh
chore: adjust fields order for #7775 (#7815)
15a8488
@github-actions github-actions bot mentioned this issue Aug 1, 2024
Merged
klesh added a commit that referenced this issue Aug 1, 2024
@github-actions @klesh
chore: adjust fields order for #7775 (#7815) (#7816)
11be777 
Co-authored-by: Klesh Wong <zhenmian.huang@merico.dev>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@abeizn abeizn

Labels
improvement type/feature-request This issue is a proposal for something new
Projects
None yet
Milestone
v1.1
2 participants
@Startrekzky @abeizn