缺陷 #15368

hudongyang 更新于 2018-04-26 20:51

之前版本:

1.1、统计了rails项目(repo_id=1334)中一共具有11085条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1334 AND pull_request=0;)。

1.2、rails项目中11085条issues一共有62704条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1334);)

1.3、62704条comments一共有9371个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )

1.4、9371个users中有2952个users会对不同的issues进行评论。2952/9371=31.5%




2.1、统计了Khan/khan-exercises项目(repo_id=10408)中一共具有139229条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=10408 AND pull_request=0;)。
2.2、Khan/khan-exercises项目中139229条issues一共有91947条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_10408);)
2.3、91947条comments一共有个688不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、688个users中有316个users会对不同的issues进行评论。316/688=45.9%



3.1、统计了TrinityCore/TrinityCore项目(repo_id=1717)中一共具有17532条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
3.2、TrinityCore/TrinityCore项目中17532条issues一共有条80067comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1717);)
3.3、80067条comments一共有2788个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1717`; )
3.4、2788个users中有1657个users会对不同的issues进行评论。1657/2788=59.4%



4.1、统计了saltstack/salt项目(repo_id=1142)中一共具有17465条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
4.2、saltstack/salt项目中17465条issues一共有93205条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1142);)
4.3、93205条comments一共有5494个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、5494个users中有2601个users会对不同的issues进行评论。2601/5494=47.3%








当前版本:

1.1、统计了rails项目(repo_id=1334)中一共具有11085条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1334 AND pull_request=0;)。

1.2、rails项目中11085条issues一共有62704条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1334);)

1.3、62704条comments一共有9371个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )

1.4、9371个users中有2952个users会对不同的issues进行评论。2952/9371=31.5%




2.1、统计了Khan/khan-exercises项目(repo_id=10408)中一共具有139229条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=10408 AND pull_request=0;)。
2.2、Khan/khan-exercises项目中139229条issues一共有91947条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_10408);)
2.3、91947条comments一共有个688不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、688个users中有316个users会对不同的issues进行评论。316/688=45.9%



3.1、统计了TrinityCore/TrinityCore项目(repo_id=1717)中一共具有17532条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
3.2、TrinityCore/TrinityCore项目中17532条issues一共有条80067comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1717);)
3.3、80067条comments一共有2788个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1717`; )
3.4、2788个users中有1657个users会对不同的issues进行评论。1657/2788=59.4%



4.1、统计了saltstack/salt项目(repo_id=1142)中一共具有17465条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
4.2、saltstack/salt项目中17465条issues一共有93205条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1142);)
4.3、93205条comments一共有5494个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、5494个users中有2601个users会对不同的issues进行评论。2601/5494=47.3%








返回

© Copyright 2007~2021 国防科技大学Trustie团队 & IntelliDE 湘ICP备 17009477号

问题和建议
还能输入50个字符 提交

加入QQ群

关注微信APP


×