5 INSERT INTO biblio.record_entry (id, last_xact_id, marc)
6 VALUES (999999998, 'pgtap', '<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim">
7 <leader>00531nam a2200157 a 4500</leader>
8 <controlfield tag="005">20080729170300.0</controlfield>
9 <controlfield tag="008"> t19981999enka 0 eng </controlfield>
10 <datafield tag="245" ind1="1" ind2="4">
11 <subfield code="a">test-value</subfield>
15 INSERT INTO biblio.monograph_part(record, label) VALUES (999999998, 'Part 1');
20 'LP#937789: new monograph parts start out active'
22 FROM biblio.monograph_part
23 WHERE record = 999999998
28 '//ns:monograph_parts/ns:monograph_part/@label',
29 unapi.holdings_xml(999999998, 1, 'CONS', 0, '{bmp}'),
30 '{{ns,http://open-ils.org/spec/holdings/v1}}'
33 'LP#937789: unapi.holdings_xml returns monograph part'
38 '/ns:monograph_part/@label',
39 unapi.bmp(CURRVAL('biblio.monograph_part_id_seq'), '', '', '{}', 'CONS'),
40 '{{ns,http://open-ils.org/spec/holdings/v1}}'
43 'LP#937789: unapi.bmp returns monograph part'
46 DELETE FROM biblio.monograph_part WHERE record = 999999998;
51 'LP#937789: deleting monograph part sets deleted flag'
53 FROM biblio.monograph_part
54 WHERE record = 999999998
59 '//ns:monograph_parts/ns:monograph_part/@label',
60 unapi.holdings_xml(999999998, 1, 'CONS', 0, '{bmp}'),
61 '{{ns,http://open-ils.org/spec/holdings/v1}}'
64 'LP#937789: unapi.holdings_xml does not return deleted monograph part'
68 unapi.bmp(CURRVAL('biblio.monograph_part_id_seq'), '', '', '{}', 'CONS')::TEXT,
70 'LP#937789: unapi.bmp does not return deleted monograph part'