From 63da6c1d692addd8725a9c6d878801feace2eaa9 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 23 May 2012 11:20:00 -0400 Subject: [PATCH] KPAC : sample search filter group main search selector Provide a default search filter group for the kid's opac main search selector. Signed-off-by: Bill Erickson Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 31 ++++++++++++++++ .../upgrade/XXXX.data.kpac_filter_group.sql | 35 +++++++++++++++++++ 2 files changed, 66 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.kpac_filter_group.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index f76ae20336..f415b40930 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -11726,3 +11726,34 @@ INSERT INTO config.org_unit_setting_type ( 'interval' ); + +-- kid's opac main search filter + +INSERT INTO actor.search_filter_group (owner, code, label) + VALUES (1, 'kpac_main', 'Kid''s OPAC Search Filter'); + +INSERT INTO actor.search_query (label, query_text) + VALUES ('Children''s Materials', 'audience(a,b,c)'); +INSERT INTO actor.search_query (label, query_text) + VALUES ('Young Adult Materials', 'audience(j,d)'); +INSERT INTO actor.search_query (label, query_text) + VALUES ('General/Adult Materials', 'audience(e,f,g, )'); + +INSERT INTO actor.search_filter_group_entry (grp, query, pos) + VALUES ( + (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), + (SELECT id FROM actor.search_query WHERE label = 'Children''s Materials'), + 0 + ); +INSERT INTO actor.search_filter_group_entry (grp, query, pos) + VALUES ( + (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), + (SELECT id FROM actor.search_query WHERE label = 'Young Adult Materials'), + 1 + ); +INSERT INTO actor.search_filter_group_entry (grp, query, pos) + VALUES ( + (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), + (SELECT id FROM actor.search_query WHERE label = 'General/Adult Materials'), + 2 + ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.kpac_filter_group.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.kpac_filter_group.sql new file mode 100644 index 0000000000..162f96484d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.kpac_filter_group.sql @@ -0,0 +1,35 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO actor.search_filter_group (owner, code, label) + VALUES (1, 'kpac_main', 'Kid''s OPAC Search Filter'); + +INSERT INTO actor.search_query (label, query_text) + VALUES ('Children''s Materials', 'audience(a,b,c)'); +INSERT INTO actor.search_query (label, query_text) + VALUES ('Young Adult Materials', 'audience(j,d)'); +INSERT INTO actor.search_query (label, query_text) + VALUES ('General/Adult Materials', 'audience(e,f,g, )'); + +INSERT INTO actor.search_filter_group_entry (grp, query, pos) + VALUES ( + (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), + (SELECT id FROM actor.search_query WHERE label = 'Children''s Materials'), + 0 + ); +INSERT INTO actor.search_filter_group_entry (grp, query, pos) + VALUES ( + (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), + (SELECT id FROM actor.search_query WHERE label = 'Young Adult Materials'), + 1 + ); +INSERT INTO actor.search_filter_group_entry (grp, query, pos) + VALUES ( + (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), + (SELECT id FROM actor.search_query WHERE label = 'General/Adult Materials'), + 2 + ); + +COMMIT; + -- 2.43.2