LP#1901932: Do not add unused org settings to enhanced dataset. Signed-off-by: Chris Sharp <csharp@georgialibraries.org> Signed-off-by: Jane Sandberg <js7389@princeton.edu> Signed-off-by: Steven Mayo <smayo@georgialibraries.org>
LP#1901932 Enhancing the enhanced concerto dataset - A date carry forward feature that carry's the various date columns forward based upon the difference between today's date and the create_date for asset.call_number in the dataset. Which is the default. This can be skipped with with: psql -v skip_date_carry='1' -f load_all.sql - Expansion of special cases for certain tables: config.metabib_class, config.org_unit_setting_type, config.global_flag. - Dropping these tables from consideration: acq.acq_lineitem_history, acq.acq_purchase_order_history, permission.perm_list Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Chris Sharp <csharp@georgialibraries.org> Adding seq Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Jane Sandberg <js7389@princeton.edu> Signed-off-by: Steven Mayo <smayo@georgialibraries.org>
LP1895699: Add an on_reserve search filter This filter allows users to limit their search to records that are attached to courses at particular libraries, like so: biology on_reserve(5, 10) The filter can also be negated to search for records that are not attached to a course: biology -on_reserve(5) Also includes some additional bib records and courses to facilitate testing. A test using the concerto data set: 1) In the OPAC, run the following search at BR3: type 2) Note that you get 5 results 3) Run this search at BR3: type on_reserve(6) 4) Note that it's down to 2 results 5) Run this search at BR3: type -on_reserve(6) 6) Note that you get 3 results -- the 3 that were included in step 2 but not step 5. Another test using concerto data set: 1) Ensure that your org is opted in to the Course Materials module, and that you don't have an old value of that library setting cached. 2) Use the advanced search screen to search for `graphic` at BR3 3) Check that the "Limit to course materials" checkbox works as expected. Signed-off-by: Jane Sandberg <sandbergja@gmail.com> Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org>
LP1804066: Don't allow overlapping bookings Note: this includes a change to the concerto test data. You will need to reload the concerto data set before successfully running the included live tests. To test: 1. Go to the Booking > Create Reservation 2. Choose resource by type: find a resource type that only has a single resource for ease of testing. 3. Select a time slot and press Create Reservation 4. Select a patron. 5. In a second tab, repeat the steps, being sure to select the same resource and time slot, but a different patron. 6. Press Confirm Reservation in one of your tabs. 7. Confirm that the reservation was made correctly. 8. Press Confirm Reservation in the second tab. 9. Confirm that the conflicting booking does not go through. Signed-off-by: Jane Sandberg <js7389@princeton.edu> Signed-off-by: Susan Morrison <smorrison@georgialibraries.org> Signed-off-by: Steven Mayo <smayo@georgialibraries.org> Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org>
LP#1901932: (follow-up) update dataset for upcoming 3.11-beta release As it happens, very little actually changed, though a significant chunk of make_concerto_from_evergreen_db.pl's output was not checked it because it consisted purely of differences in timestamp columns due to time zone differences. Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
LP#1901932 Wish List - Enhanced Concerto dataset Tweaks to the build script, hardcoding some sequences that aren't set automatically. Also removed the "admin" user (1) entry from actor.passwd Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
LP#1901932 Wish List - Enhanced Concerto dataset . Adding better ECD output for master branch . Much improved enhanced generator script . Introducing make_release changes to incorporate the upgrade of the ECD. Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
LP#1901932 Wish List - Enhanced Concerto dataset Introducing a new concerto dataset. Loadable via eg_db_config. Including the perl script and full documentation on this dataset How to re-create it, etc. Signed-off-by: blake <blake@mobiusconsortium.org> Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
LP1937294: Fix Sample Data Load Predictability Issue Add "ORDER BY id" to the main queries in the functions used to create call numbers and copies when loading the sample data. This change allows the call numbers and copies to be created in a predictable manner. The necessity of this change was revealed by the failure of the 20-hold-targeter.t Perl live test on PostgreSQL 11+. After this change, that test passes on newer PostgreSQL versions and continues to pass on PostgreSQL 10. Signed-off-by: Jason Stephenson <jason@sigio.com> Signed-off-by: Mike Rylander <mrylander@gmail.com>
Lp 1700818: Add Czech Records Add Czech bibliographic records to sample data. The records were provided courstesy of SPOK. Signed-off-by: Jason Stephenson <jason@sigio.com> Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org> Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu>
LP1849212: add sample data for course materials module Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu> Signed-off-by: Michele Morgan <mmorgan@noblenet.org> Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
RemoteAuth EZProxy CGI authentication This commit adds a RemoteAuth handler (and associated templates, configuration, and sample data) for EZProxy CGI user authentication: https://help.oclc.org/Library_Management/EZproxy/Authenticate_users/EZproxy_authentication_methods/CGI_authentication The user is presented with a login form. If their account is authorized, they will be redirected to EZProxy with a valid authentication ticket, allowing them to access online resources. If they are not authorized, an error message is displayed indicating why the auth attempt failed. The login form and error messages use Template Toolkit (TT2) templates and can be customized. Signed-off-by: Jeff Davis <jeff.davis@bc.libraries.coop> Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu> Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
LP#1863929 - Fix sample survey data. Since we enter the surveys, questions, and answers with specified ID values but don't set the values to one higher, testers were unable to enter survey data. Signed-off-by: Chris Sharp <csharp@georgialibraries.org> Signed-off-by: Bill Erickson <berickxx@gmail.com>
LP#1817645: sample data for testing remote patron auth Signed-off-by: Jeff Davis <jeff.davis@bc.libraries.coop> Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
LP1756564: Add sample data for the booking module This commit adds booking resources and resource types to Evergreen's sample data. Specifically, it includes four resource types: * meeting rooms (bookable by staff at BR1 and BR4) * phone chargers (bookable by staff at BR3, BR4, and BM1) * laptop computers (attached to a MARC record, bookable by staff at BR3) * e-readers (attached to a MARC record, bookable by staff at BR3) Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu> Signed-off-by: Bill Erickson <berickxx@gmail.com> Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Fix billing / negative balance test cases The test cases are set up manually via SQL, but were not taught about the new data needed for billings. This caused two tests to fail. Let's go ahead and update this whole block to have more realistic data conforming to the new scheme. Signed-off-by: Dan Wells <dbw2@calvin.edu>