[Dbix-class] want to confirm on issue in cookbook
Mike.G
hylinux at gmail.com
Sun Nov 9 12:50:43 GMT 2008
Hi, everyone, I think I had asked this problem, but I forgot this.
please remind me. thanks
in cookbook, we have example like this:
package My::Schema::User;
use base qw/DBIx::Class/;
# ->load_components, ->table, ->add_columns, etc.
# Make a new ResultSource based on the User class
my $source =3D __PACKAGE__->result_source_instance();
my $new_source =3D $source->new( $source );
$new_source->source_name( 'UserFriendsComplex' );
# Hand in your query as a scalar reference
# It will be added as a sub-select after FROM,
# so pay attention to the surrounding brackets!
$new_source->name( \<<SQL );
( SELECT u.* FROM user u
INNER JOIN user_friends f ON u.id =3D f.user_id
WHERE f.friend_user_id =3D ?
UNION
SELECT u.* FROM user u
INNER JOIN user_friends f ON u.id =3D f.friend_user_id
WHERE f.user_id =3D ? )
SQL
# Finally, register your new ResultSource with your Schema
I think this is register myself ResultSource,
but I have those question:
1.
my $source =3D __PACKAGE__->result_source_instance();
the method result_source_instance is which class's method?
2. I had take a look the ResultSource method:
I found there are no any method like :
my $new_source =3D $source->new( $source );
so, that document's issue?
thanks
Mike.G
My::Schema->register_source( 'UserFriendsComplex' =3D> $new_source );
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20081109/059=
e1f76/attachment.htm
More information about the DBIx-Class
mailing list