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 <[email protected]> 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 <[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] > -- Thanks, Rob Kinyon _______________________________________________ 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]
