feat(gitlab): add e2e for mr comments (#2835)
diff --git a/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_request_notes.csv b/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_request_notes.csv
index 94b3c8d..134afdf 100644
--- a/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_request_notes.csv
+++ b/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_request_notes.csv
@@ -19,3 +19,9 @@
18,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":208185588,""type"":null,""body"":""restored source branch `4-config-is-not-generic-enough`"",""attachment"":null,""author"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""created_at"":""2019-08-26T15:33:21.878Z"",""updated_at"":""2019-08-26T15:33:21.884Z"",""system"":true,""noteable_id"":35841926,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""noteable_iid"":4,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/4/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 4, ""GitlabId"": 35841926}",2022-07-01 11:00:54.809
19,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":208185663,""type"":null,""body"":""assigned to @emilie"",""attachment"":null,""author"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""created_at"":""2019-08-26T15:33:34.019Z"",""updated_at"":""2019-08-26T15:33:34.023Z"",""system"":true,""noteable_id"":35841926,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""noteable_iid"":4,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/4/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 4, ""GitlabId"": 35841926}",2022-07-01 11:00:54.809
20,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":208186075,""type"":null,""body"":""added 1 commit\n\n\u003cul\u003e\u003cli\u003e91e5666b - remove config\u003c/li\u003e\u003c/ul\u003e\n\n[Compare with previous version](/gitlab-data/snowflake_spend/merge_requests/4/diffs?diff_id=52612655\u0026start_sha=d678bea9d47b42eb13512d1c9d6a592d80b432d4)"",""attachment"":null,""author"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""created_at"":""2019-08-26T15:34:37.958Z"",""updated_at"":""2019-08-26T15:34:37.961Z"",""system"":true,""noteable_id"":35841926,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""noteable_iid"":4,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/4/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 4, ""GitlabId"": 35841926}",2022-07-01 11:00:54.809
+71,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":135100359,""type"":null,""body"":""approved this merge request"",""attachment"":null,""author"":{""id"":3393147,""username"":""liyongfeng"",""name"":""Yongfeng Li"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3393147/avatar.png"",""web_url"":""https://gitlab.com/liyongfeng""},""created_at"":""2019-01-25T16:46:23.996Z"",""updated_at"":""2019-01-25T16:46:23.996Z"",""system"":true,""noteable_id"":1149942101,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""internal"":false,""noteable_iid"":29,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/29/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 29, ""GitlabId"": 1149942101}",2022-08-24 02:38:16.720
+126,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":135223089,""type"":null,""body"":""approved this merge request"",""attachment"":null,""author"":{""id"":3393147,""username"":""liyongfeng"",""name"":""Yongfeng Li"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3393147/avatar.png"",""web_url"":""https://gitlab.com/liyongfeng""},""created_at"":""2019-01-26T11:41:34.158Z"",""updated_at"":""2019-01-26T11:41:34.158Z"",""system"":true,""noteable_id"":135772105,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""internal"":false,""noteable_iid"":30,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/30/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 30, ""GitlabId"": 135772105}",2022-08-24 02:38:17.042
+151,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":137424744,""type"":null,""body"":""approved this merge request"",""attachment"":null,""author"":{""id"":3014346,""username"":""hackwaly"",""name"":""文宇祥"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/5d814c4a23f3346e8bb40f454a039663?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/hackwaly""},""created_at"":""2019-02-01T11:43:54.686Z"",""updated_at"":""2019-02-01T11:43:54.686Z"",""system"":true,""noteable_id"":145032495,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""internal"":false,""noteable_iid"":46,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/46/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 46, ""GitlabId"": 145032495}",2022-08-24 02:38:17.348
+169,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":135848627,""type"":null,""body"":""approved this merge request"",""attachment"":null,""author"":{""id"":2436773,""username"":""basicthinker"",""name"":""Jinglei Ren"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"",""web_url"":""https://gitlab.com/basicthinker""},""created_at"":""2019-01-29T00:40:37.158Z"",""updated_at"":""2019-01-29T00:40:37.158Z"",""system"":true,""noteable_id"":15869219,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""internal"":false,""noteable_iid"":37,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/37/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 37, ""GitlabId"": 15869219}",2022-08-24 02:38:17.462
+170,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":135848646,""type"":null,""body"":""unapproved this merge request"",""attachment"":null,""author"":{""id"":2436773,""username"":""basicthinker"",""name"":""Jinglei Ren"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"",""web_url"":""https://gitlab.com/basicthinker""},""created_at"":""2019-01-29T00:40:45.520Z"",""updated_at"":""2019-01-29T00:40:45.520Z"",""system"":true,""noteable_id"":15869219,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""internal"":false,""noteable_iid"":37,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/37/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 37, ""GitlabId"": 15869219}",2022-08-24 02:38:17.462
+171,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":135848654,""type"":null,""body"":""approved this merge request"",""attachment"":null,""author"":{""id"":2436773,""username"":""basicthinker"",""name"":""Jinglei Ren"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"",""web_url"":""https://gitlab.com/basicthinker""},""created_at"":""2019-01-29T00:40:47.455Z"",""updated_at"":""2019-01-29T00:40:47.455Z"",""system"":true,""noteable_id"":15869219,""noteable_type"":""MergeRequest"",""resolvable"":false,""confidential"":false,""internal"":false,""noteable_iid"":37,""commands_changes"":{}}",https://gitlab.com/api/v4/projects/12345678/merge_requests/37/notes?page=1&per_page=100&sort=asc&system=false&with_stats=true,"{""Iid"": 37, ""GitlabId"": 15869219}",2022-08-24 02:38:17.462
diff --git a/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_requests_for_mr_notes_test.csv b/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_requests_for_mr_notes_test.csv
index 414eb2f..ca2600a 100644
--- a/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_requests_for_mr_notes_test.csv
+++ b/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_merge_requests_for_mr_notes_test.csv
@@ -11,3 +11,7 @@
10,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":58311001,""iid"":10,""project_id"":12345678,""title"":""Update version in readme"",""description"":"""",""state"":""merged"",""created_at"":""2020-05-11T17:09:12.265Z"",""updated_at"":""2020-05-11T17:09:20.565Z"",""merged_by"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""merge_user"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""merged_at"":""2020-05-11T17:09:20.603Z"",""closed_by"":null,""closed_at"":null,""target_branch"":""master"",""source_branch"":""emilie-master-patch-23079"",""user_notes_count"":0,""upvotes"":0,""downvotes"":0,""author"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""assignees"":[{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""}],""assignee"":{""id"":2295562,""username"":""emilie"",""name"":""Emilie Schario"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2295562/avatar.png"",""web_url"":""https://gitlab.com/emilie""},""reviewers"":[],""source_project_id"":12345678,""target_project_id"":12345678,""labels"":[],""draft"":false,""work_in_progress"":false,""milestone"":null,""merge_when_pipeline_succeeds"":false,""merge_status"":""can_be_merged"",""sha"":""8e551153bb4a86f7d611cf3f8459a9dc25b59ee6"",""merge_commit_sha"":""66c0f1de49a0c876b8f93e8e0dce3327e766f59d"",""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":true,""reference"":""!10"",""references"":{""short"":""!10"",""relative"":""!10"",""full"":""gitlab-data/snowflake_spend!10""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/10"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":false,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-06-23 11:23:04.770
11,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":62519057,""iid"":11,""project_id"":12345678,""title"":""Clustering metering models"",""description"":"""",""state"":""opened"",""created_at"":""2020-06-24T12:34:04.792Z"",""updated_at"":""2020-06-24T12:35:01.115Z"",""merged_by"":null,""merge_user"":null,""merged_at"":null,""closed_by"":null,""closed_at"":null,""target_branch"":""master"",""source_branch"":""clustering-metering"",""user_notes_count"":0,""upvotes"":0,""downvotes"":0,""author"":{""id"":842680,""username"":""jainnehil"",""name"":""Nehil Jain"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/7e96067ec286bc1665a4985fb52fdead?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/jainnehil""},""assignees"":[],""assignee"":null,""reviewers"":[],""source_project_id"":19569570,""target_project_id"":12345678,""labels"":[],""draft"":false,""work_in_progress"":false,""milestone"":null,""merge_when_pipeline_succeeds"":false,""merge_status"":""cannot_be_merged"",""sha"":""8d7c748e10e8d35c3d0157c8fdd5b1b73e52132b"",""merge_commit_sha"":null,""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":true,""allow_collaboration"":true,""allow_maintainer_to_push"":true,""reference"":""!11"",""references"":{""short"":""!11"",""relative"":""!11"",""full"":""gitlab-data/snowflake_spend!11""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/11"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":true,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-06-23 11:23:04.770
12,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":65505080,""iid"":12,""project_id"":12345678,""title"":""Resolve \""Upgrade package for dbt 0.17\"""",""description"":""Closes #11 \n\n* Upgrades to 0.17.0 format\n* Formatting changes to be in line with GitLab SQL Style Guide"",""state"":""merged"",""created_at"":""2020-07-24T17:47:08.238Z"",""updated_at"":""2020-07-24T21:13:34.907Z"",""merged_by"":{""id"":1942272,""username"":""tayloramurphy"",""name"":""Taylor A Murphy"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/1942272/avatar.png"",""web_url"":""https://gitlab.com/tayloramurphy""},""merge_user"":{""id"":1942272,""username"":""tayloramurphy"",""name"":""Taylor A Murphy"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/1942272/avatar.png"",""web_url"":""https://gitlab.com/tayloramurphy""},""merged_at"":""2020-07-24T21:13:35.321Z"",""closed_by"":null,""closed_at"":null,""target_branch"":""master"",""source_branch"":""11-upgrade-package-for-dbt-0-17"",""user_notes_count"":0,""upvotes"":0,""downvotes"":0,""author"":{""id"":1942272,""username"":""tayloramurphy"",""name"":""Taylor A Murphy"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/1942272/avatar.png"",""web_url"":""https://gitlab.com/tayloramurphy""},""assignees"":[],""assignee"":null,""reviewers"":[],""source_project_id"":12345678,""target_project_id"":12345678,""labels"":[""Data Team"",""Priority::3-Other"",""Refactor"",""To Do"",""dbt"",""workflow::4 - scheduled""],""draft"":false,""work_in_progress"":false,""milestone"":{""id"":1250860,""iid"":62,""group_id"":4347861,""title"":""20.07.15 - DE"",""description"":"""",""state"":""closed"",""created_at"":""2020-04-21T22:09:48.836Z"",""updated_at"":""2020-07-28T21:04:17.819Z"",""due_date"":""2020-07-28"",""start_date"":""2020-07-15"",""expired"":true,""web_url"":""https://gitlab.com/groups/gitlab-data/-/milestones/62""},""merge_when_pipeline_succeeds"":false,""merge_status"":""can_be_merged"",""sha"":""5948da3e11a972ff3fbd27e603e60f69e2107afa"",""merge_commit_sha"":""9bfc136eb90802c2ce59956c34dde01bb3de0d50"",""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":true,""reference"":""!12"",""references"":{""short"":""!12"",""relative"":""!12"",""full"":""gitlab-data/snowflake_spend!12""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/12"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":false,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-06-23 11:23:04.770
+18,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":1149942101,""iid"":29,""project_id"":12345678,""title"":""Add support for Snowpipe usage monitoring"",""description"":""Add models and docs for Snowflake pipes (Snowpipe) usage monitoring based on the views in Snowflake Usage schema"",""state"":""opened"",""created_at"":""2021-09-01T21:15:30.334Z"",""updated_at"":""2022-06-30T21:41:49.705Z"",""merged_by"":null,""merge_user"":null,""merged_at"":null,""closed_by"":null,""closed_at"":null,""target_branch"":""master"",""source_branch"":""master"",""user_notes_count"":0,""upvotes"":0,""downvotes"":0,""author"":{""id"":9635687,""username"":""gary-beautypie"",""name"":""gary-beautypie"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/33747e21c7519c6628416a6814e73f79?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/gary-beautypie""},""assignees"":[],""assignee"":null,""reviewers"":[],""source_project_id"":29298577,""target_project_id"":12345678,""labels"":[],""draft"":false,""work_in_progress"":false,""milestone"":null,""merge_when_pipeline_succeeds"":false,""merge_status"":""unchecked"",""sha"":""8a8587ff3685544e4c1e9f96f9092f026ddefb01"",""merge_commit_sha"":null,""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":null,""allow_collaboration"":false,""allow_maintainer_to_push"":false,""reference"":""!18"",""references"":{""short"":""!18"",""relative"":""!18"",""full"":""gitlab-data/snowflake_spend!18""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/18"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":false,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-07-01 11:00:53.919
+19,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":135772105,""iid"":30,""project_id"":12345678,""title"":""Updates for dbt 1.0"",""description"":""This MR sets up the repo for dbt 1.0\nA few configs were renamed.\n\nCould a new release be made for dbt 1.0?"",""state"":""opened"",""created_at"":""2022-01-18T19:59:30.723Z"",""updated_at"":""2022-02-10T14:13:47.663Z"",""merged_by"":null,""merge_user"":null,""merged_at"":null,""closed_by"":null,""closed_at"":null,""target_branch"":""master"",""source_branch"":""updates_for_dbt_1.0"",""user_notes_count"":1,""upvotes"":1,""downvotes"":0,""author"":{""id"":10663622,""username"":""johnj4"",""name"":""John Janecek"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/298ead480efde3cbf0999cc14d7e665f?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/johnj4""},""assignees"":[],""assignee"":null,""reviewers"":[],""source_project_id"":32935405,""target_project_id"":12345678,""labels"":[],""draft"":false,""work_in_progress"":false,""milestone"":null,""merge_when_pipeline_succeeds"":false,""merge_status"":""can_be_merged"",""sha"":""88cf634905f23a1142b45f433989cbc0610465dd"",""merge_commit_sha"":null,""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":true,""allow_collaboration"":true,""allow_maintainer_to_push"":true,""reference"":""!19"",""references"":{""short"":""!19"",""relative"":""!19"",""full"":""gitlab-data/snowflake_spend!19""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/19"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":false,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-07-01 11:00:53.919
+20,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":145032495,""iid"":46,""project_id"":12345678,""title"":""Draft: Update dbt_project.yml"",""description"":"""",""state"":""closed"",""created_at"":""2022-03-15T03:07:06.077Z"",""updated_at"":""2022-03-15T03:07:22.642Z"",""merged_by"":null,""merge_user"":null,""merged_at"":null,""closed_by"":{""id"":9722492,""username"":""PedramNavid"",""name"":""Pedram Navid"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/9722492/avatar.png"",""web_url"":""https://gitlab.com/PedramNavid""},""closed_at"":""2022-03-15T03:07:22.665Z"",""target_branch"":""master"",""source_branch"":""PedramNavid-master-patch-20645"",""user_notes_count"":0,""upvotes"":0,""downvotes"":0,""author"":{""id"":9722492,""username"":""PedramNavid"",""name"":""Pedram Navid"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/9722492/avatar.png"",""web_url"":""https://gitlab.com/PedramNavid""},""assignees"":[],""assignee"":null,""reviewers"":[],""source_project_id"":34491818,""target_project_id"":12345678,""labels"":[],""draft"":true,""work_in_progress"":true,""milestone"":null,""merge_when_pipeline_succeeds"":false,""merge_status"":""can_be_merged"",""sha"":""e8730e17bb809c3dd0fa8ceeb83c12798477bf94"",""merge_commit_sha"":null,""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":true,""allow_collaboration"":true,""allow_maintainer_to_push"":true,""reference"":""!20"",""references"":{""short"":""!20"",""relative"":""!20"",""full"":""gitlab-data/snowflake_spend!20""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/20"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":false,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-07-01 11:00:53.919
+21,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":15869219,""iid"":37,""project_id"":12345678,""title"":""Draft: Corrections for dbt 1"",""description"":""Closes https://gitlab.com/gitlab-data/analytics/-/issues/12941"",""state"":""opened"",""created_at"":""2022-06-03T09:24:53.707Z"",""updated_at"":""2022-06-03T18:06:46.331Z"",""merged_by"":null,""merge_user"":null,""merged_at"":null,""closed_by"":null,""closed_at"":null,""target_branch"":""master"",""source_branch"":""updates_for_dbt_1_1"",""user_notes_count"":0,""upvotes"":0,""downvotes"":0,""author"":{""id"":5618371,""username"":""paul_armstrong"",""name"":""Paul Armstrong"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/5618371/avatar.png"",""web_url"":""https://gitlab.com/paul_armstrong""},""assignees"":[{""id"":5618371,""username"":""paul_armstrong"",""name"":""Paul Armstrong"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/5618371/avatar.png"",""web_url"":""https://gitlab.com/paul_armstrong""}],""assignee"":{""id"":5618371,""username"":""paul_armstrong"",""name"":""Paul Armstrong"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/5618371/avatar.png"",""web_url"":""https://gitlab.com/paul_armstrong""},""reviewers"":[],""source_project_id"":12345678,""target_project_id"":12345678,""labels"":[],""draft"":true,""work_in_progress"":true,""milestone"":null,""merge_when_pipeline_succeeds"":false,""merge_status"":""can_be_merged"",""sha"":""f1d0704d7c6a022d4cdd1cc6d519b69740f7e5b4"",""merge_commit_sha"":null,""squash_commit_sha"":null,""discussion_locked"":null,""should_remove_source_branch"":null,""force_remove_source_branch"":false,""reference"":""!21"",""references"":{""short"":""!21"",""relative"":""!21"",""full"":""gitlab-data/snowflake_spend!21""},""web_url"":""https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/21"",""time_stats"":{""time_estimate"":0,""total_time_spent"":0,""human_time_estimate"":null,""human_total_time_spent"":null},""squash"":false,""task_completion_status"":{""count"":0,""completed_count"":0},""has_conflicts"":false,""blocking_discussions_resolved"":true,""approvals_before_merge"":null}",https://gitlab.com/api/v4/projects/12345678/merge_requests?page=1&per_page=100&sort=asc&with_stats=true,null,2022-07-01 11:00:53.919
diff --git a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_merge_requests_for_mr_notes_test.csv b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_merge_requests_for_mr_notes_test.csv
index 539b25e..fe38d41 100644
--- a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_merge_requests_for_mr_notes_test.csv
+++ b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_merge_requests_for_mr_notes_test.csv
@@ -1,4 +1,5 @@
connection_id,gitlab_id,iid,project_id,source_project_id,target_project_id,state,title,web_url,user_notes_count,work_in_progress,source_branch,target_branch,merge_commit_sha,merged_at,gitlab_created_at,closed_at,merged_by_username,description,author_username,author_user_id,component,first_comment_time,review_rounds,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,15869219,37,12345678,12345678,12345678,opened,Draft: Corrections for dbt 1,https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/21,0,1,updates_for_dbt_1_1,master,,,2022-06-03T09:24:53.707+00:00,,,Closes https://gitlab.com/gitlab-data/analytics/-/issues/12941,paul_armstrong,5618371,,,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_requests,21,
1,32348491,1,12345678,12345678,12345678,merged,"Resolve ""Add documentation to snowflake spend package""",https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/1,1,0,1-add-documentation-to-snowflake-spend-package,master,da1d6dea48f5972ffc683da6cff30934e7d6c52c,2019-06-28T14:32:06.192+00:00,2019-06-28T05:21:43.743+00:00,,tayloramurphy,Closes #1,emilie,2295562,,,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_requests,1,
1,34300715,2,12345678,12345678,12345678,merged,"Resolve ""Handle multiple prices and date ranges""",https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/2,9,0,2-handle-multiple-prices-and-date-ranges,master,2fe82576fdbd0a43a2d5e02c17c6dc6ce3e188ee,2019-08-04T22:24:41.219+00:00,2019-08-01T21:36:45.020+00:00,,emilie,"Closes #2
@@ -22,3 +23,9 @@
* Upgrades to 0.17.0 format
* Formatting changes to be in line with GitLab SQL Style Guide",tayloramurphy,1942272,,,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_requests,12,
+1,135772105,30,12345678,32935405,12345678,opened,Updates for dbt 1.0,https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/19,1,0,updates_for_dbt_1.0,master,,,2022-01-18T19:59:30.723+00:00,,,"This MR sets up the repo for dbt 1.0
+A few configs were renamed.
+
+Could a new release be made for dbt 1.0?",johnj4,10663622,,,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_requests,19,
+1,145032495,46,12345678,34491818,12345678,closed,Draft: Update dbt_project.yml,https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/20,0,1,PedramNavid-master-patch-20645,master,,,2022-03-15T03:07:06.077+00:00,2022-03-15T03:07:22.665+00:00,,,PedramNavid,9722492,,,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_requests,20,
+1,1149942101,29,12345678,29298577,12345678,opened,Add support for Snowpipe usage monitoring,https://gitlab.com/gitlab-data/snowflake_spend/-/merge_requests/18,0,0,master,master,,,2021-09-01T21:15:30.334+00:00,,,Add models and docs for Snowflake pipes (Snowpipe) usage monitoring based on the views in Snowflake Usage schema,gary-beautypie,9635687,,,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_requests,18,
diff --git a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_comments.csv b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_comments.csv
index 89ca62c..66d01a6 100644
--- a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_comments.csv
+++ b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_comments.csv
@@ -1,4 +1,10 @@
connection_id,gitlab_id,merge_request_id,merge_request_iid,body,author_username,author_user_id,gitlab_created_at,resolvable,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,135100359,1149942101,29,approved this merge request,liyongfeng,3393147,2019-01-25T16:46:23.996+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,71,
+1,135223089,135772105,30,approved this merge request,liyongfeng,3393147,2019-01-26T11:41:34.158+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,126,
+1,135848627,15869219,37,approved this merge request,basicthinker,2436773,2019-01-29T00:40:37.158+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,169,
+1,135848646,15869219,37,unapproved this merge request,basicthinker,2436773,2019-01-29T00:40:45.520+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,170,
+1,135848654,15869219,37,approved this merge request,basicthinker,2436773,2019-01-29T00:40:47.455+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,171,
+1,137424744,145032495,46,approved this merge request,hackwaly,3014346,2019-02-01T11:43:54.686+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,151,
1,186439132,32348491,1,"@tayloramurphy Once this is merged, let's make this a release version?",emilie,2295562,2019-06-28T10:56:46.646+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,7,
1,208061122,35064956,3,@mg12 This looks good to me. Want me to merge?,emilie,2295562,2019-08-26T12:14:39.003+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,12,
1,208092969,35064956,3,@emilie Let's do it!,martinguindon,3871284,2019-08-26T13:17:51.707+00:00,0,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,13,
diff --git a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_notes.csv b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_notes.csv
index 612057a..6f21ad0 100644
--- a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_notes.csv
+++ b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_mr_notes.csv
@@ -1,4 +1,10 @@
connection_id,gitlab_id,merge_request_id,merge_request_iid,noteable_type,author_username,body,gitlab_created_at,confidential,resolvable,is_system,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,135100359,1149942101,29,MergeRequest,liyongfeng,approved this merge request,2019-01-25T16:46:23.996+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,71,
+1,135223089,135772105,30,MergeRequest,liyongfeng,approved this merge request,2019-01-26T11:41:34.158+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,126,
+1,135848627,15869219,37,MergeRequest,basicthinker,approved this merge request,2019-01-29T00:40:37.158+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,169,
+1,135848646,15869219,37,MergeRequest,basicthinker,unapproved this merge request,2019-01-29T00:40:45.520+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,170,
+1,135848654,15869219,37,MergeRequest,basicthinker,approved this merge request,2019-01-29T00:40:47.455+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,171,
+1,137424744,145032495,46,MergeRequest,hackwaly,approved this merge request,2019-02-01T11:43:54.686+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,151,
1,186327072,32348491,1,MergeRequest,emilie,assigned to @emilie,2019-06-28T05:40:22.415+00:00,0,0,1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,1,
1,186327158,32348491,1,MergeRequest,emilie,"added 1 commit
diff --git a/plugins/gitlab/e2e/snapshot_tables/pull_request_comments.csv b/plugins/gitlab/e2e/snapshot_tables/pull_request_comments.csv
index 0970b3f..a6258d0 100644
--- a/plugins/gitlab/e2e/snapshot_tables/pull_request_comments.csv
+++ b/plugins/gitlab/e2e/snapshot_tables/pull_request_comments.csv
@@ -1,4 +1,10 @@
id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,pull_request_id,body,user_id,created_date,commit_sha,position
+gitlab:GitlabMrComment:1:135100359,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,71,,gitlab:GitlabMergeRequest:1:1149942101,approved this merge request,gitlab:GitlabAccount:1:3393147,2019-01-25T16:46:23.996+00:00,,0
+gitlab:GitlabMrComment:1:135223089,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,126,,gitlab:GitlabMergeRequest:1:135772105,approved this merge request,gitlab:GitlabAccount:1:3393147,2019-01-26T11:41:34.158+00:00,,0
+gitlab:GitlabMrComment:1:135848627,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,169,,gitlab:GitlabMergeRequest:1:15869219,approved this merge request,gitlab:GitlabAccount:1:2436773,2019-01-29T00:40:37.158+00:00,,0
+gitlab:GitlabMrComment:1:135848646,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,170,,gitlab:GitlabMergeRequest:1:15869219,unapproved this merge request,gitlab:GitlabAccount:1:2436773,2019-01-29T00:40:45.520+00:00,,0
+gitlab:GitlabMrComment:1:135848654,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,171,,gitlab:GitlabMergeRequest:1:15869219,approved this merge request,gitlab:GitlabAccount:1:2436773,2019-01-29T00:40:47.455+00:00,,0
+gitlab:GitlabMrComment:1:137424744,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,151,,gitlab:GitlabMergeRequest:1:145032495,approved this merge request,gitlab:GitlabAccount:1:3014346,2019-02-01T11:43:54.686+00:00,,0
gitlab:GitlabMrComment:1:186439132,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,7,,gitlab:GitlabMergeRequest:1:32348491,"@tayloramurphy Once this is merged, let's make this a release version?",gitlab:GitlabAccount:1:2295562,2019-06-28T10:56:46.646+00:00,,0
gitlab:GitlabMrComment:1:208061122,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,12,,gitlab:GitlabMergeRequest:1:35064956,@mg12 This looks good to me. Want me to merge?,gitlab:GitlabAccount:1:2295562,2019-08-26T12:14:39.003+00:00,,0
gitlab:GitlabMrComment:1:208092969,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_merge_request_notes,13,,gitlab:GitlabMergeRequest:1:35064956,@emilie Let's do it!,gitlab:GitlabAccount:1:3871284,2019-08-26T13:17:51.707+00:00,,0
diff --git a/plugins/gitlab/tasks/mr_comment_convertor.go b/plugins/gitlab/tasks/mr_comment_convertor.go
index b933ba1..7e7b0f7 100644
--- a/plugins/gitlab/tasks/mr_comment_convertor.go
+++ b/plugins/gitlab/tasks/mr_comment_convertor.go
@@ -78,8 +78,13 @@
UserId: accountIdGen.Generate(data.Options.ConnectionId, gitlabComments.AuthorUserId),
CreatedDate: gitlabComments.GitlabCreatedAt,
}
-
domainComment.Type = getStdCommentType(gitlabComments.Type)
+ if domainComment.Body == "unapproved this merge request" {
+ domainComment.Status = "CHANGES_REQUESTED"
+ }
+ if domainComment.Body == "approved this merge request" {
+ domainComment.Status = "APPROVED"
+ }
return []interface{}{
domainComment,
}, nil
diff --git a/plugins/gitlab/tasks/mr_note_extractor.go b/plugins/gitlab/tasks/mr_note_extractor.go
index fa330e9..9d1d9cd 100644
--- a/plugins/gitlab/tasks/mr_note_extractor.go
+++ b/plugins/gitlab/tasks/mr_note_extractor.go
@@ -67,7 +67,7 @@
return nil, err
}
results := make([]interface{}, 0, 2)
- if !toolMrNote.IsSystem || (toolMrNote.IsSystem && toolMrNote.Body == "approved this merge request") {
+ if !toolMrNote.IsSystem || toolMrNote.Body == "approved this merge request" || toolMrNote.Body == "unapproved this merge request" {
toolMrComment := &models.GitlabMrComment{
GitlabId: toolMrNote.GitlabId,
MergeRequestId: toolMrNote.MergeRequestId,
