[Koha-devel] Synchronizing a Koha database with kohastructure.sql (Bug 34064)

[David Cook]

I thought about using the DBIx::Class files, but that gets messy on a server
with many Koha databases, which all have their own upgrade histories. The
DBIx::Class files also don't include all database information. 

 

I wanted a solution that could analyse and compare for me in a production
environment without needing any cleanup. 

 

David Cook

Senior Software Engineer

Prosentient Systems

Suite 7.03

6a Glen St

Milsons Point NSW 2061

Australia

 

Office: 02 9212 0899

Online: 02 8005 0595

 

From: Marcel de Rooy <M.de.Rooy at rijksmuseum.nl> 
Sent: Tuesday, June 20, 2023 9:08 PM
To: David Cook <dcook at prosentient.com.au>; 'koha-devel'
<koha-devel at lists.koha-community.org>
Cc: 'Tomas Cohen Arazi' <tomascohen at theke.io>; 'Jonathan Druart'
<jonathan.druart at bugs.koha-community.org>
Subject: Re: Synchronizing a Koha database with kohastructure.sql (Bug
34064)

 

We already have misc/devel/update_dbix_class_files.pl.

Copy your Koha/Schema/Result before running. Or run it on a gitified
install.

Compare changes.

  _____  

Van: David Cook <dcook at prosentient.com.au <mailto:dcook at prosentient.com.au>
>
Verzonden: dinsdag 20 juni 2023 06:36
Aan: 'koha-devel' <koha-devel at lists.koha-community.org
<mailto:koha-devel at lists.koha-community.org> >
CC: Marcel de Rooy <M.de.Rooy at rijksmuseum.nl
<mailto:M.de.Rooy at rijksmuseum.nl> >; 'Tomas Cohen Arazi'
<tomascohen at theke.io <mailto:tomascohen at theke.io> >; 'Jonathan Druart'
<jonathan.druart at bugs.koha-community.org
<mailto:jonathan.druart at bugs.koha-community.org> >
Onderwerp: Synchronizing a Koha database with kohastructure.sql (Bug 34064) 

 

Hi all,

 

I think we've all encountered issues with a Koha database being out of sync
with kohastructure.sql, and it's not a fun experience to have. Today, I ran
into items.paidfor columns that have survived long past a 20.11.00 upgrade.
While looking to resolve that across all my instances, I was thinking how
there could be other quirks as well, so I thought it would be nice to have
an audit script:

 

"Bug 34064 - Compare kohastructure.sql against current database using
database audit script"

 

It's not 100% perfect, but it does a very good job of detecting differences
between a live Koha database and kohastructure.sql, and provides suggestions
on how to remedy the database. 

 

It could be further improved, but I'm quite happy with this first draft. I'd
like to be able to run it using koha-foreach to get a sense of how in-sync
my Koha databases are on a server.

 

David Cook

Senior Software Engineer

Prosentient Systems

Suite 7.03

6a Glen St

Milsons Point NSW 2061

Australia

 

Office: 02 9212 0899

Online: 02 8005 0595

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230621/887a27fa/attachment.htm>