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, 21 Nov 2012 17:52:03 +0000 (12:52 -0500)
commit25429d51619641bb12d68e1cd8f4116469aa0e37
tree87e8f5fa44ec0fc5613f7d771d5fcc42ef6726c3
parent8d8372f2fbd8e6c15ec4f4bb19d9deaaaaa18dc4
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