X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate28.py;h=79b0e8db8250fb3e657edcf9daf9ba4fdb1706a5;hb=066d01be84db56933591117e616ac35203dffd18;hp=1859e5056d3bc8a16b4b0fba84f4cc35a024948a;hpb=c147cf22bbaa0b9c9a27a717a43729d2c140ee1b;p=dak.git diff --git a/dak/dakdb/update28.py b/dak/dakdb/update28.py index 1859e505..79b0e8db 100755 --- a/dak/dakdb/update28.py +++ b/dak/dakdb/update28.py @@ -32,6 +32,7 @@ import psycopg2 import time from daklib.dak_exceptions import DBUpdateError from daklib.config import Config +import string ################################################################################ @@ -147,13 +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: - 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 $$