Bug 29673

Summary: Allow an English sql localization script
Product: Koha Reporter: Marcel de Rooy <m.de.rooy>
Component: Installation and upgrade (command-line installer)Assignee: Marcel de Rooy <m.de.rooy>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
22.11.00
Circulation function:
Attachments: Bug 29673: Allow English sql localization script
Bug 29673: Allow English sql localization script

Description Marcel de Rooy 2021-12-09 15:06:53 UTC
There is no default English sql localization obviously. But why shouldnt we allow it when someone adds a custom script there to do things that are done too for the other languages like de-DE etc. ?

Tiny adjustment
Comment 1 Marcel de Rooy 2021-12-09 15:41:27 UTC
DBIx::RunSQL is quite stupid on splitting by newlines btw..
Comment 2 Marcel de Rooy 2021-12-10 08:55:47 UTC
Created attachment 128386 [details] [review]
Bug 29673: Allow English sql localization script

Test plan:
You might want to add a simple SQL statement to your English
custom.sql in order to verify the execution.
Run a Koha install (in English).
Check if the data shows your custom sql action.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Comment 3 Marcel de Rooy 2021-12-10 09:14:42 UTC
See bug 13669 comment71 showing that you cannot add functions or procedures in a sql file run by DBIx::RunSQL.
Comment 4 Marcel de Rooy 2022-08-15 12:53:48 UTC
Changes one line, adds two comments. More or less a no-op to allow simple customization. Waiting for 10 months. Still applies.
Moving it to the next queue..
Comment 5 Kyle M Hall (khall) 2022-08-15 17:50:23 UTC
Created attachment 139164 [details] [review]
Bug 29673: Allow English sql localization script

Test plan:
You might want to add a simple SQL statement to your English
custom.sql in order to verify the execution.
Run a Koha install (in English).
Check if the data shows your custom sql action.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Comment 6 Tomás Cohen Arazi (tcohen) 2022-08-16 13:25:27 UTC
Pushed to master for 22.11.

Nice work everyone, thanks!