X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate28.py;h=f0c62e0e8176ba26c027943f6adde5b36bcf9739;hb=a4d717f87b23acd0f87037007aaf178abb7b2f38;hp=fcefadac4ca075119bb371d9ec73b9ce5c86b02d;hpb=3b9822f29469b9c5c960924a6e9511a9a8e6d9bf;p=dak.git

diff --git a/dak/dakdb/update28.py b/dak/dakdb/update28.py
old mode 100755
new mode 100644
index fcefadac..f0c62e0e
--- a/dak/dakdb/update28.py
+++ b/dak/dakdb/update28.py
@@ -40,7 +40,7 @@ def _suites():
     """
     return a list of suites to operate on
     """
-    suites = Config().SubTree("Suite").List()
+    suites = Config().subtree("Suite").list()
     return suites
 
 def arches(cursor, suite):
@@ -148,14 +148,15 @@ def do_update(self):
             suite_id = suiterow[0]
             arch_list = arches(c, suite_id)
             arch_list = arches(c, suite_id)
+            suitestr=string.replace(suite,'-','_');
 
             for (arch_id,arch_str) in arch_list:
-                suitestr=string.replace(suite,'-','_');
-                c.execute( "CREATE INDEX ind_deb_contents_%s_%s ON deb_contents (arch,suite) WHERE (arch=2 OR arch=%s) AND suite='%s'"%(arch_str,suite,arch_id,suite_id) )
+                arch_str = string.replace(arch_str,"-", "_")
+                c.execute( "CREATE INDEX ind_deb_contents_%s_%s ON deb_contents (arch,suite) WHERE (arch=2 OR arch=%s) AND suite='%s'"%(arch_str,suitestr,arch_id,suite_id) )
 
             for section, sname in [("debian-installer","main"),
                                   ("non-free/debian-installer", "nonfree")]:
-                c.execute( "CREATE INDEX ind_udeb_contents_%s ON udeb_contents (section,suite) WHERE section='%s' AND suite='%s'"%(sname,section,suite_id) )
+                c.execute( "CREATE INDEX ind_udeb_contents_%s_%s ON udeb_contents (section,suite) WHERE section='%s' AND suite='%s'"%(sname,suitestr,section,suite_id) )
 
 
         c.execute( """CREATE OR REPLACE FUNCTION update_contents_for_bin_a() RETURNS trigger AS  $$
@@ -264,7 +265,7 @@ $$ LANGUAGE plpythonu VOLATILE;""")
 
         self.db.commit()
 
-    except psycopg2.ProgrammingError, msg:
+    except psycopg2.ProgrammingError as msg:
         self.db.rollback()
-        raise DBUpdateError, "Unable to apply process-new update 28, rollback issued. Error message : %s" % (str(msg))
+        raise DBUpdateError("Unable to apply process-new update 28, rollback issued. Error message : %s" % (str(msg)))