3 # wanna-build: coordination script for Debian buildds
4 # Copyright (C) 1998 Roman Hodek <Roman.Hodek@informatik.uni-erlangen.de>
5 # Copyright (C) 2005-2008 Ryan Murray <rmurray@debian.org>
7 # This program is free software; you can redistribute it and/or
8 # modify it under the terms of the GNU General Public License as
9 # published by the Free Software Foundation; either version 2 of the
10 # License, or (at your option) any later version.
12 # This program is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15 # General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with this program; if not, write to the Free Software
19 # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
24 $basedir ||= "/var/lib/debbuild";
25 $dbbase ||= "build-db";
26 $transactlog ||= "transactions.log";
27 #$mailprog ||= "/usr/sbin/sendmail";
28 $mailprog = "/bin/true";
29 require "/etc/wanna-build.conf";
30 die "$conf::basedir is not a directory\n" if ! -d $conf::basedir;
31 die "dbbase is empty\n" if ! $dbbase;
32 die "transactlog is empty\n" if ! $transactlog;
33 die "mailprog binary $conf::mailprog does not exist or isn't executable\n"
34 if !-x $conf::mailprog;
35 die "no distributions defined\n" if ! %distributions;
45 our ($verbose, $mail_logs, $list_order, $list_state,
46 $curr_date, $op_mode, $user, $real_user, $distribution,
47 $fail_reason, $opt_override, $import_from, $opt_create_db,
49 $info_all_dists, $arch,
50 $category, %catval, %short_category,
51 $short_date, $list_min_age, $dbbase, @curr_time,
52 $build_priority, %new_vers, $binNMUver, %merge_srcvers, %merge_binsrc);
55 $ENV{'PATH'} = "/bin:/usr/bin:/usr/local/bin:/org/wanna-build/bin/";
59 $curr_date = strftime("%Y %b %d %H:%M:%S",@curr_time);
60 $short_date = strftime("%m/%d/%y",@curr_time);
63 # map program invocation names to operation modes
64 my %prognames = ( "uploaded-build" => "set-uploaded",
65 "failed-build" => "set-failed",
66 "no-build" => "set-not-for-us",
67 "give-back-build" => "set-needs-build",
68 "dep-wait-build" => "set-dep-wait",
69 "forget-build" => "forget",
70 "merge-quinn" => "merge-quinn",
71 "merge-packages" => "merge-packages",
72 "merge-sources" => "merge-sources",
73 "build-info" => "info" );
75 %short_category = ( u => "uploaded-fixed-pkg",
82 c => "compiler-error",
86 ($progname = $0) =~ s,.*/,,;
87 if ($prognames{$progname}) {
88 $op_mode = $prognames{$progname};
90 elsif ($progname =~ /^list-(.*)$/) {
92 $list_state = ($1 eq "all") ? "" : $1;
97 verbose => { short => "v", flag => \$verbose },
98 override => { short => "o", flag => \$opt_override },
99 "create-db" => { flag => \$opt_create_db },
100 "correct-compare" => { flag => \$WannaBuild::opt_correct_version_cmp },
101 # TODO: remove after buildds no longer pass to wanna-build
102 "no-propagation" => { short => "N" },
103 "no-down-propagation" => { short => "D" },
105 take => { mode => "set-building" },
106 failed => { short => "f", mode => "set-failed" },
107 uploaded => { short => "u", mode => "set-uploaded" },
108 "no-build" => { short => "n", mode => "set-not-for-us" },
109 built => { mode => "set-built" },
110 attempted => { mode => "set-attempted" },
111 "give-back" => { mode => "set-needs-build" },
112 "dep-wait" => { mode => "set-dep-wait" },
113 forget => { mode => "forget" },
114 'forget-user' => { mode => 'forget-user' },
115 "merge-quinn" => { mode => "merge-quinn" },
116 "merge-partial-quinn" => { mode => "merge-partial-quinn" },
117 "merge-packages" => { mode => "merge-packages" },
118 "merge-sources" => { mode => "merge-sources" },
119 "pretend-avail" => { short => "p", mode => "pretend-avail" },
120 "merge-all" => { mode => "merge-all" },
121 info => { short => "i", mode => "info" },
122 'binNMU' => { mode => 'set-binary-nmu', arg => \$binNMUver,
123 code => sub { die "Invalid binNMU version: $binNMUver\n"
124 if $binNMUver !~ /^([\d]*)$/ and $1 >= 0; } },
125 'perm-build-priority' => { mode => "set-permanent-build-priority", arg => \$build_priority,
126 code => sub { die "Invalid build priority: $build_priority\n"
127 if $build_priority !~ /^-?[\d]+$/; } },
128 'build-priority' => { mode => "set-build-priority", arg => \$build_priority,
129 code => sub { die "Invalid build priority: $build_priority\n"
130 if $build_priority !~ /^-?[\d]+$/; } },
132 { short => "l", mode => "list", arg => \$list_state,
134 die "Unknown state to list: $list_state\n"
135 if !isin( $list_state, qw(needs-build building uploaded
136 built build-attempted failed installed dep-wait
137 not-for-us all failed-removed
138 install-wait reupload-wait bd-uninstallable));} },
141 { short => "d", arg => \$distribution,
143 if ($distribution eq "a" || $distribution eq "all") {
148 $distribution = "oldstable" if $distribution eq "o";
149 $distribution = "stable" if $distribution eq "s";
150 $distribution = "testing" if $distribution eq "t";
151 $distribution = "unstable" if $distribution eq "u";
155 { short => "O", arg => \$list_order,
157 die "Bad ordering character\n"
158 if $list_order !~ /^[PSpsncb]+$/;
160 message => { short => "m", arg => \$fail_reason },
161 # database is deprecated, use arch instead.
162 database => { short => "b", arg => \$conf::dbbase },
163 arch => { short => "A", arg => \$arch },
164 user => { short => "U", arg => \$user },
165 category => { short => "c", arg => \$category,
167 $category = $short_category{$category}
168 if exists $short_category{$category};
169 die "Unknown category: $category\n"
170 if !isin( $category, values %short_category );
172 "min-age" => { short => "a", arg => \$list_min_age,
174 die "Argument of --min-age must be a non-zero number\n"
175 if $list_min_age == 0;
176 $list_min_age *= 24*60*60;
178 "max-age" => { arg => \$list_min_age,
180 die "Argument of --max-age must be a non-zero number\n"
181 if $list_min_age == 0;
182 $list_min_age *= -24*60*60;
185 import => { arg => \$import_from, mode => "import" },
186 "manual-edit" => { mode => "manual-edit" },
189 while( @ARGV && $ARGV[0] =~ /^-/ ) {
192 my($opt, $optname, $arg);
193 if (/^--([^=]+)(=|$)/) {
195 $opt = $options{$optname};
196 $arg = $1 if /^--\Q$optname\E=((.|\n)*)$/;
199 $optname = substr( $_, 1, 1 );
200 $opt = (grep { defined($_->{short}) ? $_->{short} eq $optname : 0} values %options)[0];
201 $arg = $1 if /^-$optname(.+)$/;
204 warn "Unknown option: --$1\n";
209 die "$optname option missing argument\n" if !@ARGV;
212 ${$opt->{arg}} = $arg;
214 elsif (defined $arg) {
215 die "Option $optname takes no argument\n";
219 die "Conflicting operation modes\n" if $op_mode;
220 $op_mode = $opt->{mode};
230 $op_mode = $category ? "set-failed" : "set-building"
231 if !$op_mode; # default operation
232 $list_order = $list_state eq "failed" ? 'fPcpsn' : 'PScpsn'
233 if !$list_order and $list_state;
234 $distribution ||= "unstable";
235 die "Bad distribution '$distribution'\n"
236 if !isin($distribution, keys %conf::distributions);
238 # If they didn't specify an arch, try to get it from database name which
239 # is in the form of $arch/build-db
240 # This is for backwards compatibity with older versions that didn't
241 # specify the arch yet.
242 $conf::dbbase =~ m#^([^/]+)#;
245 # TODO: Check that it's an known arch (for that dist), and give
249 my $version = '$Revision: db181a534e9d $ $Date: 2008/03/26 06:20:22 $ $Author: rmurray $';
250 $version =~ s/(^\$| \$ .*$)//g;
251 print "wanna-build $version for $distribution on $arch\n";
254 if (!@ARGV && !isin( $op_mode, qw(list merge-quinn merge-partial-quinn import
255 merge-packages manual-edit
257 warn "No packages given.\n";
261 $real_user = (getpwuid($<))[0];
262 die "Can't determine your user name\n"
263 if $op_mode ne "list" && !$user &&
264 !($user = $real_user);
267 if ($op_mode eq "set-failed" && !$category) {
268 print "Enter reason for failing (end with '.' alone on ".
273 last if $line eq ".\n";
274 $fail_reason .= $line;
276 chomp( $fail_reason );
277 } elsif ($op_mode eq "set-dep-wait") {
278 print "Enter dependencies (one line):\n";
280 while( !$line && !eof(STDIN) ) {
281 chomp( $line = <STDIN> );
283 die "No dependencies given\n" if !$line;
284 $fail_reason = $line;
285 } elsif ($op_mode eq "set-binary-nmu" and $binNMUver > 0) {
286 print "Enter changelog entry (one line):\n";
288 while( !$line && !eof(STDIN) ) {
289 chomp( $line = <STDIN> );
291 die "No changelog entry given\n" if !$line;
292 $fail_reason = $line;
301 $dbh->disconnect or warn $dbh->errstr;
305 $dbh = DBI->connect("DBI:Pg:database=wanna-build") ||
306 die "FATAL: Cannot open database: $DBI::errstr\n";
308 # TODO: This shouldn't be needed, file a bug.
309 $dbh->{pg_server_prepare} = 0;
311 $dbh->begin_work or die $dbh->errstr;
318 if ($mail_logs && $conf::log_mail) {
319 send_mail( $conf::log_mail,
320 "wanna-build $distribution state changes $curr_date",
321 "State changes at $curr_date for distribution ".
322 "$distribution:\n\n$mail_logs\n" );
330 SWITCH: foreach ($op_mode) {
332 add_packages( $1, @ARGV );
336 list_packages( $list_state );
340 info_packages( @ARGV );
343 /^forget-user/ && do {
344 die "This operation is restricted to admin users\n"
345 if (defined @conf::admin_users and
346 !isin( $real_user, @conf::admin_users));
347 forget_users( @ARGV );
351 forget_packages( @ARGV );
354 /^merge-partial-quinn/ && do {
355 die "This operation is restricted to admin users\n"
356 if (defined @conf::admin_users and
357 !isin( $real_user, @conf::admin_users));
361 /^merge-quinn/ && do {
362 die "This operation is restricted to admin users\n"
363 if (defined @conf::admin_users and
364 !isin( $real_user, @conf::admin_users));
368 /^merge-packages/ && do {
369 die "This operation is restricted to admin users\n"
370 if (defined @conf::admin_users and
371 !isin( $real_user, @conf::admin_users));
375 /^merge-sources/ && do {
376 die "This operation is restricted to admin users\n"
377 if (defined @conf::admin_users and
378 !isin( $real_user, @conf::admin_users));
382 /^pretend-avail/ && do {
383 pretend_avail( @ARGV );
387 die "This operation is restricted to admin users\n"
388 if (defined @conf::admin_users and
389 !isin( $real_user, @conf::admin_users));
391 @ARGV = ( $ARGS[0] );
392 my $pkgs = parse_packages();
393 @ARGV = ( $ARGS[1] );
395 @ARGV = ( $ARGS[2] );
396 my $srcs = parse_sources(1);
397 call_edos_depcheck( $ARGS[0], $srcs );
401 die "This operation is restricted to admin users\n"
402 if (defined @conf::admin_users and
403 !isin( $real_user, @conf::admin_users));
404 $dbh->do("DELETE from " . table_name())
407 read_db( $import_from );
411 die "Unexpected operation mode $op_mode\n";
413 if (not -t and $user =~ /-/) {
414 my $userinfo = get_user_info($user);
415 if (!defined $userinfo)
417 add_user_info($user);
421 update_user_info($user);
427 my $newstate = shift;
428 my( $package, $name, $version, $ok, $reason );
430 foreach $package (@_) {
431 $package =~ s,^.*/,,; # strip path
432 $package =~ s/\.(dsc|diff\.gz|tar\.gz|deb)$//; # strip extension
433 $package =~ s/_[a-zA-Z\d-]+\.changes$//; # strip extension
434 if ($package =~ /^([\w\d.+-]+)_([\w\d:.+~-]+)/) {
435 ($name,$version) = ($1,$2);
438 warn "$package: can't extract package name and version ".
443 if ($op_mode eq "set-building") {
444 add_one_building( $name, $version );
446 elsif ($op_mode eq "set-built") {
447 add_one_built( $name, $version );
449 elsif ($op_mode eq "set-attempted") {
450 add_one_attempted( $name, $version );
452 elsif ($op_mode eq "set-uploaded") {
453 add_one_uploaded( $name, $version );
455 elsif ($op_mode eq "set-failed") {
456 add_one_failed( $name, $version );
458 elsif ($op_mode eq "set-not-for-us") {
459 add_one_notforus( $name, $version );
461 elsif ($op_mode eq "set-needs-build") {
462 add_one_needsbuild( $name, $version );
464 elsif ($op_mode eq "set-dep-wait") {
465 add_one_depwait( $name, $version );
467 elsif ($op_mode eq "set-build-priority") {
468 set_one_buildpri( $name, $version, 'buildpri' );
470 elsif ($op_mode eq "set-permanent-build-priority") {
471 set_one_buildpri( $name, $version, 'permbuildpri' );
473 elsif ($op_mode eq "set-binary-nmu") {
474 set_one_binnmu( $name, $version );
479 sub add_one_building {
485 my $pkg = get_source_info($name);
487 if ($pkg->{'state'} eq "Not-For-Us") {
489 $reason = "not suitable for this architecture";
491 elsif ($pkg->{'state'} =~ /^Dep-Wait/) {
493 $reason = "not all source dependencies available yet";
495 elsif ($pkg->{'state'} =~ /^BD-Uninstallable/) {
497 $reason = "source dependencies are not installable";
499 elsif ($pkg->{'state'} eq "Uploaded" &&
500 (version_lesseq($version, $pkg->{'version'}))) {
502 $reason = "already uploaded by $pkg->{'builder'}";
503 $reason .= " (in newer version $pkg->{'version'})"
504 if !version_eq($pkg, $version);
506 elsif ($pkg->{'state'} eq "Installed" &&
507 version_less($version,$pkg->{'version'})) {
509 print "$name: Warning: newer version $pkg->{'version'} ".
510 "already installed, but overridden.\n";
514 $reason = "newer version $pkg->{'version'} already in ".
515 "archive; doesn't need rebuilding";
516 print "$name: Note: If the following is due to an epoch ",
517 " change, use --override\n";
520 elsif ($pkg->{'state'} eq "Installed" &&
521 pkg_version_eq($pkg,$version)) {
523 $reason = "is up-to-date in the archive; doesn't need rebuilding";
525 elsif ($pkg->{'state'} eq "Needs-Build" &&
526 version_less($version,$pkg->{'version'})) {
528 print "$name: Warning: newer version $pkg->{'version'} ".
529 "needs building, but overridden.";
533 $reason = "newer version $pkg->{'version'} needs building, ".
537 elsif (isin($pkg->{'state'},qw(Building Built Build-Attempted))) {
538 if (version_less($pkg->{'version'},$version)) {
539 print "$name: Warning: Older version $pkg->{'version'} ",
540 "is being built by $pkg->{'builder'}\n";
541 if ($pkg->{'builder'} ne $user) {
542 send_mail( $pkg->{'builder'},
543 "package takeover in newer version",
544 "You are building package '$name' in ".
545 "version $version\n".
546 "(as far as I'm informed).\n".
547 "$user now has taken the newer ".
548 "version $version for building.".
549 "You can abort the build if you like.\n" );
554 print "User $pkg->{'builder'} had already ",
555 "taken the following package,\n",
556 "but overriding this as you request:\n";
557 send_mail( $pkg->{'builder'}, "package takeover",
558 "The package '$name' (version $version) that ".
559 "was taken by you\n".
560 "has been taken over by $user\n" );
562 elsif ($pkg->{'builder'} eq $user) {
563 print "$name: Note: already taken by you.\n";
564 print "$name: ok\n" if $verbose;
569 $reason = "already taken by $pkg->{'builder'}";
570 $reason .= " (in newer version $pkg->{'version'})"
571 if !version_eq($pkg->{'version'}, $version);
575 elsif ($pkg->{'state'} =~ /^Failed/ &&
576 pkg_version_eq($pkg, $version)) {
578 print "The following package previously failed ",
579 "(by $pkg->{'builder'})\n",
580 "but overriding this as you request:\n";
581 send_mail( $pkg->{'builder'}, "failed package takeover",
582 "The package '$name' (version $version) that ".
584 "and has failed previously has been taken over ".
586 if $pkg->{'builder'} ne $user;
590 $reason = "build of $version failed previously:\n ";
591 $reason .= join( "\n ", split( "\n", $pkg->{'failed'} ));
592 $reason .= "\nalso the package doesn't need builing"
593 if $pkg->{'state'} eq 'Failed-Removed';
599 if ($pkg->{'binary_nmu_version'}) {
600 print "$name: Warning: needs binary NMU $pkg->{'binary_nmu_version'}\n" .
601 "$pkg->{'Binary-NMU-Changelog'}\n";
604 print "$name: Warning: Previous version failed!\n"
605 if $pkg->{'previous_state'} =~ /^Failed/ ||
606 $pkg->{'state'} =~ /^Failed/;
608 change_state( \$pkg, 'Building' );
609 $pkg->{'package'} = $name;
610 $pkg->{'version'} = $version;
611 $pkg->{'builder'} = $user;
612 log_ta( $pkg, "--take" );
613 update_source_info($pkg);
614 print "$name: $ok\n" if $verbose;
617 print "$name: NOT OK!\n $reason\n";
621 sub add_one_attempted {
624 my $pkg = get_source_info($name);
626 if (!defined($pkg)) {
627 print "$name: not registered yet.\n";
631 if ($pkg->{'state'} ne "Building" ) {
632 print "$name: not taken for building (state is $pkg->{'state'}). ",
636 if ($pkg->{'builder'} ne $user) {
637 print "$name: not taken by you, but by $pkg->{'builder'}. Skipping.\n";
640 elsif ( !pkg_version_eq($pkg, $version) ) {
641 print "$name: version mismatch ".
642 "$(pkg->{'version'} ".
643 "by $pkg->{'builder'})\n";
647 change_state( \$pkg, 'Build-Attempted' );
648 log_ta( $pkg, "--attempted" );
649 update_source_info($pkg);
650 print "$name: registered as uploaded\n" if $verbose;
656 my $pkg = get_source_info($name);
658 if (!defined($pkg)) {
659 print "$name: not registered yet.\n";
663 if ($pkg->{'state'} ne "Building" ) {
664 print "$name: not taken for building (state is $pkg->{'state'}). ",
668 if ($pkg->{'builder'} ne $user) {
669 print "$name: not taken by you, but by $pkg->{'builder'}. Skipping.\n";
672 elsif ( !pkg_version_eq($pkg, $version) ) {
673 print "$name: version mismatch ".
674 "$(pkg->{'version'} ".
675 "by $pkg->{'builder'})\n";
678 change_state( \$pkg, 'Built' );
679 log_ta( $pkg, "--built" );
680 update_source_info($pkg);
681 print "$name: registered as built\n" if $verbose;
684 sub add_one_uploaded {
687 my $pkg = get_source_info($name);
689 if (!defined($pkg)) {
690 print "$name: not registered yet.\n";
694 if ($pkg->{'state'} eq "Uploaded" &&
695 pkg_version_eq($pkg,$version)) {
696 print "$name: already uploaded\n";
699 if (!isin( $pkg->{'state'}, qw(Building Built Build-Attempted))) {
700 print "$name: not taken for building (state is $pkg->{'state'}). ",
704 if ($pkg->{'builder'} ne $user) {
705 print "$name: not taken by you, but by $pkg->{'builder'}. Skipping.\n";
708 # strip epoch -- buildd-uploader used to go based on the filename.
709 # (to remove at some point)
711 ($pkgver = $pkg->{'version'}) =~ s/^\d+://;
712 $version =~ s/^\d+://; # for command line use
713 if ($pkg->{'binary_nmu_version'} ) {
714 my $nmuver = binNMU_version($pkgver, $pkg->{'binary_nmu_version'});
715 if (!version_eq( $nmuver, $version )) {
716 print "$name: version mismatch ($nmuver registered). ",
720 } elsif (!version_eq($pkgver, $version)) {
721 print "$name: version mismatch ($pkg->{'version'} registered). ",
726 change_state( \$pkg, 'Uploaded' );
727 log_ta( $pkg, "--uploaded" );
728 update_source_info($pkg);
729 print "$name: registered as uploaded\n" if $verbose;
736 my $pkg = get_source_info($name);
738 if (!defined($pkg)) {
739 print "$name: not registered yet.\n";
742 $state = $pkg->{'state'};
744 if ($state eq "Not-For-Us") {
745 print "$name: not suitable for this architecture anyway. Skipping.\n";
748 elsif ($state eq "Failed-Removed") {
749 print "$name: failed previously and doesn't need building. Skipping.\n";
752 elsif ($state eq "Installed") {
753 print "$name: Is already installed in archive. Skipping.\n";
756 elsif ($pkg->{'builder'} &&
757 (($user ne $pkg->{'builder'}) &&
758 !($pkg->{'builder'} =~ /^(\w+)-\w+/ && $1 eq $user))) {
759 print "$name: not taken by you, but by ".
760 "$pkg->{'builder'}. Skipping.\n";
763 elsif ( !pkg_version_eq($pkg, $version) ) {
764 print "$name: version mismatch ".
765 "$(pkg->{'version'} ".
766 "by $pkg->{'builder'})\n";
771 if (!$cat && $fail_reason =~ /^\[([^\]]+)\]/) {
773 $cat = $short_category{$cat} if exists $short_category{$cat};
774 if (!isin( $cat, values %short_category )) {
775 print "$name: Warning: unknown category $cat; discarded\n";
778 $fail_reason =~ s/^\[[^\]]+\][ \t]*\n*//;
781 if ($state eq "Needs-Build") {
782 print "$name: Warning: not registered for building previously, ".
783 "but processing anyway.\n";
785 elsif ($state eq "Uploaded") {
786 print "$name: Warning: marked as uploaded previously, ".
787 "but processing anyway.\n";
789 elsif ($state eq "Dep-Wait") {
790 print "$name: Warning: marked as waiting for dependencies, ".
791 "but processing anyway.\n";
793 elsif ($state eq "BD-Uninstallable") {
794 print "$name: Warning: marked as having uninstallable build-dependencies, ".
795 "but processing anyway.\n";
797 elsif ($state eq "Failed") {
798 print "$name: already registered as failed; will append new message\n"
800 print "$name: already registered as failed; changing category\n"
804 if (($cat eq "reminder-sent" || $cat eq "nmu-offered") &&
805 defined $pkg->{'failed_category'} &&
806 $pkg->{'failed_category'} ne $cat) {
807 (my $action = $cat) =~ s/-/ /;
808 $fail_reason .= "\n$short_date: $action";
811 change_state( \$pkg, 'Failed' );
812 $pkg->{'builder'} = $user;
813 $pkg->{'failed'} .= "\n" if $pkg->{'failed'};
814 $pkg->{'failed'} .= $fail_reason;
815 $pkg->{'failed_category'} = $cat if $cat;
816 if (defined $pkg->{'permbuildpri'}) {
817 $pkg->{'buildpri'} = $pkg->{'permbuildpri'};
819 delete $pkg->{'buildpri'};
821 log_ta( $pkg, "--failed" );
822 update_source_info($pkg);
823 print "$name: registered as failed\n" if $verbose;
826 sub add_one_notforus {
829 my $pkg = get_source_info($name);
831 if ($pkg->{'state'} eq 'Not-For-Us') {
832 # reset Not-For-Us state in case it's called twice; this is
833 # the only way to get a package out of this state...
834 # There is no really good state in which such packages should
835 # be put :-( So use Failed for now.
836 change_state( \$pkg, 'Failed' );
837 $pkg->{'package'} = $name;
838 $pkg->{'failed'} = "Was Not-For-Us previously";
839 delete $pkg->{'builder'};
840 delete $pkg->{'depends'};
841 log_ta( $pkg, "--no-build(rev)" );
842 print "$name: now not unsuitable anymore\n";
844 send_mail( $conf::notforus_maint,
845 "$name moved out of Not-For-Us state",
846 "The package '$name' has been moved out of the Not-For-Us ".
848 "It should probably also be removed from ".
849 "Packages-arch-specific or\n".
850 "the action was wrong.\n" )
851 if $conf::notforus_maint;
854 change_state( \$pkg, 'Not-For-Us' );
855 $pkg->{'package'} = $name;
856 delete $pkg->{'builder'};
857 delete $pkg->{'depends'};
858 delete $pkg->{'buildpri'};
859 delete $pkg->{'binary_nmu_version'};
860 delete $pkg->{'Binary-NMU-Changelog'};
861 log_ta( $pkg, "--no-build" );
862 print "$name: registered as unsuitable\n" if $verbose;
864 send_mail( $conf::notforus_maint,
865 "$name set to Not-For-Us",
866 "The package '$name' has been set to state Not-For-Us ".
868 "It should probably also be added to ".
869 "Packages-arch-specific or\n".
870 "the Not-For-Us state is wrong.\n" )
871 if $conf::notforus_maint;
873 update_source_info($pkg);
876 sub add_one_needsbuild {
880 my $pkg = get_source_info($name);
882 if (!defined($pkg)) {
883 print "$name: not registered; can't give back.\n";
886 $state = $pkg->{'state'};
888 if ($state eq "BD-Uninstallable") {
890 print "$name: Forcing uninstallability mark to be removed. This is not permanent and might be reset with the next trigger run\n";
892 change_state( \$pkg, 'Needs-Build' );
893 delete $pkg->{'builder'};
894 delete $pkg->{'depends'};
895 log_ta( $pkg, "--give-back" );
896 update_source_info($pkg);
897 print "$name: given back\n" if $verbose;
901 print "$name: has uninstallable build-dependencies. Skipping\n",
902 " (use --override to clear dependency list and ",
903 "give back anyway)\n";
907 elsif ($state eq "Dep-Wait") {
909 print "$name: Forcing source dependency list to be cleared\n";
912 print "$name: waiting for source dependencies. Skipping\n",
913 " (use --override to clear dependency list and ",
914 "give back anyway)\n";
918 elsif (!isin( $state, qw(Building Built Build-Attempted))) {
919 print "$name: not taken for building (state is $state).";
921 print "\n$name: Forcing give-back\n";
924 print " Skipping.\n";
928 if (defined ($pkg->{'builder'}) && $user ne $pkg->{'builder'} &&
929 !($pkg->{'builder'} =~ /^(\w+)-\w+/ && $1 eq $user)) {
930 print "$name: not taken by you, but by ".
931 "$pkg->{'builder'}. Skipping.\n";
934 if (!pkg_version_eq($pkg, $version)) {
935 print "$name: version mismatch ($pkg->{'version'} registered). ",
939 change_state( \$pkg, 'BD-Uninstallable' );
940 $pkg->{'bd_problem'} = "Installability of build dependencies not tested yet";
941 delete $pkg->{'builder'};
942 delete $pkg->{'depends'};
943 log_ta( $pkg, "--give-back" );
944 update_source_info($pkg);
945 print "$name: given back\n" if $verbose;
951 my $pkg = get_source_info($name);
954 if (!defined($pkg)) {
955 print "$name: not registered; can't register for binNMU.\n";
958 my $db_ver = $pkg->{'version'};
960 if (!version_eq($db_ver, $version)) {
961 print "$name: version mismatch ($db_ver registered). ",
965 $state = $pkg->{'state'};
967 if (defined $pkg->{'binary_nmu_version'}) {
968 if ($binNMUver == 0) {
969 change_state( \$pkg, 'Installed' );
970 delete $pkg->{'builder'};
971 delete $pkg->{'depends'};
972 delete $pkg->{'binary_nmu_version'};
973 delete $pkg->{'Binary-NMU-Changelog'};
974 } elsif ($binNMUver <= $pkg->{'binary_nmu_version'}) {
975 print "$name: already building binNMU $pkg->{'binary_nmu_version'}\n";
978 $pkg->{'binary_nmu_version'} = $binNMUver;
979 $pkg->{'Binary-NMU-Changelog'} = $fail_reason;
980 $pkg->{'notes'} = 'out-of-date';
981 $pkg->{'buildpri'} = $pkg->{'permbuildpri'}
982 if (defined $pkg->{'permbuildpri'});
984 log_ta( $pkg, "--binNMU" );
985 update_source_info($pkg);
987 } elsif ($binNMUver == 0) {
988 print "${name}_$version: no scheduled binNMU to cancel.\n";
992 if ($state ne 'Installed') {
993 print "${name}_$version: not installed; can't register for binNMU.\n";
997 my $fullver = binNMU_version($version,$binNMUver);
998 if ( version_lesseq( $fullver, $pkg->{'installed_version'} ) )
1000 print "$name: binNMU $fullver is not newer than current version $pkg->{'installed_version'}\n";
1004 change_state( \$pkg, 'BD-Uninstallable' );
1005 $pkg->{'bd_problem'} = "Installability of build dependencies not tested yet";
1006 delete $pkg->{'builder'};
1007 delete $pkg->{'depends'};
1008 $pkg->{'binary_nmu_version'} = $binNMUver;
1009 $pkg->{'Binary-NMU-Changelog'} = $fail_reason;
1010 $pkg->{'notes'} = 'out-of-date';
1011 log_ta( $pkg, "--binNMU" );
1012 update_source_info($pkg);
1013 print "${name}: registered for binNMU $fullver\n" if $verbose;
1016 sub set_one_buildpri {
1018 my $version = shift;
1020 my $pkg = get_source_info($name);
1023 if (!defined($pkg)) {
1024 print "$name: not registered; can't set priority.\n";
1027 $state = $pkg->{'state'};
1029 if ($state eq "Not-For-Us") {
1030 print "$name: not suitable for this architecture. Skipping.\n";
1032 } elsif ($state eq "Failed-Removed") {
1033 print "$name: failed previously and doesn't need building. Skipping.\n";
1036 if (!pkg_version_eq($pkg, $version)) {
1037 print "$name: version mismatch ($pkg->{'version'} registered). ",
1041 if ( $build_priority == 0 ) {
1042 delete $pkg->{'buildpri'}
1043 if $key eq 'permbuildpri' and defined $pkg->{'buildpri'}
1044 and $pkg->{'buildpri'} == $pkg->{$key};
1045 delete $pkg->{$key};
1047 $pkg->{'buildpri'} = $build_priority
1048 if $key eq 'permbuildpri';
1049 $pkg->{$key} = $build_priority;
1051 update_source_info($pkg);
1052 print "$name: set to build priority $build_priority\n" if $verbose;
1055 sub add_one_depwait {
1057 my $version = shift;
1059 my $pkg = get_source_info($name);
1061 if (!defined($pkg)) {
1062 print "$name: not registered yet.\n";
1065 $state = $pkg->{'state'};
1067 if ($state eq "Dep-Wait") {
1068 print "$name: merging with previously registered dependencies\n";
1071 if (isin( $state, qw(Needs-Build Failed BD-Uninstallable))) {
1072 print "$name: Warning: not registered for building previously, ".
1073 "but processing anyway.\n";
1075 elsif ($state eq "Not-For-Us") {
1076 print "$name: not suitable for this architecture anyway. Skipping.\n";
1079 elsif ($state eq "Failed-Removed") {
1080 print "$name: failed previously and doesn't need building. Skipping.\n";
1083 elsif ($state eq "Installed") {
1084 print "$name: Is already installed in archive. Skipping.\n";
1087 elsif ($state eq "Uploaded") {
1088 print "$name: Is already uploaded. Skipping.\n";
1091 elsif ($pkg->{'builder'} &&
1092 $user ne $pkg->{'builder'}) {
1093 print "$name: not taken by you, but by ".
1094 "$pkg->{'builder'}. Skipping.\n";
1097 elsif ( !pkg_version_eq($pkg,$version)) {
1098 print "$name: version mismatch ".
1099 "($pkg->{'version'} ".
1100 "by $pkg->{'builder'})\n";
1103 elsif ($fail_reason =~ /^\s*$/ ||
1104 !parse_deplist( $fail_reason, 1 )) {
1105 print "$name: Bad dependency list\n";
1108 change_state( \$pkg, 'Dep-Wait' );
1109 $pkg->{'builder'} = $user;
1110 if (defined $pkg->{'permbuildpri'}) {
1111 $pkg->{'buildpri'} = $pkg->{'permbuildpri'};
1113 delete $pkg->{'buildpri'};
1115 my $deplist = parse_deplist( $pkg->{'depends'} );
1116 my $new_deplist = parse_deplist( $fail_reason );
1117 # add new dependencies, maybe overwriting old entries
1118 foreach (keys %$new_deplist) {
1119 $deplist->{$_} = $new_deplist->{$_};
1121 $pkg->{'depends'} = build_deplist($deplist);
1122 log_ta( $pkg, "--dep-wait" );
1123 update_source_info($pkg);
1124 print "$name: registered as waiting for dependencies\n" if $verbose;
1134 local($/) = ""; # read in paragraph mode
1136 my( $version, $arch, $section, $priority, $builddep, $buildconf, $binaries );
1138 /^Package:\s*(\S+)$/mi and $name = $1;
1139 /^Version:\s*(\S+)$/mi and $version = $1;
1140 /^Architecture:\s*(\S+)$/mi and $arch = $1;
1141 /^Section:\s*(\S+)$/mi and $section = $1;
1142 /^Priority:\s*(\S+)$/mi and $priority = $1;
1143 /^Build-Depends:\s*(.*)$/mi and $builddep = $1;
1144 /^Build-Conflicts:\s*(.*)$/mi and $buildconf = $1;
1145 /^Binary:\s*(.*)$/mi and $binaries = $1;
1147 next if (defined $srcver{$name} and version_less( $version, $srcver{$name} ));
1148 $srcver{$name} = $version;
1150 $pkgs{$name}{'ver'} = $version;
1151 $pkgs{$name}{'bin'} = $binaries;
1152 $pkgs{$name}{'dep'} = $builddep;
1153 $pkgs{$name}{'conf'} = $buildconf;
1154 my $pkg = get_source_info($name);
1159 if ($arch eq "all" && !version_less( $version, $pkg->{'version'} )) {
1160 # package is now Arch: all, delete it from db
1161 change_state( \$pkg, 'deleted' );
1162 log_ta( $pkg, "--merge-sources" );
1163 print "$name ($pkg->{'version'}): deleted ".
1164 "from database, because now Arch: all\n"
1166 del_source_info($name);
1170 # The "Version" should always be the source version --
1171 # not a possible binNMU version number.
1172 $pkg->{'version'} = $version, $change++
1173 if ($pkg->{'state'} eq 'Installed' and
1174 !version_eq( $pkg->{'version'}, $version));
1175 # Always update priority and section, if available
1176 $pkg->{'priority'} = $priority, $change++
1177 if defined $priority and (not defined($pkg->{'priority'}) or $pkg->{'priority'} ne $priority);
1179 $pkg->{'section'} = $section, $change++
1180 if defined $section and (not defined($pkg->{'section'}) or $pkg->{'section'} ne $section);
1182 update_source_info($pkg) if $change;
1185 # Now that we only have the latest source version, build the list
1186 # of binary packages from the Sources point of view
1187 foreach $name (keys %pkgs) {
1188 foreach my $bin (split( /\s*,\s*/, $pkgs{$name}{'bin'} ) ) {
1189 $merge_binsrc{$bin} = $name;
1192 # remove installed packages that no longer have source available
1193 # or binaries installed
1194 my $db = get_all_source_info();
1195 foreach $name (keys %$db) {
1196 next if $name =~ /^_/;
1197 my $pkg = $db->{$name};
1198 if (not defined($pkgs{$name})) {
1199 change_state( \$pkg, 'deleted' );
1200 log_ta( $pkg, "--merge-sources" );
1201 print "$name ($pkg->{'version'}): ".
1202 "deleted from database, because ".
1203 "not in Sources anymore\n"
1205 del_source_info($name);
1207 next if !isin( $pkg->{'state'}, qw(Installed) );
1208 if ($full && not defined $merge_srcvers{$name}) {
1209 change_state( \$pkg, 'deleted' );
1210 log_ta( $pkg, "--merge-sources" );
1211 print "$name ($pkg->{'version'}): ".
1212 "deleted from database, because ".
1213 "binaries don't exist anymore\n"
1215 del_source_info($name);
1216 } elsif ($full && version_less( $merge_srcvers{$name}, $pkg->{'version'})) {
1217 print "$name ($pkg->{'version'}): ".
1218 "package is Installed but binaries are from ".
1219 $merge_srcvers{$name}. "\n"
1227 # This function looks through a Packages file and sets the state of
1228 # packages to 'Installed'
1229 sub parse_packages {
1232 local($/) = ""; # read in paragraph mode
1234 my( $name, $version, $depends, $source, $sourcev, $architecture, $provides, $binaryv, $binnmu );
1236 /^Package:\s*(\S+)$/mi and $name = $1;
1237 /^Version:\s*(\S+)$/mi and $version = $1;
1238 /^Depends:\s*(.*)$/mi and $depends = $1;
1239 /^Source:\s*(\S+)(\s*\((\S+)\))?$/mi and ($source,$sourcev) = ($1, $3);
1240 /^Architecture:\s*(\S+)$/mi and $architecture = $1;
1241 /^Provides:\s*(.*)$/mi and $provides = $1;
1242 next if !$name || !$version;
1243 next if ($arch ne $architecture and $architecture ne "all");
1244 next if (defined ($installed->{$name}) and $installed->{$name}{'version'} ne "" and
1245 version_lesseq( $version, $installed->{$name}{'version'} ));
1246 $installed->{$name}{'version'} = $version;
1247 $installed->{$name}{'depends'} = $depends;
1248 $installed->{$name}{'all'} = 1 if $architecture eq "all";
1249 undef $installed->{$name}{'Provider'};
1250 $installed->{$name}{'Source'} = $source ? $source : $name;
1252 foreach (split( /\s*,\s*/, $provides )) {
1253 if (not defined ($installed->{$_})) {
1254 $installed->{$_}{'version'} = "";
1255 $installed->{$_}{'Provider'} = $name;
1259 if ( $version =~ /\+b(\d+)$/ ) {
1262 $version = $sourcev if $sourcev;
1263 $binaryv = $version;
1264 $binaryv =~ s/\+b\d+$//;
1265 $installed->{$name}{'Sourcev'} = $sourcev ? $sourcev : $binaryv;
1266 $binaryv .= "+b$binnmu" if defined($binnmu);
1268 next if $architecture ne $arch;
1269 $name = $source if $source;
1270 next if defined($merge_srcvers{$name}) and $merge_srcvers{$name} eq $version;
1271 $merge_srcvers{$name} = $version;
1273 my $pkg = get_source_info($name);
1276 if (isin( $pkg->{'state'}, qw(Not-For-Us)) ||
1277 (isin($pkg->{'state'}, qw(Installed)) &&
1278 version_lesseq($binaryv, $pkg->{'installed_version'}))) {
1279 print "Skipping $name because State == $pkg->{'state'}\n"
1283 if ($pkg->{'binary_nmu_version'} ) {
1284 my $nmuver = binNMU_version($pkg->{'version'}, $pkg->{'binary_nmu_version'});
1285 if (version_less( $binaryv, $nmuver )) {
1286 print "Skipping $name ($version) because have newer ".
1287 "version ($nmuver) in db.\n"
1291 } elsif (version_less($version, $pkg->{'version'})) {
1292 print "Skipping $name ($version) because have newer ".
1293 "version ($pkg->{'version'}) in db.\n"
1298 if (!pkg_version_eq($pkg, $version) &&
1299 $pkg->{'state'} ne "Installed") {
1300 warn "Warning: $name: newer version than expected appeared ".
1301 "in archive ($version vs. $pkg->{'version'})\n";
1302 delete $pkg->{'builder'};
1305 if (!isin( $pkg->{'state'}, qw(Uploaded) )) {
1306 warn "Warning: Package $name was not in uploaded state ".
1307 "before (but in '$pkg->{'state'}').\n";
1308 delete $pkg->{'builder'};
1309 delete $pkg->{'depends'};
1313 $pkg->{'version'} = $version;
1316 change_state( \$pkg, 'Installed' );
1317 $pkg->{'package'} = $name;
1318 $pkg->{'installed_version'} = $binaryv;
1319 if (defined $pkg->{'permbuildpri'}) {
1320 $pkg->{'buildpri'} = $pkg->{'permbuildpri'};
1322 delete $pkg->{'buildpri'};
1324 $pkg->{'version'} = $version
1325 if version_less( $pkg->{'version'}, $version);
1326 delete $pkg->{'binary_nmu_version'};
1327 delete $pkg->{'Binary-NMU-Changelog'};
1328 log_ta( $pkg, "--merge-packages" );
1329 update_source_info($pkg);
1330 print "$name ($version) is up-to-date now.\n" if $verbose;
1333 check_dep_wait( "--merge-packages", $installed );
1338 my ($package, $name, $version, $installed);
1340 foreach $package (@_) {
1341 $package =~ s,^.*/,,; # strip path
1342 $package =~ s/\.(dsc|diff\.gz|tar\.gz|deb)$//; # strip extension
1343 $package =~ s/_[\w\d]+\.changes$//; # strip extension
1344 if ($package =~ /^([\w\d.+-]+)_([\w\d:.+~-]+)/) {
1345 ($name,$version) = ($1,$2);
1348 warn "$package: can't extract package name and version ".
1352 $installed->{$name}{'version'} = $version;
1355 check_dep_wait( "--pretend-avail", $installed );
1358 sub check_dep_wait {
1360 my $installed = shift;
1362 # check all packages in state Dep-Wait if dependencies are all
1365 my $db = get_all_source_info();
1366 foreach $name (keys %$db) {
1367 next if $name =~ /^_/;
1368 my $pkg = $db->{$name};
1369 next if $pkg->{'state'} ne "Dep-Wait";
1370 my $deps = $pkg->{'depends'};
1372 print "$name: was in state Dep-Wait, but with empty ",
1374 goto make_needs_build;
1376 my $deplist = parse_deplist($deps);
1380 foreach (keys %$deplist) {
1381 if (!exists $installed->{$_} ||
1382 ($deplist->{$_}->{'rel'} && $deplist->{$_}->{'version'} &&
1383 !version_compare( $installed->{$_}{'version'},
1384 $deplist->{$_}->{'rel'},
1385 $deplist->{$_}->{'version'}))) {
1387 $new_deplist->{$_} = $deplist->{$_};
1390 push( @removed_deps, $_ );
1395 change_state( \$pkg, 'Needs-Build' );
1396 log_ta( $pkg, $action );
1397 delete $pkg->{'builder'};
1398 delete $pkg->{'depends'};
1399 print "$name ($pkg->{'version'}) has all ",
1400 "dependencies available now\n" if $verbose;
1402 update_source_info($pkg);
1404 elsif (@removed_deps) {
1405 $pkg->{'depends'} = build_deplist( $new_deplist );
1406 print "$name ($pkg->{'version'}): some dependencies ",
1407 "(@removed_deps) available now, but not all yet\n"
1409 update_source_info($pkg);
1414 # This function accepts quinn-diff output (either from a file named on
1415 # the command line, or on stdin) and sets the packages named there to
1416 # state 'Needs-Build'.
1417 sub parse_quinn_diff {
1418 my $partial = shift;
1424 next if !m,^([-\w\d/]*)/ # section
1425 ([-\w\d.+]+)_ # package name
1426 ([\w\d:.~+-]+)\.dsc\s* # version
1427 \[([^:]*): # priority
1428 ([^]]+)\]\s*$,x; # rest of notes
1429 my($section,$name,$version,$priority,$notes) = ($1, $2, $3, $4, $5);
1430 $quinn_pkgs{$name}++;
1431 $section ||= "unknown";
1432 $priority ||= "unknown";
1433 $priority = "unknown" if $priority eq "-";
1434 $priority = "standard" if ($name eq "debian-installer");
1436 my $pkg = get_source_info($name);
1438 # Always update section and priority.
1439 if (defined($pkg)) {
1441 $pkg->{'section'} = $section, $change++ if not defined
1442 $pkg->{'section'} or $section ne "unknown";
1443 $pkg->{'priority'} = $priority, $change++ if not defined
1444 $pkg->{'priority'} or $priority ne "unknown";
1447 if (defined($pkg) &&
1448 $pkg->{'state'} =~ /^Dep-Wait/ &&
1449 version_less( $pkg->{'version'}, $version )) {
1450 change_state( \$pkg, 'Dep-Wait' );
1451 $pkg->{'version'} = $version;
1452 delete $pkg->{'binary_nmu_version'};
1453 delete $pkg->{'Binary-NMU-Changelog'};
1454 log_ta( $pkg, "--merge-quinn" );
1456 print "$name ($version) still waiting for dependencies.\n"
1459 elsif (defined($pkg) &&
1460 $pkg->{'state'} =~ /-Removed$/ &&
1461 version_eq($pkg->{'version'}, $version)) {
1462 # reinstantiate a package that has been removed earlier
1463 # (probably due to a quinn-diff malfunction...)
1464 my $newstate = $pkg->{'state'};
1465 $newstate =~ s/-Removed$//;
1466 change_state( \$pkg, $newstate );
1467 $pkg->{'version'} = $version;
1468 $pkg->{'notes'} = $notes;
1469 log_ta( $pkg, "--merge-quinn" );
1471 print "$name ($version) reinstantiated to $newstate.\n"
1474 elsif (defined($pkg) &&
1475 $pkg->{'state'} eq "Not-For-Us" &&
1476 version_less( $pkg->{'version'}, $version )) {
1477 # for Not-For-Us packages just update the version etc., but
1479 change_state( \$pkg, "Not-For-Us" );
1480 $pkg->{'package'} = $name;
1481 $pkg->{'version'} = $version;
1482 $pkg->{'notes'} = $notes;
1483 delete $pkg->{'builder'};
1484 log_ta( $pkg, "--merge-quinn" );
1486 print "$name ($version) still Not-For-Us.\n" if $verbose;
1488 elsif (!defined($pkg) ||
1489 $pkg->{'state'} ne "Not-For-Us" &&
1490 (version_less( $pkg->{'version'}, $version ) ||
1491 ($pkg->{'state'} eq "Installed" && version_less($pkg->{'installed_version'}, $version)))) {
1493 if (defined( $pkg->{'state'} ) && isin( $pkg->{'state'}, qw(Building Built Build-Attempted))) {
1494 send_mail( $pkg->{'builder'},
1495 "new version of $name (dist=$distribution)",
1496 "As far as I'm informed, you're currently ".
1497 "building the package $name\n".
1498 "in version $pkg->{'version'}.\n\n".
1499 "Now there's a new source version $version. ".
1500 "If you haven't finished\n".
1501 "compiling $name yet, you can stop it to ".
1502 "save some work.\n".
1503 "Just to inform you...\n".
1504 "(This is an automated message)\n" );
1505 print "$name: new version ($version) while building ".
1506 "$pkg->{'version'} -- sending mail ".
1507 "to builder ($pkg->{'builder'})\n"
1510 change_state( \$pkg, 'Needs-Build' );
1511 $pkg->{'package'} = $name;
1512 $pkg->{'version'} = $version;
1513 $pkg->{'section'} = $section;
1514 $pkg->{'priority'} = $priority;
1515 $pkg->{'notes'} = $notes;
1516 delete $pkg->{'builder'};
1517 delete $pkg->{'binary_nmu_version'};
1518 delete $pkg->{'Binary-NMU-Changelog'};
1519 log_ta( $pkg, "--merge-quinn" );
1522 print "$name ($version) needs rebuilding now.\n" if $verbose;
1524 elsif (defined($pkg) &&
1525 !version_eq( $pkg->{'version'}, $version ) &&
1526 isin( $pkg->{'state'}, qw(Installed Not-For-Us) )) {
1527 print "$name: skipping because version in db ".
1528 "($pkg->{'version'}) is >> than ".
1529 "what quinn-diff says ($version) ".
1530 "(state is $pkg->{'state'})\n"
1532 $dubious .= "$pkg->{'state'}: ".
1533 "db ${name}_$pkg->{'version'} >> ".
1534 "quinn $version\n" if !$partial;
1536 elsif ($verbose >= 2) {
1537 if ($pkg->{'state'} eq "Not-For-Us") {
1538 print "Skipping $name because State == ".
1539 "$pkg->{'state'}\n";
1541 elsif (!version_less($pkg->{'version'}, $version)) {
1542 print "Skipping $name because version in db ".
1543 "($pkg->{'version'}) is >= than ".
1544 "what quinn-diff says ($version)\n";
1547 update_source_info($pkg) if $change;
1551 send_mail( $conf::db_maint,
1552 "Dubious versions in " . table_name() . " table",
1553 "The following packages have a newer version in the ".
1554 "wanna-build database\n".
1555 "than what quinn-diff says, and this is strange for ".
1557 "It could be caused by a lame mirror, or the version ".
1558 "in the database\n".
1563 # Now re-check the DB for packages in states Needs-Build, Failed,
1564 # Dep-Wait or BD-Uninstallable and remove them if they're not listed
1565 # anymore by quinn-diff.
1568 my $db = get_all_source_info();
1569 foreach $name (keys %$db) {
1570 next if $name =~ /^_/;
1571 my $pkg = $db->{$name};
1572 next if defined $pkg->{'binary_nmu_version'};
1573 next if !isin( $pkg->{'state'},
1574 qw(Needs-Build Building Built Build-Attempted Uploaded Failed Dep-Wait BD-Uninstallable) );
1575 my $virtual_delete = $pkg->{'state'} eq 'Failed';
1577 if (!$quinn_pkgs{$name}) {
1578 change_state( \$pkg, $virtual_delete ?
1579 $pkg->{'state'}."-Removed" :
1581 log_ta( $pkg, "--merge-quinn" );
1582 print "$name ($pkg->{'version'}): ".
1583 ($virtual_delete ? "(virtually) " : "") . "deleted ".
1584 "from database, because not in quinn-diff anymore\n"
1586 if ($virtual_delete) {
1587 update_source_info($pkg);
1589 del_source_info($name);
1597 # for sorting priorities and sections
1599 %prioval = ( required => -5,
1607 'debian-installer' => -199,
1628 localizations => -178,
1629 interpreters => -177,
1654 electronics => -152,
1660 foreach my $i (keys %sectval) {
1661 $sectval{"contrib/$i"} = $sectval{$i}+40;
1662 $sectval{"non-free/$i"} = $sectval{$i}+80;
1664 $sectval{'unknown'} = -165;
1666 %catval = ( "none" => -20,
1667 "uploaded-fixed-pkg" => -19,
1668 "fix-expected" => -18,
1669 "reminder-sent" => -17,
1670 "nmu-offered" => -16,
1674 "compiler-error" => -12 );
1677 sub sort_list_func {
1678 my( $letter, $x, $ax, $bx );
1680 foreach $letter (split( "", $list_order )) {
1681 SWITCH: foreach ($letter) {
1683 $x = $b->{'buildpri'} <=> $a->{'buildpri'};
1684 return $x if $x != 0;
1688 $x = $prioval{$a->{'priority'}} <=> $prioval{$b->{'priority'}};
1689 return $x if $x != 0;
1693 $x = $sectval{$a->{'section'}} <=> $sectval{$b->{'section'}};
1694 return $x if $x != 0;
1698 $x = $a->{'package'} cmp $b->{'package'};
1699 return $x if $x != 0;
1703 $x = $a->{'builder'} cmp $b->{'builder'};
1704 return $x if $x != 0;
1708 $ax = ($a->{'notes'} =~ /^(out-of-date|partial)/) ? 0 :
1709 ($a->{'notes'} =~ /^uncompiled/) ? 2 : 1;
1710 $bx = ($b->{'notes'} =~ /^(out-of-date|partial)/) ? 0 :
1711 ($b->{'notes'} =~ /^uncompiled/) ? 2 : 1;
1713 return $x if $x != 0;
1717 my $ca = defined $a->{'failed_category'} ?
1718 $a->{'failed_category'} : "none";
1719 my $cb = defined $b->{'failed_category'} ?
1720 $b->{'failed_category'} : "none";
1721 $x = $catval{$ca} <=> $catval{$cb};
1722 return $x if $x != 0;
1726 my $pa = $prioval{$a->{'priority'}} >
1727 $prioval{'standard'};
1728 my $pb = $prioval{$b->{'priority'}} >
1729 $prioval{'standard'};
1731 return $x if $x != 0;
1741 my( $name, $pkg, @list );
1746 my $db = get_all_source_info();
1747 foreach $name (keys %$db) {
1748 next if $name =~ /^_/;
1749 $pkg = $db->{$name};
1750 next if $state ne "all" && $pkg->{'state'} !~ /^\Q$state\E$/i;
1751 next if $user && (lc($state) ne 'needs-build' and $pkg->{'builder'} ne $user);
1752 next if $category && $pkg->{'state'} eq "Failed" &&
1753 $pkg->{'failed_category'} ne $category;
1754 next if ($list_min_age > 0 &&
1755 ($ctime-parse_date($pkg->{'State-Change'})) < $list_min_age)||
1756 ($list_min_age < 0 &&
1757 ($ctime-parse_date($pkg->{'State-Change'})) > -$list_min_age);
1758 push( @list, $pkg );
1761 foreach $pkg (sort sort_list_func @list) {
1762 print "$pkg->{'section'}/$pkg->{'package'}_$pkg->{'version'}";
1763 print ": $pkg->{'state'}"
1765 print " by $pkg->{'builder'}"
1766 if $pkg->{'state'} ne "Needs-Build" && $pkg->{'builder'};
1767 print " [$pkg->{'priority'}:$pkg->{'notes'}";
1768 print ":PREV-FAILED"
1769 if $pkg->{'previous_state'} =~ /^Failed/;
1770 print ":bp{" . $pkg->{'buildpri'} . "}"
1771 if defined $pkg->{'buildpri'};
1772 print ":binNMU{" . $pkg->{'binary_nmu_version'} . "}"
1773 if defined $pkg->{'binary_nmu_version'};
1775 print " Reasons for failing:\n",
1777 defined $pkg->{'failed_category'} ? $pkg->{'failed_category'} : "none",
1779 join("\n ",split("\n",$pkg->{'failed'})), "\n"
1780 if $pkg->{'state'} =~ /^Failed/;
1781 print " Dependencies: $pkg->{'depends'}\n"
1782 if $pkg->{'state'} eq "Dep-Wait";
1783 print " Reasons for BD-Uninstallable:\n ",
1784 join("\n ",split("\n",$pkg->{'bd_problem'})), "\n"
1785 if $pkg->{'state'} eq "BD-Uninstallable";
1786 print " Previous state was $pkg->{'previous_state'} until ",
1787 "$pkg->{'State-Change'}\n"
1788 if $verbose && $pkg->{'previous_state'};
1789 print " No previous state recorded\n"
1790 if $verbose && !$pkg->{'previous_state'};
1791 print " Previous failing reasons:\n ",
1792 join("\n ",split("\n",$pkg->{'old_failed'})), "\n"
1793 if $verbose && $pkg->{'old_failed'};
1795 $scnt{$pkg->{'state'}}++ if $state eq "all";
1797 if ($state eq "all") {
1798 foreach (sort keys %scnt) {
1799 print "Total $scnt{$_} package(s) in state $_.\n";
1802 print "Total $cnt package(s)\n";
1807 my( $name, $pkg, $key, $dist );
1808 my @firstkeys = qw(package version builder state section priority
1809 installed_version previous_state state_change);
1810 my @dists = $info_all_dists ? keys %conf::distributions : ($distribution);
1812 foreach $name (@_) {
1813 $name =~ s/_.*$//; # strip version
1814 foreach $dist (@dists) {
1815 my $pname = "$name" . ($info_all_dists ? "($dist)" : "");
1817 $pkg = get_source_info($name);
1818 if (!defined( $pkg )) {
1819 print "$pname: not registered\n";
1824 foreach $key (@firstkeys) {
1825 next if !defined $pkg->{$key};
1826 my $val = $pkg->{$key};
1828 $val = "\n$val" if isin( $key, qw(Failed Old-Failed));
1830 printf " %-20s: %s\n", $key, $val;
1832 foreach $key (sort keys %$pkg) {
1833 next if isin( $key, @firstkeys );
1834 my $val = $pkg->{$key};
1836 $val = "\n$val" if isin( $key, qw(Failed Old-Failed));
1838 printf " %-20s: %s\n", $key, $val;
1844 sub forget_packages {
1845 my( $name, $pkg, $key, $data );
1847 foreach $name (@_) {
1848 $name =~ s/_.*$//; # strip version
1849 $pkg = get_source_info($name);
1850 if (!defined( $pkg )) {
1851 print "$name: not registered\n";
1856 foreach $key (sort keys %$pkg) {
1857 my $val = $pkg->{$key};
1860 $data .= sprintf " %-20s: %s\n", $key, $val;
1862 send_mail( $conf::db_maint,
1863 "$name deleted from DB " . table_name(),
1864 "The package '$name' has been deleted from the database ".
1866 "Data registered about the deleted package:\n".
1867 "$data\n" ) if $conf::db_maint;
1868 change_state( \$pkg, 'deleted' );
1869 log_ta( $pkg, "--forget" );
1870 del_source_info($name);
1871 print "$name: deleted from database\n" if $verbose;
1876 $dbh->do("DELETE from " . user_table_name()) or die $dbh->errstr;
1882 print "Reading ASCII database from $file..." if $verbose >= 1;
1883 open( F, "<$file" ) or
1884 die "Can't open database $file: $!\n";
1886 local($/) = ""; # read in paragraph mode
1888 my( %thispkg, $name );
1890 s/\n[ \t]+/\376\377/g; # fix continuation lines
1891 s/\376\377\s*\376\377/\376\377/og;
1893 while( /^(\S+):[ \t]*(.*)[ \t]*$/mg ) {
1894 my ($key, $val) = ($1, $2);
1896 $key =~ tr/A-Z/a-z/;
1897 $val =~ s/\376\377/\n/g;
1898 $thispkg{$key} = $val;
1900 check_entry( \%thispkg );
1902 if (exists($thispkg{'package'})) {
1903 update_source_info(\%thispkg);
1905 elsif(exists($thispkg{'user'})) {
1906 # user in import, username in database.
1907 $dbh->do('INSERT INTO ' . user_table_name() .
1908 ' (username, last_seen) values (?, ?)',
1909 undef, $thispkg{'user'}, $thispkg{'last_seen'})
1910 or die $dbh->errstr;
1914 print "done\n" if $verbose >= 1;
1921 return if $op_mode eq "manual-edit"; # no checks then
1923 # check for required fields
1924 if (exists $pkg->{'user'}) {
1927 if (!exists $pkg->{'package'}) {
1928 print STDERR "Bad entry: ",
1929 join( "\n", map { "$_: $pkg->{$_}" } keys %$pkg ), "\n";
1930 die "Database entry lacks package or username field\n";
1932 if (!exists $pkg->{'version'}) {
1933 die "Database entry for $pkg->{'package'} lacks Version: field\n";
1935 # if no State: field, generate one (for old db compat)
1936 if (!exists($pkg->{'state'})) {
1938 exists $pkg->{'failed'} ? 'Failed' : 'Building';
1941 die "Bad state $pkg->{'state'} of package $pkg->{Package}\n"
1942 if !isin( $pkg->{'state'},
1943 qw(Needs-Build Building Built Build-Attempted Uploaded Installed Dep-Wait
1944 Failed Failed-Removed Not-For-Us BD-Uninstallable
1951 my $newstate = shift;
1952 my $state = \$pkg->{'state'};
1954 return if defined($$state) and $$state eq $newstate;
1955 $pkg->{'previous_state'} = $$state if defined($$state);
1956 $pkg->{'State-Change'} = $curr_date;
1958 if (defined($$state) and $$state eq 'Failed') {
1959 $pkg->{'old_failed'} =
1960 "-"x20 . " $pkg->{'version'} " . "-"x20 . "\n" .
1961 $pkg->{'failed'} . "\n" .
1962 $pkg->{'old_failed'};
1963 delete $pkg->{'failed'};
1964 delete $pkg->{'failed_category'};
1966 if (defined($$state) and $$state eq 'BD-Uninstallable') {
1967 delete $pkg->{'bd_problem'};
1969 $$state = $newstate;
1975 my $dist = $distribution;
1979 $prevstate = $pkg->{'previous_state'};
1980 $str = "$action($dist): $pkg->{'package'}_$pkg->{'version'} ".
1981 "changed from $prevstate to $pkg->{'state'} ".
1982 "by $real_user as $user";
1984 my $transactlog = db_transactlog();
1985 if (!open( LOG, ">>$transactlog" )) {
1986 warn "Can't open log file $transactlog: $!\n";
1989 print LOG "$curr_date: $str\n";
1992 if (!($prevstate eq 'Failed' && $pkg->{'state'} eq 'Failed')) {
1993 $str .= " (with --override)"
1995 $mail_logs .= "$str\n";
2002 my $subject = shift;
2005 my $from = $conf::db_maint;
2006 my $domain = $conf::buildd_domain;
2008 $from .= "\@$domain" if $from !~ /\@/;
2010 $to .= '@' . $domain if $to !~ /\@/;
2011 $text =~ s/^\.$/../mg;
2012 local $SIG{'PIPE'} = 'IGNORE';
2013 open( PIPE, "| $conf::mailprog -oem $to" )
2014 or die "Can't open pipe to $conf::mailprog: $!\n";
2016 print PIPE "From: $from\n";
2017 print PIPE "Subject: $subject\n\n";
2018 print PIPE "$text\n";
2022 sub db_transactlog {
2023 return "$conf::basedir/$arch/$conf::transactlog";
2026 # for parsing input to dep-wait
2032 foreach (split( /\s*,\s*/, $deps )) {
2034 # verification requires > starting prompts, no | crap
2035 if (!/^(\S+)\s*(\(\s*(>(?:[>=])?)\s*(\S+)\s*\))?\s*$/) {
2040 my @alts = split( /\s*\|\s*/, $_ );
2041 # Anything with an | is ignored, as it can be configured on a
2042 # per-buildd basis what will be installed
2043 next if $#alts != 0;
2046 if (!/^(\S+)\s*(\(\s*(>=|=|==|>|>>|<<|<=)\s*(\S+)\s*\))?\s*$/) {
2047 warn( "parse_deplist: bad dependency $_\n" );
2050 my($dep, $rel, $relv) = ($1, $3, $4);
2051 $rel = ">>" if defined($rel) and $rel eq ">";
2052 $result{$dep}->{'package'} = $dep;
2053 if ($rel && $relv) {
2054 $result{$dep}->{'rel'} = $rel;
2055 $result{$dep}->{'version'} = $relv;
2058 return 1 if $verify;
2062 # for parsing Build-Depends from Sources
2063 sub parse_srcdeplist {
2070 foreach $dep (split( /\s*,\s*/, $deps )) {
2071 my @alts = split( /\s*\|\s*/, $dep );
2072 # Anything with an | is ignored, as it can be configured on a
2073 # per-buildd basis what will be installed
2074 next if $#alts != 0;
2076 if (!/^([^\s([]+)\s*(\(\s*([<=>]+)\s*(\S+)\s*\))?(\s*\[([^]]+)\])?/) {
2077 warn( "parse_srcdeplist: bad dependency $_\n" );
2080 my($dep, $rel, $relv, $archlist) = ($1, $3, $4, $6);
2082 $archlist =~ s/^\s*(.*)\s*$/$1/;
2083 my @archs = split( /\s+/, $archlist );
2084 my ($use_it, $ignore_it, $include) = (0, 0, 0);
2087 $ignore_it = 1 if substr($_, 1) eq $arch;
2089 $use_it = 1 if $_ eq $arch;
2093 warn "Warning: inconsistent arch restriction on ",
2094 "$pkg: $dep depedency\n"
2095 if $ignore_it && $use_it;
2096 next if $ignore_it || ($include && !$use_it);
2104 $result->{'package'} = $dep;
2105 $result->{'Neg'} = $neg;
2106 if ($rel && $relv) {
2107 $result->{'rel'} = $rel;
2108 $result->{'version'} = $relv;
2110 push @results, $result;
2119 foreach $key (keys %$list) {
2120 $result .= ", " if $result;
2122 $result .= " ($list->{$key}->{'rel'} $list->{$key}->{'version'})"
2123 if $list->{$key}->{'rel'} && $list->{$key}->{'version'};
2128 sub get_unsatisfied_dep {
2132 my $savedep = shift;
2134 my $pkgname = $dep->{'package'};
2136 if (defined $pkgs->{$pkgname}{'Provider'}) {
2137 # provides. leave them for buildd/sbuild.
2142 return $pkgs->{$pkgname}{'Unsatisfied'} if $savedep and defined($pkgs->{$pkgname}{'Unsatisfied'});
2144 # Return unsatisfied deps to a higher caller to process
2145 if ((!defined($pkgs->{$pkgname})) or
2146 (defined($dep->{'rel'}) and !version_compare( $pkgs->{$pkgname}{'version'}, $dep->{'rel'}, $dep->{'Version'} ) ) ) {
2148 $deplist{$pkgname} = $dep;
2149 my $deps = build_deplist(\%deplist);
2150 $pkgs->{$pkgname}{'Unsatisfied'} = $deps if $savedep;
2154 # set cache to "" to avoid infinite recursion
2155 $pkgs->{$pkgname}{'Unsatisfied'} = "" if $savedep;
2157 if (defined $pkgs->{$dep->{'package'}}{'depends'}) {
2158 my $deps = parse_deplist( $pkgs->{$dep->{'package'}}{'depends'} );
2159 foreach (keys %$deps) {
2162 my $ret = get_unsatisfied_dep($bd,$pkgs,$dep,1);
2164 my $retdep = parse_deplist( $ret );
2165 foreach (keys %$retdep) {
2166 $dep = $$retdep{$_};
2168 $dep->{'rel'} = '>=' if defined($dep->{'rel'}) and $dep->{'rel'} =~ '^=';
2170 if (defined($dep->{'rel'}) and $dep->{'rel'} =~ '^>' and defined ($pkgs->{$dep->{'package'}}) and
2171 version_compare($bd->{$pkgs->{$dep->{'package'}}{'Source'}}{'ver'},'>>',$pkgs->{$dep->{'package'}}{'Sourcev'})) {
2172 if (not defined($merge_binsrc{$dep->{'package'}})) {
2173 # the uninstallable package doesn't exist in the new source; look for something else that does.
2174 delete $$retdep{$dep->{'package'}};
2175 foreach (sort (split( /\s*,\s*/, $bd->{$pkgs->{$dep->{'package'}}{'Source'}}{'bin'}))) {
2176 next if ($pkgs->{$_}{'all'} or not defined $pkgs->{$_}{'version'});
2177 $dep->{'package'} = $_;
2178 $dep->{'rel'} = '>>';
2179 $dep->{'version'} = $pkgs->{$_}{'Version'};
2180 $$retdep{$_} = $dep;
2185 # sanity check to make sure the depending binary still exists, and the depended binary exists and dep-wait on a new version of it
2186 if ( defined($merge_binsrc{$pkgname}) and defined($pkgs->{$dep->{'package'}}{'version'}) ) {
2187 delete $$retdep{$dep->{'package'}};
2188 $dep->{'package'} = $pkgname;
2189 $dep->{'rel'} = '>>';
2190 $dep->{'version'} = $pkgs->{$pkgname}{'Version'};
2191 $$retdep{$pkgname} = $dep;
2193 delete $$retdep{$dep->{'package'}} if (defined ($dep->{'rel'}) and $dep->{'rel'} =~ '^>');
2196 $ret = build_deplist($retdep);
2197 $pkgs->{$pkgname}{'Unsatisfied'} = $ret if $savedep;
2205 sub call_edos_depcheck {
2206 my $packagesfile = shift;
2210 return if defined ($conf::distributions{$distribution}{noadw});
2212 # We need to check all of needs-build, as any new upload could make
2213 # something in needs-build have uninstallable deps
2214 # We also check everything in bd-uninstallable, as any new upload could
2215 # make that work again
2216 my %interesting_packages;
2217 my $db = get_all_source_info();
2218 foreach $key (keys %$db) {
2219 my $pkg = $db->{$key};
2220 if (defined $pkg and isin($pkg->{'state'}, qw/Needs-Build BD-Uninstallable/)) {
2221 $interesting_packages{$key} = undef;
2225 #print "I would look at these sources with edos-depcheck:\n";
2226 #print join " ", keys %interesting_packages,"\n";
2228 my $tmpfile_pattern = "/tmp/wanna-build-interesting-sources-$distribution.$$-";
2230 for( $i = 0;; ++$i ) {
2231 $tmpfile = $tmpfile_pattern . $i;
2232 last if ! -e $tmpfile;
2235 open SOURCES, '>', $tmpfile or die "Could not open temporary file $tmpfile\n";
2236 for my $key (keys %interesting_packages) {
2237 my $pkg = get_source_info($key);
2238 print SOURCES "Package: $key\n";
2239 print SOURCES "Version: $pkg->{'version'}\n";
2240 print SOURCES "Build-Depends: $srcs->{$key}{'dep'}\n" if $srcs->{$key}{'dep'};
2241 print SOURCES "Build-Conflicts: $srcs->{$key}{'conf'}\n" if $srcs->{$key}{'conf'};
2242 print SOURCES "Architecture: all\n";
2247 if (open(EDOS,"-|","wb-edos-builddebcheck", "-a", $arch, $packagesfile, $tmpfile))
2249 local($/) = ""; # read in paragraph mode
2251 my( $key, $reason ) ;
2253 /^Package:\s*(\S+)$/mi and $key = $1;
2254 /^Failed-Why:(([^\n]|\n ([^\n]|\.))*)$/msi and $reason = $1;
2255 $reason =~ s/^\s*//mg;
2256 $reason ||= 'No reason given by edos-debcheck';
2258 if (exists $interesting_packages{$key}) {
2259 $interesting_packages{$key} = $reason;
2261 #print "TODO: edos reported a package we do not care about now\n" if $verbose;
2266 print "ERROR: Could not run wb-edos-builddebcheck. I am continuing, assuming\n" .
2267 "all packages have installable build-dependencies."
2272 for my $key (keys %interesting_packages) {
2273 my $pkg = get_source_info($key);
2275 (defined $interesting_packages{$key} and $pkg->{'state'} eq 'Needs-Build') ||
2276 (not defined $interesting_packages{$key} and $pkg->{'state'} eq 'BD-Uninstallable');
2277 my $problemchange = $interesting_packages{$key} ne $pkg->{'bd_problem'};
2279 if (defined $interesting_packages{$key}) {
2280 change_state( \$pkg, 'BD-Uninstallable' );
2281 $pkg->{'bd_problem'} = $interesting_packages{$key};
2283 change_state( \$pkg, 'Needs-Build' );
2286 if ($problemchange) {
2287 if (defined $interesting_packages{$key}) {
2288 $pkg->{'bd_problem'} = $interesting_packages{$key};
2292 log_ta( $pkg, "--merge-all" );
2293 print "edos-builddebchange changed state of ${key}_$pkg->{'version'} to $pkg->{'state'}\n" if $verbose;
2295 if ($change || $problemchange) {
2296 update_source_info($pkg);
2303 ($prgname = $0) =~ s,^.*/,,;
2305 Usage: $prgname <options...> <package_version...>
2307 -v, --verbose: Verbose execution.
2308 --take: Take package for building [default operation]
2309 -f, --failed: Record in database that a build failed due to
2310 deficiencies in the package (that aren't fixable without a new
2312 -u, --uploaded: Record in the database that the packages build
2313 correctly and were uploaded.
2314 -n, --no-build: Record in the database that the packages aren't
2315 desired for this architecture and shouldn't appear in listings even
2316 if they're out of date.
2317 --dep-wait: Record in the database that the packages are waiting
2318 for some source dependencies to become available
2319 --binNMU num: Schedule a re-build of the package with unchanged source, but
2320 a new version number (source-version + "+b<num>")
2321 --give-back: Mark a package as ready to build that is in state Building,
2322 Built or Build-Attempted. To give back a package in state Failed, use
2323 --override. This command will actually put the package in state
2324 BD-Uninstallable, until the installability of its Build-Dependencies
2325 were verified. This happens at each call of --merge-all, usually
2327 --merge-quinn: Merge quinn-diff output into database.
2328 --merge-packages: Merge Packages files into database.
2329 --pretend-avail: Pretend that given packages are available now and give
2330 free packages waiting for them
2331 -i SRC_PKG, --info SRC_PKG: Show information for source package
2332 -l STATE, --list=STATE: List all packages in state STATE; can be
2333 combined with -U to restrict to a specific user; STATE can
2335 -m MESSAGE, --message=MESSAGE: Give reason why package failed or
2336 source dependency list
2337 (used with -f, --dep-wait, and --binNMU)
2338 -o, --override: Override another user's lock on a package, i.e.
2339 take it over; a notice mail will be sent to the other user
2340 -U USER, --user=USER: select user name for which listings should
2341 apply, if not given all users are listed.
2342 if -l is missing, set user name to be entered in db; usually
2343 automatically choosen
2344 --import FILE: Import database from a ASCII file FILE
2346 The remaining arguments (depending on operation) usually start with
2347 "name_version", the trailer is ignored. This allows to pass the names
2348 of .dsc files, for which file name completion can be used.
2349 --merge-packages and --merge-quinn take Package/quin--diff file names
2350 on the command line or read stdin. --list needs nothing more on the
2351 command line. --info takes source package names (without version).
2356 sub pkg_version_eq {
2358 my $version = shift;
2361 if (defined $pkg->{'binary_nmu_version'}) and
2362 version_compare(binNMU_version($pkg->{'version'},
2363 $pkg->{'binary_nmu_version'}),'=', $version);
2364 return version_compare( $pkg->{'version'}, "=", $version );
2368 return $arch . '_' . $distribution;
2371 sub user_table_name {
2372 return $arch . '_' . $distribution . '_users';
2375 sub get_source_info {
2377 my $pkg = $dbh->selectrow_hashref('SELECT * FROM ' .
2378 table_name() . ' WHERE package = ?',
2383 sub get_all_source_info {
2384 my $db = $dbh->selectall_hashref('SELECT * FROM ' . table_name(),
2389 sub update_source_info {
2392 my $pkg2 = get_source_info($pkg->{'package'});
2393 if (! defined $pkg2)
2395 add_source_info($pkg);
2398 $dbh->do('UPDATE ' . table_name() . ' SET ' .
2403 'installed_version = ?, ' .
2404 'previous_state = ?, ' .
2405 'state_change = ?, ' .
2409 'old_failed = ?, ' .
2410 'binary_nmu_version = ?, ' .
2411 'binary_nmu_changelog = ?, ' .
2412 'failed_category = ?, ' .
2413 'permbuildpri = ?, ' .
2418 'WHERE package = ?',
2424 $pkg->{'installed_version'},
2425 $pkg->{'previous_state'},
2426 $pkg->{'state_change'},
2430 $pkg->{'old_failed'},
2431 $pkg->{'binary_nmu_version'},
2432 $pkg->{'binary_nmu_changelog'},
2433 $pkg->{'failed_category'},
2434 $pkg->{'permbuildpri'},
2438 $pkg->{'bd_problem'},
2439 $pkg->{'package'}) or die $dbh->errstr;
2442 sub add_source_info {
2444 $dbh->do('INSERT INTO ' . table_name() .
2445 ' (package) values (?)',
2446 undef, $pkg->{'package'}) or die $dbh->errstr;
2449 sub del_source_info {
2451 $dbh->do('DELETE FROM ' . table_name() .
2452 ' WHERE package = ?',
2453 undef, $name) or die $dbh->errstr;
2458 my $user = $dbh->selectrow_hashref('SELECT * FROM ' .
2459 user_table_name() . ' WHERE username = ?',
2464 sub update_user_info {
2466 $dbh->do('UPDATE ' . user_table_name() .
2467 ' SET last_seen = now() WHERE username = ?',
2469 or die $dbh->errstr;
2475 $dbh->do('INSERT INTO ' . user_table_name() .
2476 ' (username, last_seen) values (?, now())',
2478 or die $dbh->errstr;