Exception : Call to undefined method Illuminate\Database\Eloquent\Relations\BelongsTo::getOwnerKey()

[waleedfaridworkland]

• Laravel-mongodb Version: 5.4.1
• PHP Version: 8.2
• Database Driver & Version: 2.0.0

Description:

We have a micro services architecture and we work with multiple databases within MySQL.

In our laravel-lumen application version 10, when we specify different mysql models using different database names through the connection property, while using HybridRelations, we get the error

Call to undefined method Illuminate\Database\Eloquent\Relations\BelongsToMany::getOwnerKeyName()

1. Model A uses hybrid relations and its table resides in mysql database 1

• It has a many to many relationship with Model B.
• It also has a one to one relationship with Model C.
• It has property protected $connection = database_1

2. Model B does not use hybrid relations and its table resides in mysql database 2

• It has a many to many relationship with Model A.
• It has property protected $connection = database_2

3. Model C has a collection that resides in MongoDB.

Expected behaviour

When querying Model A like so :

$candidateUserIds = A::whereHas('B', function ($query) use ($b_ids) {
$query->whereIn('b_table.id', $b_ids);
})->get();

It should return results, respecting the condition on its relationship.

Actual behaviour

Get the error :
Call to undefined method Illuminate\Database\Eloquent\Relations\BelongsToMany::getOwnerKeyName()

This is because of this function here :
mongodb > laravel-mongodb > src > Helpers > trait QueriesRelationships

public function has($relation, $operator = '>=', $count = 1, $boolean = 'and', ?Closure $callback = null)

In particular line 56 

    if (Model::isDocumentModel($this->getModel()) || $this->isAcrossConnections($relation)) {
        return $this->addHybridHas($relation, $operator, $count, $boolean, $callback);
    }

The following function returns true.

protected function isAcrossConnections(Relation $relation)
{
    return $relation->getParent()->getConnectionName() !== $relation->getRelated()->getConnectionName();
}

In my case both model A and model B are in mysql, but because they have different connection names, they are considered hybrid relationships and laravel thinks that Model B is in MongoDB.

The temporary fix was to remove the connection property from Model B and specify the database name in the property
protected $table = 'database_2.b_table';

Would it be possible to check the driver property of the connections instead ?

[paulinevos]

Hiya @waleedfaridworkland. If I understand correctly, you're saying that the model that imports HybridRelations is applying the hybrid relation to both relationships in that model, while only one of them is stored in MongoDB. Is that right?

Would you be able to provide simplified code snippets of the models so it'll be easier to reproduce? Thanks.

[waleedfaridworkland]

@paulinevos Sure thing.

I think this is pretty close to the actual code that we have.

Mysql and external_db are both MySQL datbases.

For now I fixed the issue by removing the connection property from the Skill class and changing the table property to include the database name something like : protected $table = env('DB_EXTERNAL_DATABASE') . '.skills';

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use MongoDB\Laravel\Eloquent\HybridRelations;

class JobApplication extends Model
{
    use HybridRelations;

    public function candidate()
    {
        return $this->hasOne('App\Models\Candidate', 'job_application_id');
    }

    public function skills()
    {
        return $this->belongsToMany(
            'App\Models\Skill',
            'job_application_skill',
            'job_application_id',
            'skill_id'
        )->withTimestamps()->using('App\Models\JobApplicationSkill');
    }
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Skill extends Model
{
    protected $connection = 'external_db';
    protected $table = 'skills';

    public function jobApplications()
    {
        return $this->belongsToMany(
            'App\Models\JobApplication',
            'job_application_skill',
            'skill_id',
            'job_application_id'
        )->withTimestamps()->using('App\Models\JobApplicationSkill');
    }
}

<?php

namespace App\Models;

use MongoDB\Laravel\Eloquent\Model as Eloquent;

class Candidate extends Eloquent
{
    protected $connection = 'mongodb';
    protected $table = 'candidates';
}

database.php

<?php

return [
    'default' => env('DB_DEFAULT', 'mysql'),

    'connections' => [
        'mysql' => [
            'driver' => env('DB_DRIVER'),
            'host' => env('DB_HOST'),
            'port' => env('DB_PORT'),
            'database' => env('DB_DATABASE'),
            'username' => env('DB_USERNAME'),
            'password' => env('DB_PASSWORD')
        ],
        'mongodb' => [
            'driver' => 'mongodb',
            'dsn' => env('MONGODB_PREFIX') . env('MONGODB_USERNAME') . ':' . env('MONGODB_PASSWORD') . '@' . env('MONGODB_HOST'),
            'port' => env('MONGODB_PORT', 27017),
            'database' => env('MONGODB_DATABASE'),
            'username' => env('MONGODB_USERNAME'),
            'password' => env('MONGODB_PASSWORD'),
            'charset' => env('MONGODB_CHARSET', 'utf8'),
        ],
        'external_db' => [
            'driver' => env('DB_DRIVER'),
            'host' => env('DB_HOST'),
            'port' => env('DB_PORT'),
            'database' => env('DB_EXTERNAL_DATABASE'),
            'username' => env('DB_USERNAME'),
            'password' => env('DB_PASSWORD')
        ],
    ],

    'migrations' => 'migrations',
];

In the controller :

        $candidateUserIds = JobApplication::whereHas('skills', function ($query) use ($skillIds) {
            $query->whereIn('skills.id', $skillIds)
        })->distinct()->pluck('candidate_id');