Test data: avoid crazy transactions for expired patrons
authorDan Scott <dscott@laurentian.ca>
Wed, 21 Nov 2012 16:37:06 +0000 (11:37 -0500)
committerDan Scott <dscott@laurentian.ca>
Wed, 23 Jan 2013 05:49:01 +0000 (00:49 -0500)
commit6fc35613fd2fd5dcd9e657dfc8a3d48060644d8f
tree203b9088d225374d1a22c5b0fbacafe1ce61946b
parentfa8fa415c24393f405ea9917363bc150c92377f4
Test data: avoid crazy transactions for expired patrons

Rather than creating brand new circ transactions for patrons who expired
in 1999, make things a little more realistic by filtering out the
patrons to those whose account expired in the past month or later, and
creating xact_start / due_date values based on their account expiry
date if expired, or NOW() if still active.

Oh, and add some patrons who expired over the past month. :)

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/tests/datasets/sql/env_create.sql
Open-ILS/tests/datasets/sql/transactions.sql
Open-ILS/tests/datasets/sql/users_patrons_100.sql