This is an automated email from the ASF dual-hosted git repository.
warren pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 93482384 refactor: add jira,gitlab account e2e
93482384 is described below
commit 93482384f421fe305f604523b1deae76a10b6599
Author: abeizn <[email protected]>
AuthorDate: Wed Jul 13 22:02:11 2022 +0800
refactor: add jira,gitlab account e2e
---
plugins/gitlab/e2e/account_test.go | 91 ++++++++++++++++++++++
.../e2e/raw_tables/_raw_gitlab_api_users.csv | 7 ++
.../e2e/snapshot_tables/_tool_gitlab_accounts.csv | 7 ++
plugins/gitlab/e2e/snapshot_tables/accounts.csv | 7 ++
plugins/jira/e2e/account_test.go | 87 +++++++++++++++++++++
.../e2e/snapshot_tables/_tool_jira_accounts.csv | 31 ++++++++
plugins/jira/e2e/snapshot_tables/accounts.csv | 31 ++++++++
7 files changed, 261 insertions(+)
diff --git a/plugins/gitlab/e2e/account_test.go
b/plugins/gitlab/e2e/account_test.go
new file mode 100644
index 00000000..22948b0b
--- /dev/null
+++ b/plugins/gitlab/e2e/account_test.go
@@ -0,0 +1,91 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package e2e
+
+import (
+ "fmt"
+ "testing"
+
+ "github.com/apache/incubator-devlake/helpers/e2ehelper"
+ "github.com/apache/incubator-devlake/models/domainlayer/crossdomain"
+ "github.com/apache/incubator-devlake/plugins/gitlab/impl"
+ "github.com/apache/incubator-devlake/plugins/gitlab/models"
+ "github.com/apache/incubator-devlake/plugins/gitlab/tasks"
+)
+
+func TestGitlabAccountDataFlow(t *testing.T) {
+
+ var gitlab impl.Gitlab
+ dataflowTester := e2ehelper.NewDataFlowTester(t, "gitlab", gitlab)
+
+ taskData := &tasks.GitlabTaskData{
+ Options: &tasks.GitlabOptions{
+ ConnectionId: 1,
+ ProjectId: 12345678,
+ },
+ }
+
+ // import raw data table
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_gitlab_api_users.csv",
+ "_raw_gitlab_api_users")
+
+ // verify extraction
+ dataflowTester.FlushTabler(&models.GitlabAccount{})
+ dataflowTester.Subtask(tasks.ExtractAccountMeta, taskData)
+ dataflowTester.VerifyTable(
+ models.GitlabAccount{},
+ fmt.Sprintf("./snapshot_tables/%s.csv",
models.GitlabAccount{}.TableName()),
+ []string{
+ "connection_id",
+ "gitlab_id",
+ "username",
+ "email",
+ "name",
+ "state",
+ "membership_state",
+ "avatar_url",
+ "web_url",
+ "_raw_data_params",
+ "_raw_data_table",
+ "_raw_data_id",
+ "_raw_data_remark",
+ },
+ )
+
+ // verify conversion
+ dataflowTester.FlushTabler(&crossdomain.Account{})
+ dataflowTester.Subtask(tasks.ConvertAccountMeta, taskData)
+ dataflowTester.VerifyTable(
+ crossdomain.Account{},
+ fmt.Sprintf("./snapshot_tables/%s.csv",
crossdomain.Account{}.TableName()),
+ []string{
+ "id",
+ "_raw_data_params",
+ "_raw_data_table",
+ "_raw_data_id",
+ "_raw_data_remark",
+ "email",
+ "full_name",
+ "user_name",
+ "avatar_url",
+ "organization",
+ "created_date",
+ "status",
+ },
+ )
+}
diff --git a/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_users.csv
b/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_users.csv
new file mode 100644
index 00000000..6ea4c5d4
--- /dev/null
+++ b/plugins/gitlab/e2e/raw_tables/_raw_gitlab_api_users.csv
@@ -0,0 +1,7 @@
+id,params,data,url,input,created_at
+1,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":2436773,""username"":""abc1"",""name"":""Jabc"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"",""web_url"":""https://gitlab.com/abc1"",""access_level"":50,""created_at"":""2018-10-21T01:00:32.162Z"",""created_by"":{""id"":2436773,""username"":""abc1"",""name"":""Jabc"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png";
[...]
+2,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":2994198,""username"":""abc2"",""name"":""abcxx1"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/abc2"",""access_level"":50,""created_at"":""2018-10-22T14:54:36.245Z"",""created_by"":{""id"":2436773,""username"":""abc1"",""name"":""Jabc"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/a
[...]
+3,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":5767011,""username"":""abc3"",""name"":""abcxx2"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/ce5efe9b3acceecd4f3266fad757e6c3?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/abc3"",""access_level"":20,""created_at"":""2020-03-28T13:55:45.722Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/
[...]
+4,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":4646117,""username"":""abc4"",""name"":""abcxx3"",""state"":""active"",""avatar_url"":""https://secure.gravatar.com/avatar/85998e06af031ec6071c64976018bcb2?s=80\u0026d=identicon"",""web_url"":""https://gitlab.com/abc4"",""access_level"":20,""created_at"":""2020-04-16T16:16:09.275Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/
[...]
+5,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":4403812,""username"":""abc5"",""name"":""abcxx4"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png"",""web_url"":""https://gitlab.com/abc5"",""access_level"":20,""created_at"":""2020-04-23T01:02:54.558Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3466461/avatar.p
[...]
+6,"{""ConnectionId"":1,""ProjectId"":12345678}","{""id"":1533989,""username"":""abc6"",""name"":""abcxx5"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png"",""web_url"":""https://gitlab.com/abc6"",""access_level"":40,""created_at"":""2020-09-07T02:54:48.516Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3466461/avatar.p
[...]
diff --git a/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_accounts.csv
b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_accounts.csv
new file mode 100644
index 00000000..212b99ae
--- /dev/null
+++ b/plugins/gitlab/e2e/snapshot_tables/_tool_gitlab_accounts.csv
@@ -0,0 +1,7 @@
+connection_id,gitlab_id,username,email,name,state,membership_state,avatar_url,web_url,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,1533989,abc6,,abcxx5,active,active,https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png,https://gitlab.com/abc6,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,6,
+1,2436773,abc1,,Jabc,active,active,https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png,https://gitlab.com/abc1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,1,
+1,2994198,abc2,,abcxx1,active,active,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?s=80&d=identicon,https://gitlab.com/abc2,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,2,
+1,4403812,abc5,,abcxx4,active,active,https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png,https://gitlab.com/abc5,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,5,
+1,4646117,abc4,,abcxx3,active,active,https://secure.gravatar.com/avatar/85998e06af031ec6071c64976018bcb2?s=80&d=identicon,https://gitlab.com/abc4,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,4,
+1,5767011,abc3,,abcxx2,active,active,https://secure.gravatar.com/avatar/ce5efe9b3acceecd4f3266fad757e6c3?s=80&d=identicon,https://gitlab.com/abc3,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,3,
diff --git a/plugins/gitlab/e2e/snapshot_tables/accounts.csv
b/plugins/gitlab/e2e/snapshot_tables/accounts.csv
new file mode 100644
index 00000000..75a60fa4
--- /dev/null
+++ b/plugins/gitlab/e2e/snapshot_tables/accounts.csv
@@ -0,0 +1,7 @@
+id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,email,full_name,user_name,avatar_url,organization,created_date,status
+gitlab:GitlabAccount:1:1533989,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,6,,,,abcxx5,https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png,,,0
+gitlab:GitlabAccount:1:2436773,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,1,,,,Jabc,https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png,,,0
+gitlab:GitlabAccount:1:2994198,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,2,,,,abcxx1,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?s=80&d=identicon,,,0
+gitlab:GitlabAccount:1:4403812,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,5,,,,abcxx4,https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png,,,0
+gitlab:GitlabAccount:1:4646117,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,4,,,,abcxx3,https://secure.gravatar.com/avatar/85998e06af031ec6071c64976018bcb2?s=80&d=identicon,,,0
+gitlab:GitlabAccount:1:5767011,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,3,,,,abcxx2,https://secure.gravatar.com/avatar/ce5efe9b3acceecd4f3266fad757e6c3?s=80&d=identicon,,,0
diff --git a/plugins/jira/e2e/account_test.go b/plugins/jira/e2e/account_test.go
new file mode 100644
index 00000000..2e9d98ab
--- /dev/null
+++ b/plugins/jira/e2e/account_test.go
@@ -0,0 +1,87 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package e2e
+
+import (
+ "testing"
+
+ "github.com/apache/incubator-devlake/helpers/e2ehelper"
+ "github.com/apache/incubator-devlake/models/domainlayer/crossdomain"
+ "github.com/apache/incubator-devlake/plugins/jira/impl"
+ "github.com/apache/incubator-devlake/plugins/jira/models"
+ "github.com/apache/incubator-devlake/plugins/jira/tasks"
+)
+
+func TestJiraAccountDataFlow(t *testing.T) {
+ var plugin impl.Jira
+ dataflowTester := e2ehelper.NewDataFlowTester(t, "jira", plugin)
+
+ taskData := &tasks.JiraTaskData{
+ Options: &tasks.JiraOptions{
+ ConnectionId: 2,
+ BoardId: 8,
+ },
+ }
+
+ // import raw data table
+
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_jira_api_users.csv",
"_raw_jira_api_users")
+
+ // verify issue extraction
+ dataflowTester.FlushTabler(&models.JiraAccount{})
+ dataflowTester.Subtask(tasks.ExtractAccountsMeta, taskData)
+ dataflowTester.VerifyTable(
+ models.JiraAccount{},
+ "./snapshot_tables/_tool_jira_accounts.csv",
+ []string{
+ "_raw_data_params",
+ "_raw_data_table",
+ "_raw_data_id",
+ "_raw_data_remark",
+ "connection_id",
+ "account_id",
+ "account_type",
+ "name",
+ "email",
+ "avatar_url",
+ "timezone",
+ },
+ )
+
+ // verify board conversion
+ dataflowTester.FlushTabler(&crossdomain.Account{})
+ dataflowTester.Subtask(tasks.ConvertAccountsMeta, taskData)
+ dataflowTester.VerifyTable(
+ crossdomain.Account{},
+ "./snapshot_tables/accounts.csv",
+ []string{
+ "id",
+ "_raw_data_params",
+ "_raw_data_table",
+ "_raw_data_id",
+ "_raw_data_remark",
+ "email",
+ "full_name",
+ "user_name",
+ "avatar_url",
+ "organization",
+ "created_date",
+ "status",
+ },
+ )
+
+}
diff --git a/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv
b/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv
new file mode 100644
index 00000000..a7be9cbb
--- /dev/null
+++ b/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv
@@ -0,0 +1,31 @@
+connection_id,account_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,account_type,name,email,avatar_url,timezone
+2,557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812102,,app,"BigPicture
- for ppm, project
management",,https://secure.gravatar.com/avatar/97f7c79b50890409584990ddde1920b3?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FBM-1.png,Asia/Shanghai
+2,557058:f58131cb-b67d-43c7-b30d-6b58d40bd077,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812101,,app,Automation
for
Jira,,https://secure.gravatar.com/avatar/600529a9c8bfef89daa848e6db28ed2d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FAJ-0.png,Asia/Shanghai
+2,5e9711ba34f7b90c0fbc37d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812103,,atlassian,Rankin
Zheng,,https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FRZ-5.png,Asia/Shanghai
+2,5ecfbd0947d31e0c2a15fd83,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812104,,atlassian,yongfeng,,https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-0.png,Asia/Shanghai
+2,5ecfbd0984083c0c12e5af8f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812105,,atlassian,lin.hao,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a-f7e809e2a1b0/48,Asia/Shanghai
+2,5ecfbd0a47d31e0c2a15fd87,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812106,,atlassian,yuxiang,,https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-5.png,Asia/Shanghai
+2,5ecfbd0aaa47a00c1997ea8e,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812107,,atlassian,chao.cheng,,https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-4.png,Asia/Shanghai
+2,5ecfbd0b0827650c1eeb2ab6,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812108,,atlassian,eureka,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07-b6bd84b34e5f/48,Asia/Shanghai
+2,5ecfbd0ba04d9c0c220c18d8,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812109,,atlassian,yanghui,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11-ee4e76e2e0b1/48,Asia/Shanghai
+2,5ecfbd0beb77320c1f821a26,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812110,,atlassian,Wei
Qi,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0-a3ee63ef5455/48,Asia/Shanghai
+2,5ecfbd0c2490cf0c09e2e598,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812111,,atlassian,Gerile
Tu,,https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGT-1.png,Asia/Shanghai
+2,5ecfbd0c730ec90c1999cadf,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812112,,atlassian,Dingding
Zhang,,https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FDZ-1.png,Asia/Shanghai
+2,5eec896fe571480ac2ae6ede,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812113,,atlassian,Jingyang,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f-2e7c16be5257/48,Asia/Shanghai
+2,5eef5ae43589f00ab40dc60f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812114,,atlassian,Jinglei
Ren,,https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJR-4.png,Asia/Shanghai
+2,5eef5ae43589f00ab40dc611,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812115,,atlassian,Emma
Zou,,https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FEZ-5.png,Asia/Shanghai
+2,5ef16f3e7e95e80a81fedc0a,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812116,,atlassian,Zhengjia
Cao,,https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FZC-2.png,Asia/Shanghai
+2,5ef3254a8624070abc590972,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812117,,atlassian,郭锐,,https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png,Asia/Shanghai
+2,5f032527e407a4001cf04d5c,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812118,,atlassian,Han
Tian,,https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHT-0.png,Asia/Shanghai
+2,5f05f5b15ee2c300233b4436,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812119,,atlassian,Hezheng
Yin,,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHY-1.png,Asia/Shanghai
+2,5f184c6dd680320021c3f8a1,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812120,,atlassian,Shiwen
Luo,,https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FSL-4.png,Asia/Shanghai
+2,5f32012eea5e2f0039284885,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812121,,atlassian,Gu
Huiqin,,https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGH-5.png,Asia/Shanghai
+2,5f32012f347294003ed909fb,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812122,,atlassian,Mingjing,,https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FM-4.png,Asia/Shanghai
+2,5f586b28df83ab007d759bfa,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812123,,atlassian,shikunming,,https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FS-5.png,Asia/Shanghai
+2,5f5ede6f3242e8006f3bd173,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812124,,atlassian,Yi
Xiang,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11-0d743c70bb4e/48,Asia/Shanghai
+2,5f6c41784147d6007749dd66,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812125,,atlassian,Nicholas
Zheng,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee-c42e2ccc8676/48,Asia/Shanghai
+2,5f73f85158899e007055c7d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812126,,atlassian,Carrie,,https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-6.png,Asia/Shanghai
+2,5f8d380729bd8a006f5a90a0,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812127,,atlassian,jinxiu,,https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJ-0.png,Asia/Shanghai
+2,5fa8b6d142ab3b006eaa6f42,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812128,,atlassian,cong
wang,[email protected],https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89-0cd1deeec098/48,Asia/Shanghai
+2,5fab870b7cfc240071f37525,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812129,,atlassian,Jiewei
Ye,,https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJY-3.png,Asia/Shanghai
+2,5fb48fe20d2f61006f0d0106,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812130,,atlassian,Runjuu,[email protected],https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3-fba86afe140d/48,Asia/Shanghai
diff --git a/plugins/jira/e2e/snapshot_tables/accounts.csv
b/plugins/jira/e2e/snapshot_tables/accounts.csv
new file mode 100644
index 00000000..41a3c45c
--- /dev/null
+++ b/plugins/jira/e2e/snapshot_tables/accounts.csv
@@ -0,0 +1,31 @@
+id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,email,full_name,user_name,avatar_url,organization,created_date,status
+jira:JiraAccount:2:557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812102,,,,"BigPicture
- for ppm, project
management",https://secure.gravatar.com/avatar/97f7c79b50890409584990ddde1920b3?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FBM-1.png,,,0
+jira:JiraAccount:2:557058:f58131cb-b67d-43c7-b30d-6b58d40bd077,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812101,,,,Automation
for
Jira,https://secure.gravatar.com/avatar/600529a9c8bfef89daa848e6db28ed2d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FAJ-0.png,,,0
+jira:JiraAccount:2:5e9711ba34f7b90c0fbc37d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812103,,,,Rankin
Zheng,https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FRZ-5.png,,,0
+jira:JiraAccount:2:5ecfbd0947d31e0c2a15fd83,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812104,,,,yongfeng,https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-0.png,,,0
+jira:JiraAccount:2:5ecfbd0984083c0c12e5af8f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812105,,,,lin.hao,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a-f7e809e2a1b0/48,,,0
+jira:JiraAccount:2:5ecfbd0a47d31e0c2a15fd87,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812106,,,,yuxiang,https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-5.png,,,0
+jira:JiraAccount:2:5ecfbd0aaa47a00c1997ea8e,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812107,,,,chao.cheng,https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-4.png,,,0
+jira:JiraAccount:2:5ecfbd0b0827650c1eeb2ab6,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812108,,,,eureka,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07-b6bd84b34e5f/48,,,0
+jira:JiraAccount:2:5ecfbd0ba04d9c0c220c18d8,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812109,,,,yanghui,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11-ee4e76e2e0b1/48,,,0
+jira:JiraAccount:2:5ecfbd0beb77320c1f821a26,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812110,,,,Wei
Qi,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0-a3ee63ef5455/48,,,0
+jira:JiraAccount:2:5ecfbd0c2490cf0c09e2e598,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812111,,,,Gerile
Tu,https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGT-1.png,,,0
+jira:JiraAccount:2:5ecfbd0c730ec90c1999cadf,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812112,,,,Dingding
Zhang,https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FDZ-1.png,,,0
+jira:JiraAccount:2:5eec896fe571480ac2ae6ede,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812113,,,,Jingyang,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f-2e7c16be5257/48,,,0
+jira:JiraAccount:2:5eef5ae43589f00ab40dc60f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812114,,,,Jinglei
Ren,https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJR-4.png,,,0
+jira:JiraAccount:2:5eef5ae43589f00ab40dc611,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812115,,,,Emma
Zou,https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FEZ-5.png,,,0
+jira:JiraAccount:2:5ef16f3e7e95e80a81fedc0a,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812116,,,,Zhengjia
Cao,https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FZC-2.png,,,0
+jira:JiraAccount:2:5ef3254a8624070abc590972,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812117,,,,郭锐,https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png,,,0
+jira:JiraAccount:2:5f032527e407a4001cf04d5c,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812118,,,,Han
Tian,https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHT-0.png,,,0
+jira:JiraAccount:2:5f05f5b15ee2c300233b4436,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812119,,,,Hezheng
Yin,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHY-1.png,,,0
+jira:JiraAccount:2:5f184c6dd680320021c3f8a1,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812120,,,,Shiwen
Luo,https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FSL-4.png,,,0
+jira:JiraAccount:2:5f32012eea5e2f0039284885,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812121,,,,Gu
Huiqin,https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGH-5.png,,,0
+jira:JiraAccount:2:5f32012f347294003ed909fb,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812122,,,,Mingjing,https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FM-4.png,,,0
+jira:JiraAccount:2:5f586b28df83ab007d759bfa,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812123,,,,shikunming,https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FS-5.png,,,0
+jira:JiraAccount:2:5f5ede6f3242e8006f3bd173,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812124,,,,Yi
Xiang,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11-0d743c70bb4e/48,,,0
+jira:JiraAccount:2:5f6c41784147d6007749dd66,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812125,,,,Nicholas
Zheng,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee-c42e2ccc8676/48,,,0
+jira:JiraAccount:2:5f73f85158899e007055c7d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812126,,,,Carrie,https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-6.png,,,0
+jira:JiraAccount:2:5f8d380729bd8a006f5a90a0,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812127,,,,jinxiu,https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJ-0.png,,,0
+jira:JiraAccount:2:5fa8b6d142ab3b006eaa6f42,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812128,,[email protected],,cong
wang,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89-0cd1deeec098/48,,,0
+jira:JiraAccount:2:5fab870b7cfc240071f37525,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812129,,,,Jiewei
Ye,https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJY-3.png,,,0
+jira:JiraAccount:2:5fb48fe20d2f61006f0d0106,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812130,,[email protected],,Runjuu,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3-fba86afe140d/48,,,0
![https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"",""web_url"":""https://gitlab.com/abc1"",""access_level"":50,""created_at"":""2018-10-21T01:00:32.162Z"",""created_by"":{""id"":2436773,""username"":""abc1"",""name"":""Jabc"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"](https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"",""web_url"":""https://gitlab.com/abc1"",""access_level"":50,""created_at"":""2018-10-21T01:00:32.162Z"",""created_by"":{""id"":2436773,""username"":""abc1"",""name"":""Jabc"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png"){kind=link}
![https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png"",""web_url"":""https://gitlab.com/abc5"",""access_level"":20,""created_at"":""2020-04-23T01:02:54.558Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3466461/avatar.p](https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png"",""web_url"":""https://gitlab.com/abc5"",""access_level"":20,""created_at"":""2020-04-23T01:02:54.558Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3466461/avatar.p){kind=link}
![https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png"",""web_url"":""https://gitlab.com/abc6"",""access_level"":40,""created_at"":""2020-09-07T02:54:48.516Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3466461/avatar.p](https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png"",""web_url"":""https://gitlab.com/abc6"",""access_level"":40,""created_at"":""2020-09-07T02:54:48.516Z"",""created_by"":{""id"":3466461,""username"":""abc6"",""name"":""abc2e"",""state"":""active"",""avatar_url"":""https://gitlab.com/uploads/-/system/user/avatar/3466461/avatar.p){kind=link}
![https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png,https://gitlab.com/abc6,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,6](https://gitlab.com/uploads/-/system/user/avatar/1533989/avatar.png,https://gitlab.com/abc6,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,6){kind=link}
![https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png,https://gitlab.com/abc1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,1](https://gitlab.com/uploads/-/system/user/avatar/2436773/avatar.png,https://gitlab.com/abc1,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,1){kind=link}
![https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png,https://gitlab.com/abc5,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,5](https://gitlab.com/uploads/-/system/user/avatar/4403812/avatar.png,https://gitlab.com/abc5,"{""ConnectionId"":1,""ProjectId"":12345678}",_raw_gitlab_api_users,5){kind=link}
