From ea11bba1133acfafbea30d3eeb98dab7ebb7532f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 17 Aug 2017 15:33:20 -0400 Subject: [PATCH] LP#1699554 Create sample users with migrated passwords WIP Signed-off-by: Bill Erickson --- Open-ILS/tests/datasets/sql/env_create.sql | 14 ++++++++++++++ Open-ILS/tests/datasets/sql/env_destroy.sql | 2 ++ Open-ILS/tests/datasets/sql/users_patrons_100.sql | 4 +++- 3 files changed, 19 insertions(+), 1 deletion(-) diff --git a/Open-ILS/tests/datasets/sql/env_create.sql b/Open-ILS/tests/datasets/sql/env_create.sql index 07dae6d9ec..01e6d33b0a 100644 --- a/Open-ILS/tests/datasets/sql/env_create.sql +++ b/Open-ILS/tests/datasets/sql/env_create.sql @@ -225,5 +225,19 @@ END; $$ LANGUAGE PLPGSQL; +CREATE FUNCTION evergreen.create_password(username TEXT, password TEXT) + RETURNS void AS $$ +DECLARE + pw_salt TEXT; +BEGIN + pw_salt := actor.create_salt('main'); + PERFORM actor.set_passwd( + (SELECT id FROM actor.usr WHERE usrname = username), + 'main', + MD5(pw_salt || MD5(password)), + pw_salt + ); +END; +$$ LANGUAGE PLPGSQL; diff --git a/Open-ILS/tests/datasets/sql/env_destroy.sql b/Open-ILS/tests/datasets/sql/env_destroy.sql index 9f69865f87..9a5a96e1af 100644 --- a/Open-ILS/tests/datasets/sql/env_destroy.sql +++ b/Open-ILS/tests/datasets/sql/env_destroy.sql @@ -13,3 +13,5 @@ DROP FUNCTION evergreen.populate_circ DROP FUNCTION evergreen.populate_hold (TEXT, BIGINT, INTEGER, INTEGER, INTEGER, BOOLEAN, TIMESTAMP WITH TIME ZONE, TEXT); +DROP FUNCTION evergreen.create_password(TEXT, TEXT); + diff --git a/Open-ILS/tests/datasets/sql/users_patrons_100.sql b/Open-ILS/tests/datasets/sql/users_patrons_100.sql index 5923e87f98..e9a990e4f3 100644 --- a/Open-ILS/tests/datasets/sql/users_patrons_100.sql +++ b/Open-ILS/tests/datasets/sql/users_patrons_100.sql @@ -2,9 +2,11 @@ -- expired patron INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) - VALUES (2, 3, '99999395390', 9, 'Brooks', 'terrib1234', + VALUES (2, 3, '99999395390', 9, 'Brooks', '', 'Terri', 'Maria', '2008-01-01', NULL, NULL); +SELECT evergreen.create_password('99999395390', 'terrib1234'); + INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) VALUES ('USA', 'f', '32961', '1809 Target Way', 't', -- 2.11.0