S Package state
s Time in this state in full seconds since epoch
t time of state change
+T time since state change
u Builder (e.g. buildd_mipsel-rem)
v Package version
V full Package version (i.e. with +b.., = %v%{+b}B%B
'B' => make_fmt( sub { return $pkg->{'binary_nmu_version'} if defined $pkg->{'binary_nmu_version'}; }, $pkg, $var),
'd' => make_fmt( $pkg->{'distribution'}, $pkg, $var),
't' => make_fmt( $pkg->{'state_change'}, $pkg, $var),
+ 'T' => make_fmt( sub { return seconds2time(time() - floor(str2time($pkg->{'state_change'}))); }, $pkg, $var),
'o' => make_fmt( $pkg->{'successtime'}, $pkg, $var),
'O' => make_fmt( sub { return seconds2time ( $pkg->{'successtime'}); }, $pkg, $var),
'q' => make_fmt( $pkg->{'anytime'}, $pkg, $var),
return $result;
}
+
+sub greparch {
+ my ($gapkglong, $gaarch) = @_;
+ my ($gapkg, $gaarchs) = split(/ \[/, $gapkglong);
+ if ($gaarchs) {
+ $_ = $gapkg;
+ chop($gaarchs); # take away the ]
+ my @gaarches = split(/ /, $gaarchs);
+ if (substr($gaarches[0], 0, 1) eq '!') {
+ return 0 if grep /^!$gaarch$/, @gaarches;
+ } else { # positive case
+ return 0 unless grep /^$gaarch$/, @gaarches;
+ }
+ };
+ return 1;
+}
+sub filterarch {
+ my $faarch = $_[1];
+ return join(', ', grep { &greparch($_, $faarch) } split(/, ?/, $_[0]));
+}
+
+sub wb_edos_builddebcheck {
+# Copyright (C) 2008 Ralf Treinen <treinen@debian.org>
+# This program is free software: you can redistribute it and/or modify it under
+# the terms of the GNU General Public License as published by the Free Software
+# Foundation, version 2 of the License.
+# integrated into wanna-builds code by Andreas Barth 2010
+
+ my $args = shift;
+ my $sourceprefix="source---";
+ my $architecture=$args->{'arch'};
+ my $edosoptions = "-failures -explain -quiet";
+ my @packagefiles = $args->{'pkgs'};
+ my $sourcesfile = $args->{'src'};
+
+ my $packagearch="";
+ foreach my $packagefile (@packagefiles) {
+ open(P,$packagefile);
+ while (<P>) {
+ next unless /^Architecture/;
+ next if /^Architecture:\s*all/;
+ /Architecture:\s*([^\s]*)/;
+ if ($packagearch eq "") {
+ $packagearch = $1;
+ } elsif ( $packagearch ne $1) {
+ return "Package file contains different architectures: $packagearch, $1";
+ }
+ }
+ close P;
+ }
+
+ if ( $architecture eq "" ) {
+ if ( $packagearch eq "" ) {
+ return "No architecture option given, " .
+ "and no non-all architecture found in the Packages file";
+ } else {
+ $architecture = $packagearch;
+ }
+ } else {
+ if ( $packagearch ne "" & $architecture ne $packagearch) {
+ return "Architecture option is $architecture ".
+ "but the package file contains architecture $packagearch";
+ }
+ }
+
+ print "calling: edos-debcheck $edosoptions < $sourcesfile ".join('', map {" '-base FILE' ".$_ } @packagefiles);
+ open(RESULT, '-|',
+ "edos-debcheck $edosoptions < $sourcesfile ".join('', map {" '-base FILE' ".$_ } @packagefiles));
+
+ my $explanation="";
+ my $result={};
+ my $binpkg="";
+
+ while (<RESULT>) {
+# source---pulseaudio (= 0.9.15-4.1~bpo50+1): FAILED
+# source---pulseaudio (= 0.9.15-4.1~bpo50+1) depends on missing:
+# - libltdl-dev (>= 2.2.6a-2)
+# source---libcanberra (= 0.22-1~bpo50+1): FAILED
+# source---libcanberra (= 0.22-1~bpo50+1) depends on missing:
+# - libltdl-dev
+# - libltdl7-dev (>= 2.2.6)
+
+ if (/^\s+/) {
+ s/^(\s*)$sourceprefix(.*)depends on/$1$2build-depends on/o;
+ s/^(\s*)$sourceprefix(.*) and (.*) conflict/$1$2 build-conflicts with $3/o;
+ $explanation .= $_;
+ } else {
+ if (/^$sourceprefix(.*) \(.*\): FAILED/o) {
+ $result->{$binpkg} = $explanation if $binpkg;
+ $explanation = "";
+ $binpkg = $1;
+ } # else something broken is happening
+ }
+ }
+
+ close RESULT;
+ $result->{$binpkg} = $explanation if $binpkg;
+ return $result;
+
+}
+
+
sub call_edos_depcheck {
my $packagesfile = shift;
my $srcs = shift;
#print "I would look at these sources with edos-depcheck:\n";
#print join " ", keys %interesting_packages,"\n";
+ return unless %interesting_packages;
- my $tmpfile_pattern = "/tmp/wanna-build-interesting-sources-$distribution.$$-";
- my ($tmpfile, $i);
- for( $i = 0;; ++$i ) {
- $tmpfile = $tmpfile_pattern . $i;
- last if ! -e $tmpfile;
- }
-
- open SOURCES, '>', $tmpfile or die "Could not open temporary file $tmpfile\n";
+ my $tmpfile_pattern = "/tmp/wanna-build-interesting-sources-$distribution.$$-XXXXX";
+ use File::Temp qw/ tempfile /;
+ my ($SOURCES, $tmpfile) = tempfile( $tmpfile_pattern, UNLINK => 1 );
for my $key (keys %interesting_packages) {
my $pkg = $db->{$key};
- print SOURCES "Package: $key\n";
- print SOURCES "Version: $pkg->{'version'}\n";
- print SOURCES "Build-Depends: $srcs->{$key}{'dep'}\n" if $srcs->{$key}{'dep'};
- print SOURCES "Build-Conflicts: $srcs->{$key}{'conf'}\n" if $srcs->{$key}{'conf'};
- print SOURCES "Architecture: all\n";
- print SOURCES "\n";
+ # we print the source files as binary ones (with "source---"-prefixed),
+ # so we can try if these "binary" packages are installable.
+ # If such a "binary" package is installable, the corresponding source package is buildable.
+ print $SOURCES "Package: source---$key\n";
+ print $SOURCES "Version: $pkg->{'version'}\n";
+ my $t = &filterarch($srcs->{$key}{'dep'}, $arch);
+ print $SOURCES "Depends: $t\n" if $t;
+ my $u = &filterarch($srcs->{$key}{'conf'}, $arch);
+ print $SOURCES "Conflicts: $u\n" if $u;
+ print $SOURCES "Architecture: all\n";
+ print $SOURCES "\n";
}
- close SOURCES;
-
- if (open(EDOS,"-|","wb-edos-builddebcheck", "-a", $arch, $packagesfile, $tmpfile))
- {
- local($/) = ""; # read in paragraph mode
- while( <EDOS> ) {
- my( $key, $reason ) ;
- s/\s*$//m;
- /^Package:\s*(\S+)$/mi and $key = $1;
- /^Failed-Why:(([^\n]|\n ([^\n]|\.))*)$/msi and $reason = $1;
- $reason =~ s/^\s*//mg;
- $reason ||= 'No reason given by edos-debcheck';
+ close $SOURCES;
+ my $edosresults = wb_edos_builddebcheck({'arch' => $arch, 'pkgs' => [$packagesfile], 'src' => $tmpfile});
+ if (ref($edosresults) eq 'HASH') {
+ foreach my $key (keys %$edosresults) {
if (exists $interesting_packages{$key}) {
- $interesting_packages{$key} = $reason;
+ $interesting_packages{$key} = $edosresults->{$key};
} else {
#print "TODO: edos reported a package we do not care about now\n" if $verbose;
}
- }
- close EDOS;
+ }
} else {
- print "ERROR: Could not run wb-edos-builddebcheck. I am continuing, assuming\n" .
- "all packages have installable build-dependencies."
+ # if $edosresults isn't an hash, then something went wrong and the string is the error message
+ print "ERROR: Could not run wb-edos-builddebcheck. I am continuing, assuming\n" .
+ "all packages have installable build-dependencies."
}
unlink( $tmpfile );
my %options = @_;
my $q = "SELECT rel, priority, state_change, permbuildpri, section, buildpri, failed, state, binary_nmu_changelog, bd_problem, version, package, distribution, installed_version, notes, failed_category, builder, old_failed, previous_state, binary_nmu_version, depends, extract(days from date_trunc('days', now() - state_change)) as state_days"
- . ", (SELECT max(build_time) FROM ".pkg_history_table_name()." WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution AND result = 'successful') AS successtime"
- . ", (SELECT max(build_time) FROM ".pkg_history_table_name()." WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution ) AS anytime"
+# . ", (SELECT max(build_time) FROM ".pkg_history_table_name()." WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution AND result = 'successful') AS successtime"
+# . ", (SELECT max(build_time) FROM ".pkg_history_table_name()." WHERE pkg_history.package = packages.package AND pkg_history.distribution = packages.distribution ) AS anytime"
+ . ", successtime.build_time as successtime, anytime.build_time as anytime"
. " FROM " . table_name()
+ . " left join ( "
+ . "select distinct on (package, distribution) build_time, package, distribution from ".pkg_history_table_name()." where result = 'successful' order by package, distribution, timestamp "
+ . " ) as successtime using (package, distribution) "
+ . " left join ( "
+ . "select distinct on (package, distribution) build_time, package, distribution from ".pkg_history_table_name()." order by package, distribution, timestamp desc"
+ . " ) as anytime using (package, distribution) "
. " WHERE TRUE ";
my @args = ();
if ($distribution) {
push @args, uc($options{state});
}
- if ($options{user}) {
+ if ($options{user} && uc($options{state}) ne "NEEDS-BUILD") { # if it's NEEDS-BUILD, we don't look at users
#this basically means "this user, or no user at all":
- $q .= ' AND (builder = ? OR upper(state) = ?)';
+ $q .= " AND (builder = ? OR upper(state) = 'NEEDS-BUILD')";
push @args, $options{user};
- push @args, "NEEDS-BUILD";
}
if ($options{category}) {
projects / wannabuild.git / blobdiff