Laravel Nova & Corcel - many-to-many relation #643

NowakAdmin · 2024-02-13T07:43:27Z

NowakAdmin
Feb 13, 2024

I'm not sure if it is corcel or nova issue (or my limited understanding), maybe can someone deep into corcel look at this?

I have a hard time to acquire proper relation betwen fair_lead and product(corcel), nova try to search for pivot table in wordpress database instead of laravel database.

Laravel: 10.43.0
Nova: 4.23.0
PHP: 8.2.13
Corcel: jgrossi/corcel @ v7.0.0

I need to nova to search for pivot in laravel database not in corcel(wordpress) database for fair_lead_product table.
Displaying Products works well in nova, but I can't get relation work as wanted.

I posted details on stack:
https://stackoverflow.com/questions/77986219/laravel-nova-corcel-many-to-many-relation

NowakAdmin · 2024-02-13T12:53:00Z

NowakAdmin
Feb 13, 2024
Author

After few hours of digging I tried to apply solutions from:
https://stackoverflow.com/questions/25142968/belongstomany-relationship-in-laravel-across-multiple-databases
now my code looks like:
FairLead.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class FairLead extends Model
{
    use HasFactory;

    //protected $table = 'mysql.fair_lead';

    public function fair(): BelongsTo
    {
        return $this->belongsTo(Fair::class);
    }

    public function client(): BelongsTo
    {
        return $this->belongsTo(Client::class);
    }

    public function product(): BelongsToMany
    {
        $database = $this->getConnection()->getDatabaseName();

        if (is_file($database)) {
            $connection = app('B')->getConnection()->getName();
            $name = $this->getConnection()->getName();
            \Illuminate\Support\Facades\DB::connection($connection)->statement("ATTACH DATABASE '$database' AS $name");
            $database = $name;
        }
        return $this->belongsToMany(Product::class, "$database.fair_lead_products", 'fair_lead_id', 'product_ID')->using(FairLeadProduct::class)->withPivot('amount');
    }
}

my product.php

<?php

namespace App\Models;

use Corcel\WooCommerce\Model\Product as Corcel;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class Product extends Corcel
{

    protected $connection = 'corcel';

    public function fair_lead(): BelongsToMany
    {
        $database = $this->getConnection()->getDatabaseName();
        if (is_file($database)) {
            $connection = app('B')->getConnection()->getName();
            $name = $this->getConnection()->getName();
            \Illuminate\Support\Facades\DB::connection($connection)->statement("ATTACH DATABASE '$database' AS $name");
            $database = $name;
        }
        return $this->belongsToMany(FairLead::class, "$database.fair_lead_products", 'product_ID', 'fair_lead_id')->using(FairLeadProduct::class)->withPivot('amount');
    }
}

Now it seems well pick databases but WP_DB_PREFIX seems to still apply and even twice, how to null it inside public function ?

 "message": "SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'WP_USER'@'localhost' for table `WP_DB_PREFIX_WP_DB_PREFIX_LARAVEL_DB`.`fair_lead_products` (Connection: corcel, SQL: select * from `WP_DB_PREFIX_posts` where `post_type` = product and not exists (select `product_ID` from `WP_DB_PREFIX_WP_DB_PREFIX_LARAVEL_DB`.`fair_lead_products` where `WP_DB_PREFIX_LARAVEL_DB`.`fair_lead_products`.`fair_lead_id` = 2 and `WP_DB_PREFIX_posts`.`ID` = `WP_DB_PREFIX_LARAVEL_DB`.`fair_lead_products`.`product_ID`) order by `WP_DB_PREFIX_posts`.`ID` desc)",

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Laravel Nova & Corcel - many-to-many relation #643

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Laravel Nova & Corcel - many-to-many relation #643

Uh oh!

NowakAdmin Feb 13, 2024

Replies: 1 comment

Uh oh!

NowakAdmin Feb 13, 2024 Author

NowakAdmin
Feb 13, 2024

NowakAdmin
Feb 13, 2024
Author