From 7333364972038701fade2f7e9ccdd3a057e55606 Mon Sep 17 00:00:00 2001
From: Mike O'Connor <stew@dhcp-101.dfw1.kickstart.lan>
Date: Sat, 31 Oct 2009 12:31:59 +0000
Subject: [PATCH] triggers now work

Signed-off-by: Mike O'Connor <stew@dhcp-101.dfw1.kickstart.lan>
---
 dak/dakdb/update23.py | 36 ++++++++++++++++--------------------
 1 file changed, 16 insertions(+), 20 deletions(-)

diff --git a/dak/dakdb/update23.py b/dak/dakdb/update23.py
index 9d97172b..708011cf 100644
--- a/dak/dakdb/update23.py
+++ b/dak/dakdb/update23.py
@@ -92,8 +92,7 @@ def do_update(self):
         package text,
         binary_id integer,
         arch integer,
-        suite integer,
-        component text)""" )
+        suite integer)""" )
 
         c.execute("""CREATE TABLE udeb_contents (
         filename text,
@@ -101,8 +100,7 @@ def do_update(self):
         package text,
         binary_id integer,
         suite integer,
-        arch integer,
-        component text )""" )
+        arch integer)""" )
 
         c.execute("""ALTER TABLE ONLY deb_contents
         ADD CONSTRAINT deb_contents_arch_fkey
@@ -171,24 +169,19 @@ def do_update(self):
     if event == "INSERT" or event == "UPDATE":
 
        content_data = plpy.execute(plpy.prepare(
-            """SELECT s.section, b.package, b.architecture, c.name, ot.type
+            """SELECT s.section, b.package, b.architecture, ot.type
             FROM override o
             JOIN override_type ot on o.type=ot.id
             JOIN binaries b on b.package=o.package
             JOIN files f on b.file=f.id
             JOIN location l on l.id=f.location
             JOIN section s on s.id=o.section
-            JOIN component c on c.id=l.component
             WHERE b.id=$1
             AND o.suite=$2
             """,
             ["int", "int"]),
             [TD["new"]["bin"], TD["new"]["suite"]])[0]
 
-       component_str = "";
-       if not content_data["name"] === "main":
-           component_str=content_data["name"]+"/"
-
        filenames = plpy.execute(plpy.prepare(
            "SELECT bc.file FROM bin_contents bc where bc.binary_id=$1",
            ["int"]),
@@ -197,16 +190,15 @@ def do_update(self):
        for filename in filenames:
            plpy.execute(plpy.prepare(
                """INSERT INTO deb_contents
-                   (file,section,package,binary_id,arch,suite,component)
-                   VALUES($1,$2,$3,$4,$5,$6,$7)""",
-               ["text","text","text","int","int","int","text"]),
-               [filename["filename"],
+                   (filename,section,package,binary_id,arch,suite)
+                   VALUES($1,$2,$3,$4,$5,$6)""",
+               ["text","text","text","int","int","int"]),
+               [filename["file"],
                 content_data["section"],
                 content_data["package"],
                 TD["new"]["bin"],
                 content_data["architecture"],
-                TD["new"]["suite"],
-                component_str])
+                TD["new"]["suite"]] )
 $$ LANGUAGE plpythonu VOLATILE SECURITY DEFINER;
 """)
 
@@ -215,12 +207,16 @@ $$ LANGUAGE plpythonu VOLATILE SECURITY DEFINER;
     event = TD["event"]
     if event == "UPDATE":
 
-        otype = plpy.execute(plpy.prepare("SELECT type from override_type where id=$1",["int"]),TD["new"]["type"] )[0];
+        otype = plpy.execute(plpy.prepare("SELECT type from override_type where id=$1",["int"]),[TD["new"]["type"]] )[0];
         if otype["type"].endswith("deb"):
+            section = plpy.execute(plpy.prepare("SELECT section from section where id=$1",["int"]),[TD["new"]["section"]] )[0];
+
             table_name = "%s_contents" % otype["type"]
-            plpy.execute(plpy.prepare("UPDATE %s set sections=$1" % table_name
-                                      ["text"]),
-                                      [TD["new"]["section"]])
+            plpy.execute(plpy.prepare("UPDATE %s set section=$1 where package=$2 and suite=$3" % table_name,
+                                      ["text","text","int"]),
+                                      [section["section"],
+                                      TD["new"]["package"],
+                                      TD["new"]["suite"]])
 
 $$ LANGUAGE plpythonu VOLATILE SECURITY DEFINER;
 """)
-- 
2.39.5