From b500f8644f26fd837e7a8d95392918e3b6a43a5d Mon Sep 17 00:00:00 2001
From: Bill Erickson <berick@esilibrary.com>
Date: Thu, 18 Oct 2012 16:28:44 -0400
Subject: [PATCH] test data: added simple hold population func

Signed-off-by: Bill Erickson <berick@esilibrary.com>
---
 Open-ILS/tests/datasets/sql/env_create.sql  | 26 ++++++++++++++++++++++++++
 Open-ILS/tests/datasets/sql/env_destroy.sql |  2 ++
 2 files changed, 28 insertions(+)

diff --git a/Open-ILS/tests/datasets/sql/env_create.sql b/Open-ILS/tests/datasets/sql/env_create.sql
index 218c028856..519af0aa2e 100644
--- a/Open-ILS/tests/datasets/sql/env_create.sql
+++ b/Open-ILS/tests/datasets/sql/env_create.sql
@@ -104,4 +104,30 @@ $$ LANGUAGE PLPGSQL;
 
 
 
+/** Create one hold */
+CREATE FUNCTION evergreen.populate_hold (
+    hold_type TEXT,
+    target BIGINT,
+    patron_barcode TEXT, 
+    pickup_lib INTEGER
+    -- ...
+)
+RETURNS void AS $$
+BEGIN
+    INSERT INTO action.hold_request (
+        requestor, hold_type, target, usr, pickup_lib, request_lib, selection_ou)
+    VALUES (
+        1, -- requestor 
+        hold_type,
+        target,
+        (SELECT usr FROM actor.card WHERE barcode = patron_barcode),
+        pickup_lib,
+        pickup_lib,
+        pickup_lib
+    );
+END;
+$$ LANGUAGE PLPGSQL;
+
+
+
 
diff --git a/Open-ILS/tests/datasets/sql/env_destroy.sql b/Open-ILS/tests/datasets/sql/env_destroy.sql
index 5795f897de..ca64cd5059 100644
--- a/Open-ILS/tests/datasets/sql/env_destroy.sql
+++ b/Open-ILS/tests/datasets/sql/env_destroy.sql
@@ -6,3 +6,5 @@ DROP FUNCTION evergreen.populate_copy(INTEGER, INTEGER, TEXT, TEXT);
 DROP FUNCTION evergreen.next_copy (BIGINT);
 DROP FUNCTION evergreen.populate_circ 
     (TEXT, TEXT, INTEGER, TEXT, TEXT, TEXT, BOOLEAN);
+DROP FUNCTION evergreen.populate_hold (TEXT, BIGINT, TEXT, INTEGER);
+
-- 
2.11.0