Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Alias (5735)

Alias
  (email not shown publicly)
http://ali.as/

Journal of Alias (5735)

Wednesday July 08, 2009
08:12 PM

CPANDB Tricks: Your personal version of the FAIL 100

[ #39258 ]

You may have seen my FAIL 100 list of modules, the 100 modules who's failure in CPAN Testers cause the most pain to other people.

Now that I have support for CPAN Testers results in the CPANDB schema, it's now easy to replicate the math I was doing on that website in one SQL script.

Here's a quickie report of all the modules that I maintain that have failures causing problems for other people (which is a pretty decent clue to the order in which I need to fix them).

Please excuse the weird indenting, I have no idea how Slashcode managed to achieve that...

use CPANDB;
 
print map {
    sprintf("%4s %s\n", $_->[1], $_->[0])
} @{
    CPANDB->selectall_arrayref(
        'select distribution, (fail + unknown) * volatility as FAILure
         from distribution
         where author = "ADAMK"
         and
         FAILure > 0
         order by FAILure desc'
    )
}
 
9460 PPI
4389 DBD-SQLite
3237 IPC-Run
1407 File-HomeDir
  484 Test-ClassAPI
  396 prefork
  345 SMS-Send
  334 File-Remove
  289 Config-Tiny
  240 Class-Autouse
  217 File-ShareDir
  150 LWP-Online
  74 Devel-Dumpvar
  73 Test-Script
  68 Test-Inline
  60 Perl-Squish
  58 PITA-POE-SupportServer
  53 Module-CGI-Install
  38 ORLite-Migrate
  37 Module-Extract
  36 Module-Inspector
  28 Chart-Math-Axis
  24 Test-File-Cleaner
  20 PITA-XML
  15 PITA-Scheme
  15 Portable-Dist
  14 Xtract
  10 CSS-Tiny
  10 JSAN-Client
  10 PPI-HTML
   8 CPAN-Inject
   8 File-UserConfig
   7 PITA
   6 PITA-Test-Dummy-Perl5-Build
   6 Perl-Metrics
   4 Method-Alias
   4 Test-NeedsDisplay
   3 Algorithm-Dependency-Source-DBI
   3 Archive-Builder
   3 Data-Package
   3 JavaScript-Librarian
   2 CGI-Capture
   2 PITA-Image
   1 PITA-Test-Dummy-Perl5-MI
   1 PITA-Test-Dummy-Perl5-Make
   1 POE-Declare
   1 Parse-CPAN-MirroredBy
   1 Perl-Signature

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.