1 -- tests to verify that metarecord mapping updates happen correctly
6 INSERT INTO biblio.record_entry (last_xact_id, marc) VALUES (
7 'metarecord-remap-test',
8 $record$<record xmlns="http://www.loc.gov/MARC21/slim">
9 <leader>02137cam a2200457 a 4500</leader>
10 <controlfield tag="001">ocn694080497</controlfield>
11 <controlfield tag="005">20160729104757.0</controlfield>
12 <controlfield tag="008">101217s2011 txu b 001 0 eng </controlfield>
13 <datafield tag="245" ind1="0" ind2="0">
14 <subfield code="a">Random Title AFDSDGFJ /</subfield>
15 <subfield code="c">Felix T. Cat.</subfield>
21 SELECT COUNT(*) FROM metabib.metarecord
22 WHERE master_record = CURRVAL('biblio.record_entry_id_seq')
25 'unique bib becomes master of just one metarecord'
29 SELECT COUNT(*) FROM metabib.metarecord_source_map
30 WHERE source = CURRVAL('biblio.record_entry_id_seq')
33 'unique bib part of just one metarecord mapping'
36 UPDATE biblio.record_entry
37 SET marc = REPLACE(marc, 'Random Title AFDSDGFJ', 'Random Title XXDFYLNJ')
38 WHERE id = CURRVAL('biblio.record_entry_id_seq');
42 SELECT COUNT(*) FROM metabib.metarecord
43 WHERE master_record = CURRVAL('biblio.record_entry_id_seq')
46 'LP#1488655: after fingerprint change, bib still master of just one metarecord'
50 SELECT COUNT(*) FROM metabib.metarecord_source_map
51 WHERE source = CURRVAL('biblio.record_entry_id_seq')
54 'LP#1488655: after fingerprint change, bib still in just one metarecord mapping'