From f34062f3f00d1ab8b0f3339d9e9c24a3e9d43c1b Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 3 May 2023 10:50:04 -0400 Subject: [PATCH] LP#1901932: (follow-up) update dataset for upcoming 3.11-beta release As it happens, very little actually changed, though a significant chunk of make_concerto_from_evergreen_db.pl's output was not checked it because it consisted purely of differences in timestamp columns due to time zone differences. Signed-off-by: Galen Charlton --- .../sql/concerto_enhanced/config.upgrade_log.sql | 48 ++++++++----------- .../datasets/sql/concerto_enhanced/load_all.sql | 5 ++ 2 files changed, 25 insertions(+), 28 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/concerto_enhanced/config.upgrade_log.sql b/Open-ILS/tests/datasets/sql/concerto_enhanced/config.upgrade_log.sql index d3bf497..a107d79 100644 --- a/Open-ILS/tests/datasets/sql/concerto_enhanced/config.upgrade_log.sql +++ b/Open-ILS/tests/datasets/sql/concerto_enhanced/config.upgrade_log.sql @@ -1,31 +1,23 @@ COPY config.upgrade_log (version, install_date, applied_to) FROM stdin; -1326 2023-01-23 09:07:40.702363-06 \N -1327 2023-01-23 09:09:59.440276-06 enhanced_concerto_script -1328 2023-01-23 09:09:59.476631-06 enhanced_concerto_script -1329 2023-01-23 09:09:59.514596-06 enhanced_concerto_script -1330 2023-01-23 09:09:59.563224-06 enhanced_concerto_script -1331 2023-01-23 09:09:59.59903-06 enhanced_concerto_script -1332 2023-01-23 09:09:59.635707-06 enhanced_concerto_script -1333 2023-01-23 09:09:59.671488-06 enhanced_concerto_script -1334 2023-01-23 09:09:59.709196-06 enhanced_concerto_script -1335 2023-01-23 09:09:59.745422-06 enhanced_concerto_script -1336 2023-01-23 09:09:59.78202-06 enhanced_concerto_script -1337 2023-01-23 09:09:59.817761-06 enhanced_concerto_script -1338 2023-01-23 09:09:59.863997-06 enhanced_concerto_script -1339 2023-01-23 09:09:59.901489-06 enhanced_concerto_script -1340 2023-01-23 09:09:59.942334-06 enhanced_concerto_script -1341 2023-01-23 09:09:59.994223-06 enhanced_concerto_script -1342 2023-01-23 09:10:00.034458-06 enhanced_concerto_script -1343 2023-01-23 09:10:00.0756-06 enhanced_concerto_script -1344 2023-01-23 09:10:00.124941-06 enhanced_concerto_script -1345 2023-01-23 09:10:01.853049-06 enhanced_concerto_script -1346 2023-01-23 09:10:01.908584-06 enhanced_concerto_script -1347 2023-01-23 09:10:01.951773-06 enhanced_concerto_script -1348 2023-01-23 09:10:01.990843-06 enhanced_concerto_script -1349 2023-01-23 09:10:02.038836-06 enhanced_concerto_script -1350 2023-01-23 09:10:02.076415-06 enhanced_concerto_script -1351 2023-01-23 09:10:02.115085-06 enhanced_concerto_script -1352 2023-01-23 09:10:02.153571-06 enhanced_concerto_script -1353 2023-01-23 09:10:02.189843-06 enhanced_concerto_script +1353 2023-05-03 10:37:50.65053-04 \N +1354 2023-05-03 10:40:50.838361-04 enhanced_concerto_script +1355 2023-05-03 10:40:50.913929-04 enhanced_concerto_script +1356 2023-05-03 10:40:50.961078-04 enhanced_concerto_script +1357 2023-05-03 10:40:51.010525-04 enhanced_concerto_script +1358 2023-05-03 10:40:51.059122-04 enhanced_concerto_script +1359 2023-05-03 10:40:51.133812-04 enhanced_concerto_script +1360 2023-05-03 10:40:51.192903-04 enhanced_concerto_script +1361 2023-05-03 10:40:51.263991-04 enhanced_concerto_script +1362 2023-05-03 10:40:51.317468-04 enhanced_concerto_script +1363 2023-05-03 10:40:51.385602-04 enhanced_concerto_script +1364 2023-05-03 10:40:51.468124-04 enhanced_concerto_script +1365 2023-05-03 10:40:51.528566-04 enhanced_concerto_script +1366 2023-05-03 10:40:51.584174-04 enhanced_concerto_script +1367 2023-05-03 10:40:51.700166-04 enhanced_concerto_script +1368 2023-05-03 10:40:51.76067-04 enhanced_concerto_script +1369 2023-05-03 10:40:51.818615-04 enhanced_concerto_script +1370 2023-05-03 10:40:51.941558-04 enhanced_concerto_script +1371 2023-05-03 10:40:51.998501-04 enhanced_concerto_script +1372 2023-05-03 10:40:52.05898-04 enhanced_concerto_script \. diff --git a/Open-ILS/tests/datasets/sql/concerto_enhanced/load_all.sql b/Open-ILS/tests/datasets/sql/concerto_enhanced/load_all.sql index a33204f..c320c8b 100644 --- a/Open-ILS/tests/datasets/sql/concerto_enhanced/load_all.sql +++ b/Open-ILS/tests/datasets/sql/concerto_enhanced/load_all.sql @@ -385,10 +385,15 @@ SET CONSTRAINTS ALL DEFERRED; \i vandelay.session_tracker.sql SELECT SETVAL('money.billable_xact_id_seq', (SELECT MAX(id) FROM money.billing)); + SELECT SETVAL('config.remote_account_id_seq', (SELECT MAX(id) FROM config.remote_account)); + SELECT SETVAL('money.payment_id_seq', (SELECT MAX(id) FROM money.payment)); + SELECT SETVAL('asset.copy_id_seq', (SELECT MAX(id) FROM asset.copy)); + SELECT SETVAL('vandelay.queue_id_seq', (SELECT MAX(id) FROM vandelay.queue)); + SELECT SETVAL('vandelay.queued_record_id_seq', (SELECT MAX(id) FROM vandelay.queued_record)); COMMIT; -- 1.7.2.5