Bug#702085: debian-devel-changes is importing correctly
A more full report is forthcoming. I wanted to first declare success here,
and then explain how things work for benefit of later readers (or current
UDD maintainers with opinions on how to change them).
I created a query that conveniently limits the width of the query to <=
80 characters, to avoid email wrappering. I also want to note:
This query demonstrates that the transition from the
debian-devel-changes.201307 file to the debian-devel-changes.current (AKA
inbound mail) is smooth.
We also might want to fix the code to avoid the historical problem with
believing that some packages were submitted in 2018 and 2019.
Anyway! See:
paulproteus@ullmann:~$ psql service=udd
psql (9.1.9)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
udd=> select SubStr(source || ' ' || version::text, 0, 20), date::date,
file from upload_history order by date desc limit 140;
substr | date | file
---------------------+------------+------------------------------
libhtml-embperl-per | 2019-02-07 | debian-devel-changes.199902
data-dumper 2.10-2 | 2019-02-06 | debian-devel-changes.199902
custom 1.9962-2 | 2019-02-05 | debian-devel-changes.199902
libcompress-zlib-pe | 2019-02-05 | debian-devel-changes.199902
alias 2.31-2 | 2019-02-05 | debian-devel-changes.199902
xqf 0.8.7.2-1 | 2019-02-05 | debian-devel-changes.199902
libhtml-tree-perl 0 | 2019-02-05 | debian-devel-changes.199902
data-dumper 2.10-1 | 2019-02-05 | debian-devel-changes.199902
kernel-patch-2.0.35 | 2018-10-29 | debian-devel-changes.199810
debian-goodies 0.63 | 2013-07-05 | debian-devel-changes.current
jakarta-jmeter 2.8- | 2013-07-05 | debian-devel-changes.current
bygfoot 2.3.2-1.1 | 2013-07-05 | debian-devel-changes.current
djvusmooth 0.2.14-1 | 2013-07-05 | debian-devel-changes.current
gearman-interface 0 | 2013-07-05 | debian-devel-changes.current
cp2k 2.3.0-1 | 2013-07-05 | debian-devel-changes.current
debian-edu-artwork | 2013-07-05 | debian-devel-changes.current
libcpan-perl-releas | 2013-07-05 | debian-devel-changes.current
trickle 1.07-10 | 2013-07-05 | debian-devel-changes.current
secure-delete 3.1-6 | 2013-07-05 | debian-devel-changes.current
cairo-dock-plug-ins | 2013-07-05 | debian-devel-changes.current
wdq2wav 0.9.0-1 | 2013-07-05 | debian-devel-changes.current
starpu-contrib 1.0. | 2013-07-05 | debian-devel-changes.current
cairo-dock-plug-ins | 2013-07-05 | debian-devel-changes.current
mididings 0~2012041 | 2013-07-05 | debian-devel-changes.current
flim 1:1.14.9+0.201 | 2013-07-05 | debian-devel-changes.current
pygobject 3.8.3-1 | 2013-07-05 | debian-devel-changes.current
wl-beta 2.15.9+0.20 | 2013-07-05 | debian-devel-changes.current
xmhtml 1.1.7-19 | 2013-07-05 | debian-devel-changes.current
openimageio 1.2.0~b | 2013-07-05 | debian-devel-changes.current
myproxy 5.9-2 | 2013-07-05 | debian-devel-changes.current
latex-cjk-chinese-a | 2013-07-05 | debian-devel-changes.current
sigrok 0.2-2 | 2013-07-05 | debian-devel-changes.current
zeroinstall-injecto | 2013-07-05 | debian-devel-changes.current
php-net-ipv4 1.3.4- | 2013-07-05 | debian-devel-changes.current
apel 10.8+0.2012042 | 2013-07-05 | debian-devel-changes.current
sigrok-cli 0.4.0-1 | 2013-07-05 | debian-devel-changes.current
ocamlbricks 0.90+bz | 2013-07-05 | debian-devel-changes.current
beignet 0.2-1 | 2013-07-05 | debian-devel-changes.current
debian-edu 1.710 | 2013-07-05 | debian-devel-changes.current
dicom3tools 1.00~20 | 2013-07-05 | debian-devel-changes.current
openturns 1.1-7 | 2013-07-05 | debian-devel-changes.current
cuetools 1.3.1-13 | 2013-07-05 | debian-devel-changes.current
qt4-x11 4:4.8.5+dfs | 2013-07-05 | debian-devel-changes.current
xdemorse 1.3-7 | 2013-07-05 | debian-devel-changes.current
mew-beta 7.0.50~6.5 | 2013-07-05 | debian-devel-changes.current
python-whoosh 2.5.1 | 2013-07-05 | debian-devel-changes.current
privoxy 3.0.21-1 | 2013-07-05 | debian-devel-changes.current
procenv 0.24-1 | 2013-07-05 | debian-devel-changes.current
libiscwt-java 5.3.2 | 2013-07-05 | debian-devel-changes.current
apel 10.8+0.2012042 | 2013-07-05 | debian-devel-changes.current
beignet 0.2-2 | 2013-07-05 | debian-devel-changes.current
neko 2.0.0-1 | 2013-07-05 | debian-devel-changes.current
sdpa 7.3.9+dfsg-1 | 2013-07-05 | debian-devel-changes.current
media-player-info 1 | 2013-07-05 | debian-devel-changes.current
mhc 0.25.1+20130612 | 2013-07-05 | debian-devel-changes.current
tbb 4.1~20130516-1. | 2013-07-05 | debian-devel-changes.current
krb5-auth-dialog 3. | 2013-07-05 | debian-devel-changes.current
gnuradio 3.7.0-2 | 2013-07-05 | debian-devel-changes.current
sane-backends 1.0.2 | 2013-07-05 | debian-devel-changes.current
libvigraimpex 1.9.0 | 2013-07-05 | debian-devel-changes.current
starpu 1.0.1-4 | 2013-07-05 | debian-devel-changes.current
nvidia-settings 319 | 2013-07-05 | debian-devel-changes.current
salt 0.16.0-1 | 2013-07-05 | debian-devel-changes.current
dicelab 0.7-2 | 2013-07-05 | debian-devel-changes.current
qt-assistant-compat | 2013-07-04 | debian-devel-changes.current
ulogd2 2.0.2-3 | 2013-07-04 | debian-devel-changes.current
libglazedlists-java | 2013-07-04 | debian-devel-changes.current
apr 1.4.8-1 | 2013-07-04 | debian-devel-changes.current
irssi-scripts 20130 | 2013-07-04 | debian-devel-changes.current
node-async-stacktra | 2013-07-04 | debian-devel-changes.current
libmodule-build-cle | 2013-07-04 | debian-devel-changes.current
trac-icalviewplugin | 2013-07-04 | debian-devel-changes.current
libpam-sshauth 0.3. | 2013-07-04 | debian-devel-changes.current
trac-datefieldplugi | 2013-07-04 | debian-devel-changes.current
libmodule-build-cle | 2013-07-04 | debian-devel-changes.current
debian-goodies 0.62 | 2013-07-04 | debian-devel-changes.current
kfreebsd-9 9.1-1 | 2013-07-04 | debian-devel-changes.current
python-pefile 1.2.9 | 2013-07-04 | debian-devel-changes.current
libtry-tiny-perl 0. | 2013-07-04 | debian-devel-changes.current
python-bibtex 1.2.5 | 2013-07-04 | debian-devel-changes.current
eukleides 1.5.4-3 | 2013-07-04 | debian-devel-changes.current
libvigraimpex 1.9.0 | 2013-07-04 | debian-devel-changes.current
fauhdlc 20130704-1 | 2013-07-04 | debian-devel-changes.current
exuberant-ctags 1:5 | 2013-07-04 | debian-devel-changes.current
dvdbackup 0.4.2-4 | 2013-07-04 | debian-devel-changes.current
syslinux 3:6.01+dfs | 2013-07-04 | debian-devel-changes.current
nvidia-graphics-dri | 2013-07-04 | debian-devel-changes.current
mozilla-noscript 2. | 2013-07-04 | debian-devel-changes.current
libclass-c3-perl 0. | 2013-07-04 | debian-devel-changes.current
sane-backends 1.0.2 | 2013-07-04 | debian-devel-changes.current
rgbpaint 0.8.7-4 | 2013-07-04 | debian-devel-changes.current
python-pcs 0.5+debi | 2013-07-04 | debian-devel-changes.current
python-xmpp 0.4.1-c | 2013-07-04 | debian-devel-changes.current
openvdb 1.2.0-1 | 2013-07-04 | debian-devel-changes.current
tor 0.2.4.15-rc-1 | 2013-07-04 | debian-devel-changes.current
proftpd-dfsg 1.3.5~ | 2013-07-04 | debian-devel-changes.current
trac-wikitablemacro | 2013-07-04 | debian-devel-changes.current
tau 2.16.4-1.5 | 2013-07-04 | debian-devel-changes.current
qt4-x11 4:4.8.5+dfs | 2013-07-04 | debian-devel-changes.current
libterm-editoredit- | 2013-07-04 | debian-devel-changes.current
libconfig-model-per | 2013-07-04 | debian-devel-changes.current
libspring-java 3.0. | 2013-07-04 | debian-devel-changes.current
winetricks 0.0+2013 | 2013-07-04 | debian-devel-changes.current
tophat 2.0.9-1 | 2013-07-04 | debian-devel-changes.current
nvidia-graphics-dri | 2013-07-04 | debian-devel-changes.current
cmake 2.8.11.2-1 | 2013-07-04 | debian-devel-changes.current
ghostscript 9.05~df | 2013-07-04 | debian-devel-changes.current
mha4mysql-node 0.54 | 2013-07-04 | debian-devel-changes.current
libapache2-mod-rive | 2013-07-04 | debian-devel-changes.current
youtube-dl 2013.07. | 2013-07-04 | debian-devel-changes.current
openscap 0.9.8-1 | 2013-07-04 | debian-devel-changes.current
bzr-email 0.0.1~bzr | 2013-07-04 | debian-devel-changes.current
librelp 1.1.4-1 | 2013-07-04 | debian-devel-changes.current
gunicorn 17.5-1 | 2013-07-04 | debian-devel-changes.current
nwchem 6.3-1 | 2013-07-04 | debian-devel-changes.current
zeroinstall-injecto | 2013-07-04 | debian-devel-changes.current
antlr-maven-plugin | 2013-07-04 | debian-devel-changes.current
librdf-query-client | 2013-07-04 | debian-devel-changes.current
mancala 1.0.3-1 | 2013-07-04 | debian-devel-changes.current
icedtea-web 1.4-3 | 2013-07-04 | debian-devel-changes.current
suricata 1.4.3-1 | 2013-07-04 | debian-devel-changes.current
mialmpick 0.2.9-1 | 2013-07-04 | debian-devel-changes.current
didjvu 0.2.7-1 | 2013-07-04 | debian-devel-changes.current
vym 2.3.18-1 | 2013-07-04 | debian-devel-changes.current
trousers 0.3.10-3 | 2013-07-04 | debian-devel-changes.current
dicom3tools 1.00~20 | 2013-07-04 | debian-devel-changes.current
context 2013.05.28. | 2013-07-04 | debian-devel-changes.current
sslsniff 0.8-4 | 2013-07-04 | debian-devel-changes.current
nyancat 1.2.1-1 | 2013-07-04 | debian-devel-changes.current
php5 5.5.0+dfsg-6 | 2013-07-04 | debian-devel-changes.current
guile-2.0 2.0.9+1-1 | 2013-07-04 | debian-devel-changes.201307
haskell-hopenpgp 0. | 2013-07-04 | debian-devel-changes.201307
gnuradio 3.7.0-1 | 2013-07-04 | debian-devel-changes.current
quadrule 0~20121001 | 2013-07-04 | debian-devel-changes.current
jquery-minicolors 2 | 2013-07-04 | debian-devel-changes.current
psad 2.2.1-2.1 | 2013-07-04 | debian-devel-changes.current
antlr-maven-plugin | 2013-07-03 | debian-devel-changes.201307
python-scipy 0.12.0 | 2013-07-03 | debian-devel-changes.201307
foundry 0.0.2013070 | 2013-07-03 | debian-devel-changes.201307
antlr3 3.2-8 | 2013-07-03 | debian-devel-changes.201307
Reply to: