[Dbix-class] Cross-schema relationships.

[Rob Kinyon]

If you're talking about different physical DB instances and there's no
feature in the DBMS to manage those cross-connections for you, then
you have to do it by hand.

Suggestions for API improvements welcome.

Rob

On Mon, Feb 1, 2010 at 12:38, Oleg Pronin <syber.rus at gmail.com> wrote:
> 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
>>
>
> _______________________________________________
> 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
>



-- 
Thanks,
Rob Kinyon