[Dbix-class] Cross-schema relationships.

Oleg Pronin syber.rus at gmail.com
Mon Feb 1 17:38:18 GMT 2010


I can do this by my own by writing in Schema::Message for example

sub user {
    my $self = shift;
    MyApp->schema2->resultset('User')->search({id =>
$self->get_column('user')});
}

All i meant is that dbic could do this for me theoretically.

2010/2/1 Rob Kinyon <rob.kinyon at gmail.com>:
> On Mon, Feb 1, 2010 at 11:52, Oleg Pronin <syber.rus at gmail.com> wrote:
>> Hi everyone.
>>
>> I'm separating a part of database tables to second database server.
>> Therefore i created second schema and put a part of result sources in
>> there.
>>
>> I discovered that cross-schema relationships doesn't work: i get error
>> DBIx::Class::ResultSource::related_source(): Can't find source for
>> MyApp::Schema::SomeRS at ...
>> when i try to get related source from Schema2 to Schema
>>
>> Is there an easy way to workaround on it ? i understand that table
>> joins are not possible anymore, but in theory DBIC could continue to
>> support relationships without joins.
>> $obj->many_to_many_accessor->search(...), etc
>
> How would you write the SQL to do this? Also, what RDBMS are you on?
> Is it Oracle?
>
> Rob
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>



More information about the DBIx-Class mailing list