Mailing List Archive: Using C::DBI::Loader::Relationship with Model::CDBI?

Using C::DBI::Loader::Relationship with Model::CDBI?

Apr 5, 2005, 10:55 PM

Post #1 of 5 (3045 views)

Since I'm not able to automatically setup my table relationships using
Class::DBI::Loader::mysql (I think that requires InnoDB tables), I was
looking to add on the Loader::Relationship module which lets you specify
your relationships using english syntax. In a non-Catalyst app,
I can do something like this:

use Class::DBI::Loader;
use Class::DBI::Loader::Relationship;
my $loader = Class::DBI::Loader->new(
dsn => 'dbi:mysql:test',
namespace => 'MyApp',
);
$loader->relationship( "a user has groups" );

I tried to do something similar in Catalyst, but I can't figure out how
to make the Relationship class load up properly:

package MyApp::Model::CDBI;
use base 'Catalyst::Model::CDBI';

__PACKAGE__->config(
dsn => 'dbi:mysql:test',
additional_classes => [qw/Class::DBI::Loader::Relationship/],
);
__PACKAGE__->loader->relationship( "a user has groups" );

I've also tried __PACKAGE__->relationship( ... ) and use'ing the
Relationship module at the top of the module.

Thanks,
-Andy

Using C::DBI::Loader::Relationship with Model::CDBI? [ In reply to ]

sriatoook.de

Apr 5, 2005, 11:18 PM

Post #2 of 5 (2941 views)

Permalink

Am 05.04.2005 um 22:55 schrieb Andy Grundman:

> Since I'm not able to automatically setup my table relationships using
> Class::DBI::Loader::mysql (I think that requires InnoDB tables), I was
> looking to add on the Loader::Relationship module which lets you
> specify
> your relationships using english syntax. In a non-Catalyst app,
> I can do something like this:
>
> use Class::DBI::Loader;
> use Class::DBI::Loader::Relationship;
> my $loader = Class::DBI::Loader->new(
> dsn => 'dbi:mysql:test',
> namespace => 'MyApp',
> );
> $loader->relationship( "a user has groups" );
>
> I tried to do something similar in Catalyst, but I can't figure out how
> to make the Relationship class load up properly:
>
> package MyApp::Model::CDBI;
> use base 'Catalyst::Model::CDBI';
>
> __PACKAGE__->config(
> dsn => 'dbi:mysql:test',
> additional_classes => [qw/Class::DBI::Loader::Relationship/],
> );
> __PACKAGE__->loader->relationship( "a user has groups" );
>
> I've also tried __PACKAGE__->relationship( ... ) and use'ing the
> Relationship module at the top of the module.
>
> Thanks,
> -Andy

try

use NEXT;

sub new {
my $class = shift;
my $self = $class->NEXT::new(@_);
$self->loader->relationship(...);
return $self;
}

--
sebastian

Using C::DBI::Loader::Relationship with Model::CDBI? [ In reply to ]

mreeceatsacbee.com

Apr 5, 2005, 11:22 PM

Post #3 of 5 (2936 views)

Permalink

You may need to overload the constructor ..

use Class::DBI::Loader::Relationship;

sub new {
my ($self, $c) = @_;
$self = $self->NEXT::new($c);

$self->loader->relationship( "a user has groups" );

return $self;
}

On 4/5/05 12:55 PM, "Andy Grundman" <andy@hybridized.org> wrote:

> Since I'm not able to automatically setup my table relationships using
> Class::DBI::Loader::mysql (I think that requires InnoDB tables), I was
> looking to add on the Loader::Relationship module which lets you specify
> your relationships using english syntax. In a non-Catalyst app,
> I can do something like this:
>
> use Class::DBI::Loader;
> use Class::DBI::Loader::Relationship;
> my $loader = Class::DBI::Loader->new(
> dsn => 'dbi:mysql:test',
> namespace => 'MyApp',
> );
> $loader->relationship( "a user has groups" );
>
> I tried to do something similar in Catalyst, but I can't figure out how
> to make the Relationship class load up properly:
>
> package MyApp::Model::CDBI;
> use base 'Catalyst::Model::CDBI';
>
> __PACKAGE__->config(
> dsn => 'dbi:mysql:test',
> additional_classes => [qw/Class::DBI::Loader::Relationship/],
> );
> __PACKAGE__->loader->relationship( "a user has groups" );
>
> I've also tried __PACKAGE__->relationship( ... ) and use'ing the
> Relationship module at the top of the module.
>
> Thanks,
> -Andy
>
>
>
>
> _______________________________________________
> Catalyst mailing list
> Catalyst@lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst
>

--
michael reece :: web engineer :: mreece@sacbee.com :: (916)321-1249

Using C::DBI::Loader::Relationship with Model::CDBI? [ In reply to ]

andyathybridized.org

Apr 5, 2005, 11:59 PM

Post #4 of 5 (2942 views)

Permalink

Sebastian Riedel wrote:
> try
>
> use NEXT;
>
> sub new {
> my $class = shift;
> my $self = $class->NEXT::new(@_);
> $self->loader->relationship(...);
> return $self;
> }

Nice, this works! But I don't really understand why it does. The
Relationship class just adds a relationship() method to
Class::DBI::Loader::Generic's namespace. I guess the object getting set
in loader() was created before Relationship was added, or something like
that?

FYI I didn't need 'use NEXT;' for whatever reason.

--
Andy Grundman

Using C::DBI::Loader::Relationship with Model::CDBI? [ In reply to ]

sriatoook.de

Apr 6, 2005, 12:07 AM

Post #5 of 5 (2945 views)

Permalink

Am 06.04.2005 um 00:00 schrieb Andy Grundman:

> Sebastian Riedel wrote:
>> try
>> use NEXT;
>> sub new {
>> my $class = shift;
>> my $self = $class->NEXT::new(@_);
>> $self->loader->relationship(...);
>> return $self;
>> }
>
> Nice, this works! But I don't really understand why it does. The
> Relationship class just adds a relationship() method to
> Class::DBI::Loader::Generic's namespace. I guess the object getting
> set in loader() was created before Relationship was added, or
> something like that?

The magic line is "my $self = $class->NEXT::new(@_);", because
loader gets initialized in the new method of our SUPER class...

> FYI I didn't need 'use NEXT;' for whatever reason.

Right, it's already used in Catalyst::Base...

--
sebastian