[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