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:28:46 +0000 (00:28 -0500)
commitf18b1f34c0187582cdb493aa19beddf94c62692d
tree7aabcc8a7fcff0fe5106c12d407990535adb54c5
parent4cd217ac7fafcbf69706f4b25903d27964c565d6
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