2 -- note: using hard-coded ID's for most objects or this
3 -- would require 3 times as much SQL.
5 INSERT INTO acq.funding_source (id, owner, name, currency_type, code) VALUES
6 (1, 1, 'LSTA', 'USD', 'LSTA'),
7 (2, 2, 'State', 'USD', 'ST'),
8 (3, 4, 'Foundation', 'USD', 'FNTN');
10 SELECT SETVAL('acq.funding_source_id_seq'::TEXT, 3);
12 INSERT INTO acq.funding_source_credit (amount, funding_source) VALUES
13 ('10000',1), ('5000', 2), ('5000', 3);
15 INSERT INTO acq.fund (id, org, year, currency_type, name, code) VALUES
16 (1, 1, EXTRACT(year FROM now()), 'USD', 'Adult', 'AD'),
17 (2, 2, EXTRACT(year FROM now()), 'USD', 'AV', 'AV'),
18 (3, 3, EXTRACT(year FROM now()), 'USD', 'AV', 'AV'),
19 (4, 4, EXTRACT(year FROM now()), 'USD', 'Juvenile', 'JUV'),
20 (5, 5, EXTRACT(year FROM now()), 'USD', 'Young Adult', 'YA'),
21 (6, 6, EXTRACT(year FROM now()), 'USD', 'Juvenile', 'JUV'),
22 (7, 7, EXTRACT(year FROM now()), 'USD', 'Young Adult', 'YA'),
23 (8, 2, EXTRACT(year FROM now()), 'USD', 'Reference', 'RF'),
24 (9, 2, EXTRACT(year FROM now()), 'USD', 'Fiction Print', 'FP'),
25 (10, 2, EXTRACT(year FROM now()), 'USD', 'Fiction Non-Print', 'FNP'),
26 (11, 3, EXTRACT(year FROM now()), 'USD', 'Fiction Print', 'FP'),
27 (12, 3, EXTRACT(year FROM now()), 'USD', 'Fiction Non-Print', 'FNP');
29 SELECT SETVAL('acq.fund_id_seq'::TEXT, 12);
31 INSERT INTO acq.fund_allocation
32 (funding_source, fund, amount, allocator) VALUES
40 INSERT INTO acq.provider
41 (id, name, owner, currency_type, code, holding_tag, san) VALUES
42 (1, 'Ingram', 1, 'USD', 'INGRAM', '970', '1697978'),
43 (2, 'Brodart', 2, 'USD', 'BRODART', '970', '1697684'),
44 (3, 'Baker & Taylor', 1, 'USD', 'BT', '970', '3349659'),
45 (4, 'Initech', 4, 'USD', 'IT', '970', '1001001');
47 SELECT SETVAL('acq.provider_id_seq'::TEXT, 4);
49 INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield) VALUES
51 (1, 'estimated_price', 'p'),
52 (1, 'owning_lib', 'o'),
53 (1, 'call_number', 'n'),
54 (1, 'fund_code', 'f'),
55 (1, 'circ_modifier', 'm'),
57 (1, 'copy_location', 'l'),
59 (1, 'collection_code', 'c');
61 -- give every provider the same holding subfield maps
62 INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield)
63 SELECT 2, name, subfield
64 FROM acq.provider_holding_subfield_map
67 INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield)
68 SELECT 3, name, subfield
69 FROM acq.provider_holding_subfield_map
72 INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield)
73 SELECT 4, name, subfield
74 FROM acq.provider_holding_subfield_map
77 INSERT INTO acq.purchase_order (id, owner, creator,
78 editor, ordering_agency, provider, state, order_date) VALUES
79 (1, 1, 1, 1, 4, 1, 'pending', NULL),
80 (2, 1, 1, 1, 4, 2, 'on-order', NOW());
82 SELECT SETVAL('acq.purchase_order_id_seq'::TEXT, 2);
84 INSERT INTO acq.lineitem (id, creator, editor, selector,
85 provider, purchase_order, state, cancel_reason,
86 estimated_unit_price, eg_bib_id, marc) VALUES
87 (1, 1, 1, 1, 1, 1, 'new', NULL, '25.00', 1,
88 (SELECT marc FROM biblio.record_entry WHERE id = 1)),
89 (2, 1, 1, 1, 1, 1, 'new', NULL, '15.00', 2,
90 (SELECT marc FROM biblio.record_entry WHERE id = 2)),
91 (3, 1, 1, 1, 1, 2, 'on-order', NULL, '12.00', 3,
92 (SELECT marc FROM biblio.record_entry WHERE id = 3)),
93 (4, 1, 1, 1, 1, 2, 'cancelled', 1283, '18.50', 4,
94 (SELECT marc FROM biblio.record_entry WHERE id = 4)),
95 (5, 1, 1, 1, 1, 2, 'cancelled', 1, '22.00', 5,
96 (SELECT marc FROM biblio.record_entry WHERE id = 5));
98 SELECT SETVAL('acq.lineitem_id_seq'::TEXT, 5);
100 INSERT INTO acq.fund_debit (id, fund, origin_amount,
101 origin_currency_type, amount, debit_type) VALUES
102 (1, 1, '12.00', 'USD', '12.00', 'purchase'),
103 (2, 1, '12.00', 'USD', '12.00', 'purchase'),
104 (3, 1, '18.50', 'USD', '12.00', 'purchase');
106 SELECT SETVAL('acq.fund_debit_id_seq'::TEXT, 4);
108 INSERT INTO acq.lineitem_detail (lineitem, fund, fund_debit, eg_copy_id,
109 barcode, cn_label, owning_lib, location, cancel_reason) VALUES
110 (3, 1, 1, 3, 'ACQ0001', 'ACQ001', 4, 113, NULL),
111 (3, 1, 2, 103, 'ACQ0002', 'ACQ002', 5, 125, NULL),
112 (4, 1, 3, 4, 'ACQ0002', 'ACQ002', 4, 118, 1),
113 (5, 1, NULL, 5, 'ACQ0002', 'ACQ002', 4, 123, 1283);