wrong way to paramaterize

[dak.git] / dak / dakdb / update28.py

diff --git a/dak/dakdb/update28.py b/dak/dakdb/update28.py
index 39a268016beb773883c7192f85ed089703df4f42..0ff0151e4779e7a3845885cb783113527838832b 100755 (executable)
--- a/dak/dakdb/update28.py
+++ b/dak/dakdb/update28.py
@@ -32,7 +32,6 @@ import psycopg2
 import time
 from daklib.dak_exceptions import DBUpdateError
 from daklib.config import Config
-from daklib.dakdb import DBConn
 
 ################################################################################
 
@@ -51,7 +50,7 @@ def arches(cursor, suite):
     cursor.execute("""SELECT s.architecture, a.arch_string
     FROM suite_architectures s
     JOIN architecture a ON (s.architecture=a.id)
-    WHERE suite = :suite""", {'suite' : suite })
+    WHERE suite = '%s'""" % suite)
 
     while True:
         r = cursor.fetchone()
@@ -144,10 +143,8 @@ def do_update(self):
         for suite in [i.lower() for i in suites]:
 
             c.execute("SELECT id FROM suite WHERE suite_name ='%s'" % suite )
-            rows = c.fetchall()
-
-
-            suite_id = DBConn().get_suite_id(suite)
+            suiterow = c.fetchall()
+            suite_id=suiterow[0]
             arch_list = arches(c, suite_id)
             arch_list = arches(c, suite_id)