[Koha-devel] New 'configurations' table (26129)

[dcook at prosentient.com.au]

Actually, something to build into this would be better data validation. The Global System Preferences are terrible when it comes to this. 

 

David Cook

Systems Librarian

Prosentient Systems

72/330 Wattle St

Ultimo, NSW 2007

Australia

 

Office: 02 9212 0899

Online: 02 8005 0595

 

From: Koha-devel <koha-devel-bounces at lists.koha-community.org> On Behalf Of dcook at prosentient.com.au
Sent: Tuesday, 4 August 2020 9:21 AM
To: 'Tomas Cohen Arazi' <tomascohen at gmail.com>; 'koha-devel' <koha-devel at lists.koha-community.org>
Subject: Re: [Koha-devel] New 'configurations' table (26129)

 

I’m intrigued!

 

Honestly, I was looking at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22343 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22343m>  and I was thinking that it was too bad we didn’t have a more generalizable CRUD setup. Using that “configurations” table could make that a lot easier. 

 

I’m not 100% sure what I thought about the db schema design. It doesn’t seem like there is any way to group configuration rows together, so I’m guessing for anything multi-value (like SMTP servers or Z39.50 servers), you’d be storing some JSON as the value? 

 

David Cook

Systems Librarian

Prosentient Systems

72/330 Wattle St

Ultimo, NSW 2007

Australia

 

Office: 02 9212 0899

Online: 02 8005 0595

 

From: Koha-devel <koha-devel-bounces at lists.koha-community.org <mailto:koha-devel-bounces at lists.koha-community.org> > On Behalf Of Tomas Cohen Arazi
Sent: Tuesday, 4 August 2020 4:00 AM
To: koha-devel <koha-devel at lists.koha-community.org <mailto:koha-devel at lists.koha-community.org> >
Subject: [Koha-devel] New 'configurations' table (26129)

 

TL;DR;

This email is for getting some feedback about a new table I'm proposing to add that implements a pattern I'm seeing more and more often as required: global, and per-library, per-item type and per-category settings. It can be easily extended with new constraints as well.

 

Hi all, I wanted to highlight bug 26129 [1] which proposes to add a new table, for storing configuration entries. It differs from the systempreferences table basically on the ability to set values with per-library, per-item type and per-category basis, as well as default catch-all.

 

It is the result of noticing that the smtp_servers table I was going to add on bug 22343 [2], could be easily generalized and could become useful.

 

If someone is willing to do it, we could migrate systempreferences into this new table, but that definitely deserves more thinking. The SMTP configuration page won't live in the sysprefs page, and so a way to differentiate them could be added.

 

One sample use of this configurations table, could be moving z39.50 servers there.

 

[1] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26129

[2] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22343


 

-- 

Tomás Cohen Arazi

Theke Solutions (http://theke.io <http://theke.io/> )
✆ +54 9351 3513384
GPG: B2F3C15F

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20200804/d9435659/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 484 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20200804/d9435659/attachment-0001.sig>