From 7967cf080c768ea9e20eb1716ee8fece54a0397e Mon Sep 17 00:00:00 2001 From: miker Date: Sun, 28 Sep 2008 20:48:10 +0000 Subject: [PATCH] expose the new in-db z39.50 config git-svn-id: svn://svn.open-ils.org/ILS/trunk@10718 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 38 ++++++++++++++++ .../OpenILS/Application/Search/Z3950.pm | 3 ++ Open-ILS/src/sql/Pg/002.schema.config.sql | 45 +++++++++++++++++++ 3 files changed, 86 insertions(+) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index fd7274b114..49419ddb9d 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -420,6 +420,44 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Search/Z3950.pm b/Open-ILS/src/perlmods/OpenILS/Application/Search/Z3950.pm index fc2f6724f7..97cf08b06d 100755 --- a/Open-ILS/src/perlmods/OpenILS/Application/Search/Z3950.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Search/Z3950.pm @@ -101,6 +101,8 @@ sub query_services { host => $s->host, port => $s->port, db => $s->db, + record_format => $s->record_format, + transmission_format => $s->transmission_format, auth => $s->auth, }; @@ -111,6 +113,7 @@ sub query_services { code => $a->code, format => $a->format, source => $a->source, + truncation => $a->truncation, }; } } diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 57f2c78e28..fbe5b0dc05 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -444,6 +444,51 @@ CREATE TABLE config.bib_level_map ( value TEXT NOT NULL ); +CREATE TABLE config.z3950_source ( + name TEXT PRIMARY KEY, + label TEXT NOT NULL UNIQUE, + host TEXT NOT NULL, + port INT NOT NULL, + db TEXT NOT NULL, + record_format TEXT NOT NULL DEFAULT 'FI', + transmission_format TEXT NOT NULL DEFAULT 'usmarc', + auth BOOL NOT NULL DEFAULT TRUE +); + +INSERT INTO config.z3950_source (name,label,host,port,db,auth) VALUES ('loc','Library of Congress','z3950.loc.gov',7090,'Voyager',FALSE); +INSERT INTO config.z3950_source (name,label,host,port,db) VALUES ('oclc','OCLC','zcat.oclc.org',210,'OLUCWorldCat'); + +CREATE TABLE config.z3950_attr ( + id SERIAL PRIMARY KEY, + source TEXT NOT NULL REFERENCES config.z3950_source (name), + name TEXT NOT NULL, + label TEXT NOT NULL, + code INT NOT NULL, + format INT NOT NULL, + truncation INT NOT NULL DEFAULT 0, + CONSTRAINT z_code_format_once_per_source UNIQUE (code,format,source) +); + +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','tcn','Title Control Number',12,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','isbn','ISBN',7,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','lccn','LCCN',9,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','author','Author',1003,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','title','Title',4,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','issn','ISSN',8,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','publisher','Publisher',1018,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','pubdate','Publication Date',31,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','item_type','Item Type',1001,1); + +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','tcn','Title Control Number',12,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','isbn','ISBN',7,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','lccn','LCCN',9,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','author','Author',1003,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','title','Title',4,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','issn','ISSN',8,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','publisher','Publisher',1018,6); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','pubdate','Publication Date',31,1); +INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','item_type','Item Type',1001,1); + CREATE TABLE config.i18n_locale ( code TEXT PRIMARY KEY, marc_code TEXT NOT NULL REFERENCES config.language_map (code) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, -- 2.43.2