[Debichem-devel] Revitalising Weekly infolist of updatable packages for the debichem project?

Andreas Tille tille at debian.org
Mon Jun 3 12:39:33 UTC 2013


Hi Nicholas,

On Sun, May 26, 2013 at 06:31:02AM -0700, Nicholas Breen wrote:
> On Sat, May 25, 2013 at 09:59:55PM +0200, Andreas Tille wrote:
> > $ ./upgradable.sh debichem
> >   source  | unstable_version | unstable_upstream 
> 
> Could it be extended to check the version in experimental as well, if there is
> one?

Hmmm, at least the dehs table in udd does not carry this information:

udd=# SELECT distinct experimental_version, experimental_upstream, experimental_parsed_version, experimental_status, experimental_last_uptodate from dehs ;
 experimental_version | experimental_upstream | experimental_parsed_version | experimental_status | experimental_last_uptodate 
----------------------+-----------------------+-----------------------------+---------------------+----------------------------
                      |                       |                             |                     | 
(1 row)


I have no idea, whether this is intended or just a broken importer of
DEHS data.


> We don't have very many of those (only two at the moment, and one of them
> is still behind upstream), but especially when the next freeze rolls around
> that number will go back up.


However, in a very similar way the data gathering for Debian GIS thermometer[1]

http://anonscm.debian.org/gitweb/?p=blends/website.git;a=blob;f=misc/sql/gis-thermometer.sh

When calling `gis-thermometer.sh debichem` you get:


        source         |       stable        |       testing       |      unstable       | experimental |          ubuntu           |  upstream   |     status      
-----------------------+---------------------+---------------------+---------------------+--------------+---------------------------+-------------+-----------------
 abinit                | 5.3.4.dfsg-3        | 5.3.4.dfsg-3        | 5.3.4.dfsg-3        |              | 5.3.4.dfsg-3build2        |             | 
 aces3                 | 3.0.6-7             | 3.0.6-7             | 3.0.6-7             |              | 3.0.6-5                   | 3.0.7       | outdated
 adun.app              | 0.81-5              | 0.81-5              | 0.81-5              |              | 0.81-5                    | 0.81        | uptodate
 avogadro              | 1.0.3-5             | 1.0.3-6.1           | 1.0.3-10            | 1.1.0-4      | 1.0.3-5ubuntu2            | 1.0.3       | uptodate
 ball                  | 1.4.1+20111206-4    | 1.4.1+20111206-4    | 1.4.1+20111206-4    |              | 1.4.1+20111206-4ubuntu1   | 1.4.1       | newer-in-debian
 bkchem                | 0.13.0-4            | 0.13.0-4            | 0.13.0-4            |              | 0.13.0-4                  | 0.13.0      | uptodate
 cclib                 | 1.0.1-2             | 1.1-1               | 1.1-1               |              | 1.0.1-2                   | 1.1         | uptodate
 cdk                   | 1.2.10-3            | 1.2.10-3            | 1.2.10-3            |              | 1.2.10-3                  | 1.4.18      | outdated
 chemfp                | 1.0-1               | 1.0-1               | 1.1p1-2             |              | 1.0-1                     | 1.1p1       | uptodate
 chemtool              | 1.6.13-1            | 1.6.13-1            | 1.6.13-1            |              | 1.6.13-1                  | 1.6.13      | uptodate
 cinfony               | 1.1-1               | 1.2-1               | 1.2-1               |              | 1.1-1                     | 1.2         | uptodate
 cp2k                  | 2.2.426-8           | 2.2.426-8           | 2.2.426-8           |              | 2.2.426-6                 | 2.3         | outdated
 drawxtl               | 5.5-3               | 5.5-3               | 5.5-3               |              | 5.5-3                     | 5.5         | uptodate
 easychem              | 0.6-7               | 0.6-8               | 0.6-8               |              | 0.6-7                     | 0.6         | uptodate
 espresso              | 5.0-1               | 5.0-1               | 5.0-1               |              | 5.0-1                     | 5.0.2       | outdated
 fmcs                  | 1.0-1               | 1.0-1               | 1.0-1               |              | 1.0-1                     | 1.0         | uptodate
 gabedit               | 2.4.2-2             | 2.4.6-1             | 2.4.6-1             |              | 2.4.3-1                   | 2.4.6       | uptodate
 garlic                | 1.6-1.1             | 1.6-1.1             | 1.6-1.1             |              | 1.6-1.1                   | 1.6         | uptodate
 gausssum              | 2.2.5-2             | 2.2.6.1-1           | 2.2.6.1-1           |              | 2.2.5-2                   | 2.2.6.1     | uptodate
 gdis                  | 0.90-4              | 0.90-4              | 0.90-4              |              | 0.90-4                    | 0.90        | uptodate
 gdpc                  | 2.2.5-2             | 2.2.5-2             | 2.2.5-2             |              | 2.2.5-2                   | 2.2.5       | uptodate
 ghemical              | 3.0.0-1             | 3.0.0-1             | 3.0.0-1             |              | 3.0.0-1                   | 3.0.0       | uptodate
 gnome-chemistry-utils | 0.12.12-1           | 0.12.12-1           | 0.14.2-1            |              | 0.12.10-1ubuntu2          | 0.14.2      | uptodate
 gromacs               | 4.5.5-2             | 4.5.5-2             | 4.5.5-2             | 4.6-1        | 4.5.5-2                   | 4.6.2       | outdated
 indigo                | 1.0.0-2             | 1.0.0-2             | 1.0.0-2             |              | 1.0.0-2                   |             | 
 jmol                  | 12.2.32+dfsg2-1     | 12.2.32+dfsg2-1     | 12.2.32+dfsg2-1     |              | 12.2.32+dfsg-1            | 13.0.15     | outdated
 kalzium               | 4.8.4-1             | 4.8.4-1             | 4.8.4-1             | 4.10.2-2     | 4.9.2-0ubuntu1            | 4.10.3      | outdated
 lutefisk              | 1.0.5a.cleaned-1    | 1.0.5a.cleaned-1    | 1.0.5a.cleaned-1    |              | 1.0.5a.cleaned-1          |             | 
 massxpert             | 3.2.3-1             | 3.4.0-1             | 3.4.0-1             |              | 3.2.3-1                   | 3.3.0       | newer-in-debian
 mmass                 | 5.1.0-2             | 5.4.1-1             | 5.4.1-1             |              | 5.2.0-1                   | 5.4.1.5.4.1 | outdated
 mmtk                  |                     | 2.7.8-2             | 2.7.8-2             |              |                           | 2.7.8       | uptodate
 mopac7                | 1.15-5              | 1.15-5              | 1.15-5              |              | 1.15-5                    | 1.15        | uptodate
 mpqc                  | 2.3.1-14            | 2.3.1-14            | 2.3.1-14            |              | 2.3.1-14                  | 2.3.1       | uptodate
 nwchem                | 6.1-6               | 6.1-6               | 6.1-6               |              | 6.1-3                     | 6.0         | newer-in-debian
 openbabel             | 2.3.1+dfsg-4        | 2.3.1+dfsg-4        | 2.3.2+dfsg-1        |              | 2.3.1+dfsg-4              | 2.3.2       | uptodate
 openmx                | 3.5-1               | 3.5-1               | 3.5-1               |              | 3.5-1                     | 3.7         | outdated
 opsin                 | 1.2.0-1             | 1.2.0-1             | 1.4.0-1             |              | 1.2.0-1                   | 1.4.0       | uptodate
 psicode               | 3.4.0-4             | 3.4.0-4             | 3.4.0-4             |              | 3.4.0-3                   | 3.4.0       | uptodate
 pymol                 | 1.5.0.1-2           | 1.5.0.1-2           | 1.5.0.1-2           |              | 1.5.0.1-2build1           | 1.6~beta1   | outdated
 qutemol               | 0.4.1~cvs20081111-2 | 0.4.1~cvs20081111-2 | 0.4.1~cvs20081111-2 |              | 0.4.1~cvs20081111-2build1 |             | 
 rasmol                | 2.7.5.2-1           | 2.7.5.2-1           | 2.7.5.2-2           |              | 2.7.5.2-1ubuntu1          | 2.7.5.2     | uptodate
 raster3d              | 3.0-2-4             | 3.0-2-4             | 3.0-2-4             |              | 3.0-2-4ubuntu1            | 3.0-2       | uptodate
 rdkit                 | 201203-3            | 201212-1            | 201303-1            |              | 201203-2                  | 201303      | uptodate
 shelxle               | 1.0.564-1           | 1.0.623-1           | 1.0.629-1           |              | 1.0.564-1                 | 1.0.629     | uptodate
 v-sim                 | 3.6.0-2             | 3.6.0-2             | 3.6.0-2             |              | 3.6.0-2build3             | 3.6.1.1     | outdated
 viewmol               | 2.4.1-18            | 2.4.1-19            | 2.4.1-19            |              | 2.4.1-18                  | 2.4.1       | uptodate
 xbs                   | 0-8                 | 0-8                 | 0-8                 |              | 0-8                       |             | 
 xcrysden              | 1.5.53-1            | 1.5.53-1            | 1.5.53-1            |              | 1.5.53-1                  | 1.5.53      | uptodate
 xdrawchem             | 2.0-2               | 2.0-2               | 2.0-2               |              | 2.0-2                     |             | 
 xmakemol              | 5.16-6              | 5.16-6              | 5.16-6              |              | 5.16-5ubuntu1             | 5.16        | uptodate
(50 Zeilen)


This (not yet finished) query is a bit more verbose than the
upgradable.sh script and for sure you can generate also the experimental
data.  I'm just playing around with this kind of UDD queries to get some
reasonable QA tools for Blends and we need to find out what might fit
best.  My plan was to replace what we lost previously (the upgradable
mails used by DebiChem team see example[1]) and what is used by the
Debian GIS team[1] for checking the packaging status.

Any hints what will be considered helpful is welcome.

Kind regards

        Andreas.

[1] http://pkg-grass.alioth.debian.org/debiangis-status.html
[2] http://lists.alioth.debian.org/pipermail/debichem-devel/2011-March/003038.html

-- 
http://fam-tille.de



More information about the Debichem-devel mailing list