vuntz@buildmachine ~/>./bin/create-summaries --output-database ~/data.db
vuntz@buildmachine ~/>python
Python 2.5.1 (r251:54863, Sep 21 2007, 22:46:31)
[GCC 4.2.1 (SUSE Linux)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> db=sqlite3.connect('/suse/vuntz/data.db')
>>> c=db.cursor()
>>> c.execute('select count(*) from patch where srcpackage = (select id from srcpackage where name = "gnome-panel")').fetchone()[0]
25
>>> c.execute('select count(*) from rpmlint').fetchone()[0]
7120
>>> c.execute('select count(*) from rpmlint where type="not-listed-as-documentation"').fetchone()[0]
6388
>>> c.execute('select count(*) from srcpackage where version < upstream_version').fetchone()[0]
26

Quick answers to some FAQ:

• yes, I know, the UI isn't really user-friendly ;-)
• this demo is really short, more can be done right now. And after a bit more work, there'll be some more data in there to query.
• there are certainly bugs when collecting the data, so I wouldn't trust the returned values. It still gives a rough idea of how things are.
• it's only working on packages where upstream is hosted on the GNOME FTP server. That's mainly for convenience reasons; adding other packages later shouldn't be hard.
• yes, there are lots of gnome-panel patches in our package. I'll look at them in a not too distant future.
• most of the rpmlint warnings (6388 out of 7120 -- this includes some false positives, but still) seem to be related to this bug. The good news is that I attached a simple patch earlier today.

I love my job :-)

I fixed the openSUSE package conventions about .desktop files a few minutes ago. No big change there (see the details of the changes), but it contained some outdated information and some errors. I was especially annoyed by the fact that it was talking about the GenericName key for tooltips instead of the Comment key: because of this, there are some patches in our packages to change the .desktop files to use the GenericName key instead of the Comment one. The page can probably do with some more work to clarify things, and I guess I'll do this in the future.

It reminded me that last year, I contacted someone to change the Fedora packaging guidelines because the example was not a valid .desktop file. Do other distributions have packaging guidelines or conventions related to .desktop files? If yes, please tell me where I can look at them so I can check that they're fine :-)