[Koha-bugs] [Bug 34064] Compare kohastructure.sql against current database using database audit script

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34064

--- Comment #15 from David Cook <dcook at prosentient.com.au> ---
(In reply to Marcel de Rooy from comment #10)
> (In reply to Jonathan Druart from comment #7)
> > Why not using koha-dump?
> > With misc/maintenance/sync_db_comments.pl you could then compare with
> > kohastructure.sql I think.
> 
> Yes, we are already having code to do this job or similar code that we could
> merge instead of adding more?

(In reply to Marcel de Rooy from comment #11)
> Another example (code that I added :) is Koha/Database/Commenter.
> The associated script helps you to get rid of all changed comment cruft and
> only focus on the real db changes.

I did take a look at Koha::Database::Commenter, but it is specific to comments
and it's not fully parsing the SQL. 

SQL::Translator is a great externally maintained library that makes it easy to
programmatically work with database schemas, and it's already a dependency of
the DBIx::Class deb package.

Koha::Database::Commenter could be replaced with a SQL::Translator based
mechanism.

-- 
You are receiving this mail because:
You are watching all bug changes.