From 7eff18dfc5bb918b6a95cc1d8682b330d07715bd Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 25 Aug 2006 20:51:45 +0000 Subject: [PATCH] updating loader sql git-svn-id: svn://svn.open-ils.org/ILS/trunk@5690 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Evergreen/src/extras/import/load_legacy.sql | 22 +++++++++++++++++++++ 1 file changed, 22 insertions(+) diff --git a/Evergreen/src/extras/import/load_legacy.sql b/Evergreen/src/extras/import/load_legacy.sql index eb8d7b72f8..4cdcfbc31e 100644 --- a/Evergreen/src/extras/import/load_legacy.sql +++ b/Evergreen/src/extras/import/load_legacy.sql @@ -168,5 +168,27 @@ INSERT INTO asset.copy_note (owning_copy,creator,title,value) WHERE l.item_comment IS NOT NULL AND l.item_comment <> ''; +-- Now do stat cats +INSERT INTO asset.stat_cat_entry_copy_map (stat_cat, stat_cat_entry, owning_copy) + SELECT sc.id, + sce.id, + cp.id + FROM joined_legacy l + JOIN asset.copy cp ON (cp.barcode = l.item_id) + JOIN asset.stat_cat_entry sce ON (sce.value = l.cat_1) + JOIN asset.stat_cat sc ON (sce.stat_cat = sc.id) + WHERE sc.name = 'Legacy CAT1'; + +INSERT INTO asset.stat_cat_entry_copy_map (stat_cat, stat_cat_entry, owning_copy) + SELECT sc.id, + sce.id, + cp.id + FROM joined_legacy l + JOIN asset.copy cp ON (cp.barcode = l.item_id) + JOIN asset.stat_cat_entry sce ON (sce.value = l.cat_2) + JOIN asset.stat_cat sc ON (sce.stat_cat = sc.id) + WHERE sc.name = 'Legacy CAT2'; + + COMMIT; -- 2.43.2