Many-To-Many Relationship not working across databases

posted 11 years ago

I'm trying to integrate a new Laravel app with an legacy application. That's why I'm in need to use two databases/connections.

Specified my default connection in app/config/database

'default' => 'connection-one',

A normal one-to-one relation across two databases is working as expected.

But when I'm trying to use a many-to-many relationship Laravel is using the wrong database.

models/Member.php

class Member extends Eloquent
{
	protected $connection = 'connection-two';
	protected $primaryKey = 'id_member';
	protected $table = 'legacy_members_table';
	
	public function topics()
	{
		return $this-->belongsToMany('Topic');
	}
}

models/Topic.php

class Topic extends Eloquent
{
	protected $primaryKey = 'token';
	
	public function members()
	{
		return $this->belongsToMany('Member');
	}	
}

Laravel is searching for the correct pivot table member_topic but does this in the old databse with connection-two and not in the new database with connection-one

Is there a way to achieve this ?

The only solution currently on my mind is to use a view in the 'new' database that will use/mimic the data from the table in the old database.

Last updated 3 years ago.

thevelement

replied 11 years ago

Using 'legacy_db' as an example of the actual name for your old database, would this work?

class Topic extends Eloquent
{
    protected $primaryKey = 'token';

    public function members()
    {
        $relation = $this->belongsToMany('Member');
        $relation->table = 'legacy_db.legacy_members_table';
        return $relation;
    }   
}

Last updated 3 years ago.

diego1araujo

replied 11 years ago

Take a look at this to clarify http://fideloper.com/laravel-multiple-database-connections

Last updated 3 years ago.

pixelpeter

replied 11 years ago

Solution

OK, I figured it out (after some sleep). Thanks @thevelement to point me into the right direction.

Simply specify [database].[table_name] as the second argument of the relation

class Topic extends Eloquent
{
    protected $primaryKey = 'token';

    public function members()
    {
        retrun $this->belongsToMany('Member','legacy_db.legacy_members_table');
    }   
}

Last updated 3 years ago.