I thought of 'database' as of 'physical database', i.e. database server. Two
different databases on the same server is one 'physical database'. So i
meant there was no way to do that in case of two different physical
databases.
2007/4/4, Ash Berlin <[EMAIL PROTECTED]>:
Oleg Pronin wrote:
> As far as i know there is not.
> There is no way to execute select with joining two tables in different
> databases so the relationships are useless.
>
>
That depends entierly on your definition of database. If you are talking
about the MySQL definition of database, then yes you can by changing the
table from
->table('foo')
to
->table('db.foo')
So long as they are on the same host and the same user can access both.
If you want to do this at some arbitrary point in time, I thinjk you
have to do something like the following:
$schema->source('Foo')->table('db.foo')
Completely untested mind.
HTH
-ash
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive:
http://www.mail-archive.com/[email protected]/
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
