Attachment 146438 Details for Bug 32918 – Bug 32918: ERM authorized values should be in installer/data/mysql/en/mandatory/auth_values.yml

[patch] Bug 32918: ERM authorized values should be in installer/data/mysql/en/mandatory/auth_values.yml

Bug-32918-ERM-authorized-values-should-be-in-insta.patch (text/plain), 11.66 KB, created by Caroline Cyr La Rose on 2023-02-09 16:13:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Caroline Cyr La Rose

Created: 2023-02-09 16:13:59 UTC

Size: 11.66 KB

patch

obsolete

>From 580373e4ca5ba72bd5e65fac0825b0c4adce360b Mon Sep 17 00:00:00 2001
>From: Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com>
>Date: Wed, 8 Feb 2023 17:11:40 -0500
>Subject: [PATCH] Bug 32918: ERM authorized values should be in
> installer/data/mysql/en/mandatory/auth_values.yml
>
>This patch moves the authorized value insertions for ERM categories into
>the language-specific auth_values.yml file.
>
>To test:
>1. Count the number of authorized values in the mandatory categories
>
>select count(*) from authorised_values where category in ('YES_NO', 'PAYMENT_TYPE', 'HSBND_FREQ', 'ERM_AGREEMENT_STATUS', 'ERM_AGREEMENT_CLOSURE_REASON', 'ERM_AGREEMENT_RENEWAL_PRIORITY', 'ERM_USER_ROLES', 'ERM_LICENSE_TYPE', 'ERM_LICENSE_STATUS', 'ERM_AGREEMENT_LICENSE_STATUS', 'ERM_AGREEMENT_LICENSE_LOCATION', 'ERM_PACKAGE_TYPE', 'ERM_PACKAGE_CONTENT_TYPE', 'ERM_TITLE_PUBLICATION_TYPE', 'COUNTRY', 'LANG', 'qualif');
>
>--> There should be 929
>
>2. Delete the authorized values from these categories
>
>delete from authorised_values where category in ('YES_NO', 'PAYMENT_TYPE', 'HSBND_FREQ', 'ERM_AGREEMENT_STATUS', 'ERM_AGREEMENT_CLOSURE_REASON', 'ERM_AGREEMENT_RENEWAL_PRIORITY', 'ERM_USER_ROLES', 'ERM_LICENSE_TYPE', 'ERM_LICENSE_STATUS', 'ERM_AGREEMENT_LICENSE_STATUS', 'ERM_AGREEMENT_LICENSE_LOCATION', 'ERM_PACKAGE_TYPE', 'ERM_PACKAGE_CONTENT_TYPE', 'ERM_TITLE_PUBLICATION_TYPE', 'COUNTRY', 'LANG', 'qualif');
>
>3. Apply patch
>4. Load the mandatory authorized values
>
>./misc/load_yaml.pl --file installer/data/mysql/en/mandatory/auth_values.yml --load
>
>5. Redo step 1
>   --> There should be the same number (929)
>6. Update translations
>
>cd misc/translator
>./translate update xx-XX
>
>7. Search the po/xx-XX-installer.po file for any of the loaded
>   authorized values
>
>   For example,
>
>   grep "Abstract and index" po/xx-XX-installer.po
>
>   --> descriptions should be translatable
>---
> .../data/mysql/en/mandatory/auth_values.yml   | 151 ++++++++++++++++++
> .../data/mysql/mandatory/auth_val_cat.sql     |  53 ------
> 2 files changed, 151 insertions(+), 53 deletions(-)
>
>diff --git a/installer/data/mysql/en/mandatory/auth_values.yml b/installer/data/mysql/en/mandatory/auth_values.yml
>index 9e6e7f7567..b863071ebf 100644
>--- a/installer/data/mysql/en/mandatory/auth_values.yml
>+++ b/installer/data/mysql/en/mandatory/auth_values.yml
>@@ -57,6 +57,157 @@ tables:
>         - category: "HSBND_FREQ"
>           authorised_value: "EW"
>           lib: "Every week"
>+      #ERM
>+        - category: "ERM_AGREEMENT_STATUS"
>+          authorised_value: "active"
>+          lib: "Active"
>+        - category: "ERM_AGREEMENT_STATUS"
>+          authorised_value: "in_negotiation"
>+          lib: "In negotiation"
>+        - category: "ERM_AGREEMENT_STATUS"
>+          authorised_value: "closed"
>+          lib: "Closed"
>+        - category: "ERM_AGREEMENT_CLOSURE_REASON"
>+          authorised_value: "expired"
>+          lib: "Expired"
>+        - category: "ERM_AGREEMENT_CLOSURE_REASON"
>+          authorised_value: "cancelled"
>+          lib: "Cancelled"
>+        - category: "ERM_AGREEMENT_RENEWAL_PRIORITY"
>+          authorised_value: "for_review"
>+          lib: "For review"
>+        - category: "ERM_AGREEMENT_RENEWAL_PRIORITY"
>+          authorised_value: "renew"
>+          lib: "Renew"
>+        - category: "ERM_AGREEMENT_RENEWAL_PRIORITY"
>+          authorised_value: "cancel"
>+          lib: "Cancel"
>+        - category: "ERM_USER_ROLES"
>+          authorised_value: "librarian"
>+          lib: "ERM librarian"
>+        - category: "ERM_USER_ROLES"
>+          authorised_value: "subject_specialist"
>+          lib: "Subject specialist"
>+        - category: "ERM_LICENSE_TYPE"
>+          authorised_value: "local"
>+          lib: "Local"
>+        - category: "ERM_LICENSE_TYPE"
>+          authorised_value: "consortial"
>+          lib: "Consortial"
>+        - category: "ERM_LICENSE_TYPE"
>+          authorised_value: "national"
>+          lib: "National"
>+        - category: "ERM_LICENSE_TYPE"
>+          authorised_value: "alliance"
>+          lib: "Alliance"
>+        - category: "ERM_LICENSE_STATUS"
>+          authorised_value: "in_negotiation"
>+          lib: "In negotiation"
>+        - category: "ERM_LICENSE_STATUS"
>+          authorised_value: "not_yet_active"
>+          lib: "Not yet active"
>+        - category: "ERM_LICENSE_STATUS"
>+          authorised_value: "active"
>+          lib: "Active"
>+        - category: "ERM_LICENSE_STATUS"
>+          authorised_value: "rejected"
>+          lib: "Rejected"
>+        - category: "ERM_LICENSE_STATUS"
>+          authorised_value: "expired"
>+          lib: "Expired"
>+        - category: "ERM_AGREEMENT_LICENSE_STATUS"
>+          authorised_value: "controlling"
>+          lib: "Controlling"
>+        - category: "ERM_AGREEMENT_LICENSE_STATUS"
>+          authorised_value: "future"
>+          lib: "Future"
>+        - category: "ERM_AGREEMENT_LICENSE_STATUS"
>+          authorised_value: "history"
>+          lib: "Historic"
>+        - category: "ERM_AGREEMENT_LICENSE_LOCATION"
>+          authorised_value: "filing_cabinet"
>+          lib: "Filing cabinet"
>+        - category: "ERM_AGREEMENT_LICENSE_LOCATION"
>+          authorised_value: "cupboard"
>+          lib: "Cupboard"
>+        - category: "ERM_PACKAGE_TYPE"
>+          authorised_value: "local"
>+          lib: "Local"
>+        - category: "ERM_PACKAGE_TYPE"
>+          authorised_value: "complete"
>+          lib: "Complete"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "AggregatedFullText"
>+          lib: "Aggregated full"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "AbstractAndIndex"
>+          lib: "Abstract and index"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "EBook"
>+          lib: "E-book"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "MixedContent"
>+          lib: "Mixed content"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "EJournal"
>+          lib: "E-journal"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "OnlineReference"
>+          lib: "Online reference"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "Print"
>+          lib: "Print"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "StreamingMedia"
>+          lib: "Streaming media"
>+        - category: "ERM_PACKAGE_CONTENT_TYPE"
>+          authorised_value: "Unknown"
>+          lib: "Unknown"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "journal"
>+          lib: "Journal"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "newsletter"
>+          lib: "Newsletter"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "report"
>+          lib: "Report"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "proceedings"
>+          lib: "Proceedings"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "website"
>+          lib: "Website"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "newspaper"
>+          lib: "Newspaper"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "unspecified"
>+          lib: "Unspecified"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "book"
>+          lib: "Book"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "ebook"
>+          lib: "E-book"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "bookseries"
>+          lib: "Bookseries"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "database"
>+          lib: "Database"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "thesisdissertation"
>+          lib: "Thesis/Dissertation"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "streamingaudio"
>+          lib: "Streaming audio"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "streamingvideo"
>+          lib: "Streaming video"
>+        - category: "ERM_TITLE_PUBLICATION_TYPE"
>+          authorised_value: "audiobook"
>+          lib: "AudioBook"
> 
>   # Country codes
>   - authorised_values:
>diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql
>index 4162f94f13..fc11f7ac9a 100644
>--- a/installer/data/mysql/mandatory/auth_val_cat.sql
>+++ b/installer/data/mysql/mandatory/auth_val_cat.sql
>@@ -87,56 +87,3 @@ VALUES
>     ('ERM_PACKAGE_TYPE', 1),
>     ('ERM_PACKAGE_CONTENT_TYPE', 1),
>     ('ERM_TITLE_PUBLICATION_TYPE', 1);
>-
>-INSERT IGNORE INTO authorised_values (category, authorised_value, lib)
>-VALUES
>-    ('ERM_AGREEMENT_STATUS', 'active', 'Active'),
>-    ('ERM_AGREEMENT_STATUS', 'in_negotiation', 'In negotiation'),
>-    ('ERM_AGREEMENT_STATUS', 'closed', 'Closed'),
>-    ('ERM_AGREEMENT_CLOSURE_REASON', 'expired', 'Expired'),
>-    ('ERM_AGREEMENT_CLOSURE_REASON', 'cancelled', 'Cancelled'),
>-    ('ERM_AGREEMENT_RENEWAL_PRIORITY', 'for_review', 'For review'),
>-    ('ERM_AGREEMENT_RENEWAL_PRIORITY', 'renew', 'Renew'),
>-    ('ERM_AGREEMENT_RENEWAL_PRIORITY', 'cancel', 'Cancel'),
>-    ('ERM_USER_ROLES', 'librarian', 'ERM librarian'),
>-    ('ERM_USER_ROLES', 'subject_specialist', 'Subject specialist'),
>-    ('ERM_LICENSE_TYPE', 'local', 'Local'),
>-    ('ERM_LICENSE_TYPE', 'consortial', 'Consortial'),
>-    ('ERM_LICENSE_TYPE', 'national', 'National'),
>-    ('ERM_LICENSE_TYPE', 'alliance', 'Alliance'),
>-    ('ERM_LICENSE_STATUS', 'in_negotiation', 'In negotiation'),
>-    ('ERM_LICENSE_STATUS', 'not_yet_active', 'Not yet active'),
>-    ('ERM_LICENSE_STATUS', 'active', 'Active'),
>-    ('ERM_LICENSE_STATUS', 'rejected', 'Rejected'),
>-    ('ERM_LICENSE_STATUS', 'expired', 'Expired'),
>-    ('ERM_AGREEMENT_LICENSE_STATUS', 'controlling', 'Controlling'),
>-    ('ERM_AGREEMENT_LICENSE_STATUS', 'future', 'Future'),
>-    ('ERM_AGREEMENT_LICENSE_STATUS', 'history', 'Historic'),
>-    ('ERM_AGREEMENT_LICENSE_LOCATION', 'filing_cabinet', 'Filing cabinet'),
>-    ('ERM_AGREEMENT_LICENSE_LOCATION', 'cupboard', 'Cupboard'),
>-    ('ERM_PACKAGE_TYPE', 'local', 'Local'),
>-    ('ERM_PACKAGE_TYPE', 'complete', 'Complete'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'AggregatedFullText', 'Aggregated full'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'AbstractAndIndex', 'Abstract and index'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'EBook', 'E-book'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'MixedContent', 'Mixed content'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'EJournal', 'E-journal'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'OnlineReference', 'Online reference'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'Print', 'Print'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'StreamingMedia', 'Streaming media'),
>-    ('ERM_PACKAGE_CONTENT_TYPE', 'Unknown', 'Unknown'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'journal', 'Journal'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'newsletter', 'Newsletter'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'report', 'Report'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'proceedings', 'Proceedings'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'website', 'Website'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'newspaper', 'Newspaper'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'unspecified', 'Unspecified'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'book', 'Book'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'ebook', 'E-book'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'bookseries', 'Bookseries'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'database', 'Database'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'thesisdissertation', 'Thesis/Dissertation'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'streamingaudio', 'Streaming audio'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'streamingvideo', 'Streaming video'),
>-    ('ERM_TITLE_PUBLICATION_TYPE', 'audiobook', 'AudioBook');
>-- 
>2.34.1

Actions: View | Diff | Splinter Review

Attachments on bug 32918: 146413 | 146438 | 146983 | 146984 | 147132 | 147133