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 require "/etc/wanna-build.conf";
29 die "$conf::basedir is not a directory\n" if ! -d $conf::basedir;
30 die "dbbase is empty\n" if ! $dbbase;
31 die "transactlog is empty\n" if ! $transactlog;
32 die "mailprog binary $conf::mailprog does not exist or isn't executable\n"
33 if !-x $conf::mailprog;
34 die "no distributions defined\n" if ! %distributions;
44 our ($verbose, $mail_logs, $list_order, $list_state,
45 $curr_date, $op_mode, $user, $real_user, $distribution,
46 $fail_reason, $opt_override, $import_from, $opt_create_db,
48 $info_all_dists, $arch,
49 $category, %catval, %short_category,
50 $short_date, $list_min_age, $dbbase, @curr_time,
51 $build_priority, %new_vers, $binNMUver, %merge_srcvers, %merge_binsrc);
54 $ENV{'PATH'} = "/bin:/usr/bin:/usr/local/bin:/org/wanna-build/bin/";
58 $curr_date = strftime("%Y %b %d %H:%M:%S",@curr_time);
59 $short_date = strftime("%m/%d/%y",@curr_time);
62 # map program invocation names to operation modes
63 my %prognames = ( "uploaded-build" => "set-uploaded",
64 "failed-build" => "set-failed",
65 "no-build" => "set-not-for-us",
66 "give-back-build" => "set-needs-build",
67 "dep-wait-build" => "set-dep-wait",
68 "forget-build" => "forget",
69 "merge-quinn" => "merge-quinn",
70 "merge-packages" => "merge-packages",
71 "merge-sources" => "merge-sources",
72 "build-info" => "info" );
74 %short_category = ( u => "uploaded-fixed-pkg",
81 c => "compiler-error",
85 ($progname = $0) =~ s,.*/,,;
86 if ($prognames{$progname}) {
87 $op_mode = $prognames{$progname};
89 elsif ($progname =~ /^list-(.*)$/) {
91 $list_state = ($1 eq "all") ? "" : $1;
96 verbose => { short => "v", flag => \$verbose },
97 override => { short => "o", flag => \$opt_override },
98 "create-db" => { flag => \$opt_create_db },
99 "correct-compare" => { flag => \$WannaBuild::opt_correct_version_cmp },
100 # TODO: remove after buildds no longer pass to wanna-build
101 "no-propagation" => { short => "N" },
102 "no-down-propagation" => { short => "D" },
104 take => { mode => "set-building" },
105 failed => { short => "f", mode => "set-failed" },
106 uploaded => { short => "u", mode => "set-uploaded" },
107 "no-build" => { short => "n", mode => "set-not-for-us" },
108 built => { mode => "set-built" },
109 attempted => { mode => "set-attempted" },
110 "give-back" => { mode => "set-needs-build" },
111 "dep-wait" => { mode => "set-dep-wait" },
112 forget => { mode => "forget" },
113 'forget-user' => { mode => 'forget-user' },
114 "merge-quinn" => { mode => "merge-quinn" },
115 "merge-partial-quinn" => { mode => "merge-partial-quinn" },
116 "merge-packages" => { mode => "merge-packages" },
117 "merge-sources" => { mode => "merge-sources" },
118 "pretend-avail" => { short => "p", mode => "pretend-avail" },
119 "merge-all" => { mode => "merge-all" },
120 info => { short => "i", mode => "info" },
121 'binNMU' => { mode => 'set-binary-nmu', arg => \$binNMUver,
122 code => sub { die "Invalid binNMU version: $binNMUver\n"
123 if $binNMUver !~ /^([\d]*)$/ and $1 >= 0; } },
124 'perm-build-priority' => { mode => "set-permanent-build-priority", arg => \$build_priority,
125 code => sub { die "Invalid build priority: $build_priority\n"
126 if $build_priority !~ /^-?[\d]+$/; } },
127 'build-priority' => { mode => "set-build-priority", arg => \$build_priority,
128 code => sub { die "Invalid build priority: $build_priority\n"
129 if $build_priority !~ /^-?[\d]+$/; } },
131 { short => "l", mode => "list", arg => \$list_state,
133 die "Unknown state to list: $list_state\n"
134 if !isin( $list_state, qw(needs-build building uploaded
135 built build-attempted failed installed dep-wait
136 not-for-us all failed-removed
137 install-wait reupload-wait bd-uninstallable));} },
140 { short => "d", arg => \$distribution,
142 if ($distribution eq "a" || $distribution eq "all") {
147 $distribution = "oldstable" if $distribution eq "o";
148 $distribution = "stable" if $distribution eq "s";
149 $distribution = "testing" if $distribution eq "t";
150 $distribution = "unstable" if $distribution eq "u";
154 { short => "O", arg => \$list_order,
156 die "Bad ordering character\n"
157 if $list_order !~ /^[PSpsncb]+$/;
159 message => { short => "m", arg => \$fail_reason },
160 # database is deprecated, use arch instead.
161 database => { short => "b", arg => \$conf::dbbase },
162 arch => { short => "A", arg => \$arch },
163 user => { short => "U", arg => \$user },
164 category => { short => "c", arg => \$category,
166 $category = $short_category{$category}
167 if exists $short_category{$category};
168 die "Unknown category: $category\n"
169 if !isin( $category, values %short_category );
171 "min-age" => { short => "a", arg => \$list_min_age,
173 die "Argument of --min-age must be a non-zero number\n"
174 if $list_min_age == 0;
175 $list_min_age *= 24*60*60;
177 "max-age" => { arg => \$list_min_age,
179 die "Argument of --max-age must be a non-zero number\n"
180 if $list_min_age == 0;
181 $list_min_age *= -24*60*60;
184 import => { arg => \$import_from, mode => "import" },
185 "manual-edit" => { mode => "manual-edit" },
188 while( @ARGV && $ARGV[0] =~ /^-/ ) {
191 my($opt, $optname, $arg);
192 if (/^--([^=]+)(=|$)/) {
194 $opt = $options{$optname};
195 $arg = $1 if /^--\Q$optname\E=((.|\n)*)$/;
198 $optname = substr( $_, 1, 1 );
199 $opt = (grep { defined($_->{short}) ? $_->{short} eq $optname : 0} values %options)[0];
200 $arg = $1 if /^-$optname(.+)$/;
203 warn "Unknown option: --$1\n";
208 die "$optname option missing argument\n" if !@ARGV;
211 ${$opt->{arg}} = $arg;
213 elsif (defined $arg) {
214 die "Option $optname takes no argument\n";
218 die "Conflicting operation modes\n" if $op_mode;
219 $op_mode = $opt->{mode};
229 $op_mode = $category ? "set-failed" : "set-building"
230 if !$op_mode; # default operation
231 $list_order = $list_state eq "failed" ? 'fPcpsn' : 'PScpsn'
232 if !$list_order and $list_state;
233 $distribution ||= "unstable";
234 die "Bad distribution '$distribution'\n"
235 if !isin($distribution, keys %conf::distributions);
237 # If they didn't specify an arch, try to get it from database name which
238 # is in the form of $arch/build-db
239 # This is for backwards compatibity with older versions that didn't
240 # specify the arch yet.
241 $conf::dbbase =~ m#^([^/]+)#;
244 # TODO: Check that it's an known arch (for that dist), and give
248 my $version = '$Revision: db181a534e9d $ $Date: 2008/03/26 06:20:22 $ $Author: rmurray $';
249 $version =~ s/(^\$| \$ .*$)//g;
250 print "wanna-build $version for $distribution on $arch\n";
253 if (!@ARGV && !isin( $op_mode, qw(list merge-quinn merge-partial-quinn import
254 merge-packages manual-edit
256 warn "No packages given.\n";
260 $real_user = (getpwuid($<))[0];
261 die "Can't determine your user name\n"
262 if $op_mode ne "list" && !$user &&
263 !($user = $real_user);
266 if ($op_mode eq "set-failed" && !$category) {
267 print "Enter reason for failing (end with '.' alone on ".
272 last if $line eq ".\n";
273 $fail_reason .= $line;
275 chomp( $fail_reason );
276 } elsif ($op_mode eq "set-dep-wait") {
277 print "Enter dependencies (one line):\n";
279 while( !$line && !eof(STDIN) ) {
280 chomp( $line = <STDIN> );
282 die "No dependencies given\n" if !$line;
283 $fail_reason = $line;
284 } elsif ($op_mode eq "set-binary-nmu" and $binNMUver > 0) {
285 print "Enter changelog entry (one line):\n";
287 while( !$line && !eof(STDIN) ) {
288 chomp( $line = <STDIN> );
290 die "No changelog entry given\n" if !$line;
291 $fail_reason = $line;
300 $dbh->disconnect or warn $dbh->errstr;
304 my $schema_suffix = '';
305 # TODO: Base this on something else, like an option that is passed.
306 if ($real_user eq 'nobody') {
307 $dbh = DBI->connect("DBI:Pg:service=wanna-build") ||
308 die "FATAL: Cannot open database: $DBI::errstr\n";
309 $schema_suffix = '_public';
313 $dbh = DBI->connect("DBI:Pg:service=wanna-build-privileged") ||
314 die "FATAL: Cannot open database: $DBI::errstr\n";
317 # TODO: This shouldn't be needed, file a bug.
318 $dbh->{pg_server_prepare} = 0;
320 $dbh->begin_work or die $dbh->errstr;
327 if ($mail_logs && $conf::log_mail) {
328 send_mail( $conf::log_mail,
329 "wanna-build $distribution state changes $curr_date",
330 "State changes at $curr_date for distribution ".
331 "$distribution:\n\n$mail_logs\n" );
339 SWITCH: foreach ($op_mode) {
341 add_packages( $1, @ARGV );
345 list_packages( $list_state );
349 info_packages( @ARGV );
352 /^forget-user/ && do {
353 die "This operation is restricted to admin users\n"
354 if (defined @conf::admin_users and
355 !isin( $real_user, @conf::admin_users));
356 forget_users( @ARGV );
360 forget_packages( @ARGV );
363 /^merge-partial-quinn/ && do {
364 die "This operation is restricted to admin users\n"
365 if (defined @conf::admin_users and
366 !isin( $real_user, @conf::admin_users));
370 /^merge-quinn/ && do {
371 die "This operation is restricted to admin users\n"
372 if (defined @conf::admin_users and
373 !isin( $real_user, @conf::admin_users));
377 /^merge-packages/ && do {
378 die "This operation is restricted to admin users\n"
379 if (defined @conf::admin_users and
380 !isin( $real_user, @conf::admin_users));
384 /^merge-sources/ && do {
385 die "This operation is restricted to admin users\n"
386 if (defined @conf::admin_users and
387 !isin( $real_user, @conf::admin_users));
391 /^pretend-avail/ && do {
392 pretend_avail( @ARGV );
396 die "This operation is restricted to admin users\n"
397 if (defined @conf::admin_users and
398 !isin( $real_user, @conf::admin_users));
400 @ARGV = ( $ARGS[0] );
401 my $pkgs = parse_packages();
402 @ARGV = ( $ARGS[1] );
404 @ARGV = ( $ARGS[2] );
405 my $srcs = parse_sources(1);
406 call_edos_depcheck( $ARGS[0], $srcs );
410 die "This operation is restricted to admin users\n"
411 if (defined @conf::admin_users and
412 !isin( $real_user, @conf::admin_users));
413 $dbh->do("DELETE from " . table_name() .
414 " WHERE distribution = ?", undef,
418 read_db( $import_from );
422 die "Unexpected operation mode $op_mode\n";
424 if (not -t and $user =~ /-/) {
425 my $userinfo = get_user_info($user);
426 if (!defined $userinfo)
428 add_user_info($user);
432 update_user_info($user);
438 my $newstate = shift;
439 my( $package, $name, $version, $ok, $reason );
441 foreach $package (@_) {
442 $package =~ s,^.*/,,; # strip path
443 $package =~ s/\.(dsc|diff\.gz|tar\.gz|deb)$//; # strip extension
444 $package =~ s/_[a-zA-Z\d-]+\.changes$//; # strip extension
445 if ($package =~ /^([\w\d.+-]+)_([\w\d:.+~-]+)/) {
446 ($name,$version) = ($1,$2);
449 warn "$package: can't extract package name and version ".
454 if ($op_mode eq "set-building") {
455 add_one_building( $name, $version );
457 elsif ($op_mode eq "set-built") {
458 add_one_built( $name, $version );
460 elsif ($op_mode eq "set-attempted") {
461 add_one_attempted( $name, $version );
463 elsif ($op_mode eq "set-uploaded") {
464 add_one_uploaded( $name, $version );
466 elsif ($op_mode eq "set-failed") {
467 add_one_failed( $name, $version );
469 elsif ($op_mode eq "set-not-for-us") {
470 add_one_notforus( $name, $version );
472 elsif ($op_mode eq "set-needs-build") {
473 add_one_needsbuild( $name, $version );
475 elsif ($op_mode eq "set-dep-wait") {
476 add_one_depwait( $name, $version );
478 elsif ($op_mode eq "set-build-priority") {
479 set_one_buildpri( $name, $version, 'buildpri' );
481 elsif ($op_mode eq "set-permanent-build-priority") {
482 set_one_buildpri( $name, $version, 'permbuildpri' );
484 elsif ($op_mode eq "set-binary-nmu") {
485 set_one_binnmu( $name, $version );
490 sub add_one_building {
496 my $pkg = get_source_info($name);
498 if ($pkg->{'state'} eq "Not-For-Us") {
500 $reason = "not suitable for this architecture";
502 elsif ($pkg->{'state'} =~ /^Dep-Wait/) {
504 $reason = "not all source dependencies available yet";
506 elsif ($pkg->{'state'} =~ /^BD-Uninstallable/) {
508 $reason = "source dependencies are not installable";
510 elsif ($pkg->{'state'} eq "Uploaded" &&
511 (version_lesseq($version, $pkg->{'version'}))) {
513 $reason = "already uploaded by $pkg->{'builder'}";
514 $reason .= " (in newer version $pkg->{'version'})"
515 if !version_eq($pkg, $version);
517 elsif ($pkg->{'state'} eq "Installed" &&
518 version_less($version,$pkg->{'version'})) {
520 print "$name: Warning: newer version $pkg->{'version'} ".
521 "already installed, but overridden.\n";
525 $reason = "newer version $pkg->{'version'} already in ".
526 "archive; doesn't need rebuilding";
527 print "$name: Note: If the following is due to an epoch ",
528 " change, use --override\n";
531 elsif ($pkg->{'state'} eq "Installed" &&
532 pkg_version_eq($pkg,$version)) {
534 $reason = "is up-to-date in the archive; doesn't need rebuilding";
536 elsif ($pkg->{'state'} eq "Needs-Build" &&
537 version_less($version,$pkg->{'version'})) {
539 print "$name: Warning: newer version $pkg->{'version'} ".
540 "needs building, but overridden.";
544 $reason = "newer version $pkg->{'version'} needs building, ".
548 elsif (isin($pkg->{'state'},qw(Building Built Build-Attempted))) {
549 if (version_less($pkg->{'version'},$version)) {
550 print "$name: Warning: Older version $pkg->{'version'} ",
551 "is being built by $pkg->{'builder'}\n";
552 if ($pkg->{'builder'} ne $user) {
553 send_mail( $pkg->{'builder'},
554 "package takeover in newer version",
555 "You are building package '$name' in ".
556 "version $version\n".
557 "(as far as I'm informed).\n".
558 "$user now has taken the newer ".
559 "version $version for building.".
560 "You can abort the build if you like.\n" );
565 print "User $pkg->{'builder'} had already ",
566 "taken the following package,\n",
567 "but overriding this as you request:\n";
568 send_mail( $pkg->{'builder'}, "package takeover",
569 "The package '$name' (version $version) that ".
570 "was taken by you\n".
571 "has been taken over by $user\n" );
573 elsif ($pkg->{'builder'} eq $user) {
574 print "$name: Note: already taken by you.\n";
575 print "$name: ok\n" if $verbose;
580 $reason = "already taken by $pkg->{'builder'}";
581 $reason .= " (in newer version $pkg->{'version'})"
582 if !version_eq($pkg->{'version'}, $version);
586 elsif ($pkg->{'state'} =~ /^Failed/ &&
587 pkg_version_eq($pkg, $version)) {
589 print "The following package previously failed ",
590 "(by $pkg->{'builder'})\n",
591 "but overriding this as you request:\n";
592 send_mail( $pkg->{'builder'}, "failed package takeover",
593 "The package '$name' (version $version) that ".
595 "and has failed previously has been taken over ".
597 if $pkg->{'builder'} ne $user;
601 $reason = "build of $version failed previously:\n ";
602 $reason .= join( "\n ", split( "\n", $pkg->{'failed'} ));
603 $reason .= "\nalso the package doesn't need builing"
604 if $pkg->{'state'} eq 'Failed-Removed';
610 if ($pkg->{'binary_nmu_version'}) {
611 print "$name: Warning: needs binary NMU $pkg->{'binary_nmu_version'}\n" .
612 "$pkg->{'binary_nmu_changelog'}\n";
615 print "$name: Warning: Previous version failed!\n"
616 if $pkg->{'previous_state'} =~ /^Failed/ ||
617 $pkg->{'state'} =~ /^Failed/;
619 change_state( \$pkg, 'Building' );
620 $pkg->{'package'} = $name;
621 $pkg->{'version'} = $version;
622 $pkg->{'builder'} = $user;
623 log_ta( $pkg, "--take" );
624 update_source_info($pkg);
625 print "$name: $ok\n" if $verbose;
628 print "$name: NOT OK!\n $reason\n";
632 sub add_one_attempted {
635 my $pkg = get_source_info($name);
637 if (!defined($pkg)) {
638 print "$name: not registered yet.\n";
642 if ($pkg->{'state'} ne "Building" ) {
643 print "$name: not taken for building (state is $pkg->{'state'}). ",
647 if ($pkg->{'builder'} ne $user) {
648 print "$name: not taken by you, but by $pkg->{'builder'}. Skipping.\n";
651 elsif ( !pkg_version_eq($pkg, $version) ) {
652 print "$name: version mismatch ".
653 "$(pkg->{'version'} ".
654 "by $pkg->{'builder'})\n";
658 change_state( \$pkg, 'Build-Attempted' );
659 log_ta( $pkg, "--attempted" );
660 update_source_info($pkg);
661 print "$name: registered as uploaded\n" if $verbose;
667 my $pkg = get_source_info($name);
669 if (!defined($pkg)) {
670 print "$name: not registered yet.\n";
674 if ($pkg->{'state'} ne "Building" ) {
675 print "$name: not taken for building (state is $pkg->{'state'}). ",
679 if ($pkg->{'builder'} ne $user) {
680 print "$name: not taken by you, but by $pkg->{'builder'}. Skipping.\n";
683 elsif ( !pkg_version_eq($pkg, $version) ) {
684 print "$name: version mismatch ".
685 "$(pkg->{'version'} ".
686 "by $pkg->{'builder'})\n";
689 change_state( \$pkg, 'Built' );
690 log_ta( $pkg, "--built" );
691 update_source_info($pkg);
692 print "$name: registered as built\n" if $verbose;
695 sub add_one_uploaded {
698 my $pkg = get_source_info($name);
700 if (!defined($pkg)) {
701 print "$name: not registered yet.\n";
705 if ($pkg->{'state'} eq "Uploaded" &&
706 pkg_version_eq($pkg,$version)) {
707 print "$name: already uploaded\n";
710 if (!isin( $pkg->{'state'}, qw(Building Built Build-Attempted))) {
711 print "$name: not taken for building (state is $pkg->{'state'}). ",
715 if ($pkg->{'builder'} ne $user) {
716 print "$name: not taken by you, but by $pkg->{'builder'}. Skipping.\n";
719 # strip epoch -- buildd-uploader used to go based on the filename.
720 # (to remove at some point)
722 ($pkgver = $pkg->{'version'}) =~ s/^\d+://;
723 $version =~ s/^\d+://; # for command line use
724 if ($pkg->{'binary_nmu_version'} ) {
725 my $nmuver = binNMU_version($pkgver, $pkg->{'binary_nmu_version'});
726 if (!version_eq( $nmuver, $version )) {
727 print "$name: version mismatch ($nmuver registered). ",
731 } elsif (!version_eq($pkgver, $version)) {
732 print "$name: version mismatch ($pkg->{'version'} registered). ",
737 change_state( \$pkg, 'Uploaded' );
738 log_ta( $pkg, "--uploaded" );
739 update_source_info($pkg);
740 print "$name: registered as uploaded\n" if $verbose;
747 my $pkg = get_source_info($name);
749 if (!defined($pkg)) {
750 print "$name: not registered yet.\n";
753 $state = $pkg->{'state'};
755 if ($state eq "Not-For-Us") {
756 print "$name: not suitable for this architecture anyway. Skipping.\n";
759 elsif ($state eq "Failed-Removed") {
760 print "$name: failed previously and doesn't need building. Skipping.\n";
763 elsif ($state eq "Installed") {
764 print "$name: Is already installed in archive. Skipping.\n";
767 elsif ($pkg->{'builder'} &&
768 (($user ne $pkg->{'builder'}) &&
769 !($pkg->{'builder'} =~ /^(\w+)-\w+/ && $1 eq $user))) {
770 print "$name: not taken by you, but by ".
771 "$pkg->{'builder'}. Skipping.\n";
774 elsif ( !pkg_version_eq($pkg, $version) ) {
775 print "$name: version mismatch ".
776 "$(pkg->{'version'} ".
777 "by $pkg->{'builder'})\n";
782 if (!$cat && $fail_reason =~ /^\[([^\]]+)\]/) {
784 $cat = $short_category{$cat} if exists $short_category{$cat};
785 if (!isin( $cat, values %short_category )) {
786 print "$name: Warning: unknown category $cat; discarded\n";
789 $fail_reason =~ s/^\[[^\]]+\][ \t]*\n*//;
792 if ($state eq "Needs-Build") {
793 print "$name: Warning: not registered for building previously, ".
794 "but processing anyway.\n";
796 elsif ($state eq "Uploaded") {
797 print "$name: Warning: marked as uploaded previously, ".
798 "but processing anyway.\n";
800 elsif ($state eq "Dep-Wait") {
801 print "$name: Warning: marked as waiting for dependencies, ".
802 "but processing anyway.\n";
804 elsif ($state eq "BD-Uninstallable") {
805 print "$name: Warning: marked as having uninstallable build-dependencies, ".
806 "but processing anyway.\n";
808 elsif ($state eq "Failed") {
809 print "$name: already registered as failed; will append new message\n"
811 print "$name: already registered as failed; changing category\n"
815 if (($cat eq "reminder-sent" || $cat eq "nmu-offered") &&
816 defined $pkg->{'failed_category'} &&
817 $pkg->{'failed_category'} ne $cat) {
818 (my $action = $cat) =~ s/-/ /;
819 $fail_reason .= "\n$short_date: $action";
822 change_state( \$pkg, 'Failed' );
823 $pkg->{'builder'} = $user;
824 $pkg->{'failed'} .= "\n" if $pkg->{'failed'};
825 $pkg->{'failed'} .= $fail_reason;
826 $pkg->{'failed_category'} = $cat if $cat;
827 if (defined $pkg->{'permbuildpri'}) {
828 $pkg->{'buildpri'} = $pkg->{'permbuildpri'};
830 delete $pkg->{'buildpri'};
832 log_ta( $pkg, "--failed" );
833 update_source_info($pkg);
834 print "$name: registered as failed\n" if $verbose;
837 sub add_one_notforus {
840 my $pkg = get_source_info($name);
842 if ($pkg->{'state'} eq 'Not-For-Us') {
843 # reset Not-For-Us state in case it's called twice; this is
844 # the only way to get a package out of this state...
845 # There is no really good state in which such packages should
846 # be put :-( So use Failed for now.
847 change_state( \$pkg, 'Failed' );
848 $pkg->{'package'} = $name;
849 $pkg->{'failed'} = "Was Not-For-Us previously";
850 delete $pkg->{'builder'};
851 delete $pkg->{'depends'};
852 log_ta( $pkg, "--no-build(rev)" );
853 print "$name: now not unsuitable anymore\n";
855 send_mail( $conf::notforus_maint,
856 "$name moved out of Not-For-Us state",
857 "The package '$name' has been moved out of the Not-For-Us ".
859 "It should probably also be removed from ".
860 "Packages-arch-specific or\n".
861 "the action was wrong.\n" )
862 if $conf::notforus_maint;
865 change_state( \$pkg, 'Not-For-Us' );
866 $pkg->{'package'} = $name;
867 delete $pkg->{'builder'};
868 delete $pkg->{'depends'};
869 delete $pkg->{'buildpri'};
870 delete $pkg->{'binary_nmu_version'};
871 delete $pkg->{'binary_nmu_changelog'};
872 log_ta( $pkg, "--no-build" );
873 print "$name: registered as unsuitable\n" if $verbose;
875 send_mail( $conf::notforus_maint,
876 "$name set to Not-For-Us",
877 "The package '$name' has been set to state Not-For-Us ".
879 "It should probably also be added to ".
880 "Packages-arch-specific or\n".
881 "the Not-For-Us state is wrong.\n" )
882 if $conf::notforus_maint;
884 update_source_info($pkg);
887 sub add_one_needsbuild {
891 my $pkg = get_source_info($name);
893 if (!defined($pkg)) {
894 print "$name: not registered; can't give back.\n";
897 $state = $pkg->{'state'};
899 if ($state eq "BD-Uninstallable") {
901 print "$name: Forcing uninstallability mark to be removed. This is not permanent and might be reset with the next trigger run\n";
903 change_state( \$pkg, 'Needs-Build' );
904 delete $pkg->{'builder'};
905 delete $pkg->{'depends'};
906 log_ta( $pkg, "--give-back" );
907 update_source_info($pkg);
908 print "$name: given back\n" if $verbose;
912 print "$name: has uninstallable build-dependencies. Skipping\n",
913 " (use --override to clear dependency list and ",
914 "give back anyway)\n";
918 elsif ($state eq "Dep-Wait") {
920 print "$name: Forcing source dependency list to be cleared\n";
923 print "$name: waiting for source dependencies. Skipping\n",
924 " (use --override to clear dependency list and ",
925 "give back anyway)\n";
929 elsif (!isin( $state, qw(Building Built Build-Attempted))) {
930 print "$name: not taken for building (state is $state).";
932 print "\n$name: Forcing give-back\n";
935 print " Skipping.\n";
939 if (defined ($pkg->{'builder'}) && $user ne $pkg->{'builder'} &&
940 !($pkg->{'builder'} =~ /^(\w+)-\w+/ && $1 eq $user)) {
941 print "$name: not taken by you, but by ".
942 "$pkg->{'builder'}. Skipping.\n";
945 if (!pkg_version_eq($pkg, $version)) {
946 print "$name: version mismatch ($pkg->{'version'} registered). ",
950 if ($distribution eq "unstable") {
951 change_state( \$pkg, 'BD-Uninstallable' );
952 $pkg->{'bd_problem'} = "Installability of build dependencies not tested yet";
954 change_state( \$pkg, 'Needs-Build' );
956 $pkg->{'builder'} = undef;
957 $pkg->{'depends'} = undef;
958 log_ta( $pkg, "--give-back" );
959 update_source_info($pkg);
960 print "$name: given back\n" if $verbose;
966 my $pkg = get_source_info($name);
969 if (!defined($pkg)) {
970 print "$name: not registered; can't register for binNMU.\n";
973 my $db_ver = $pkg->{'version'};
975 if (!version_eq($db_ver, $version)) {
976 print "$name: version mismatch ($db_ver registered). ",
980 $state = $pkg->{'state'};
982 if (defined $pkg->{'binary_nmu_version'}) {
983 if ($binNMUver == 0) {
984 change_state( \$pkg, 'Installed' );
985 delete $pkg->{'builder'};
986 delete $pkg->{'depends'};
987 delete $pkg->{'binary_nmu_version'};
988 delete $pkg->{'binary_nmu_changelog'};
989 } elsif ($binNMUver <= $pkg->{'binary_nmu_version'}) {
990 print "$name: already building binNMU $pkg->{'binary_nmu_version'}\n";
993 $pkg->{'binary_nmu_version'} = $binNMUver;
994 $pkg->{'binary_nmu_changelog'} = $fail_reason;
995 $pkg->{'notes'} = 'out-of-date';
996 $pkg->{'buildpri'} = $pkg->{'permbuildpri'}
997 if (defined $pkg->{'permbuildpri'});
999 log_ta( $pkg, "--binNMU" );
1000 update_source_info($pkg);
1002 } elsif ($binNMUver == 0) {
1003 print "${name}_$version: no scheduled binNMU to cancel.\n";
1007 if ($state ne 'Installed') {
1008 print "${name}_$version: not installed; can't register for binNMU.\n";
1012 my $fullver = binNMU_version($version,$binNMUver);
1013 if ( version_lesseq( $fullver, $pkg->{'installed_version'} ) )
1015 print "$name: binNMU $fullver is not newer than current version $pkg->{'installed_version'}\n";
1019 change_state( \$pkg, 'BD-Uninstallable' );
1020 $pkg->{'bd_problem'} = "Installability of build dependencies not tested yet";
1021 delete $pkg->{'builder'};
1022 delete $pkg->{'depends'};
1023 $pkg->{'binary_nmu_version'} = $binNMUver;
1024 $pkg->{'binary_nmu_changelog'} = $fail_reason;
1025 $pkg->{'notes'} = 'out-of-date';
1026 log_ta( $pkg, "--binNMU" );
1027 update_source_info($pkg);
1028 print "${name}: registered for binNMU $fullver\n" if $verbose;
1031 sub set_one_buildpri {
1033 my $version = shift;
1035 my $pkg = get_source_info($name);
1038 if (!defined($pkg)) {
1039 print "$name: not registered; can't set priority.\n";
1042 $state = $pkg->{'state'};
1044 if ($state eq "Not-For-Us") {
1045 print "$name: not suitable for this architecture. Skipping.\n";
1047 } elsif ($state eq "Failed-Removed") {
1048 print "$name: failed previously and doesn't need building. Skipping.\n";
1051 if (!pkg_version_eq($pkg, $version)) {
1052 print "$name: version mismatch ($pkg->{'version'} registered). ",
1056 if ( $build_priority == 0 ) {
1057 delete $pkg->{'buildpri'}
1058 if $key eq 'permbuildpri' and defined $pkg->{'buildpri'}
1059 and $pkg->{'buildpri'} == $pkg->{$key};
1060 delete $pkg->{$key};
1062 $pkg->{'buildpri'} = $build_priority
1063 if $key eq 'permbuildpri';
1064 $pkg->{$key} = $build_priority;
1066 update_source_info($pkg);
1067 print "$name: set to build priority $build_priority\n" if $verbose;
1070 sub add_one_depwait {
1072 my $version = shift;
1074 my $pkg = get_source_info($name);
1076 if (!defined($pkg)) {
1077 print "$name: not registered yet.\n";
1080 $state = $pkg->{'state'};
1082 if ($state eq "Dep-Wait") {
1083 print "$name: merging with previously registered dependencies\n";
1086 if (isin( $state, qw(Needs-Build Failed BD-Uninstallable))) {
1087 print "$name: Warning: not registered for building previously, ".
1088 "but processing anyway.\n";
1090 elsif ($state eq "Not-For-Us") {
1091 print "$name: not suitable for this architecture anyway. Skipping.\n";
1094 elsif ($state eq "Failed-Removed") {
1095 print "$name: failed previously and doesn't need building. Skipping.\n";
1098 elsif ($state eq "Installed") {
1099 print "$name: Is already installed in archive. Skipping.\n";
1102 elsif ($state eq "Uploaded") {
1103 print "$name: Is already uploaded. Skipping.\n";
1106 elsif ($pkg->{'builder'} &&
1107 $user ne $pkg->{'builder'}) {
1108 print "$name: not taken by you, but by ".
1109 "$pkg->{'builder'}. Skipping.\n";
1112 elsif ( !pkg_version_eq($pkg,$version)) {
1113 print "$name: version mismatch ".
1114 "($pkg->{'version'} ".
1115 "by $pkg->{'builder'})\n";
1118 elsif ($fail_reason =~ /^\s*$/ ||
1119 !parse_deplist( $fail_reason, 1 )) {
1120 print "$name: Bad dependency list\n";
1123 change_state( \$pkg, 'Dep-Wait' );
1124 $pkg->{'builder'} = $user;
1125 if (defined $pkg->{'permbuildpri'}) {
1126 $pkg->{'buildpri'} = $pkg->{'permbuildpri'};
1128 delete $pkg->{'buildpri'};
1130 my $deplist = parse_deplist( $pkg->{'depends'} );
1131 my $new_deplist = parse_deplist( $fail_reason );
1132 # add new dependencies, maybe overwriting old entries
1133 foreach (keys %$new_deplist) {
1134 $deplist->{$_} = $new_deplist->{$_};
1136 $pkg->{'depends'} = build_deplist($deplist);
1137 log_ta( $pkg, "--dep-wait" );
1138 update_source_info($pkg);
1139 print "$name: registered as waiting for dependencies\n" if $verbose;
1149 local($/) = ""; # read in paragraph mode
1151 my( $version, $arch, $section, $priority, $builddep, $buildconf, $binaries );
1153 /^Package:\s*(\S+)$/mi and $name = $1;
1154 /^Version:\s*(\S+)$/mi and $version = $1;
1155 /^Architecture:\s*(\S+)$/mi and $arch = $1;
1156 /^Section:\s*(\S+)$/mi and $section = $1;
1157 /^Priority:\s*(\S+)$/mi and $priority = $1;
1158 /^Build-Depends:\s*(.*)$/mi and $builddep = $1;
1159 /^Build-Conflicts:\s*(.*)$/mi and $buildconf = $1;
1160 /^Binary:\s*(.*)$/mi and $binaries = $1;
1162 next if (defined $srcver{$name} and version_less( $version, $srcver{$name} ));
1163 $srcver{$name} = $version;
1165 $pkgs{$name}{'ver'} = $version;
1166 $pkgs{$name}{'bin'} = $binaries;
1167 $pkgs{$name}{'dep'} = $builddep;
1168 $pkgs{$name}{'conf'} = $buildconf;
1169 my $pkg = get_source_info($name);
1174 if ($arch eq "all" && !version_less( $version, $pkg->{'version'} )) {
1175 # package is now Arch: all, delete it from db
1176 change_state( \$pkg, 'deleted' );
1177 log_ta( $pkg, "--merge-sources" );
1178 print "$name ($pkg->{'version'}): deleted ".
1179 "from database, because now Arch: all\n"
1181 del_source_info($name);
1185 # The "Version" should always be the source version --
1186 # not a possible binNMU version number.
1187 $pkg->{'version'} = $version, $change++
1188 if ($pkg->{'state'} eq 'Installed' and
1189 !version_eq( $pkg->{'version'}, $version));
1190 # Always update priority and section, if available
1191 $pkg->{'priority'} = $priority, $change++
1192 if defined $priority and (not defined($pkg->{'priority'}) or $pkg->{'priority'} ne $priority);
1194 $pkg->{'section'} = $section, $change++
1195 if defined $section and (not defined($pkg->{'section'}) or $pkg->{'section'} ne $section);
1197 update_source_info($pkg) if $change;
1200 # Now that we only have the latest source version, build the list
1201 # of binary packages from the Sources point of view
1202 foreach $name (keys %pkgs) {
1203 foreach my $bin (split( /\s*,\s*/, $pkgs{$name}{'bin'} ) ) {
1204 $merge_binsrc{$bin} = $name;
1207 # remove installed packages that no longer have source available
1208 # or binaries installed
1209 my $db = get_all_source_info();
1210 foreach $name (keys %$db) {
1211 next if $name =~ /^_/;
1212 my $pkg = $db->{$name};
1213 if (not defined($pkgs{$name})) {
1214 change_state( \$pkg, 'deleted' );
1215 log_ta( $pkg, "--merge-sources" );
1216 print "$name ($pkg->{'version'}): ".
1217 "deleted from database, because ".
1218 "not in Sources anymore\n"
1220 del_source_info($name);
1222 next if !isin( $pkg->{'state'}, qw(Installed) );
1223 if ($full && not defined $merge_srcvers{$name}) {
1224 change_state( \$pkg, 'deleted' );
1225 log_ta( $pkg, "--merge-sources" );
1226 print "$name ($pkg->{'version'}): ".
1227 "deleted from database, because ".
1228 "binaries don't exist anymore\n"
1230 del_source_info($name);
1231 } elsif ($full && version_less( $merge_srcvers{$name}, $pkg->{'version'})) {
1232 print "$name ($pkg->{'version'}): ".
1233 "package is Installed but binaries are from ".
1234 $merge_srcvers{$name}. "\n"
1242 # This function looks through a Packages file and sets the state of
1243 # packages to 'Installed'
1244 sub parse_packages {
1247 local($/) = ""; # read in paragraph mode
1249 my( $name, $version, $depends, $source, $sourcev, $architecture, $provides, $binaryv, $binnmu );
1251 /^Package:\s*(\S+)$/mi and $name = $1;
1252 /^Version:\s*(\S+)$/mi and $version = $1;
1253 /^Depends:\s*(.*)$/mi and $depends = $1;
1254 /^Source:\s*(\S+)(\s*\((\S+)\))?$/mi and ($source,$sourcev) = ($1, $3);
1255 /^Architecture:\s*(\S+)$/mi and $architecture = $1;
1256 /^Provides:\s*(.*)$/mi and $provides = $1;
1257 next if !$name || !$version;
1258 next if ($arch ne $architecture and $architecture ne "all");
1259 next if (defined ($installed->{$name}) and $installed->{$name}{'version'} ne "" and
1260 version_lesseq( $version, $installed->{$name}{'version'} ));
1261 $installed->{$name}{'version'} = $version;
1262 $installed->{$name}{'depends'} = $depends;
1263 $installed->{$name}{'all'} = 1 if $architecture eq "all";
1264 undef $installed->{$name}{'Provider'};
1265 $installed->{$name}{'Source'} = $source ? $source : $name;
1267 foreach (split( /\s*,\s*/, $provides )) {
1268 if (not defined ($installed->{$_})) {
1269 $installed->{$_}{'version'} = "";
1270 $installed->{$_}{'Provider'} = $name;
1274 if ( $version =~ /\+b(\d+)$/ ) {
1277 $version = $sourcev if $sourcev;
1278 $binaryv = $version;
1279 $binaryv =~ s/\+b\d+$//;
1280 $installed->{$name}{'Sourcev'} = $sourcev ? $sourcev : $binaryv;
1281 $binaryv .= "+b$binnmu" if defined($binnmu);
1283 next if $architecture ne $arch;
1284 $name = $source if $source;
1285 next if defined($merge_srcvers{$name}) and $merge_srcvers{$name} eq $version;
1286 $merge_srcvers{$name} = $version;
1288 my $pkg = get_source_info($name);
1291 if (isin( $pkg->{'state'}, qw(Not-For-Us)) ||
1292 (isin($pkg->{'state'}, qw(Installed)) &&
1293 version_lesseq($binaryv, $pkg->{'installed_version'}))) {
1294 print "Skipping $name because State == $pkg->{'state'}\n"
1298 if ($pkg->{'binary_nmu_version'} ) {
1299 my $nmuver = binNMU_version($pkg->{'version'}, $pkg->{'binary_nmu_version'});
1300 if (version_less( $binaryv, $nmuver )) {
1301 print "Skipping $name ($version) because have newer ".
1302 "version ($nmuver) in db.\n"
1306 } elsif (version_less($version, $pkg->{'version'})) {
1307 print "Skipping $name ($version) because have newer ".
1308 "version ($pkg->{'version'}) in db.\n"
1313 if (!pkg_version_eq($pkg, $version) &&
1314 $pkg->{'state'} ne "Installed") {
1315 warn "Warning: $name: newer version than expected appeared ".
1316 "in archive ($version vs. $pkg->{'version'})\n";
1317 delete $pkg->{'builder'};
1320 if (!isin( $pkg->{'state'}, qw(Uploaded) )) {
1321 warn "Warning: Package $name was not in uploaded state ".
1322 "before (but in '$pkg->{'state'}').\n";
1323 delete $pkg->{'builder'};
1324 delete $pkg->{'depends'};
1328 $pkg->{'version'} = $version;
1331 change_state( \$pkg, 'Installed' );
1332 $pkg->{'package'} = $name;
1333 $pkg->{'installed_version'} = $binaryv;
1334 if (defined $pkg->{'permbuildpri'}) {
1335 $pkg->{'buildpri'} = $pkg->{'permbuildpri'};
1337 delete $pkg->{'buildpri'};
1339 $pkg->{'version'} = $version
1340 if version_less( $pkg->{'version'}, $version);
1341 delete $pkg->{'binary_nmu_version'};
1342 delete $pkg->{'binary_nmu_changelog'};
1343 log_ta( $pkg, "--merge-packages" );
1344 update_source_info($pkg);
1345 print "$name ($version) is up-to-date now.\n" if $verbose;
1348 check_dep_wait( "--merge-packages", $installed );
1353 my ($package, $name, $version, $installed);
1355 foreach $package (@_) {
1356 $package =~ s,^.*/,,; # strip path
1357 $package =~ s/\.(dsc|diff\.gz|tar\.gz|deb)$//; # strip extension
1358 $package =~ s/_[\w\d]+\.changes$//; # strip extension
1359 if ($package =~ /^([\w\d.+-]+)_([\w\d:.+~-]+)/) {
1360 ($name,$version) = ($1,$2);
1363 warn "$package: can't extract package name and version ".
1367 $installed->{$name}{'version'} = $version;
1370 check_dep_wait( "--pretend-avail", $installed );
1373 sub check_dep_wait {
1375 my $installed = shift;
1377 # check all packages in state Dep-Wait if dependencies are all
1380 my $db = get_all_source_info();
1381 foreach $name (keys %$db) {
1382 next if $name =~ /^_/;
1383 my $pkg = $db->{$name};
1384 next if $pkg->{'state'} ne "Dep-Wait";
1385 my $deps = $pkg->{'depends'};
1387 print "$name: was in state Dep-Wait, but with empty ",
1389 goto make_needs_build;
1391 my $deplist = parse_deplist($deps);
1395 foreach (keys %$deplist) {
1396 if (!exists $installed->{$_} ||
1397 ($deplist->{$_}->{'rel'} && $deplist->{$_}->{'version'} &&
1398 !version_compare( $installed->{$_}{'version'},
1399 $deplist->{$_}->{'rel'},
1400 $deplist->{$_}->{'version'}))) {
1402 $new_deplist->{$_} = $deplist->{$_};
1405 push( @removed_deps, $_ );
1410 change_state( \$pkg, 'Needs-Build' );
1411 log_ta( $pkg, $action );
1412 delete $pkg->{'builder'};
1413 delete $pkg->{'depends'};
1414 print "$name ($pkg->{'version'}) has all ",
1415 "dependencies available now\n" if $verbose;
1417 update_source_info($pkg);
1419 elsif (@removed_deps) {
1420 $pkg->{'depends'} = build_deplist( $new_deplist );
1421 print "$name ($pkg->{'version'}): some dependencies ",
1422 "(@removed_deps) available now, but not all yet\n"
1424 update_source_info($pkg);
1429 # This function accepts quinn-diff output (either from a file named on
1430 # the command line, or on stdin) and sets the packages named there to
1431 # state 'Needs-Build'.
1432 sub parse_quinn_diff {
1433 my $partial = shift;
1439 next if !m,^([-\w\d/]*)/ # section
1440 ([-\w\d.+]+)_ # package name
1441 ([\w\d:.~+-]+)\.dsc\s* # version
1442 \[([^:]*): # priority
1443 ([^]]+)\]\s*$,x; # rest of notes
1444 my($section,$name,$version,$priority,$notes) = ($1, $2, $3, $4, $5);
1445 $quinn_pkgs{$name}++;
1446 $section ||= "unknown";
1447 $priority ||= "unknown";
1448 $priority = "unknown" if $priority eq "-";
1449 $priority = "standard" if ($name eq "debian-installer");
1451 my $pkg = get_source_info($name);
1453 # Always update section and priority.
1454 if (defined($pkg)) {
1456 $pkg->{'section'} = $section, $change++ if not defined
1457 $pkg->{'section'} or $section ne "unknown";
1458 $pkg->{'priority'} = $priority, $change++ if not defined
1459 $pkg->{'priority'} or $priority ne "unknown";
1462 if (defined($pkg) &&
1463 $pkg->{'state'} =~ /^Dep-Wait/ &&
1464 version_less( $pkg->{'version'}, $version )) {
1465 change_state( \$pkg, 'Dep-Wait' );
1466 $pkg->{'version'} = $version;
1467 delete $pkg->{'binary_nmu_version'};
1468 delete $pkg->{'binary_nmu_changelog'};
1469 log_ta( $pkg, "--merge-quinn" );
1471 print "$name ($version) still waiting for dependencies.\n"
1474 elsif (defined($pkg) &&
1475 $pkg->{'state'} =~ /-Removed$/ &&
1476 version_eq($pkg->{'version'}, $version)) {
1477 # reinstantiate a package that has been removed earlier
1478 # (probably due to a quinn-diff malfunction...)
1479 my $newstate = $pkg->{'state'};
1480 $newstate =~ s/-Removed$//;
1481 change_state( \$pkg, $newstate );
1482 $pkg->{'version'} = $version;
1483 $pkg->{'notes'} = $notes;
1484 log_ta( $pkg, "--merge-quinn" );
1486 print "$name ($version) reinstantiated to $newstate.\n"
1489 elsif (defined($pkg) &&
1490 $pkg->{'state'} eq "Not-For-Us" &&
1491 version_less( $pkg->{'version'}, $version )) {
1492 # for Not-For-Us packages just update the version etc., but
1494 change_state( \$pkg, "Not-For-Us" );
1495 $pkg->{'package'} = $name;
1496 $pkg->{'version'} = $version;
1497 $pkg->{'notes'} = $notes;
1498 delete $pkg->{'builder'};
1499 log_ta( $pkg, "--merge-quinn" );
1501 print "$name ($version) still Not-For-Us.\n" if $verbose;
1503 elsif (!defined($pkg) ||
1504 $pkg->{'state'} ne "Not-For-Us" &&
1505 (version_less( $pkg->{'version'}, $version ) ||
1506 ($pkg->{'state'} eq "Installed" && version_less($pkg->{'installed_version'}, $version)))) {
1508 if (defined( $pkg->{'state'} ) && isin( $pkg->{'state'}, qw(Building Built Build-Attempted))) {
1509 send_mail( $pkg->{'builder'},
1510 "new version of $name (dist=$distribution)",
1511 "As far as I'm informed, you're currently ".
1512 "building the package $name\n".
1513 "in version $pkg->{'version'}.\n\n".
1514 "Now there's a new source version $version. ".
1515 "If you haven't finished\n".
1516 "compiling $name yet, you can stop it to ".
1517 "save some work.\n".
1518 "Just to inform you...\n".
1519 "(This is an automated message)\n" );
1520 print "$name: new version ($version) while building ".
1521 "$pkg->{'version'} -- sending mail ".
1522 "to builder ($pkg->{'builder'})\n"
1525 change_state( \$pkg, 'Needs-Build' );
1526 $pkg->{'package'} = $name;
1527 $pkg->{'version'} = $version;
1528 $pkg->{'section'} = $section;
1529 $pkg->{'priority'} = $priority;
1530 $pkg->{'notes'} = $notes;
1531 delete $pkg->{'builder'};
1532 delete $pkg->{'binary_nmu_version'};
1533 delete $pkg->{'binary_nmu_changelog'};
1534 log_ta( $pkg, "--merge-quinn" );
1537 print "$name ($version) needs rebuilding now.\n" if $verbose;
1539 elsif (defined($pkg) &&
1540 !version_eq( $pkg->{'version'}, $version ) &&
1541 isin( $pkg->{'state'}, qw(Installed Not-For-Us) )) {
1542 print "$name: skipping because version in db ".
1543 "($pkg->{'version'}) is >> than ".
1544 "what quinn-diff says ($version) ".
1545 "(state is $pkg->{'state'})\n"
1547 $dubious .= "$pkg->{'state'}: ".
1548 "db ${name}_$pkg->{'version'} >> ".
1549 "quinn $version\n" if !$partial;
1551 elsif ($verbose >= 2) {
1552 if ($pkg->{'state'} eq "Not-For-Us") {
1553 print "Skipping $name because State == ".
1554 "$pkg->{'state'}\n";
1556 elsif (!version_less($pkg->{'version'}, $version)) {
1557 print "Skipping $name because version in db ".
1558 "($pkg->{'version'}) is >= than ".
1559 "what quinn-diff says ($version)\n";
1562 update_source_info($pkg) if $change;
1566 send_mail( $conf::db_maint,
1567 "Dubious versions in " . table_name() . " "
1568 . $distribution . " table",
1569 "The following packages have a newer version in the ".
1570 "wanna-build database\n".
1571 "than what quinn-diff says, and this is strange for ".
1573 "It could be caused by a lame mirror, or the version ".
1574 "in the database\n".
1579 # Now re-check the DB for packages in states Needs-Build, Failed,
1580 # Dep-Wait or BD-Uninstallable and remove them if they're not listed
1581 # anymore by quinn-diff.
1584 my $db = get_all_source_info();
1585 foreach $name (keys %$db) {
1586 next if $name =~ /^_/;
1587 my $pkg = $db->{$name};
1588 next if defined $pkg->{'binary_nmu_version'};
1589 next if !isin( $pkg->{'state'},
1590 qw(Needs-Build Building Built Build-Attempted Uploaded Failed Dep-Wait BD-Uninstallable) );
1591 my $virtual_delete = $pkg->{'state'} eq 'Failed';
1593 if (!$quinn_pkgs{$name}) {
1594 change_state( \$pkg, $virtual_delete ?
1595 $pkg->{'state'}."-Removed" :
1597 log_ta( $pkg, "--merge-quinn" );
1598 print "$name ($pkg->{'version'}): ".
1599 ($virtual_delete ? "(virtually) " : "") . "deleted ".
1600 "from database, because not in quinn-diff anymore\n"
1602 if ($virtual_delete) {
1603 update_source_info($pkg);
1605 del_source_info($name);
1613 # for sorting priorities and sections
1615 %prioval = ( required => -5,
1623 'debian-installer' => -199,
1644 localizations => -178,
1645 interpreters => -177,
1670 electronics => -152,
1676 foreach my $i (keys %sectval) {
1677 $sectval{"contrib/$i"} = $sectval{$i}+40;
1678 $sectval{"non-free/$i"} = $sectval{$i}+80;
1680 $sectval{'unknown'} = -165;
1682 %catval = ( "none" => -20,
1683 "uploaded-fixed-pkg" => -19,
1684 "fix-expected" => -18,
1685 "reminder-sent" => -17,
1686 "nmu-offered" => -16,
1690 "compiler-error" => -12 );
1693 sub sort_list_func {
1694 my( $letter, $x, $ax, $bx );
1696 foreach $letter (split( "", $list_order )) {
1697 SWITCH: foreach ($letter) {
1699 $x = $b->{'buildpri'} <=> $a->{'buildpri'};
1700 return $x if $x != 0;
1704 $x = $prioval{$a->{'priority'}} <=> $prioval{$b->{'priority'}};
1705 return $x if $x != 0;
1709 $x = $sectval{$a->{'section'}} <=> $sectval{$b->{'section'}};
1710 return $x if $x != 0;
1714 $x = $a->{'package'} cmp $b->{'package'};
1715 return $x if $x != 0;
1719 $x = $a->{'builder'} cmp $b->{'builder'};
1720 return $x if $x != 0;
1724 $ax = ($a->{'notes'} =~ /^(out-of-date|partial)/) ? 0 :
1725 ($a->{'notes'} =~ /^uncompiled/) ? 2 : 1;
1726 $bx = ($b->{'notes'} =~ /^(out-of-date|partial)/) ? 0 :
1727 ($b->{'notes'} =~ /^uncompiled/) ? 2 : 1;
1729 return $x if $x != 0;
1733 my $ca = defined $a->{'failed_category'} ?
1734 $a->{'failed_category'} : "none";
1735 my $cb = defined $b->{'failed_category'} ?
1736 $b->{'failed_category'} : "none";
1737 $x = $catval{$ca} <=> $catval{$cb};
1738 return $x if $x != 0;
1742 my $pa = $prioval{$a->{'priority'}} >
1743 $prioval{'standard'};
1744 my $pb = $prioval{$b->{'priority'}} >
1745 $prioval{'standard'};
1747 return $x if $x != 0;
1757 my( $name, $pkg, @list );
1762 my $db = get_all_source_info();
1763 foreach $name (keys %$db) {
1764 next if $name =~ /^_/;
1765 $pkg = $db->{$name};
1766 next if $state ne "all" && $pkg->{'state'} !~ /^\Q$state\E$/i;
1767 next if $user && (lc($state) ne 'needs-build' and $pkg->{'builder'} ne $user);
1768 next if $category && $pkg->{'state'} eq "Failed" &&
1769 $pkg->{'failed_category'} ne $category;
1770 next if ($list_min_age > 0 &&
1771 ($ctime-parse_date($pkg->{'state_change'})) < $list_min_age)||
1772 ($list_min_age < 0 &&
1773 ($ctime-parse_date($pkg->{'state_change'})) > -$list_min_age);
1774 push( @list, $pkg );
1777 foreach $pkg (sort sort_list_func @list) {
1778 print "$pkg->{'section'}/$pkg->{'package'}_$pkg->{'version'}";
1779 print ": $pkg->{'state'}"
1781 print " by $pkg->{'builder'}"
1782 if $pkg->{'state'} ne "Needs-Build" && $pkg->{'builder'};
1783 print " [$pkg->{'priority'}:$pkg->{'notes'}";
1784 print ":PREV-FAILED"
1785 if $pkg->{'previous_state'} =~ /^Failed/;
1786 print ":bp{" . $pkg->{'buildpri'} . "}"
1787 if defined $pkg->{'buildpri'};
1788 print ":binNMU{" . $pkg->{'binary_nmu_version'} . "}"
1789 if defined $pkg->{'binary_nmu_version'};
1791 print " Reasons for failing:\n",
1793 defined $pkg->{'failed_category'} ? $pkg->{'failed_category'} : "none",
1795 join("\n ",split("\n",$pkg->{'failed'})), "\n"
1796 if $pkg->{'state'} =~ /^Failed/;
1797 print " Dependencies: $pkg->{'depends'}\n"
1798 if $pkg->{'state'} eq "Dep-Wait";
1799 print " Reasons for BD-Uninstallable:\n ",
1800 join("\n ",split("\n",$pkg->{'bd_problem'})), "\n"
1801 if $pkg->{'state'} eq "BD-Uninstallable";
1802 print " Previous state was $pkg->{'previous_state'} until ",
1803 "$pkg->{'state_change'}\n"
1804 if $verbose && $pkg->{'previous_state'};
1805 print " No previous state recorded\n"
1806 if $verbose && !$pkg->{'previous_state'};
1807 print " Previous failing reasons:\n ",
1808 join("\n ",split("\n",$pkg->{'old_failed'})), "\n"
1809 if $verbose && $pkg->{'old_failed'};
1811 $scnt{$pkg->{'state'}}++ if $state eq "all";
1813 if ($state eq "all") {
1814 foreach (sort keys %scnt) {
1815 print "Total $scnt{$_} package(s) in state $_.\n";
1818 print "Total $cnt package(s)\n";
1823 my( $name, $pkg, $key, $dist );
1824 my @firstkeys = qw(package version builder state section priority
1825 installed_version previous_state state_change);
1826 my @dists = $info_all_dists ? keys %conf::distributions : ($distribution);
1828 foreach $name (@_) {
1829 $name =~ s/_.*$//; # strip version
1830 foreach $dist (@dists) {
1831 my $pname = "$name" . ($info_all_dists ? "($dist)" : "");
1833 $pkg = get_source_info($name);
1834 if (!defined( $pkg )) {
1835 print "$pname: not registered\n";
1840 foreach $key (@firstkeys) {
1841 next if !defined $pkg->{$key};
1842 my $val = $pkg->{$key};
1844 $val = "\n$val" if isin( $key, qw(Failed Old-Failed));
1846 printf " %-20s: %s\n", $key, $val;
1848 foreach $key (sort keys %$pkg) {
1849 next if isin( $key, @firstkeys );
1850 my $val = $pkg->{$key};
1852 $val = "\n$val" if isin( $key, qw(Failed Old-Failed));
1854 printf " %-20s: %s\n", $key, $val;
1860 sub forget_packages {
1861 my( $name, $pkg, $key, $data );
1863 foreach $name (@_) {
1864 $name =~ s/_.*$//; # strip version
1865 $pkg = get_source_info($name);
1866 if (!defined( $pkg )) {
1867 print "$name: not registered\n";
1872 foreach $key (sort keys %$pkg) {
1873 my $val = $pkg->{$key};
1876 $data .= sprintf " %-20s: %s\n", $key, $val;
1878 send_mail( $conf::db_maint,
1879 "$name deleted from DB " . table_name() . " " . $distribution,
1880 "The package '$name' has been deleted from the database ".
1882 "Data registered about the deleted package:\n".
1883 "$data\n" ) if $conf::db_maint;
1884 change_state( \$pkg, 'deleted' );
1885 log_ta( $pkg, "--forget" );
1886 del_source_info($name);
1887 print "$name: deleted from database\n" if $verbose;
1892 $dbh->do("DELETE from " . user_table_name() .
1893 " WHERE distribution = ?", undef, $distribution) or die $dbh->errstr;
1899 print "Reading ASCII database from $file..." if $verbose >= 1;
1900 open( F, "<$file" ) or
1901 die "Can't open database $file: $!\n";
1903 local($/) = ""; # read in paragraph mode
1905 my( %thispkg, $name );
1907 s/\n[ \t]+/\376\377/g; # fix continuation lines
1908 s/\376\377\s*\376\377/\376\377/og;
1910 while( /^(\S+):[ \t]*(.*)[ \t]*$/mg ) {
1911 my ($key, $val) = ($1, $2);
1913 $key =~ tr/A-Z/a-z/;
1914 $val =~ s/\376\377/\n/g;
1915 $thispkg{$key} = $val;
1917 check_entry( \%thispkg );
1919 if (exists($thispkg{'package'})) {
1920 update_source_info(\%thispkg);
1922 elsif(exists($thispkg{'user'})) {
1923 # user in import, username in database.
1924 $dbh->do('INSERT INTO ' . user_table_name() .
1925 ' (username, distribution, last_seen)' .
1926 ' values (?, ?, ?)',
1927 undef, $thispkg{'user'}, $distribution,
1928 $thispkg{'last_seen'})
1929 or die $dbh->errstr;
1933 print "done\n" if $verbose >= 1;
1940 return if $op_mode eq "manual-edit"; # no checks then
1942 # check for required fields
1943 if (exists $pkg->{'user'}) {
1946 if (!exists $pkg->{'package'}) {
1947 print STDERR "Bad entry: ",
1948 join( "\n", map { "$_: $pkg->{$_}" } keys %$pkg ), "\n";
1949 die "Database entry lacks package or username field\n";
1951 # if no State: field, generate one (for old db compat)
1952 if (!exists($pkg->{'state'})) {
1954 exists $pkg->{'failed'} ? 'Failed' : 'Building';
1956 if (!exists $pkg->{'version'} and $pkg->{'state'} ne 'Not-For-Us') {
1957 die "Database entry for $pkg->{'package'} lacks Version: field\n";
1960 die "Bad state $pkg->{'state'} of package $pkg->{Package}\n"
1961 if !isin( $pkg->{'state'},
1962 qw(Needs-Build Building Built Build-Attempted Uploaded Installed Dep-Wait Dep-Wait-Removed
1963 Failed Failed-Removed Not-For-Us BD-Uninstallable
1970 my $newstate = shift;
1971 my $state = \$pkg->{'state'};
1973 return if defined($$state) and $$state eq $newstate;
1974 $pkg->{'previous_state'} = $$state if defined($$state);
1975 $pkg->{'state_change'} = $curr_date;
1977 if (defined($$state) and $$state eq 'Failed') {
1978 $pkg->{'old_failed'} =
1979 "-"x20 . " $pkg->{'version'} " . "-"x20 . "\n" .
1980 $pkg->{'failed'} . "\n" .
1981 $pkg->{'old_failed'};
1982 delete $pkg->{'failed'};
1983 delete $pkg->{'failed_category'};
1985 if (defined($$state) and $$state eq 'BD-Uninstallable') {
1986 delete $pkg->{'bd_problem'};
1988 $$state = $newstate;
1994 my $dist = $distribution;
1998 $prevstate = $pkg->{'previous_state'};
1999 $str = "$action($dist): $pkg->{'package'}_$pkg->{'version'} ".
2000 "changed from $prevstate to $pkg->{'state'} ".
2001 "by $real_user as $user";
2003 my $transactlog = db_transactlog();
2004 if (!open( LOG, ">>$transactlog" )) {
2005 warn "Can't open log file $transactlog: $!\n";
2008 print LOG "$curr_date: $str\n";
2011 if (!($prevstate eq 'Failed' && $pkg->{'state'} eq 'Failed')) {
2012 $str .= " (with --override)"
2014 $mail_logs .= "$str\n";
2021 my $subject = shift;
2024 my $from = $conf::db_maint;
2025 my $domain = $conf::buildd_domain;
2027 $from .= "\@$domain" if $from !~ /\@/;
2029 $to .= '@' . $domain if $to !~ /\@/;
2030 $text =~ s/^\.$/../mg;
2031 local $SIG{'PIPE'} = 'IGNORE';
2032 open( PIPE, "| $conf::mailprog -oem $to" )
2033 or die "Can't open pipe to $conf::mailprog: $!\n";
2035 print PIPE "From: $from\n";
2036 print PIPE "Subject: $subject\n\n";
2037 print PIPE "$text\n";
2041 sub db_transactlog {
2042 return "$conf::basedir/$arch/$conf::transactlog";
2045 # for parsing input to dep-wait
2051 foreach (split( /\s*,\s*/, $deps )) {
2053 # verification requires > starting prompts, no | crap
2054 if (!/^(\S+)\s*(\(\s*(>(?:[>=])?)\s*(\S+)\s*\))?\s*$/) {
2059 my @alts = split( /\s*\|\s*/, $_ );
2060 # Anything with an | is ignored, as it can be configured on a
2061 # per-buildd basis what will be installed
2062 next if $#alts != 0;
2065 if (!/^(\S+)\s*(\(\s*(>=|=|==|>|>>|<<|<=)\s*(\S+)\s*\))?\s*$/) {
2066 warn( "parse_deplist: bad dependency $_\n" );
2069 my($dep, $rel, $relv) = ($1, $3, $4);
2070 $rel = ">>" if defined($rel) and $rel eq ">";
2071 $result{$dep}->{'package'} = $dep;
2072 if ($rel && $relv) {
2073 $result{$dep}->{'rel'} = $rel;
2074 $result{$dep}->{'version'} = $relv;
2077 return 1 if $verify;
2081 # for parsing Build-Depends from Sources
2082 sub parse_srcdeplist {
2089 foreach $dep (split( /\s*,\s*/, $deps )) {
2090 my @alts = split( /\s*\|\s*/, $dep );
2091 # Anything with an | is ignored, as it can be configured on a
2092 # per-buildd basis what will be installed
2093 next if $#alts != 0;
2095 if (!/^([^\s([]+)\s*(\(\s*([<=>]+)\s*(\S+)\s*\))?(\s*\[([^]]+)\])?/) {
2096 warn( "parse_srcdeplist: bad dependency $_\n" );
2099 my($dep, $rel, $relv, $archlist) = ($1, $3, $4, $6);
2101 $archlist =~ s/^\s*(.*)\s*$/$1/;
2102 my @archs = split( /\s+/, $archlist );
2103 my ($use_it, $ignore_it, $include) = (0, 0, 0);
2106 $ignore_it = 1 if substr($_, 1) eq $arch;
2108 $use_it = 1 if $_ eq $arch;
2112 warn "Warning: inconsistent arch restriction on ",
2113 "$pkg: $dep depedency\n"
2114 if $ignore_it && $use_it;
2115 next if $ignore_it || ($include && !$use_it);
2123 $result->{'package'} = $dep;
2124 $result->{'Neg'} = $neg;
2125 if ($rel && $relv) {
2126 $result->{'rel'} = $rel;
2127 $result->{'version'} = $relv;
2129 push @results, $result;
2138 foreach $key (keys %$list) {
2139 $result .= ", " if $result;
2141 $result .= " ($list->{$key}->{'rel'} $list->{$key}->{'version'})"
2142 if $list->{$key}->{'rel'} && $list->{$key}->{'version'};
2147 sub get_unsatisfied_dep {
2151 my $savedep = shift;
2153 my $pkgname = $dep->{'package'};
2155 if (defined $pkgs->{$pkgname}{'Provider'}) {
2156 # provides. leave them for buildd/sbuild.
2161 return $pkgs->{$pkgname}{'Unsatisfied'} if $savedep and defined($pkgs->{$pkgname}{'Unsatisfied'});
2163 # Return unsatisfied deps to a higher caller to process
2164 if ((!defined($pkgs->{$pkgname})) or
2165 (defined($dep->{'rel'}) and !version_compare( $pkgs->{$pkgname}{'version'}, $dep->{'rel'}, $dep->{'Version'} ) ) ) {
2167 $deplist{$pkgname} = $dep;
2168 my $deps = build_deplist(\%deplist);
2169 $pkgs->{$pkgname}{'Unsatisfied'} = $deps if $savedep;
2173 # set cache to "" to avoid infinite recursion
2174 $pkgs->{$pkgname}{'Unsatisfied'} = "" if $savedep;
2176 if (defined $pkgs->{$dep->{'package'}}{'depends'}) {
2177 my $deps = parse_deplist( $pkgs->{$dep->{'package'}}{'depends'} );
2178 foreach (keys %$deps) {
2181 my $ret = get_unsatisfied_dep($bd,$pkgs,$dep,1);
2183 my $retdep = parse_deplist( $ret );
2184 foreach (keys %$retdep) {
2185 $dep = $$retdep{$_};
2187 $dep->{'rel'} = '>=' if defined($dep->{'rel'}) and $dep->{'rel'} =~ '^=';
2189 if (defined($dep->{'rel'}) and $dep->{'rel'} =~ '^>' and defined ($pkgs->{$dep->{'package'}}) and
2190 version_compare($bd->{$pkgs->{$dep->{'package'}}{'Source'}}{'ver'},'>>',$pkgs->{$dep->{'package'}}{'Sourcev'})) {
2191 if (not defined($merge_binsrc{$dep->{'package'}})) {
2192 # the uninstallable package doesn't exist in the new source; look for something else that does.
2193 delete $$retdep{$dep->{'package'}};
2194 foreach (sort (split( /\s*,\s*/, $bd->{$pkgs->{$dep->{'package'}}{'Source'}}{'bin'}))) {
2195 next if ($pkgs->{$_}{'all'} or not defined $pkgs->{$_}{'version'});
2196 $dep->{'package'} = $_;
2197 $dep->{'rel'} = '>>';
2198 $dep->{'version'} = $pkgs->{$_}{'Version'};
2199 $$retdep{$_} = $dep;
2204 # sanity check to make sure the depending binary still exists, and the depended binary exists and dep-wait on a new version of it
2205 if ( defined($merge_binsrc{$pkgname}) and defined($pkgs->{$dep->{'package'}}{'version'}) ) {
2206 delete $$retdep{$dep->{'package'}};
2207 $dep->{'package'} = $pkgname;
2208 $dep->{'rel'} = '>>';
2209 $dep->{'version'} = $pkgs->{$pkgname}{'Version'};
2210 $$retdep{$pkgname} = $dep;
2212 delete $$retdep{$dep->{'package'}} if (defined ($dep->{'rel'}) and $dep->{'rel'} =~ '^>');
2215 $ret = build_deplist($retdep);
2216 $pkgs->{$pkgname}{'Unsatisfied'} = $ret if $savedep;
2224 sub call_edos_depcheck {
2225 my $packagesfile = shift;
2229 return if defined ($conf::distributions{$distribution}{noadw});
2231 # We need to check all of needs-build, as any new upload could make
2232 # something in needs-build have uninstallable deps
2233 # We also check everything in bd-uninstallable, as any new upload could
2234 # make that work again
2235 my %interesting_packages;
2236 my $db = get_all_source_info();
2237 foreach $key (keys %$db) {
2238 my $pkg = $db->{$key};
2239 if (defined $pkg and isin($pkg->{'state'}, qw/Needs-Build BD-Uninstallable/)) {
2240 $interesting_packages{$key} = undef;
2244 #print "I would look at these sources with edos-depcheck:\n";
2245 #print join " ", keys %interesting_packages,"\n";
2247 my $tmpfile_pattern = "/tmp/wanna-build-interesting-sources-$distribution.$$-";
2249 for( $i = 0;; ++$i ) {
2250 $tmpfile = $tmpfile_pattern . $i;
2251 last if ! -e $tmpfile;
2254 open SOURCES, '>', $tmpfile or die "Could not open temporary file $tmpfile\n";
2255 for my $key (keys %interesting_packages) {
2256 my $pkg = get_source_info($key);
2257 print SOURCES "Package: $key\n";
2258 print SOURCES "Version: $pkg->{'version'}\n";
2259 print SOURCES "Build-Depends: $srcs->{$key}{'dep'}\n" if $srcs->{$key}{'dep'};
2260 print SOURCES "Build-Conflicts: $srcs->{$key}{'conf'}\n" if $srcs->{$key}{'conf'};
2261 print SOURCES "Architecture: all\n";
2266 if (open(EDOS,"-|","wb-edos-builddebcheck", "-a", $arch, $packagesfile, $tmpfile))
2268 local($/) = ""; # read in paragraph mode
2270 my( $key, $reason ) ;
2272 /^Package:\s*(\S+)$/mi and $key = $1;
2273 /^Failed-Why:(([^\n]|\n ([^\n]|\.))*)$/msi and $reason = $1;
2274 $reason =~ s/^\s*//mg;
2275 $reason ||= 'No reason given by edos-debcheck';
2277 if (exists $interesting_packages{$key}) {
2278 $interesting_packages{$key} = $reason;
2280 #print "TODO: edos reported a package we do not care about now\n" if $verbose;
2285 print "ERROR: Could not run wb-edos-builddebcheck. I am continuing, assuming\n" .
2286 "all packages have installable build-dependencies."
2291 for my $key (keys %interesting_packages) {
2292 my $pkg = get_source_info($key);
2294 (defined $interesting_packages{$key} and $pkg->{'state'} eq 'Needs-Build') ||
2295 (not defined $interesting_packages{$key} and $pkg->{'state'} eq 'BD-Uninstallable');
2296 my $problemchange = $interesting_packages{$key} ne $pkg->{'bd_problem'};
2298 if (defined $interesting_packages{$key}) {
2299 change_state( \$pkg, 'BD-Uninstallable' );
2300 $pkg->{'bd_problem'} = $interesting_packages{$key};
2302 change_state( \$pkg, 'Needs-Build' );
2305 if ($problemchange) {
2306 if (defined $interesting_packages{$key}) {
2307 $pkg->{'bd_problem'} = $interesting_packages{$key};
2311 log_ta( $pkg, "--merge-all" );
2312 print "edos-builddebchange changed state of ${key}_$pkg->{'version'} to $pkg->{'state'}\n" if $verbose;
2314 if ($change || $problemchange) {
2315 update_source_info($pkg);
2322 ($prgname = $0) =~ s,^.*/,,;
2324 Usage: $prgname <options...> <package_version...>
2326 -v, --verbose: Verbose execution.
2327 --take: Take package for building [default operation]
2328 -f, --failed: Record in database that a build failed due to
2329 deficiencies in the package (that aren't fixable without a new
2331 -u, --uploaded: Record in the database that the packages build
2332 correctly and were uploaded.
2333 -n, --no-build: Record in the database that the packages aren't
2334 desired for this architecture and shouldn't appear in listings even
2335 if they're out of date.
2336 --dep-wait: Record in the database that the packages are waiting
2337 for some source dependencies to become available
2338 --binNMU num: Schedule a re-build of the package with unchanged source, but
2339 a new version number (source-version + "+b<num>")
2340 --give-back: Mark a package as ready to build that is in state Building,
2341 Built or Build-Attempted. To give back a package in state Failed, use
2342 --override. This command will actually put the package in state
2343 BD-Uninstallable, until the installability of its Build-Dependencies
2344 were verified. This happens at each call of --merge-all, usually
2346 --merge-quinn: Merge quinn-diff output into database.
2347 --merge-packages: Merge Packages files into database.
2348 --pretend-avail: Pretend that given packages are available now and give
2349 free packages waiting for them
2350 -i SRC_PKG, --info SRC_PKG: Show information for source package
2351 -l STATE, --list=STATE: List all packages in state STATE; can be
2352 combined with -U to restrict to a specific user; STATE can
2354 -m MESSAGE, --message=MESSAGE: Give reason why package failed or
2355 source dependency list
2356 (used with -f, --dep-wait, and --binNMU)
2357 -o, --override: Override another user's lock on a package, i.e.
2358 take it over; a notice mail will be sent to the other user
2359 -U USER, --user=USER: select user name for which listings should
2360 apply, if not given all users are listed.
2361 if -l is missing, set user name to be entered in db; usually
2362 automatically choosen
2363 --import FILE: Import database from a ASCII file FILE
2365 The remaining arguments (depending on operation) usually start with
2366 "name_version", the trailer is ignored. This allows to pass the names
2367 of .dsc files, for which file name completion can be used.
2368 --merge-packages and --merge-quinn take Package/quin--diff file names
2369 on the command line or read stdin. --list needs nothing more on the
2370 command line. --info takes source package names (without version).
2375 sub pkg_version_eq {
2377 my $version = shift;
2380 if (defined $pkg->{'binary_nmu_version'}) and
2381 version_compare(binNMU_version($pkg->{'version'},
2382 $pkg->{'binary_nmu_version'}),'=', $version);
2383 return version_compare( $pkg->{'version'}, "=", $version );
2387 return '"' . $arch . $schema_suffix . '".packages';
2390 sub user_table_name {
2391 return '"' . $arch . $schema_suffix . '".users';
2394 sub get_source_info {
2396 my $pkg = $dbh->selectrow_hashref('SELECT * FROM ' .
2397 table_name() . ' WHERE package = ? AND distribution = ?',
2398 undef, $name, $distribution);
2402 sub get_all_source_info {
2403 my $db = $dbh->selectall_hashref('SELECT * FROM ' . table_name() .
2404 ' WHERE distribution = ?',
2405 'package', undef, $distribution);
2409 sub update_source_info {
2412 my $pkg2 = get_source_info($pkg->{'package'});
2413 if (! defined $pkg2)
2415 add_source_info($pkg);
2418 $dbh->do('UPDATE ' . table_name() . ' SET ' .
2423 'installed_version = ?, ' .
2424 'previous_state = ?, ' .
2425 'state_change = ?, ' .
2429 'old_failed = ?, ' .
2430 'binary_nmu_version = ?, ' .
2431 'binary_nmu_changelog = ?, ' .
2432 'failed_category = ?, ' .
2433 'permbuildpri = ?, ' .
2438 'WHERE package = ? AND distribution = ?',
2444 $pkg->{'installed_version'},
2445 $pkg->{'previous_state'},
2446 $pkg->{'state_change'},
2450 $pkg->{'old_failed'},
2451 $pkg->{'binary_nmu_version'},
2452 $pkg->{'binary_nmu_changelog'},
2453 $pkg->{'failed_category'},
2454 $pkg->{'permbuildpri'},
2458 $pkg->{'bd_problem'},
2460 $distribution) or die $dbh->errstr;
2463 sub add_source_info {
2465 $dbh->do('INSERT INTO ' . table_name() .
2466 ' (package, distribution) values (?, ?)',
2467 undef, $pkg->{'package'}, $distribution) or die $dbh->errstr;
2470 sub del_source_info {
2472 $dbh->do('DELETE FROM ' . table_name() .
2473 ' WHERE package = ? AND distribution = ?',
2474 undef, $name, $distribution) or die $dbh->errstr;
2479 my $user = $dbh->selectrow_hashref('SELECT * FROM ' .
2480 user_table_name() . ' WHERE username = ? AND distribution = ?',
2481 undef, $name, $distribution);
2485 sub update_user_info {
2487 $dbh->do('UPDATE ' . user_table_name() .
2488 ' SET last_seen = now() WHERE username = ?' .
2489 ' AND distribution = ?',
2490 undef, $user, $distribution)
2491 or die $dbh->errstr;
2497 $dbh->do('INSERT INTO ' . user_table_name() .
2498 ' (username, distribution, last_seen)' .
2499 ' values (?, ?, now())',
2500 undef, $user, $distribution)
2501 or die $dbh->errstr;