]> git.evergreen-ils.org Git - contrib/Conifer.git/commit
projects / contrib / Conifer.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8d3d18a) | patch
More example in-database MARC fixing
authorDan Scott <dscott@laurentian.ca>
Sat, 27 Dec 2014 21:51:32 +0000 (16:51 -0500)
committerDan Scott <dscott@laurentian.ca>
Sat, 27 Dec 2014 21:51:32 +0000 (16:51 -0500)
commita1638d30c3acaa13d5f5c2f2b26786d2ad79ac0f
tree8a108bd1cfa8af47690fc7f8b21b38fd2a685ff5tree
parent8d3d18afc661dfa534dffd68efa208484cff93c3commit | diff
More example in-database MARC fixing

Generated the fix file with

\o ecco_uris_to_fix.sql
SELECT 'UPDATE biblio.record_entry SET marc = conifer.fix_ecco_uris(' || id ||
 ') WHERE id = ' || id || ';' FROM biblio.record_entry WHERE marc ~
 'galegroup.com/ecco' AND marc ~ 'wind05901' ORDER BY id ASC;
\o

And then running ecco_uris_to_fix.sql

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/fix_ecco_uris.sql [new file with mode: 0644] blob
Evergreen contribs