You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by gi...@apache.org on 2024/08/02 12:56:49 UTC
(incubator-devlake) 01/01: fix(gitlab): fix issue.url (#7824)
This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch release-v1.0-auto-cherry-pick-7824
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
commit f047540cc1d4a0982963bf9d77932b586948d2ad
Author: Lynwee <15...@qq.com>
AuthorDate: Fri Aug 2 20:56:28 2024 +0800
fix(gitlab): fix issue.url (#7824)
* fix(gitlab): fix issue.url
* fix(gitlab): fix e2e test
* fix(zentao): fix e2e test
---
.../e2e/snapshot_tables/_tool_gitlab_issues.csv | 32 +++++++++++-----------
.../plugins/gitlab/e2e/snapshot_tables/issues.csv | 32 +++++++++++-----------
backend/plugins/gitlab/tasks/issue_extractor.go | 4 +--
backend/plugins/zentao/e2e/account_test.go | 3 +-
backend/plugins/zentao/e2e/bug_test.go | 1 +
.../e2e/snapshot_tables/execution_sprint.csv | 16 +++++------
6 files changed, 45 insertions(+), 43 deletions(-)
diff --git a/backend/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_issues.csv b/backend/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_issues.csv
index f7b5f4b69..24194f1c3 100644
--- a/backend/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_issues.csv
+++ b/backend/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_issues.csv
@@ -1,28 +1,28 @@
connection_id,gitlab_id,project_id,number,state,title,body,priority,type,status,assignee_id,assignee_name,creator_id,creator_name,lead_time_minutes,url,closed_at,gitlab_created_at,gitlab_updated_at,severity,component,time_estimate,total_time_spent,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,22097949,12345678,1,closed,Add documentation to snowflake spend package,,,ISSUE,,2295562,emilie,2295562,emilie,11487,,2019-06-28T14:32:05.376+00:00,2019-06-20T15:04:58.946+00:00,2019-06-28T14:32:05.434+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,1,
-1,23413488,12345678,2,closed,Handle multiple prices and date ranges,https://gitlab.com/gitlab-data/analytics/issues/2098,,ISSUE,,0,,1942272,tayloramurphy,4368,,2019-08-04T22:24:40.978+00:00,2019-08-01T21:36:28.766+00:00,2019-08-04T22:24:41.244+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,2,
-1,23577209,12345678,3,opened,Expand package,I wonder how much more we can do with this https://www.tableau.com/about/blog/2019/5/monitor-understand-snowflake-account-usage,,ISSUE,,0,,2295562,emilie,,,,2019-08-07T13:52:40.231+00:00,2020-04-08T20:53:43.146+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,3,
-1,23812433,12345678,4,closed,Config is not generic enough,Not everybody is going to have role reporter or schema analytics,,ISSUE,,0,,1942272,tayloramurphy,15823,,2019-08-26T15:37:49.678+00:00,2019-08-15T15:54:17.378+00:00,2019-08-26T15:37:49.718+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,4,
+1,22097949,12345678,1,closed,Add documentation to snowflake spend package,,,ISSUE,,2295562,emilie,2295562,emilie,11487,https://gitlab.com/api/v4/projects/12345678/issues/1,2019-06-28T14:32:05.376+00:00,2019-06-20T15:04:58.946+00:00,2019-06-28T14:32:05.434+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,1,
+1,23413488,12345678,2,closed,Handle multiple prices and date ranges,https://gitlab.com/gitlab-data/analytics/issues/2098,,ISSUE,,0,,1942272,tayloramurphy,4368,https://gitlab.com/api/v4/projects/12345678/issues/2,2019-08-04T22:24:40.978+00:00,2019-08-01T21:36:28.766+00:00,2019-08-04T22:24:41.244+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,2,
+1,23577209,12345678,3,opened,Expand package,I wonder how much more we can do with this https://www.tableau.com/about/blog/2019/5/monitor-understand-snowflake-account-usage,,ISSUE,,0,,2295562,emilie,,https://gitlab.com/api/v4/projects/12345678/issues/3,,2019-08-07T13:52:40.231+00:00,2020-04-08T20:53:43.146+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,3,
+1,23812433,12345678,4,closed,Config is not generic enough,Not everybody is going to have role reporter or schema analytics,,ISSUE,,0,,1942272,tayloramurphy,15823,https://gitlab.com/api/v4/projects/12345678/issues/4,2019-08-26T15:37:49.678+00:00,2019-08-15T15:54:17.378+00:00,2019-08-26T15:37:49.718+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,4,
1,23816268,12345678,5,closed,Update README to include steps to resolve a potential dbt-utils conflict,"Depending on the main project configuration for packages, adding snowflake_spend may return an error about duplicate dbt-utils projects.
-I'll update the README to include details and how to resolve it.",,ISSUE,,0,,3871284,martinguindon,15543,,2019-08-26T14:15:27.808+00:00,2019-08-15T19:11:30.169+00:00,2019-08-26T14:15:32.854+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,5,
-1,24172103,12345678,6,closed,Document release process,,,ISSUE,,5212782,m_walker,2295562,emilie,325745,,2020-04-08T20:52:10.973+00:00,2019-08-26T15:46:58.045+00:00,2020-04-08T20:52:11.010+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,6,
-1,32460839,12345678,7,closed,Add sources and cleanup structure,,,ISSUE,,2295562,emilie,1942272,tayloramurphy,18174,,2020-04-07T12:51:53.273+00:00,2020-03-25T21:56:57.084+00:00,2020-04-07T12:51:53.563+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,7,
-1,32667832,12345678,8,closed,Add reviewer roulette to the package,https://gitlab.com/gitlab-org/gitlab/-/tree/master/danger/roulette,,ISSUE,,0,,2295562,emilie,166318,,2020-07-24T20:32:07.650+00:00,2020-03-31T08:33:30.240+00:00,2020-07-24T20:32:07.689+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,8,
-1,33004486,12345678,9,closed,Make sure I can run locally the models,,,ISSUE,,4189780,mpeychet_,4189780,mpeychet_,155740,,2020-07-24T20:31:52.819+00:00,2020-04-07T16:50:58.253+00:00,2020-07-24T20:31:52.872+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,9,
+I'll update the README to include details and how to resolve it.",,ISSUE,,0,,3871284,martinguindon,15543,https://gitlab.com/api/v4/projects/12345678/issues/5,2019-08-26T14:15:27.808+00:00,2019-08-15T19:11:30.169+00:00,2019-08-26T14:15:32.854+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,5,
+1,24172103,12345678,6,closed,Document release process,,,ISSUE,,5212782,m_walker,2295562,emilie,325745,https://gitlab.com/api/v4/projects/12345678/issues/6,2020-04-08T20:52:10.973+00:00,2019-08-26T15:46:58.045+00:00,2020-04-08T20:52:11.010+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,6,
+1,32460839,12345678,7,closed,Add sources and cleanup structure,,,ISSUE,,2295562,emilie,1942272,tayloramurphy,18174,https://gitlab.com/api/v4/projects/12345678/issues/7,2020-04-07T12:51:53.273+00:00,2020-03-25T21:56:57.084+00:00,2020-04-07T12:51:53.563+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,7,
+1,32667832,12345678,8,closed,Add reviewer roulette to the package,https://gitlab.com/gitlab-org/gitlab/-/tree/master/danger/roulette,,ISSUE,,0,,2295562,emilie,166318,https://gitlab.com/api/v4/projects/12345678/issues/8,2020-07-24T20:32:07.650+00:00,2020-03-31T08:33:30.240+00:00,2020-07-24T20:32:07.689+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,8,
+1,33004486,12345678,9,closed,Make sure I can run locally the models,,,ISSUE,,4189780,mpeychet_,4189780,mpeychet_,155740,https://gitlab.com/api/v4/projects/12345678/issues/9,2020-07-24T20:31:52.819+00:00,2020-04-07T16:50:58.253+00:00,2020-07-24T20:31:52.872+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,9,
1,47175437,12345678,10,closed,Create alert for missing phone number and emergency contact in BambooHR,"Hi team, per this [issue](https://gitlab.com/gitlab-com/people-group/total-rewards/-/issues/140#note_362993437), can you please help us in creating an alert for missing phone numbers and emergency contacts.
Regarding phone number, we only require 1 of the 3 fields filled out (Work Home, Home Phone, Mobile Phone). Is there a way to create an alert for this **only** if all 3 fields are missing info?
-Thanks!",,ISSUE,,0,,4582589,julie.samson,29952,,2020-07-08T19:05:30.953+00:00,2020-06-17T23:52:31.133+00:00,2020-07-08T19:05:31.101+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,10,
+Thanks!",,ISSUE,,0,,4582589,julie.samson,29952,https://gitlab.com/api/v4/projects/12345678/issues/10,2020-07-08T19:05:30.953+00:00,2020-06-17T23:52:31.133+00:00,2020-07-08T19:05:31.101+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,10,
1,59444322,12345678,11,closed,Upgrade package for dbt 0.17,"Check:
* dbt_project.yml new version
-* packages",,ISSUE,,0,,1942272,tayloramurphy,13223,,2020-07-24T21:13:37.403+00:00,2020-07-15T16:49:44.079+00:00,2020-07-24T21:13:37.533+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,11,
-1,69025114,12345678,12,closed,Mirror to GitHub,,,ISSUE,,0,,1942272,tayloramurphy,82548,,2020-09-22T22:08:20.103+00:00,2020-07-27T14:19:40.700+00:00,2020-09-22T22:08:20.280+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,12,
+* packages",,ISSUE,,0,,1942272,tayloramurphy,13223,https://gitlab.com/api/v4/projects/12345678/issues/11,2020-07-24T21:13:37.403+00:00,2020-07-15T16:49:44.079+00:00,2020-07-24T21:13:37.533+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,11,
+1,69025114,12345678,12,closed,Mirror to GitHub,,,ISSUE,,0,,1942272,tayloramurphy,82548,https://gitlab.com/api/v4/projects/12345678/issues/12,2020-09-22T22:08:20.103+00:00,2020-07-27T14:19:40.700+00:00,2020-09-22T22:08:20.280+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,12,
1,89051403,12345678,13,opened,The mirror at https://github.com/gitlabhq/snowflake_spend is managed with an expired personal access token,"Taylor Murphy indicated that the mirror from this repo to github may have been setup on his personal access token. This mirror exists so it will show up on hub.getdbt.com . We need somebody else to manage the mirror to github.com since Taylor's access is expired.
-cc @gitlab-data/engineers",,ISSUE,,0,,5212782,m_walker,,,,2021-06-21T19:30:40.087+00:00,2021-10-08T14:26:35.650+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,13,
+cc @gitlab-data/engineers",,ISSUE,,0,,5212782,m_walker,,https://gitlab.com/api/v4/projects/12345678/issues/13,,2021-06-21T19:30:40.087+00:00,2021-10-08T14:26:35.650+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,13,
1,91069461,12345678,14,opened,packages.yml refers to a deprecated version of dbt_utils,"## Context
fishtown-analytics/* packages have been renamed dbt-labs/*
@@ -46,7 +46,7 @@ packages:
revision: v1.2.0
- package: dbt-labs/dbt_external_tables
version: 0.7.0
-```",,ISSUE,,0,,6214107,loicchesneau,,,,2021-07-29T07:58:08.871+00:00,2022-05-02T20:24:23.772+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,14,
+```",,ISSUE,,0,,6214107,loicchesneau,,https://gitlab.com/api/v4/projects/12345678/issues/14,,2021-07-29T07:58:08.871+00:00,2022-05-02T20:24:23.772+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,14,
1,106802088,12345678,15,opened,Getting issues and warning upgrading the new dbt version 1.0.4,"## Context
Upgrade DBT version 1.0.4
@@ -103,9 +103,9 @@ The `source-paths` config has been renamed to `model-paths`. Please update your
The `data-paths` config has been renamed to `seed-paths`. Please update your
`dbt_project.yml` configuration to reflect this change.
22:42:59 Encountered an error:
-Found duplicate project ""dbt_utils"". This occurs when a dependency has the same project name as some other dependency.",,ISSUE,,0,,11386488,gerardoparticle,,,,2022-04-19T00:16:22.360+00:00,2022-04-19T00:16:22.360+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,15,
+Found duplicate project ""dbt_utils"". This occurs when a dependency has the same project name as some other dependency.",,ISSUE,,0,,11386488,gerardoparticle,,https://gitlab.com/api/v4/projects/12345678/issues/15,,2022-04-19T00:16:22.360+00:00,2022-04-19T00:16:22.360+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,15,
1,108497826,12345678,16,closed,Release new snowplow spend package,"I've been contacted by Doug Beatty from dbt labs regarding the open PR on out GitHub repo [here](https://github.com/gitlabhq/snowflake_spend/pull/2)
This is a synched repo to the GitLab version [here](https://gitlab.com/gitlab-data/snowflake_spend/-/blob/master/packages.yml) where the change has already been made.
-I think the issue is that the tag wasn't applied to release this as a version. Release instructions [here](https://gitlab.com/gitlab-data/snowflake_spend/-/tree/master/#how-this-package-gets-released-for-maintainers-only).",,ISSUE,,9386100,chrissharp,9386100,chrissharp,49408,,2022-06-16T16:23:09.759+00:00,2022-05-13T08:54:58.859+00:00,2022-06-16T16:23:09.779+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,16,
+I think the issue is that the tag wasn't applied to release this as a version. Release instructions [here](https://gitlab.com/gitlab-data/snowflake_spend/-/tree/master/#how-this-package-gets-released-for-maintainers-only).",,ISSUE,,9386100,chrissharp,9386100,chrissharp,49408,https://gitlab.com/api/v4/projects/12345678/issues/16,2022-06-16T16:23:09.759+00:00,2022-05-13T08:54:58.859+00:00,2022-06-16T16:23:09.779+00:00,UNKNOWN,,,,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api [...]
diff --git a/backend/plugins/gitlab/e2e/snapshot_tables/issues.csv b/backend/plugins/gitlab/e2e/snapshot_tables/issues.csv
index 7a0132e7b..78e956181 100644
--- a/backend/plugins/gitlab/e2e/snapshot_tables/issues.csv
+++ b/backend/plugins/gitlab/e2e/snapshot_tables/issues.csv
@@ -1,5 +1,5 @@
id,url,issue_key,title,description,epic_key,type,status,original_status,story_point,resolution_date,created_date,updated_date,lead_time_minutes,parent_issue_id,priority,original_estimate_minutes,time_spent_minutes,time_remaining_minutes,creator_id,assignee_id,assignee_name,severity,component,icon_url,creator_name,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-gitlab:GitlabIssue:1:106802088,,15,Getting issues and warning upgrading the new dbt version 1.0.4,"## Context
+gitlab:GitlabIssue:1:106802088,https://gitlab.com/api/v4/projects/12345678/issues/15,15,Getting issues and warning upgrading the new dbt version 1.0.4,"## Context
Upgrade DBT version 1.0.4
## Problem
@@ -56,36 +56,36 @@ The `data-paths` config has been renamed to `seed-paths`. Please update your
`dbt_project.yml` configuration to reflect this change.
22:42:59 Encountered an error:
Found duplicate project ""dbt_utils"". This occurs when a dependency has the same project name as some other dependency.",,,TODO,,,,2022-04-19T00:16:22.360+00:00,2022-04-19T00:16:22.360+00:00,,,,,,,gitlab:GitlabAccount:1:11386488,gitlab:GitlabAccount:1:0,,UNKNOWN,,,gerardoparticle,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,15,
-gitlab:GitlabIssue:1:108497826,,16,Release new snowplow spend package,"I've been contacted by Doug Beatty from dbt labs regarding the open PR on out GitHub repo [here](https://github.com/gitlabhq/snowflake_spend/pull/2)
+gitlab:GitlabIssue:1:108497826,https://gitlab.com/api/v4/projects/12345678/issues/16,16,Release new snowplow spend package,"I've been contacted by Doug Beatty from dbt labs regarding the open PR on out GitHub repo [here](https://github.com/gitlabhq/snowflake_spend/pull/2)
This is a synched repo to the GitLab version [here](https://gitlab.com/gitlab-data/snowflake_spend/-/blob/master/packages.yml) where the change has already been made.
I think the issue is that the tag wasn't applied to release this as a version. Release instructions [here](https://gitlab.com/gitlab-data/snowflake_spend/-/tree/master/#how-this-package-gets-released-for-maintainers-only).",,,DONE,,,2022-06-16T16:23:09.759+00:00,2022-05-13T08:54:58.859+00:00,2022-06-16T16:23:09.779+00:00,49408,,,,,,gitlab:GitlabAccount:1:9386100,gitlab:GitlabAccount:1:9386100,chrissharp,UNKNOWN,,,chrissharp,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_is [...]
-gitlab:GitlabIssue:1:22097949,,1,Add documentation to snowflake spend package,,,,DONE,,,2019-06-28T14:32:05.376+00:00,2019-06-20T15:04:58.946+00:00,2019-06-28T14:32:05.434+00:00,11487,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:2295562,emilie,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,1,
-gitlab:GitlabIssue:1:23413488,,2,Handle multiple prices and date ranges,https://gitlab.com/gitlab-data/analytics/issues/2098,,,DONE,,,2019-08-04T22:24:40.978+00:00,2019-08-01T21:36:28.766+00:00,2019-08-04T22:24:41.244+00:00,4368,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,2,
-gitlab:GitlabIssue:1:23577209,,3,Expand package,I wonder how much more we can do with this https://www.tableau.com/about/blog/2019/5/monitor-understand-snowflake-account-usage,,,TODO,,,,2019-08-07T13:52:40.231+00:00,2020-04-08T20:53:43.146+00:00,,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:0,,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,3,
-gitlab:GitlabIssue:1:23812433,,4,Config is not generic enough,Not everybody is going to have role reporter or schema analytics,,,DONE,,,2019-08-26T15:37:49.678+00:00,2019-08-15T15:54:17.378+00:00,2019-08-26T15:37:49.718+00:00,15823,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,4,
-gitlab:GitlabIssue:1:23816268,,5,Update README to include steps to resolve a potential dbt-utils conflict,"Depending on the main project configuration for packages, adding snowflake_spend may return an error about duplicate dbt-utils projects.
+gitlab:GitlabIssue:1:22097949,https://gitlab.com/api/v4/projects/12345678/issues/1,1,Add documentation to snowflake spend package,,,,DONE,,,2019-06-28T14:32:05.376+00:00,2019-06-20T15:04:58.946+00:00,2019-06-28T14:32:05.434+00:00,11487,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:2295562,emilie,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,1,
+gitlab:GitlabIssue:1:23413488,https://gitlab.com/api/v4/projects/12345678/issues/2,2,Handle multiple prices and date ranges,https://gitlab.com/gitlab-data/analytics/issues/2098,,,DONE,,,2019-08-04T22:24:40.978+00:00,2019-08-01T21:36:28.766+00:00,2019-08-04T22:24:41.244+00:00,4368,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,2,
+gitlab:GitlabIssue:1:23577209,https://gitlab.com/api/v4/projects/12345678/issues/3,3,Expand package,I wonder how much more we can do with this https://www.tableau.com/about/blog/2019/5/monitor-understand-snowflake-account-usage,,,TODO,,,,2019-08-07T13:52:40.231+00:00,2020-04-08T20:53:43.146+00:00,,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:0,,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,3,
+gitlab:GitlabIssue:1:23812433,https://gitlab.com/api/v4/projects/12345678/issues/4,4,Config is not generic enough,Not everybody is going to have role reporter or schema analytics,,,DONE,,,2019-08-26T15:37:49.678+00:00,2019-08-15T15:54:17.378+00:00,2019-08-26T15:37:49.718+00:00,15823,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,4,
+gitlab:GitlabIssue:1:23816268,https://gitlab.com/api/v4/projects/12345678/issues/5,5,Update README to include steps to resolve a potential dbt-utils conflict,"Depending on the main project configuration for packages, adding snowflake_spend may return an error about duplicate dbt-utils projects.
I'll update the README to include details and how to resolve it.",,,DONE,,,2019-08-26T14:15:27.808+00:00,2019-08-15T19:11:30.169+00:00,2019-08-26T14:15:32.854+00:00,15543,,,,,,gitlab:GitlabAccount:1:3871284,gitlab:GitlabAccount:1:0,,UNKNOWN,,,martinguindon,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,5,
-gitlab:GitlabIssue:1:24172103,,6,Document release process,,,,DONE,,,2020-04-08T20:52:10.973+00:00,2019-08-26T15:46:58.045+00:00,2020-04-08T20:52:11.010+00:00,325745,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:5212782,m_walker,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,6,
-gitlab:GitlabIssue:1:32460839,,7,Add sources and cleanup structure,,,,DONE,,,2020-04-07T12:51:53.273+00:00,2020-03-25T21:56:57.084+00:00,2020-04-07T12:51:53.563+00:00,18174,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:2295562,emilie,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,7,
-gitlab:GitlabIssue:1:32667832,,8,Add reviewer roulette to the package,https://gitlab.com/gitlab-org/gitlab/-/tree/master/danger/roulette,,,DONE,,,2020-07-24T20:32:07.650+00:00,2020-03-31T08:33:30.240+00:00,2020-07-24T20:32:07.689+00:00,166318,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:0,,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,8,
-gitlab:GitlabIssue:1:33004486,,9,Make sure I can run locally the models,,,,DONE,,,2020-07-24T20:31:52.819+00:00,2020-04-07T16:50:58.253+00:00,2020-07-24T20:31:52.872+00:00,155740,,,,,,gitlab:GitlabAccount:1:4189780,gitlab:GitlabAccount:1:4189780,mpeychet_,UNKNOWN,,,mpeychet_,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,9,
-gitlab:GitlabIssue:1:47175437,,10,Create alert for missing phone number and emergency contact in BambooHR,"Hi team, per this [issue](https://gitlab.com/gitlab-com/people-group/total-rewards/-/issues/140#note_362993437), can you please help us in creating an alert for missing phone numbers and emergency contacts.
+gitlab:GitlabIssue:1:24172103,https://gitlab.com/api/v4/projects/12345678/issues/6,6,Document release process,,,,DONE,,,2020-04-08T20:52:10.973+00:00,2019-08-26T15:46:58.045+00:00,2020-04-08T20:52:11.010+00:00,325745,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:5212782,m_walker,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,6,
+gitlab:GitlabIssue:1:32460839,https://gitlab.com/api/v4/projects/12345678/issues/7,7,Add sources and cleanup structure,,,,DONE,,,2020-04-07T12:51:53.273+00:00,2020-03-25T21:56:57.084+00:00,2020-04-07T12:51:53.563+00:00,18174,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:2295562,emilie,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,7,
+gitlab:GitlabIssue:1:32667832,https://gitlab.com/api/v4/projects/12345678/issues/8,8,Add reviewer roulette to the package,https://gitlab.com/gitlab-org/gitlab/-/tree/master/danger/roulette,,,DONE,,,2020-07-24T20:32:07.650+00:00,2020-03-31T08:33:30.240+00:00,2020-07-24T20:32:07.689+00:00,166318,,,,,,gitlab:GitlabAccount:1:2295562,gitlab:GitlabAccount:1:0,,UNKNOWN,,,emilie,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,8,
+gitlab:GitlabIssue:1:33004486,https://gitlab.com/api/v4/projects/12345678/issues/9,9,Make sure I can run locally the models,,,,DONE,,,2020-07-24T20:31:52.819+00:00,2020-04-07T16:50:58.253+00:00,2020-07-24T20:31:52.872+00:00,155740,,,,,,gitlab:GitlabAccount:1:4189780,gitlab:GitlabAccount:1:4189780,mpeychet_,UNKNOWN,,,mpeychet_,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,9,
+gitlab:GitlabIssue:1:47175437,https://gitlab.com/api/v4/projects/12345678/issues/10,10,Create alert for missing phone number and emergency contact in BambooHR,"Hi team, per this [issue](https://gitlab.com/gitlab-com/people-group/total-rewards/-/issues/140#note_362993437), can you please help us in creating an alert for missing phone numbers and emergency contacts.
Regarding phone number, we only require 1 of the 3 fields filled out (Work Home, Home Phone, Mobile Phone). Is there a way to create an alert for this **only** if all 3 fields are missing info?
Thanks!",,,DONE,,,2020-07-08T19:05:30.953+00:00,2020-06-17T23:52:31.133+00:00,2020-07-08T19:05:31.101+00:00,29952,,,,,,gitlab:GitlabAccount:1:4582589,gitlab:GitlabAccount:1:0,,UNKNOWN,,,julie.samson,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,10,
-gitlab:GitlabIssue:1:59444322,,11,Upgrade package for dbt 0.17,"Check:
+gitlab:GitlabIssue:1:59444322,https://gitlab.com/api/v4/projects/12345678/issues/11,11,Upgrade package for dbt 0.17,"Check:
* dbt_project.yml new version
* packages",,,DONE,,,2020-07-24T21:13:37.403+00:00,2020-07-15T16:49:44.079+00:00,2020-07-24T21:13:37.533+00:00,13223,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,11,
-gitlab:GitlabIssue:1:69025114,,12,Mirror to GitHub,,,,DONE,,,2020-09-22T22:08:20.103+00:00,2020-07-27T14:19:40.700+00:00,2020-09-22T22:08:20.280+00:00,82548,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,12,
-gitlab:GitlabIssue:1:89051403,,13,The mirror at https://github.com/gitlabhq/snowflake_spend is managed with an expired personal access token,"Taylor Murphy indicated that the mirror from this repo to github may have been setup on his personal access token. This mirror exists so it will show up on hub.getdbt.com . We need somebody else to manage the mirror to github.com since Taylor's access is expired.
+gitlab:GitlabIssue:1:69025114,https://gitlab.com/api/v4/projects/12345678/issues/12,12,Mirror to GitHub,,,,DONE,,,2020-09-22T22:08:20.103+00:00,2020-07-27T14:19:40.700+00:00,2020-09-22T22:08:20.280+00:00,82548,,,,,,gitlab:GitlabAccount:1:1942272,gitlab:GitlabAccount:1:0,,UNKNOWN,,,tayloramurphy,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,12,
+gitlab:GitlabIssue:1:89051403,https://gitlab.com/api/v4/projects/12345678/issues/13,13,The mirror at https://github.com/gitlabhq/snowflake_spend is managed with an expired personal access token,"Taylor Murphy indicated that the mirror from this repo to github may have been setup on his personal access token. This mirror exists so it will show up on hub.getdbt.com . We need somebody else to manage the mirror to github.com since Taylor's access is expired.
cc @gitlab-data/engineers",,,TODO,,,,2021-06-21T19:30:40.087+00:00,2021-10-08T14:26:35.650+00:00,,,,,,,gitlab:GitlabAccount:1:5212782,gitlab:GitlabAccount:1:0,,UNKNOWN,,,m_walker,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_issues,13,
-gitlab:GitlabIssue:1:91069461,,14,packages.yml refers to a deprecated version of dbt_utils,"## Context
+gitlab:GitlabIssue:1:91069461,https://gitlab.com/api/v4/projects/12345678/issues/14,14,packages.yml refers to a deprecated version of dbt_utils,"## Context
fishtown-analytics/* packages have been renamed dbt-labs/*
diff --git a/backend/plugins/gitlab/tasks/issue_extractor.go b/backend/plugins/gitlab/tasks/issue_extractor.go
index c834935b3..9d6a56fda 100644
--- a/backend/plugins/gitlab/tasks/issue_extractor.go
+++ b/backend/plugins/gitlab/tasks/issue_extractor.go
@@ -122,11 +122,11 @@ type IssuesResponse struct {
Component string
Priority string
Links struct {
- Self string `json:"url"`
+ Self string `json:"self"`
Notes string
AwardEmoji string
Project string
- }
+ } `json:"_links"`
TaskCompletionStatus struct {
Count int
CompletedCount int
diff --git a/backend/plugins/zentao/e2e/account_test.go b/backend/plugins/zentao/e2e/account_test.go
index 04ec31a6f..a42ad4d6e 100644
--- a/backend/plugins/zentao/e2e/account_test.go
+++ b/backend/plugins/zentao/e2e/account_test.go
@@ -35,7 +35,8 @@ var basicContext = runner.CreateAppBasicRes()
func getFakeAPIClient() *helper.ApiAsyncClient {
client, _ := helper.NewApiClient(gocontext.Background(),
- "https://zentao.demo.haogs.cn/api.php/v1/",
+ "https://zentaomax.demo.qucheng.cc/api.php/v1/",
+ //"https://zentao.demo.haogs.cn/api.php/v1/",
nil, time.Second*5, "",
basicContext,
)
diff --git a/backend/plugins/zentao/e2e/bug_test.go b/backend/plugins/zentao/e2e/bug_test.go
index 292adeec6..16dbc6c11 100644
--- a/backend/plugins/zentao/e2e/bug_test.go
+++ b/backend/plugins/zentao/e2e/bug_test.go
@@ -66,6 +66,7 @@ func TestZentaoBugDataFlow(t *testing.T) {
// verify conversion
dataflowTester.FlushTabler(&ticket.Issue{})
dataflowTester.FlushTabler(&ticket.BoardIssue{})
+ dataflowTester.FlushTabler(&ticket.SprintIssue{})
dataflowTester.FlushTabler(&ticket.IssueAssignee{})
dataflowTester.Subtask(tasks.ConvertBugMeta, taskData)
dataflowTester.VerifyTableWithOptions(&ticket.Issue{}, e2ehelper.TableOptions{
diff --git a/backend/plugins/zentao/e2e/snapshot_tables/execution_sprint.csv b/backend/plugins/zentao/e2e/snapshot_tables/execution_sprint.csv
index db9071d0c..adcc379f3 100644
--- a/backend/plugins/zentao/e2e/snapshot_tables/execution_sprint.csv
+++ b/backend/plugins/zentao/e2e/snapshot_tables/execution_sprint.csv
@@ -1,9 +1,9 @@
id,name,url,status,started_date,ended_date,completed_date,original_board_id
-zentao:ZentaoExecution:1:133,为长期项目创建一个迭代,https://zentao.demo.haogs.cn/execution-view-133.html,,2023-08-28T00:00:00.000+00:00,2023-09-08T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:193,为长期项目创建一个迭代,https://zentao.demo.haogs.cn/execution-view-193.html,ACTIVE,2023-08-28T00:00:00.000+00:00,2023-09-08T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:194,新建一个迭代，完成之后检查sprints表,https://zentao.demo.haogs.cn/execution-view-194.html,CLOSED,2023-08-29T00:00:00.000+00:00,2023-09-05T00:00:00.000+00:00,2023-08-29T08:04:13.000+00:00,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:266,新建迭代然后关闭,https://zentao.demo.haogs.cn/execution-view-266.html,CLOSED,2023-09-07T00:00:00.000+00:00,2023-09-13T00:00:00.000+00:00,2023-09-07T02:15:31.000+00:00,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:267,建一个计划未来开始迭代,https://zentao.demo.haogs.cn/execution-view-267.html,FUTURE,2023-09-09T00:00:00.000+00:00,2023-09-22T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:268,起始-截止都是结束时间,https://zentao.demo.haogs.cn/execution-view-268.html,FUTURE,2023-09-04T00:00:00.000+00:00,2023-09-05T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:269,把迭代挂起,https://zentao.demo.haogs.cn/execution-view-269.html,SUSPENDED,2023-09-07T00:00:00.000+00:00,2023-09-20T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
-zentao:ZentaoExecution:1:270,流程扭转--挂起迭代2,https://zentao.demo.haogs.cn/execution-view-270.html,SUSPENDED,2023-09-07T00:00:00.000+00:00,2023-09-20T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:133,为长期项目创建一个迭代,https://zentaomax.demo.qucheng.cc/execution-view-133.html,,2023-08-28T00:00:00.000+00:00,2023-09-08T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:193,为长期项目创建一个迭代,https://zentaomax.demo.qucheng.cc/execution-view-193.html,ACTIVE,2023-08-28T00:00:00.000+00:00,2023-09-08T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:194,新建一个迭代，完成之后检查sprints表,https://zentaomax.demo.qucheng.cc/execution-view-194.html,CLOSED,2023-08-29T00:00:00.000+00:00,2023-09-05T00:00:00.000+00:00,2023-08-29T08:04:13.000+00:00,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:266,新建迭代然后关闭,https://zentaomax.demo.qucheng.cc/execution-view-266.html,CLOSED,2023-09-07T00:00:00.000+00:00,2023-09-13T00:00:00.000+00:00,2023-09-07T02:15:31.000+00:00,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:267,建一个计划未来开始迭代,https://zentaomax.demo.qucheng.cc/execution-view-267.html,FUTURE,2023-09-09T00:00:00.000+00:00,2023-09-22T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:268,起始-截止都是结束时间,https://zentaomax.demo.qucheng.cc/execution-view-268.html,FUTURE,2023-09-04T00:00:00.000+00:00,2023-09-05T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:269,把迭代挂起,https://zentaomax.demo.qucheng.cc/execution-view-269.html,SUSPENDED,2023-09-07T00:00:00.000+00:00,2023-09-20T00:00:00.000+00:00,,zentao:ZentaoProject:1:192
+zentao:ZentaoExecution:1:270,流程扭转--挂起迭代2,https://zentaomax.demo.qucheng.cc/execution-view-270.html,SUSPENDED,2023-09-07T00:00:00.000+00:00,2023-09-20T00:00:00.000+00:00,,zentao:ZentaoProject:1:192