[Feature] `activity` of each user in a repo by month

[tyn1998]

Description

Hi OpenDigger community,

In Hypercrx we have a feature called repo's developer network, which consumes data file like: https://oss.x-lab.info/open_digger/github/X-lab2017/open-digger/developer_network.json. With the data in the file, we can know each user's activity in that repo with the time span of 90 days.

Hypercrx is looking forward to datas that has every user's activity in every month for a repo. Maybe the data file is organized in this way:

• https://oss.x-lab.info/open_digger/github/X-lab2017/open-digger/developer-activity.json

and a possible json scheme for a file might look like this:

{
  "2020-08": [["frank-zsy",43.85],["xgdyp",22.36],["longyanz",13.09],["birdflyi",9.83]],
  "2020-09": [["frank-zsy",23.85],["xgdyp",22.36],["longyanz",13.09],["birdflyi",5.83]],
  ...
}

With these data files, Hypercrx can implement features like:

• [Feature] Show the top devleoper and scores. hypertrons/hypertrons-crx#234
• [Feature] A place to show the repo's history most active contributors hypertrons/hypertrons-crx#263
• [Summer2022/OSPP-Project02] Implementation and Injection of Two React Components hypertrons/hypertrons-crx#348

These data can be generated when repo's activity is computed, right? Not cost too much?

[open-digger-bot]

This issue has not been replied for 24 hours, please pay attention to this issue: @gymgym1212 @xiaoya-yaya @xgdyp

[frank-zsy]

@tyn1998 The network data is generated from Neo4j database while relationship data can be extracted more easily. I think the detail can be retrieved from ClickHouse when activity metric is generated.

Right now the repo activity metric function does not return any details about the developers but actually we can add an option to query option so the query will return the detail about developers. So the data can be generated while activity metric is generated. It can be done of course.

[frank-zsy]

/self-assign

[frank-zsy]

@tyn1998 Could you take a look on this file: https://oss.x-lab.info/open_digger/github/X-lab2017/open-digger/activity_details.json , does it fit your requirement?

[tyn1998]

@frank-zsy

That is exactly what we want, thank you!

[frank-zsy]

@tyn1998 All the data has been uploaded, but the data size is quite large compare with former data, like for vscode, the activity details contains 3MB data.

I think we should limit how many developers will be contained in a single month, this will reduce lots of storage usage.