[CDBI] Using One Class to connect to multiple instances and more.

Jeff Pelkey pelkey.jeff at gmail.com
Sat Apr 4 22:38:30 BST 2009

Thanks for the info and links!  I got that to work, but this week and I have
been told I am going to working on a new development project!  So I won't
start on the other project of replacing the legacy system until next fall.

In reading the other threads, I also looked at using DBIx::Class, but like
the ease of using CDBI and it's easier to teach our junior programmers.  One
of the jr programmers has caught on quickly and now she is creating the
basic regular classes and will be creating reports and test scripts on this
project.  I think she was really motivated to learn perl, when she heard
they wanted her to attend a COBOL programming seminar!  LOL!

Thanks for the info and the help! -- Jeff.

On Fri, Mar 20, 2009 at 10:48 PM, Michael G Schwern <schwern at pobox.com>wrote:

> Perrin Harkins wrote:
> > On Fri, Mar 20, 2009 at 6:44 PM, Jeff Pelkey <pelkey.jeff at gmail.com>
> wrote:
> >> My question is this:  What is the best way to create one base to
> >> connect to all the instances and one regular class for each table.
> >> Then I just pass the region_id to the base class and have it connect
> >> to that instance.  Plus access all the tables using a variable that
> >> identifies each stores and connect to each table using that method?
> >
> > There are examples of dynamically switching between schemas on the
> > wiki.  Switching tables on the fly might be harder.  I'm not sure off
> > the top of my head what's being done at compile time.  But check the
> > wiki first and see what the examples there do for you.
> The wiki being here.
> http://wiki.class-dbi.com/wiki/Main_Page
> And the article on multiple databases here:
> http://wiki.class-dbi.com/wiki/Using_multiple_databases
> --
> I have a date with some giant cartoon robots and booze.

Jeff Pelkey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digitalcraftsmen.net/pipermail/classdbi/attachments/20090404/843ef070/attachment.htm 

More information about the ClassDBI mailing list