Test data: avoid crazy transactions for expired patrons collab/berick/concerto-expand-modularize-squash
authorDan Scott <dscott@laurentian.ca>
Wed, 21 Nov 2012 16:37:06 +0000 (11:37 -0500)
committerBill Erickson <berick@esilibrary.com>
Wed, 21 Nov 2012 17:14:54 +0000 (12:14 -0500)
commit9222be56103a1a5688340e4bcf0995b102283abf
tree60300693c6fe1c19402e6ca38974039b567edb34
parent973e43381d0356213737d61a96058aa43eeba424
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