[Koha-bugs] [Bug 11390] DBIx::Class schema deployment script

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390

--- Comment #4 from David Cook <dcook at prosentient.com.au> ---
(In reply to David Cook from comment #3)
> I did think about this... deploying a DBIC schema to a database and doing a
> MySQL dump to get the structure of the deployed database.
> 
> Probably also do a MySQL dump of a database populated using
> kohastructure.sql.
> 
> Then those two dumps can be compared using regular diff tools or
> SQL::Translator::Diff.
> 
> At the very least, it would be nice to start using Koha::Database::deploy()
> rather than kohastructure.sql...

To that end, how might we factor in data that we want to import into the
database?

We could additionally run our other SQL as we currently do (for system
preferences and the like), although then I wonder what we'll do for upgrades
when we're not using upgradedatabase.pl.

I suppose we could either manually add to the SQL diffs (release managers
responsibility) or have versioned upgrade scripts or...

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