]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/perlmods/OpenILS/Application/Storage/Driver/Pg/dbi.pm
adding user_circulation_summary; adding xact_type to billable_transaction_summary
[Evergreen.git] / Open-ILS / src / perlmods / OpenILS / Application / Storage / Driver / Pg / dbi.pm
1 {
2         #---------------------------------------------------------------------
3         package money::billable_transaction;
4         
5         money::billable_transaction->table( 'money.billable_transaction' );
6         money::billable_transaction->sequence( 'money.billable_transaction_id_seq' );
7
8         #---------------------------------------------------------------------
9         package money::billing;
10         
11         money::billing->table( 'money.billing' );
12         money::billing->sequence( 'money.billing_id_seq' );
13
14         #---------------------------------------------------------------------
15         package money::payment;
16         
17         money::payment->table( 'money.payment' );
18         money::payment->sequence( 'money.payment_id_seq' );
19
20         #---------------------------------------------------------------------
21         package money::cash_payment;
22         
23         money::cash_payment->table( 'money.cash_payment' );
24         money::cash_payment->sequence( 'money.payment_id_seq' );
25
26         #---------------------------------------------------------------------
27         package money::check_payment;
28         
29         money::check_payment->table( 'money.check_payment' );
30         money::check_payment->sequence( 'money.payment_id_seq' );
31
32         #---------------------------------------------------------------------
33         package money::credit_payment;
34         
35         money::credit_payment->table( 'money.credit_payment' );
36         money::credit_payment->sequence( 'money.payment_id_seq' );
37
38         #---------------------------------------------------------------------
39         package money::credit_card_payment;
40         
41         money::credit_card_payment->table( 'money.credit_card_payment' );
42         money::credit_card_payment->sequence( 'money.payment_id_seq' );
43
44         #---------------------------------------------------------------------
45         package money::work_payment;
46         
47         money::work_payment->table( 'money.work_payment' );
48         money::work_payment->sequence( 'money.payment_id_seq' );
49
50         #---------------------------------------------------------------------
51         package money::forgive_payment;
52         
53         money::forgive_payment->table( 'money.forgive_payment' );
54         money::forgive_payment->sequence( 'money.payment_id_seq' );
55
56         #---------------------------------------------------------------------
57         package money::billable_transaction_summary;
58         
59         money::billable_transaction_summary->table( 'money.billable_xact_summary' );
60
61         #---------------------------------------------------------------------
62         package money::user_summary;
63         
64         money::user_summary->table( 'money.usr_summary' );
65
66         #---------------------------------------------------------------------
67         package money::user_circulation_summary;
68         
69         money::user_summary->table( 'money.usr_circulation_summary' );
70
71         #---------------------------------------------------------------------
72         package action::circulation;
73         
74         action::circulation->table( 'action.circulation' );
75         action::circulation->sequence( 'money.billable_xact_id_seq' );
76
77         #---------------------------------------------------------------------
78         package action::survey;
79         
80         action::survey->table( 'action.survey' );
81         action::survey->sequence( 'action.survey_id_seq' );
82         
83         #---------------------------------------------------------------------
84         package action::survey_question;
85         
86         action::survey_question->table( 'action.survey_question' );
87         action::survey_question->sequence( 'action.survey_question_id_seq' );
88         
89         #---------------------------------------------------------------------
90         package action::survey_answer;
91         
92         action::survey_answer->table( 'action.survey_answer' );
93         action::survey_answer->sequence( 'action.survey_answer_id_seq' );
94         
95         #---------------------------------------------------------------------
96         package action::survey_response;
97         
98         action::survey_response->table( 'action.survey_response' );
99         action::survey_response->sequence( 'action.survey_response_id_seq' );
100         
101         #---------------------------------------------------------------------
102         package config::copy_status;
103         
104         config::copy_status->table( 'config.copy_status' );
105         config::copy_status->sequence( 'config.copy_status_id_seq' );
106
107         #---------------------------------------------------------------------
108         package config::rules::circ_duration;
109         
110         config::rules::circ_duration->table( 'config.rule_circ_duration' );
111         config::rules::circ_duration->sequence( 'config.rule_circ_duration_id_seq' );
112         
113         #---------------------------------------------------------------------
114         package config::rules::age_hold_protect;
115         
116         config::rules::age_hold_protect->table( 'config.rule_age_hold_protect' );
117         config::rules::age_hold_protect->sequence( 'config.rule_age_hold_protect_id_seq' );
118         
119         #---------------------------------------------------------------------
120         package config::rules::max_fine;
121         
122         config::rules::max_fine->table( 'config.rule_max_fine' );
123         config::rules::max_fine->sequence( 'config.rule_max_fine_id_seq' );
124         
125         #---------------------------------------------------------------------
126         package config::rules::recuring_fine;
127         
128         config::rules::recuring_fine->table( 'config.rule_recuring_fine' );
129         config::rules::recuring_fine->sequence( 'config.rule_recuring_fine_id_seq' );
130         
131         #---------------------------------------------------------------------
132         package config::net_access_level;
133         
134         config::net_access_level->table( 'config.net_access_level' );
135         config::net_access_level->sequence( 'config.net_access_level_id_seq' );
136         
137         #---------------------------------------------------------------------
138         package config::standing;
139         
140         config::standing->table( 'config.standing' );
141         config::standing->sequence( 'config.standing_id_seq' );
142         
143         #---------------------------------------------------------------------
144         package config::metabib_field;
145         
146         config::metabib_field->table( 'config.metabib_field' );
147         config::metabib_field->sequence( 'config.metabib_field_id_seq' );
148         
149         #---------------------------------------------------------------------
150         package config::bib_source;
151         
152         config::bib_source->table( 'config.bib_source' );
153         config::bib_source->sequence( 'config.bib_source_id_seq' );
154         
155         #---------------------------------------------------------------------
156         package config::identification_type;
157         
158         config::identification_type->table( 'config.identification_type' );
159         config::identification_type->sequence( 'config.identification_type_id_seq' );
160         
161         #---------------------------------------------------------------------
162         package asset::call_number_note;
163         
164         asset::call_number_note->table( 'asset.call_number_note' );
165         asset::call_number_note->sequence( 'asset.call_number_note_id_seq' );
166         
167         #---------------------------------------------------------------------
168         package asset::copy_note;
169         
170         asset::copy_note->table( 'asset.copy_note' );
171         asset::copy_note->sequence( 'asset.copy_note_id_seq' );
172
173         #---------------------------------------------------------------------
174         package asset::call_number;
175         
176         asset::call_number->table( 'asset.call_number' );
177         asset::call_number->sequence( 'asset.call_number_id_seq' );
178         
179         #---------------------------------------------------------------------
180         package asset::copy_location;
181         
182         asset::copy_location->table( 'asset.copy_location' );
183         asset::copy_location->sequence( 'asset.copy_location_id_seq' );
184
185         #---------------------------------------------------------------------
186         package asset::copy;
187         
188         asset::copy->table( 'asset.copy' );
189         asset::copy->sequence( 'asset.copy_id_seq' );
190
191         #---------------------------------------------------------------------
192         package asset::stat_cat;
193         
194         asset::stat_cat->table( 'asset.stat_cat' );
195         asset::stat_cat->sequence( 'asset.stat_cat_id_seq' );
196         
197         #---------------------------------------------------------------------
198         package asset::stat_cat_entry;
199         
200         asset::stat_cat_entry->table( 'asset.stat_cat_entry' );
201         asset::stat_cat_entry->sequence( 'asset.stat_cat_entry_id_seq' );
202         
203         #---------------------------------------------------------------------
204         package asset::stat_cat_entry_copy_map;
205         
206         asset::stat_cat_entry_copy_map->table( 'asset.stat_cat_entry_copy_map' );
207         asset::stat_cat_entry_copy_map->sequence( 'asset.stat_cat_entry_copy_map_id_seq' );
208         
209         #---------------------------------------------------------------------
210         package biblio::record_entry;
211         
212         biblio::record_entry->table( 'biblio.record_entry' );
213         biblio::record_entry->sequence( 'biblio.record_entry_id_seq' );
214
215         #---------------------------------------------------------------------
216         #package biblio::record_marc;
217         #
218         #biblio::record_marc->table( 'biblio.record_marc' );
219         #biblio::record_marc->sequence( 'biblio.record_marc_id_seq' );
220         #
221         #---------------------------------------------------------------------
222         package biblio::record_note;
223         
224         biblio::record_note->table( 'biblio.record_note' );
225         biblio::record_note->sequence( 'biblio.record_note_id_seq' );
226         
227         #---------------------------------------------------------------------
228         package actor::user;
229         
230         actor::user->table( 'actor.usr' );
231         actor::user->sequence( 'actor.usr_id_seq' );
232
233         #---------------------------------------------------------------------
234         package actor::user_setting;
235         
236         actor::user_setting->table( 'actor.usr_setting' );
237         actor::user_setting->sequence( 'actor.usr_setting_id_seq' );
238
239         #---------------------------------------------------------------------
240         package actor::user_address;
241         
242         actor::user_address->table( 'actor.usr_address' );
243         actor::user_address->sequence( 'actor.usr_address_id_seq' );
244
245         #---------------------------------------------------------------------
246         package actor::org_address;
247         
248         actor::org_address->table( 'actor.org_address' );
249         actor::org_address->sequence( 'actor.org_address_id_seq' );
250         
251         #---------------------------------------------------------------------
252         package actor::profile;
253         
254         actor::profile->table( 'actor.profile' );
255         actor::profile->sequence( 'actor.profile_id_seq' );
256         
257         #---------------------------------------------------------------------
258         package actor::org_unit_type;
259         
260         actor::org_unit_type->table( 'actor.org_unit_type' );
261         actor::org_unit_type->sequence( 'actor.org_unit_type_id_seq' );
262
263         #---------------------------------------------------------------------
264         package actor::org_unit;
265         
266         actor::org_unit->table( 'actor.org_unit' );
267         actor::org_unit->sequence( 'actor.org_unit_id_seq' );
268
269         #---------------------------------------------------------------------
270         package actor::stat_cat;
271         
272         actor::stat_cat->table( 'actor.stat_cat' );
273         actor::stat_cat->sequence( 'actor.stat_cat_id_seq' );
274         
275         #---------------------------------------------------------------------
276         package actor::stat_cat_entry;
277         
278         actor::stat_cat_entry->table( 'actor.stat_cat_entry' );
279         actor::stat_cat_entry->sequence( 'actor.stat_cat_entry_id_seq' );
280         
281         #---------------------------------------------------------------------
282         package actor::stat_cat_entry_user_map;
283         
284         actor::stat_cat_entry_user_map->table( 'actor.stat_cat_entry_usr_map' );
285         actor::stat_cat_entry_user_map->sequence( 'actor.stat_cat_entry_usr_map_id_seq' );
286         
287         #---------------------------------------------------------------------
288         package actor::card;
289         
290         actor::card->table( 'actor.card' );
291         actor::card->sequence( 'actor.card_id_seq' );
292
293         #---------------------------------------------------------------------
294
295         #-------------------------------------------------------------------------------
296         package metabib::metarecord;
297
298         metabib::metarecord->table( 'metabib.metarecord' );
299         metabib::metarecord->sequence( 'metabib.metarecord_id_seq' );
300
301         OpenILS::Application::Storage->register_method(
302                 api_name        => 'open-ils.storage.direct.metabib.metarecord.batch.create',
303                 method          => 'copy_create',
304                 api_level       => 1,
305                 'package'       => 'OpenILS::Application::Storage',
306                 cdbi            => 'metabib::metarecord',
307         );
308
309
310         #-------------------------------------------------------------------------------
311
312         #-------------------------------------------------------------------------------
313         package metabib::title_field_entry;
314
315         metabib::title_field_entry->table( 'metabib.title_field_entry' );
316         metabib::title_field_entry->sequence( 'metabib.title_field_entry_id_seq' );
317         metabib::title_field_entry->columns( 'FTS' => 'index_vector' );
318
319 #       metabib::title_field_entry->add_trigger(
320 #               before_create => \&OpenILS::Application::Storage::Driver::Pg::tsearch2_trigger
321 #       );
322 #       metabib::title_field_entry->add_trigger(
323 #               before_update => \&OpenILS::Application::Storage::Driver::Pg::tsearch2_trigger
324 #       );
325
326         OpenILS::Application::Storage->register_method(
327                 api_name        => 'open-ils.storage.direct.metabib.title_field_entry.batch.create',
328                 method          => 'copy_create',
329                 api_level       => 1,
330                 'package'       => 'OpenILS::Application::Storage',
331                 cdbi            => 'metabib::title_field_entry',
332         );
333
334         #-------------------------------------------------------------------------------
335
336         #-------------------------------------------------------------------------------
337         package metabib::author_field_entry;
338
339         metabib::author_field_entry->table( 'metabib.author_field_entry' );
340         metabib::author_field_entry->sequence( 'metabib.author_field_entry_id_seq' );
341         metabib::author_field_entry->columns( 'FTS' => 'index_vector' );
342
343         OpenILS::Application::Storage->register_method(
344                 api_name        => 'open-ils.storage.direct.metabib.author_field_entry.batch.create',
345                 method          => 'copy_create',
346                 api_level       => 1,
347                 'package'       => 'OpenILS::Application::Storage',
348                 cdbi            => 'metabib::author_field_entry',
349         );
350
351         #-------------------------------------------------------------------------------
352
353         #-------------------------------------------------------------------------------
354         package metabib::subject_field_entry;
355
356         metabib::subject_field_entry->table( 'metabib.subject_field_entry' );
357         metabib::subject_field_entry->sequence( 'metabib.subject_field_entry_id_seq' );
358         metabib::subject_field_entry->columns( 'FTS' => 'index_vector' );
359
360         OpenILS::Application::Storage->register_method(
361                 api_name        => 'open-ils.storage.direct.metabib.subject_field_entry.batch.create',
362                 method          => 'copy_create',
363                 api_level       => 1,
364                 'package'       => 'OpenILS::Application::Storage',
365                 cdbi            => 'metabib::subject_field_entry',
366         );
367
368         #-------------------------------------------------------------------------------
369
370         #-------------------------------------------------------------------------------
371         package metabib::keyword_field_entry;
372
373         metabib::keyword_field_entry->table( 'metabib.keyword_field_entry' );
374         metabib::keyword_field_entry->sequence( 'metabib.keyword_field_entry_id_seq' );
375         metabib::keyword_field_entry->columns( 'FTS' => 'index_vector' );
376
377         OpenILS::Application::Storage->register_method(
378                 api_name        => 'open-ils.storage.direct.metabib.keyword_field_entry.batch.create',
379                 method          => 'copy_create',
380                 api_level       => 1,
381                 'package'       => 'OpenILS::Application::Storage',
382                 cdbi            => 'metabib::keyword_field_entry',
383         );
384
385         #-------------------------------------------------------------------------------
386         package metabib::series_field_entry;
387
388         metabib::series_field_entry->table( 'metabib.series_field_entry' );
389         metabib::series_field_entry->sequence( 'metabib.series_field_entry_id_seq' );
390         metabib::series_field_entry->columns( 'FTS' => 'index_vector' );
391
392         OpenILS::Application::Storage->register_method(
393                 api_name        => 'open-ils.storage.direct.metabib.series_field_entry.batch.create',
394                 method          => 'copy_create',
395                 api_level       => 1,
396                 'package'       => 'OpenILS::Application::Storage',
397                 cdbi            => 'metabib::series_field_entry',
398         );
399
400         #-------------------------------------------------------------------------------
401
402         #-------------------------------------------------------------------------------
403         #package metabib::title_field_entry_source_map;
404
405         #metabib::title_field_entry_source_map->table( 'metabib.title_field_entry_source_map' );
406
407         #-------------------------------------------------------------------------------
408
409         #-------------------------------------------------------------------------------
410         #package metabib::author_field_entry_source_map;
411
412         #metabib::author_field_entry_source_map->table( 'metabib.author_field_entry_source_map' );
413
414         #-------------------------------------------------------------------------------
415
416         #-------------------------------------------------------------------------------
417         #package metabib::subject_field_entry_source_map;
418
419         #metabib::subject_field_entry_source_map->table( 'metabib.subject_field_entry_source_map' );
420
421         #-------------------------------------------------------------------------------
422
423         #-------------------------------------------------------------------------------
424         #package metabib::keyword_field_entry_source_map;
425
426         #metabib::keyword_field_entry_source_map->table( 'metabib.keyword_field_entry_source_map' );
427
428         #-------------------------------------------------------------------------------
429
430         #-------------------------------------------------------------------------------
431         package metabib::metarecord_source_map;
432
433         metabib::metarecord_source_map->table( 'metabib.metarecord_source_map' );
434         OpenILS::Application::Storage->register_method(
435                 api_name        => 'open-ils.storage.direct.metabib.metarecord_source_map.batch.create',
436                 method          => 'copy_create',
437                 api_level       => 1,
438                 'package'       => 'OpenILS::Application::Storage',
439                 cdbi            => 'metabib::metarecord_source_map',
440         );
441
442
443         #-------------------------------------------------------------------------------
444         package metabib::record_descriptor;
445
446         metabib::record_descriptor->table( 'metabib.rec_descriptor' );
447         metabib::record_descriptor->sequence( 'metabib.rec_descriptor_id_seq' );
448
449         OpenILS::Application::Storage->register_method(
450                 api_name        => 'open-ils.storage.direct.metabib.record_descriptor.batch.create',
451                 method          => 'copy_create',
452                 api_level       => 1,
453                 'package'       => 'OpenILS::Application::Storage',
454                 cdbi            => 'metabib::record_descriptor',
455         );
456
457         #-------------------------------------------------------------------------------
458
459
460         #-------------------------------------------------------------------------------
461         package metabib::full_rec;
462
463         metabib::full_rec->table( 'metabib.full_rec' );
464         metabib::full_rec->sequence( 'metabib.full_rec_id_seq' );
465         metabib::full_rec->columns( 'FTS' => 'index_vector' );
466
467         OpenILS::Application::Storage->register_method(
468                 api_name        => 'open-ils.storage.direct.metabib.full_rec.batch.create',
469                 method          => 'copy_create',
470                 api_level       => 1,
471                 'package'       => 'OpenILS::Application::Storage',
472                 cdbi            => 'metabib::full_rec',
473         );
474
475
476         #-------------------------------------------------------------------------------
477
478         package permission::perm_list;
479
480         permission::perm_list->sequence( 'permission.perm_list_id_seq' );
481         permission::perm_list->table('permission.perm_list');
482
483         #-------------------------------------------------------------------------------
484
485         package permission::grp_tree;
486
487         permission::grp_tree->sequence( 'permission.grp_tree_id_seq' );
488         permission::grp_tree->table('permission.grp_tree');
489
490         #-------------------------------------------------------------------------------
491
492         package permission::usr_grp_map;
493
494         permission::usr_grp_map->sequence( 'permission.usr_grp_map_id_seq' );
495         permission::usr_grp_map->table('permission.usr_grp_map');
496
497         #-------------------------------------------------------------------------------
498
499         package permission::usr_perm_map;
500
501         permission::usr_perm_map->sequence( 'permission.usr_perm_map_id_seq' );
502         permission::usr_perm_map->table('permission.usr_perm_map');
503
504         #-------------------------------------------------------------------------------
505
506         package permission::grp_perm_map;
507
508         permission::grp_perm_map->sequence( 'permission.grp_perm_map_id_seq' );
509         permission::grp_perm_map->table('permission.grp_perm_map');
510
511         #-------------------------------------------------------------------------------
512
513         package action::hold_request;
514
515         action::hold_request->sequence( 'action.hold_request_id_seq' );
516         action::hold_request->table('action.hold_request');
517
518         #-------------------------------------------------------------------------------
519
520         package action::hold_notification;
521
522         action::hold_notification->sequence( 'action.hold_notification_id_seq' );
523         action::hold_notification->table('action.hold_notification');
524
525         #-------------------------------------------------------------------------------
526
527         package action::hold_copy_map;
528
529         action::hold_copy_map->sequence( 'action.hold_copy_map_id_seq' );
530         action::hold_copy_map->table('action.hold_copy_map');
531
532         #-------------------------------------------------------------------------------
533
534         package action::hold_transit_copy;
535
536         action::hold_transit_copy->sequence( 'action.hold_transit_copy_id_seq' );
537         action::hold_transit_copy->table('action.hold_transit_copy');
538
539         #-------------------------------------------------------------------------------
540
541
542 }
543
544 1;