Bug 9869

Summary: Add object oriented database access system to Koha.
Product: Koha Reporter: Kyle M Hall (khall) <kyle>
Component: Architecture, internals, and plumbingAssignee: Kyle M Hall (khall) <kyle>
Status: CLOSED INVALID QA Contact:
Severity: enhancement    
Priority: P5 - low CC: kyle.m.hall, magnus
Version: 3.14   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8798
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 9869 - Add object oriented database access system to Koha.
Bug 9869 - Add object oriented database access system to Koha.
Bug 9869 - Add object oriented database access system to Koha.

Description Kyle M Hall (khall) 2013-03-20 10:36:19 UTC

    
Comment 1 Kyle M Hall (khall) 2013-03-20 10:36:58 UTC Comment hidden (obsolete)
Comment 2 Kyle M Hall (khall) 2013-03-20 11:30:52 UTC Comment hidden (obsolete)
Comment 3 Jared Camins-Esakov 2013-03-20 11:41:57 UTC
(In reply to comment #2)
> This patch adds the framework necessary to enable object oriented
> database access to Koha via DBIx::SearchBuilder. The advantage to
> SearchBuilder over DBIx::Class is the fact that SearchBuilder does
> not require Moose as a prerequisite.

Neither does DBIx::Class so far as I am aware.
Comment 4 Kyle M Hall (khall) 2013-03-20 12:17:50 UTC
Created attachment 16507 [details] [review]
Bug 9869 - Add object oriented database access system to Koha.

This patch adds the framework necessary to enable object oriented
database access to Koha via DBIx::SearchBuilder. The advantage to
SearchBuilder over DBIx::Class is the fact that SearchBuilder does
not require Moose as a prerequisite.

This patch includes only one table class, AuthorisedValues as a
concept test. Each table can be added as neccessary.

Test Plan:
1) Apply patch
2) Run t/db_dependent/SearchBuilder.t
Comment 5 Kyle M Hall 2013-04-01 12:19:06 UTC
(In reply to comment #3)
> (In reply to comment #2)
> > This patch adds the framework necessary to enable object oriented
> > database access to Koha via DBIx::SearchBuilder. The advantage to
> > SearchBuilder over DBIx::Class is the fact that SearchBuilder does
> > not require Moose as a prerequisite.
> 
> Neither does DBIx::Class so far as I am aware.

You are correct. I was misinformed on that point.
Comment 6 Kyle M Hall 2013-04-01 20:07:58 UTC
Discussion leads me to believe that the use of DBIx::Class will be better long term than using DBIx::SearchBuilder.