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 <[email protected]>:
> On Mon, Feb 1, 2010 at 11:52, Oleg Pronin <[email protected]> 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/[email protected]
>
_______________________________________________
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/[email protected]
