From 7d83fdd77efac60636ccd4174ae4feb61143d264 Mon Sep 17 00:00:00 2001 From: erickson Date: Wed, 15 Apr 2009 15:45:42 +0000 Subject: [PATCH] don't remove the lineitem and attrs if it points to a selection list git-svn-id: svn://svn.open-ils.org/ILS/trunk@12878 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/support-scripts/test-scripts/purge_po.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/support-scripts/test-scripts/purge_po.sql b/Open-ILS/src/support-scripts/test-scripts/purge_po.sql index 6343b352e9..8169102db6 100644 --- a/Open-ILS/src/support-scripts/test-scripts/purge_po.sql +++ b/Open-ILS/src/support-scripts/test-scripts/purge_po.sql @@ -16,8 +16,12 @@ BEGIN DELETE FROM acq.fund_debit WHERE id in ( SELECT fund_debit FROM acq.lineitem_detail WHERE lineitem = li.id); DELETE FROM acq.lineitem_detail WHERE lineitem = li.id; - DELETE FROM acq.lineitem_attr WHERE lineitem = li.id; - DELETE from acq.lineitem WHERE id = li.id; + IF li.picklist IS NULL THEN + DELETE FROM acq.lineitem_attr WHERE lineitem = li.id; + DELETE from acq.lineitem WHERE id = li.id; + ELSE + UPDATE acq.lineitem SET purchase_order = NULL WHERE id = li.id; + END IF; END LOOP; DELETE FROM acq.purchase_order WHERE id = po_id; -- 2.11.0