[Koha-bugs] [Bug 32334] Sync comments in database with schema

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

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

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart+koha at gmail.
                   |                            |com, tomascohen at gmail.com

--- Comment #5 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
A few excerpts from the POD of the new module and script:

===
SYNOPSIS
        perl sync_db_comments.pl [-h] [-v] [-database DB_NAME] [-table
TABLE_NAME] [-dry_run] [-clear|-reset|-renumber]

        Synchronize column comments in database with Koha schema. Allows you
        to clear comments too. Operates additionally on specific tables only.
        And provides a dry run mode that prints sql statements.

        This script may prove helpful to track synchronization issues between
        Koha schema and actual database structure due to inconsistencies in
        database revisions. It reduces the noise from missing column comments
        when running script update_dbix_class_files.pl.

and

        The advantage of keeping in sync is that you can easily track
differences
        between schema and database with the maintenance script
        update_dbix_class_files.pl.

===

Yes, it adds another module. But keeping track of schema issues is imo
important enough. The noise of missing or changed comments can be handled in
various ways. This approach was the most practical one for me in the end.

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