[Bug 5837] New: Change installer to use DBIx::Class::Schema::Versioned instead of updatedatabase.pl
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Bug #: 5837 Summary: Change installer to use DBIx::Class::Schema::Versioned instead of updatedatabase.pl Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_4 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Architecture, internals, and plumbing AssignedTo: gmcharlt@gmail.com ReportedBy: chris@bigballofwax.co.nz QAContact: koha-bugs@lists.koha-community.org In order to move us one step closer to database independence we should move to using a db independent schema. DBIx::Class::Schema gives us this. If we use DBIx::Class::Schema::Versioned we can do away with both kohastructure.sql and updatedatabase.pl -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 --- Comment #1 from Chris Cormack <chris@bigballofwax.co.nz> 2011-03-07 04:07:52 UTC --- http://git.koha-community.org/gitweb/?p=wip/koha-catalyst.git;a=shortlog;h=r... -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyle.m.hall@gmail.com --- Comment #2 from Kyle M Hall <kyle.m.hall@gmail.com> --- What's the status on this? I'd love to see this in Koha proper. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|rel_3_4 |master Assignee|gmcharlt@gmail.com |chris@bigballofwax.co.nz -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 --- Comment #3 from Kyle M Hall <kyle.m.hall@gmail.com> --- DBIx::Class::DeploymentHandler would be another alternative to Versioned. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 --- Comment #4 from Chris Cormack <chris@bigballofwax.co.nz> --- (In reply to comment #3)
DBIx::Class::DeploymentHandler would be another alternative to Versioned.
Not without Moose it wouldn't. Versioned is a much more lightweight tool, and doesn't depend on installing every perl module in the entire world, which Moose seems to want to do. :) Short version this is stalled, I had a schema built, that I deployed to both postgres and mysql successfully. The code remains in a git branch, but then I crazily volunteered to be RM, and now RMaint .. and so haven't any time to devote to it. https://gitorious.org/koha/mainline/trees/dbix_class/lib/Koha/Schema I think working on this instead of poking at ` would be a much better use of someone's time :) -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Elliott Davis <elliott@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |8798 -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Bug 5837 depends on bug 8798, which changed state. Bug 8798 Summary: Add the use of DBIx::Class http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8798 What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |RESOLVED Resolution|--- |DUPLICATE -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Bug 5837 depends on bug 8798, which changed state. Bug 8798 Summary: Add the use of DBIx::Class http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8798 What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|DUPLICATE |--- -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #5 from David Cook <dcook@prosentient.com.au> --- (In reply to Chris Cormack from comment #4)
(In reply to comment #3)
DBIx::Class::DeploymentHandler would be another alternative to Versioned.
Not without Moose it wouldn't. Versioned is a much more lightweight tool, and doesn't depend on installing every perl module in the entire world, which Moose seems to want to do. :)
Short version this is stalled, I had a schema built, that I deployed to both postgres and mysql successfully. The code remains in a git branch, but then I crazily volunteered to be RM, and now RMaint .. and so haven't any time to devote to it.
https://gitorious.org/koha/mainline/trees/dbix_class/lib/Koha/Schema
I think working on this instead of poking at ` would be a much better use of someone's time :)
I wouldn't say I'm working on this, but when I have free time here and there, I've been finding and solving the problems that stand in the way of using DBIx::Class for deploying and upgrading our DB schema. I have a few minor details to work on in terms of getting the schema to deploy the way we have it currently, but the biggest obstacle I'm facing is DBIx::Class::Schema::Loader. I think some changes might have to be done by hand to the DBIC Result classes themselves. I'm going to investigate that further though. In any case... I also think DBIx::Class::DeploymentHandler is probably too heavy, but I'm not 100% sure that DBIx::Class::Schema::Versioned will provide all we need either. Since it's just a module, we'll need an update script of some kind anyway. We'll also need a way of inserting data (for system preference, for example) and not just doing schema structure changes which DCSV is meant for. Anyway, yep, it's certainly on my mind... poking a lot at this on http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390 -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=11390 -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 Olli-Antti Kivilahti <olli-antti.kivilahti@jns.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |olli-antti.kivilahti@jns.fi --- Comment #6 from Olli-Antti Kivilahti <olli-antti.kivilahti@jns.fi> --- Hi there! Can you share the code you have been working on here as commits? I am not asking for anything "git bz apply":able, just something to read your thoughts from. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5837 --- Comment #7 from David Cook <dcook@prosentient.com.au> --- (In reply to Olli-Antti Kivilahti from comment #6)
Hi there! Can you share the code you have been working on here as commits? I am not asking for anything "git bz apply":able, just something to read your thoughts from.
I don't have any code for this, but I'll post something to bug 11390 in a minute. -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org