In order to speed up the API call where we ask for the number of visible (or total...
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 9 Aug 2010 20:54:35 +0000 (20:54 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 9 Aug 2010 20:54:35 +0000 (20:54 +0000)
commit568bbef57478c8109679303a248af9e9b1750655
tree3132901a7e54cfcf421c3be98d673e73c600333a
parentd08b279098bc2c7580a8fe4429a737a881ac0a11
In order to speed up the API call where we ask for the number of visible (or total, in the staff client), available and "unshadow" (aka total) copies, as well as record transcendance visiblity, we create here 10 stored procedures.  Eight of them implement the record/metarecord, staff/opac, OU/lasso varients, and two more are wrappers simplifying the calling API.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@17143 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/040.schema.asset.sql
Open-ILS/src/sql/Pg/upgrade/0366.schema.copy-visibility-count-as-stored-proc.sql [new file with mode: 0644]