From 65f14d095ffa9b95598974d414e084845c271092 Mon Sep 17 00:00:00 2001
From: Dan Scott <dscott@laurentian.ca>
Date: Sun, 22 Jan 2012 14:29:16 -0500
Subject: [PATCH] Fix sorting by pubdate for records migrated to 2.1
The 'pubdate' attribute is necessary for sorting by publication date to
work correctly. It was not populated in the 2.0-2.1 upgrade script, so
populate it now based on the 'date1' attribute.
Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Michael Peters <mrpeters@library.in.gov>
---
Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql | 6 ++++--
Open-ILS/src/sql/Pg/version-upgrade/2.1.1-2.1.2-upgrade-db.sql | 6 ++++++
2 files changed, 10 insertions(+), 2 deletions(-)
create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/2.1.1-2.1.2-upgrade-db.sql
diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql
index e245c831c0..0d66ddcf77 100644
--- a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql
+++ b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql
@@ -8927,5 +8927,7 @@ UPDATE metabib.record_attr
GROUP BY 1) x
WHERE x.record = metabib.record_attr.id;
-
-
+UPDATE metabib.record_attr
+ SET attrs = attrs || ('pubdate' => (attrs->'date1'))
+ WHERE defined(attrs, 'pubdate') IS FALSE
+ AND defined(attrs, 'date1') IS TRUE;
diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.1.1-2.1.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.1.1-2.1.2-upgrade-db.sql
new file mode 100644
index 0000000000..301edd453c
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/version-upgrade/2.1.1-2.1.2-upgrade-db.sql
@@ -0,0 +1,6 @@
+-- Fix sorting by pubdate by ensuring migrated records
+-- have a pubdate attribute in metabib.record_attr.attrs
+UPDATE metabib.record_attr
+ SET attrs = attrs || ('pubdate' => (attrs->'date1'))
+ WHERE defined(attrs, 'pubdate') IS FALSE
+ AND defined(attrs, 'date1') IS TRUE;
--
2.11.0