From 76daa25d758aca571c937bc1fbadb5f69bfabc2d Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 21 Jan 2010 16:43:26 +0000
Subject: [PATCH] upgrade script to accompany r15353

git-svn-id: svn://svn.open-ils.org/ILS/trunk@15354 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 .../0139.schema.vandelay-item-import-fix.sql  | 66 +++++++++++++++++++
 1 file changed, 66 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/0139.schema.vandelay-item-import-fix.sql

diff --git a/Open-ILS/src/sql/Pg/upgrade/0139.schema.vandelay-item-import-fix.sql b/Open-ILS/src/sql/Pg/upgrade/0139.schema.vandelay-item-import-fix.sql
new file mode 100644
index 0000000000..15cae107b6
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0139.schema.vandelay-item-import-fix.sql
@@ -0,0 +1,66 @@
+
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0139'); -- Dan Wells via miker
+
+CREATE OR REPLACE FUNCTION vandelay.ingest_bib_items ( ) RETURNS TRIGGER AS $func$
+DECLARE
+    attr_def    BIGINT;
+    item_data   vandelay.import_item%ROWTYPE;
+BEGIN
+
+    SELECT item_attr_def INTO attr_def FROM vandelay.bib_queue WHERE id = NEW.queue;
+
+    FOR item_data IN SELECT * FROM vandelay.ingest_items( NEW.id::BIGINT, attr_def ) LOOP
+        INSERT INTO vandelay.import_item (
+            record,
+            definition,
+            owning_lib,
+            circ_lib,
+            call_number,
+            copy_number,
+            status,
+            location,
+            circulate,
+            deposit,
+            deposit_amount,
+            ref,
+            holdable,
+            price,
+            barcode,
+            circ_modifier,
+            circ_as_type,
+            alert_message,
+            pub_note,
+            priv_note,
+            opac_visible
+        ) VALUES (
+            NEW.id,
+            item_data.definition,
+            item_data.owning_lib,
+            item_data.circ_lib,
+            item_data.call_number,
+            item_data.copy_number,
+            item_data.status,
+            item_data.location,
+            item_data.circulate,
+            item_data.deposit,
+            item_data.deposit_amount,
+            item_data.ref,
+            item_data.holdable,
+            item_data.price,
+            item_data.barcode,
+            item_data.circ_modifier,
+            item_data.circ_as_type,
+            item_data.alert_message,
+            item_data.pub_note,
+            item_data.priv_note,
+            item_data.opac_visible
+        );
+    END LOOP;
+
+    RETURN NULL;
+END;
+$func$ LANGUAGE PLPGSQL;
+
+COMMIT;
-- 
2.43.2