have a "slightly" more efficient frontpage query

1 files changed, 15 insertions, 2 deletions

diff --git a/patchtracker/DB.py b/patchtracker/DB.py
index efa3c8e..4160b90 100644
--- a/patchtracker/DB.py
+++ b/patchtracker/DB.py
@@ -108,8 +108,21 @@ class PatchTrackerDB:
   def findLetterToc(self, letter):
     return self.findCollection(package=letter+"%").getletter(letter)
 
-  def findMasterIndex(self):
-    return self.findCollection(package="%")
+  def findIndices(self):
+    indices = []
+    cursor = self.db.cursor()
+    q1 = "SELECT DISTINCT SUBSTR(name,1,1) FROM packages \
+            WHERE name NOT LIKE 'lib%'"
+    q2 = "SELECT DISTINCT SUBSTR(name,1,4) FROM packages \
+            WHERE name LIKE 'lib%'"
+
+    for q in [q1, q2]:
+      cursor.execute(q)
+      for idx in cursor.fetchall():
+        indices.append(idx[0])
+    
+    indices.sort()
+    return indices
      
   def relateSourcePackage(self, name, version, suite, component):
     q = "INSERT INTO package_rel_map \