[OPEN-ILS-DEV] A Proposal for Improving Functional DB Upgrades

[Galen Charlton]

Hi,

On Fri, Oct 28, 2016 at 12:17 PM, Dan Wells <dbw2 at calvin.edu> wrote:
> I know it would take a little massaging to get our dependency ducks in a
> row, but it is certainly doable and I think it would be worth it.
>
> What say you all?

I think it's a good idea and worth discussing at the hack-a-way, so
I've taken the liberty of adding it to the agenda.

I think it would be useful to retain some sort of version stamp, but
that can be readily handled via a conditional insert into
config.upgrade_log at the top of the functions script.  I also note
that it will necessarily accumulate 'DROP FUNCTION IF EXISTS'
statements over time, as stored functions either disappear or change
signature, but that doesn't strike me as a big deal.

Regards,

Galen
-- 
Galen Charlton
Infrastructure and Added Services Manager
Equinox Software, Inc. / Open Your Library
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org