5 -------------------------
6 -- Setup test environment
7 -- User w/ library card
8 -- Vandelay settings (merge profile, queue)
9 -- "Pre-loaded" authority record to be overlayed
10 -- Matching authority record added to Vandelay queue
11 -- including 905u with user barcode
12 -------------------------
14 INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name,
15 passwd, first_given_name, expire_date, dob, suffix)
16 VALUES (13, 1, 'TEST_USER', 1, 'TESTER', 'TEST1234', 'TEST',
17 NOW() + '3 years'::INTERVAL, NULL, NULL);
19 INSERT INTO actor.card (barcode, usr)
20 VALUES ('TEST_BARCODE', CURRVAL('actor.usr_id_seq'));
23 SET card = CURRVAL('actor.card_id_seq')
24 WHERE id = CURRVAL('actor.usr_id_seq');
26 INSERT INTO vandelay.merge_profile
27 (owner, name, preserve_spec) VALUES (1, 'TEST', '901c');
29 INSERT INTO vandelay.authority_queue (owner, name)
30 VALUES (CURRVAL('actor.usr_id_seq'), 'TEST');
32 INSERT INTO authority.record_entry (id, edit_date, last_xact_id, marc)
33 VALUES (1234512345, now() - '15 days'::INTERVAL, 'TEST',
34 '<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"><leader>00208nz a2200097o 45 0</leader><controlfield tag="001">73</controlfield><controlfield tag="003">CONS</controlfield><controlfield tag="005">20021207110052.0</controlfield><controlfield tag="008">021207n| acannaabn |n aac d</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(IISG)IISGa11554924</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">IISG</subfield><subfield code="c">IISG</subfield></datafield><datafield tag="100" ind1="0" ind2=" "><subfield code="a">Maloy, Eileen</subfield></datafield><datafield tag="901" ind1=" " ind2=" "><subfield code="t">authority</subfield></datafield></record>');
36 INSERT INTO vandelay.queued_authority_record (queue, purpose, marc)
37 SELECT CURRVAL('vandelay.queue_id_seq'), 'overlay',
38 '<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"><leader>00208nz a2200097o 45 0</leader><controlfield tag="001">73</controlfield><controlfield tag="003">CONS</controlfield><controlfield tag="005">20021207110052.0</controlfield><controlfield tag="008">021207n| acannaabn |n aac d</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(IISG)IISGa11554924</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">IISG</subfield><subfield code="c">IISG</subfield></datafield><datafield tag="100" ind1="0" ind2=" "><subfield code="a">Maloy, Eileen</subfield></datafield><datafield tag="901" ind1=" " ind2=" "><subfield code="c">1234512345</subfield><subfield code="t">authority</subfield></datafield><datafield tag="905" ind1=" " ind2=" "><subfield code="u">'
39 || barcode || '</subfield></datafield></record>'
41 WHERE id = CURRVAL('actor.card_id_seq');
43 -----------------------
44 -- Import the record --
45 -----------------------
48 SELECT vandelay.overlay_authority_record(queued_record, eg_record,
49 CURRVAL('vandelay.merge_profile_id_seq')::int )
50 FROM vandelay.authority_match
51 WHERE queued_record = CURRVAL('vandelay.queued_record_id_seq')
53 'Function call succeeded'
56 ---------------------------------
57 -- Test for new values of editor,
58 -- edit date, and source
59 ---------------------------------
61 (SELECT editor::bigint FROM authority.record_entry ORDER BY id DESC LIMIT 1),
62 CURRVAL('actor.usr_id_seq'),
67 (SELECT edit_date::date FROM authority.record_entry ORDER BY id DESC LIMIT 1),
69 'Edit Date was updated'