Author: fw
Date: 2005-09-14 21:19:35 +0000 (Wed, 14 Sep 2005)
New Revision: 1986
Modified:
lib/python/security_db.py
Log:
lib/python/security_db.py (DB.getFunnyPackageVersions):
New method.
Modified: lib/python/security_db.py
==================================================================---
lib/python/security_db.py 2005-09-14 21:14:17 UTC (rev 1985)
+++ lib/python/security_db.py 2005-09-14 21:19:35 UTC (rev 1986)
@@ -505,6 +505,18 @@
return result
+ def getFunnyPackageVersions(self):
+ """Returns a list of (PACKAGE, RELEASE, ARCHIVE,
VERSION,
+ SOURCE-VERSION) tuples such that PACKAGE is both a source and
+ binary package, but the associated version numbers are
+ different."""
+
+ return list(self.db.cursor().execute(
+ """SELECT DISTINCT name, release, archive, version,
source_version
+ FROM binary_packages
+ WHERE name = source AND version <> source_version
+ ORDER BY name, release, archive"""))
+
def getVersion(self, cursor, release, package):
"""Returns the version number for package in release.