[RDBO] Best way to do multiple calls to database

2007-03-26 Thread James Masters
A fundamental question has occurred to me. In my legacy code, I do a single call to the database and load (for the sake of arg), an entire table into a hash right at the start. e.g. If I have a table of suppliers, I will construct a hash with the first key as the suppliercode and subkeys correspo

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread Peter Karman
Uwe Voelker scribbled on 3/26/07 2:33 PM: > I'm using Cat and RDBO for quite some time now - they both work very > well. Just a few days ago I saw Catalyst::Model::RDBO on CPAN. So there > are more users with this combination. :-) > That was me. I'm a few days away from some more Catalyst/Ros

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread Uwe Voelker
Hello Jeff, > Sadly, I posted an earlier variant of the file. I followed up with the > current version. I'll live with the error for now. I'm sure I'll figure > it out as I learn to use Catalyst and Rose. Catalyst and Rose are two complex modules, not the easiest to start with :-) I suggest usin

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread Jeff Chimene
John Siracusa wrote: > On 3/26/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: > >> make_classes(); >> >> sub make_classes >> { >> use base qw(Rose::DB Rose::DB::Object::Loader); >> > > You do not need to inherit from Rose::DB::Object::Loader. Loader is a > standalone cla

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread John Siracusa
On 3/26/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: > make_classes(); > > sub make_classes > { > use base qw(Rose::DB Rose::DB::Object::Loader); You do not need to inherit from Rose::DB::Object::Loader. Loader is a standalone class that can do work for you. It's not part of

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread Jeff Chimene
John Siracusa wrote: > On 3/26/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: > >> John Siracusa wrote: >> >>> On 3/23/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: >>> How do I eliminate the following error message? $ perl ./fred.pl Subroutine init_db redefined at inspectD

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread John Siracusa
On 3/26/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: > John Siracusa wrote: >> On 3/23/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: >>> How do I eliminate the following error message? >>> $ perl ./fred.pl >>> Subroutine init_db redefined at inspectDB/DB/Object/AutoBase1.pm line 7. >> >> AutoBaseNNN.p

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread Jeff Chimene
John Siracusa wrote: > On 3/23/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: > >> How do I eliminate the following error message? >> $ perl ./fred.pl >> Subroutine init_db redefined at inspectDB/DB/Object/AutoBase1.pm line 7. >> > > AutoBaseNNN.pm classes are the automatically generated RDBO

Re: [RDBO] Paging with Iterators

2007-03-26 Thread John Siracusa
On 3/24/07, Randal L. Schwartz wrote: > > "rose" == rose <[EMAIL PROTECTED]> writes: > rose> I'm using Rose with a fairly large MySQL database and using an > rose> iterator like > > rose> my $itr = Bar->get_bars_iterator(); > rose> while($itr->next()) { > > rose> won't work because by

Re: [RDBO] Duplicate many-to-many map rows

2007-03-26 Thread John Siracusa
On 3/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On Fri, 23 Mar 2007, John Siracusa wrote: >> If you add the same bar twice, it'll add a new mapping each time. >> That's what add_bars() does. > > Given that Rose knows that this is a many-to-many relationship between > foos and bars, isn't

Re: [RDBO] Using the results of make_methods()

2007-03-26 Thread John Siracusa
On 3/23/07, Jeff Chimene <[EMAIL PROTECTED]> wrote: > How do I eliminate the following error message? > $ perl ./fred.pl > Subroutine init_db redefined at inspectDB/DB/Object/AutoBase1.pm line 7. AutoBaseNNN.pm classes are the automatically generated RDBO base classes created by the Loader. How i