From 4917035d9ad519cf44f6f96099b4171e17233eae Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Sun, 19 Jul 2020 21:23:06 -0700 Subject: [PATCH] LP1849212: add sample data for course materials module Signed-off-by: Jane Sandberg Signed-off-by: Michele Morgan Signed-off-by: Galen Charlton --- Open-ILS/tests/datasets/sql/course_materials.sql | 12 ++++++++++++ Open-ILS/tests/datasets/sql/load_all.sql | 3 +++ 2 files changed, 15 insertions(+) create mode 100644 Open-ILS/tests/datasets/sql/course_materials.sql diff --git a/Open-ILS/tests/datasets/sql/course_materials.sql b/Open-ILS/tests/datasets/sql/course_materials.sql new file mode 100644 index 0000000000..271802f52b --- /dev/null +++ b/Open-ILS/tests/datasets/sql/course_materials.sql @@ -0,0 +1,12 @@ +-- Create courses +INSERT INTO asset.course_module_course +(name, course_number, owning_lib) VALUES +('History of Indonesia', 'HST243', 1); + + +-- Associate materials with the courses +INSERT INTO asset.course_module_course_materials +(course, record, relationship) VALUES +(1, 200, 'Required'), +(1, 201, 'Optional'); + diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index 128372e202..2388fc3ef4 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -102,6 +102,9 @@ INSERT INTO biblio.record_entry (marc, last_xact_id) -- load remoteauth data \i remoteauth.sql +-- load course materials data +\i course_materials.sql + -- clean up the env \i env_destroy.sql -- 2.43.2