package App::lcpan::Cmd::dzil_authors_by_plugin_count;

our $DATE = '2019-11-20'; # DATE
our $VERSION = '0.060'; # VERSION

use 5.010;
use strict;
use warnings;

require App::lcpan;

our %SPEC;

$SPEC{'handle_cmd'} = {
    v => 1.1,
    summary => 'List authors ranked by number of Dist::Zilla plugins',
    args => {
sub handle_cmd {
    my %args = @_;

    my $cpan = $args{cpan};
    my $index_name = $args{index_name};

    my $dbh = App::lcpan::_connect_db('ro', $cpan, $index_name);

    my $sql = "SELECT
  cpanid author,
  COUNT(*) AS mod_count
FROM module m
WHERE LIKE 'Dist::Zilla::Plugin::%'
GROUP BY cpanid
ORDER BY mod_count DESC

    my @res;
    my $sth = $dbh->prepare($sql);
    while (my $row = $sth->fetchrow_hashref) {
        push @res, $row;
    my $resmeta = {};
    $resmeta->{'table.field'} = [qw/author mod_count/];
    [200, "OK", \@res, $resmeta];

# ABSTRACT: List authors ranked by number of Dist::Zilla plugins



=encoding UTF-8

=head1 NAME

App::lcpan::Cmd::dzil_authors_by_plugin_count - List authors ranked by number of Dist::Zilla plugins

=head1 VERSION

This document describes version 0.060 of App::lcpan::Cmd::dzil_authors_by_plugin_count (from Perl distribution App-lcpan-CmdBundle-dzil), released on 2019-11-20.


This module handles the L<lcpan> subcommand C<dzil-authors-by-plugin-count>.


=head2 handle_cmd


 handle_cmd(%args) -> [status, msg, payload, meta]

List authors ranked by number of Dist::Zilla plugins.

This function is not exported.

Arguments ('*' denotes required arguments):

=over 4

=item * B<cpan> => I<dirname>

Location of your local CPAN mirror, e.g. /path/to/cpan.

Defaults to C<~/cpan>.

=item * B<index_name> => I<filename> (default: "index.db")

Filename of index.

If C<index_name> is a filename without any path, e.g. C<index.db> then index will
be located in the top-level of C<cpan>. If C<index_name> contains a path, e.g.
C<./index.db> or C</home/ujang/lcpan.db> then the index will be located solely
using the C<index_name>.

=item * B<use_bootstrap> => I<bool> (default: 1)

Whether to use bootstrap database from App-lcpan-Bootstrap.

If you are indexing your private CPAN-like repository, you want to turn this


Returns an enveloped result (an array).

First element (status) is an integer containing HTTP status code
(200 means OK, 4xx caller error, 5xx function error). Second element
(msg) is a string containing error message, or 'OK' if status is
200. Third element (payload) is optional, the actual result. Fourth
element (meta) is called result metadata and is optional, a hash
that contains extra information.

Return value:  (any)


Please visit the project's homepage at L<>.

=head1 SOURCE

Source repository is at L<>.

=head1 BUGS

Please report any bugs or feature requests on the bugtracker website L<>

When submitting a bug or request, please include a test-file or a
patch to an existing test-file that illustrates the bug or desired

=head1 AUTHOR

perlancar <>


This software is copyright (c) 2019, 2017, 2016, 2015 by

This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.