1=head1 NAME
2
3ltnu - lists packages of a maintainer ordered by last upload
4
5=head1 SYNOPSIS
6
7B<env> DEBEMAIL=I<maintainer> B<ltnu> [-m]
8
9B<ltnu> [-m] I<maintainer>
10
11B<ltnu> --help
12
13=head1 DESCRIPTION
14
15B<ltnu> (Long Time No Upload) queries the public mirror of the
16Ultimate Debian Database (udd-mirror.debian.net) for all uploads of
17packages by the given uploader or maintainer and displays them ordered
18by the last upload of that package to Debian Unstable, oldest uploads
19first.
20
21Its primary purpose is to check which of your own or your team's
22packages haven't been uploaded for a long time and likely need a
23packaging revamp. It's less suitable for MIA team purposes as it
24doesn't make a difference with regards to who actually uploaded a
25package.
26
27=head1 OPTIONS
28
29=over 4
30
31=item -m
32
33Only search in the Maintainer field and ignore the Uploaders field.
34
35=back
36
37=head1 PARAMETERS
38
39The maintainer/uploader to query can be given either by setting
40C<$DEBEMAIL> as environment variable or as single commandline parameter.
41
42If a commandline parameter does not contain an C<@>, C<@debian.org> is
43appended, e.g. C<ltnu abe> queries for C<abe@debian.org>.
44
45Exceptions are some shortcuts for common, long e-mail addresses. So
46far implemented shortcuts:
47
48=over 13
49
50=item pkg-gnustep
51
52pkg-gnustep-maintainers@lists.alioth.debian.org
53
54=item pkg-perl
55
56pkg-perl-maintainers@lists.alioth.debian.org
57
58=item pkg-zsh
59
60pkg-zsh-devel@lists.alioth.debian.org
61
62=item qa
63
64packages@qa.debian.org
65
66=back
67
68=head1 ENVIRONMENT
69
70The following environment variables are honoured:
71
72=over
73
74=item DEBEMAIL
75
76Used for querying if no parameter is given.
77
78=item PAGER
79
80Used by B<psql> as pager.
81
82=back
83
84=head1 EXAMPLE
85
86    $ ltnu pkg-zsh
87             source          |     ver      |        uploaded
88    -------------------------+--------------+------------------------
89     zgen                    | 0~20150919-3 | 2016-08-24 04:55:31+00
90     zplug                   | 2.4.1-1      | 2017-01-13 09:51:26+00
91     zsh-syntax-highlighting | 0.6.0-1      | 2017-08-30 09:06:26+00
92     zsh                     | 5.4.2-2      | 2017-11-02 20:56:55+00
93    (4 rows)
94
95=head1 DEPENDENCIES
96
97B<ltnu> uses the PostgreSQL client command B<psql> and hence needs
98Debian's B<postgresql-client> package to be installed.
99
100=head1 AUTHOR, COPYRIGHT, LICENSE
101
102Copyright 2017 Axel Beckert <abe@debian.org>. Licensed under the GNU
103General Public License, version 2 or later.
104
105=head1 SEE ALSO
106
107L<https://udd-mirror.debian.net/>, L<https://udd.debian.org/>,
108L<https://wiki.debian.org/UltimateDebianDatabase>
109