From 4ec9f606fbc2ec8c121369c7b6a6a3b2b11bb18e Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Mon, 13 Jun 2011 10:43:55 -0400 Subject: [PATCH] Backporting 36b0a67a4520151082e72056893d92ad3bf797f1, in-db unAPI improvement Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...chema.in-db_unapi_copy_related_visibility-1.sql | 27 ++++++++++++++++++++++ ...chema.in-db_unapi_copy_related_visibility-2.sql | 25 ++++++++++++++++++++ 3 files changed, 53 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql create mode 100644 Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index f5e60e9eca..5d91b9147d 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -57,7 +57,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0556'); -- dbs +INSERT INTO config.upgrade_log (version) VALUES ('0558'); -- miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql b/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql new file mode 100644 index 0000000000..8157b6b59c --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql @@ -0,0 +1,27 @@ +-- Evergreen DB patch 0557.schmea.in-db_unapi_copy_related_visibility-1.sql +-- +-- Bring in-db unAPI opac visibility info up to date with (and a little beyond) ea3b8857d08b8a9050e763f8084c841e8df9a473 +-- +BEGIN; + + +INSERT INTO config.upgrade_log (version) VALUES ('0557'); -- miker + +CREATE OR REPLACE FUNCTION unapi.acl ( obj_id BIGINT, format TEXT, ename TEXT, includes TEXT[], org TEXT, depth INT DEFAULT NULL, slimit INT DEFAULT NULL, soffset INT DEFAULT NULL, include_xmlns BOOL DEFAULT TRUE ) RETURNS XML AS $F$ + SELECT XMLELEMENT( + name location, + XMLATTRIBUTES( + CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, + id AS ident + holdable, + opac_visible, + label_prefix AS prefix, + label_suffix AS suffix + ), + name + ) + FROM asset.copy_location + WHERE id = $1; +$F$ LANGUAGE SQL; + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql b/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql new file mode 100644 index 0000000000..3931f0fb60 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql @@ -0,0 +1,25 @@ +-- Evergreen DB patch 0558.schema.in-db_unapi_copy_related_visibility-2.sql +-- +-- Bring in-db unAPI opac visibility info up to date with (and a little beyond) ea3b8857d08b8a9050e763f8084c841e8df9a473 +-- +BEGIN; + + +INSERT INTO config.upgrade_log (version) VALUES ('0558'); -- miker + +CREATE OR REPLACE FUNCTION unapi.ccs ( obj_id BIGINT, format TEXT, ename TEXT, includes TEXT[], org TEXT, depth INT DEFAULT NULL, slimit INT DEFAULT NULL, soffset INT DEFAULT NULL, include_xmlns BOOL DEFAULT TRUE ) RETURNS XML AS $F$ + SELECT XMLELEMENT( + name status, + XMLATTRIBUTES( + CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, + id AS ident + holdable, + opac_visible + ), + name + ) + FROM config.copy_status + WHERE id = $1; +$F$ LANGUAGE SQL; + +COMMIT; -- 2.11.0