From 8b1b69293f3a62360d152fff0f7f73049e2b1afb Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Wed, 3 Sep 2014 13:43:50 +0200 Subject: [PATCH] [PASSED QA] Bug 12864: Add LOC SRU server to sample z3950servers.sql MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Add LOC SRU server to sample servers installed. This patch modifies four language files: de, en, es and nb. For the other languages this may not be useful. Test plan: You could test this by using the webinstaller. But you could also (backup) and delete your records in z3950servers, and run the sample_z3950_servers.sql file from the command line. Check if you see the new SRU server. Tested using mysql. I truncated the table (to reset the IDs as well) and then ran the file. Works as expected. Signed-off-by: Marc VĂ©ron Signed-off-by: Martin Renvoize --- installer/data/mysql/de-DE/optional/sample_z3950_servers.sql | 6 ++++++ installer/data/mysql/en/optional/sample_z3950_servers.sql | 6 ++++++ installer/data/mysql/es-ES/optional/sample_z3950_servers.sql | 6 ++++++ installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql | 6 ++++++ 4 files changed, 24 insertions(+) diff --git a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql index 57c6481..8006f37 100644 --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql @@ -5,3 +5,9 @@ INSERT INTO z3950servers ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), ('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), ('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); + +#Insert SRU server +INSERT INTO z3950servers +(host, port, db, servername, syntax, encoding, servertype, sru_fields) +VALUES +('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier'); diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.sql b/installer/data/mysql/en/optional/sample_z3950_servers.sql index 57c6481..8006f37 100644 --- a/installer/data/mysql/en/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/en/optional/sample_z3950_servers.sql @@ -5,3 +5,9 @@ INSERT INTO z3950servers ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), ('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), ('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); + +#Insert SRU server +INSERT INTO z3950servers +(host, port, db, servername, syntax, encoding, servertype, sru_fields) +VALUES +('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier'); diff --git a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql b/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql index aed01b2..9099566 100644 --- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql @@ -3,3 +3,9 @@ INSERT INTO `z3950servers` ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), ('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), ('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); + +#Insert SRU server +INSERT INTO z3950servers +(host, port, db, servername, syntax, encoding, servertype, sru_fields) +VALUES +('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql b/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql index 8a4db12..9b303a1 100644 --- a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql +++ b/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql @@ -4,3 +4,9 @@ INSERT INTO z3950servers (host, port, db, userid, password, servername, id, chec ('z3950.nb.no',2100,'Norbok','','','NORBOK',13,0,0,'NORMARC',0,'zed','ISO_8859-1'), ('z3950.nb.no',2100,'Sambok','','','SAMBOK',14,0,0,'NORMARC',0,'zed','ISO_8859-1'), ('z3950.deich.folkebibl.no',210,'data','','','DEICHMAN',15,0,0,'NORMARC',0,'zed','ISO_8859-1'); + +#Insert SRU server +INSERT INTO z3950servers +(host, port, db, servername, syntax, encoding, servertype, sru_fields) +VALUES +('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier'); -- 1.7.10.4