Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

top committers by repo? #120

Closed
swills opened this issue Jul 12, 2019 · 5 comments

Comments

@swills
Copy link

commented Jul 12, 2019

Is this page:

https://www.freshports.org/graphs2.php

only for ports commits? or is there a page that shows top committers by repo (src/ports/doc)?

@swills

This comment has been minimized.

Copy link
Author

commented Jul 12, 2019

The numbers there look to be for all repos, src/ports/doc. Please make this graph show only ports, or make separate graphs for each repo.

@dlangille

This comment has been minimized.

Copy link
Contributor

commented Jul 13, 2019

@dlangille

This comment has been minimized.

Copy link
Contributor

commented Jul 13, 2019

This is for the database:

insert into graphs (title, query, label, is_clickable, json) values ('Top 10 Committers - ports', 
'
  SELECT CL.committer, count(*) AS count
    FROM commit_log CL, repo R
   WHERE CL.repo_id = R.id
     AND R.name     = ''ports''
GROUP BY CL.committer
ORDER BY count(*) DESC
   LIMIT 10
',
'top10committers_ports()',
false,
true);


insert into graphs (title, query, label, is_clickable, json) values ('Top 10 Committers - doc', 
'
  SELECT CL.committer, count(*) AS count
    FROM commit_log CL, repo R
   WHERE CL.repo_id = R.id
     AND R.name     = ''doc''
GROUP BY CL.committer
ORDER BY count(*) DESC
   LIMIT 10
',
'top10committers_doc()',
false,
true);
insert into graphs (title, query, label, is_clickable, json) values ('Top 10 Committers - src', 
'
  SELECT CL.committer, count(*) AS count
    FROM commit_log CL, repo R
   WHERE CL.repo_id = R.id
     AND R.name     = ''src''
GROUP BY CL.committer
ORDER BY count(*) DESC
   LIMIT 10
',
'top10committers_src()',
false,
true);

@dlangille dlangille closed this in f7f18c6 Jul 13, 2019

@dlangille

This comment has been minimized.

Copy link
Contributor

commented Jul 13, 2019

@dlangille

This comment has been minimized.

Copy link
Contributor

commented Jul 28, 2019

Now in production

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.