From cd6b3b32698517d04121002f9933c574f640cb40 Mon Sep 17 00:00:00 2001 From: edd Date: Thu, 2 Jul 2009 03:07:36 +0000 Subject: [PATCH] added other category git-svn-id: svn://svn.r-forge.r-project.org/svnroot/cran2deb@268 edb9625f-4e0d-4859-8d74-9fd3b1da38cb --- trunk/exec/diagnose | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/trunk/exec/diagnose b/trunk/exec/diagnose index cd1e896..b696929 100755 --- a/trunk/exec/diagnose +++ b/trunk/exec/diagnose @@ -2,7 +2,8 @@ last='natural join (select system,package,max(id) as id from builds where package not in (select package from blacklist_packages) group by package,system)' echo blacklist: -sqlite3 -header -column /var/cache/cran2deb/cran2deb.db "select count(*) as total_blacklist,sum(nonfree) as num_nonfree, sum(obsolete) as num_obsolete, sum(broken_dependency) as num_broke_depend, sum(unsatisfied_dependency) as num_unsat_depend, sum(breaks_cran2deb) as num_break_cran2deb from blacklist_packages;" +#sqlite3 -header -column /var/cache/cran2deb/cran2deb.db "select count(*) as total_blacklist,sum(nonfree) as num_nonfree, sum(obsolete) as num_obsolete, sum(broken_dependency) as num_broke_depend, sum(unsatisfied_dependency) as num_unsat_depend, sum(breaks_cran2deb) as num_break_cran2deb, sum(other) as num_other from blacklist_packages;" +sqlite3 -header -column /var/cache/cran2deb/cran2deb.db "select count(*) as total,sum(nonfree) as nonfree, sum(obsolete) as obsolete, sum(broken_dependency) as broke_depend, sum(unsatisfied_dependency) as unsat_depend, sum(breaks_cran2deb) as break_cran2deb, sum(other) as other from blacklist_packages;" echo bad licenses: sqlite3 /var/cache/cran2deb/cran2deb.db "select system,count(package),group_concat(package) from builds $last where success = 0 and log like '%No acceptable license:%' group by system;" -- 2.39.2