E
E
EVOSandru62018-08-05 17:41:38
Laravel
EVOSandru6, 2018-08-05 17:41:38

Why can't laravel save via hasMany connection?

Good afternoon, tell me please - why can't I get access to the hasMany connection?
Migrations, Seeders and models are located here:
https://paste.laravel.io/1188864d-3bbe-400b-8e9a-2...
In view of the comment below, I will duplicate it here.
Migrations:

class CreateBrandsTable extends Migration
{
    public function up()
    {
        Schema::create('brands', function (Blueprint $t) {
            $t->increments('id');
            $t->string('name')->index();
            $t->timestamps();
            $t->softDeletes();
        });
    }
 
    public function down()
    {
         Schema::dropIfExists('brands');
    }
}

class CreateEditionsTable extends Migration
{
    public function up()
    {
        Schema::create('editions', function (Blueprint $t) {            
            $t->increments('id');
            $t->integer('brand_id')->index(); 
            $t->foreign('brand_id')->references('id')->on('brands')->onDelete('cascade');
            $t->string('name')->index();
            $t->string('slug')->nullable()->index();
            $t->text('body')->nullable();
            $t->timestamps();
            $t->softDeletes();
        });
    }
 
    public function down()
    {
        Schema::dropIfExists('editions');
    }
}

Models:
<?php
namespace App\Entity\Vehicle;
 
use App\Entity\Behaviors\ImagePublicBehavior;
use App\Entity\brand\BrandComment;
use App\Entity\User;
use Cviebrock\EloquentSluggable\Sluggable;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Notifications\Notifiable;
 
class Brand extends Model
{
    use Notifiable;
    use SoftDeletes;
    use Sluggable;
    use ImagePublicBehavior;
 
    protected $dates = ['created_at','updated_at', 'deleted_at'];
    protected $fillable = ['name', 'slug',];
    
    public function editions()
    {
        return $this->hasMany(Edition::class,  'id', 'brand_id');
    }
}

namespace App\Entity\Vehicle;

use App\Entity\Behaviors\ImagePublicBehavior;
use Cviebrock\EloquentSluggable\Sluggable;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Notifications\Notifiable;
 
class Edition extends Model
{
    use Notifiable;
    use SoftDeletes;
    use Sluggable;
    use ImagePublicBehavior;
 
    protected $table = 'editions'; 
    protected $dates = ['created_at','updated_at', 'deleted_at'];
    protected $visible = ['id', 'name'];
    protected $fillable = ['name', 'brand_id',];
 
    public function sluggable()
    {
        return ['slug' => ['source' => 'name']];
    }
    
    public function brand()
    {
        return $this->belongsTo(Brand::class, 'brand_id', 'id');
    }
}

Controller(!!!problem):
namespace App\Http\Controllers\Admin\Vehicles;
 
use App\Entity\Vehicle\Brand;
use App\Entity\Vehicle\Edition;
use App\Entity\Vehicle\Vehicle;
use App\Http\Controllers\Controller;
use App\Http\Requests\Admin\Vehicle\BrandRequest;
 
class BrandsController extends Controller
{
    public function show(Brand $brand)
    {
         // пробленая зона ахтунг
         $brand->editions()->create(['name' => 'Example-xx']);
 
        // Всегда 0, зотя записи в таблицах есть
        echo $brand->editions()->count();
 
        // так работает
        // Edition::create(['name' => 'xxx', 'brand_id'=>$brand->id]);
 
        return view('brands.admin.show', compact('brand','editions'));
    }
}
?>

When saving, I catch:
Illuminate \ Database \ QueryException (23502)
SQLSTATE[23502]: Not null violation: 7 ОШИБКА: нулевое значение в столбце "id" нарушает ограничение NOT NULL DETAIL: 
Ошибочная строка содержит (null, null, yyy, yyy, null, null, null, null, 1, null, null, 1, 2018-08-05 14:34:02, 2018-08-05 14:34:02, null). (SQL: insert into "editions" ("name", "id", "slug", "updated_at", "created_at") values (yyy, , yyy, 2018-08-05 14:34:02, 2018-08-05 14:34:02) returning "id")

Just in case, also Seeder :
<?php
 
use Illuminate\Database\Seeder;
 
class BrandEditionTableSeeder extends Seeder
{
    public function run()
    {
        DB::insert("INSERT INTO brands (id, name) VALUES (1,'Acura'),(2,'Alfa Romeo'),(3,'Alpina'),(4,'Aro'),(5,'Asia'),(6,'Aston Martin').........");
 
        DB::insert("INSERT INTO editions (id,brand_id,name) VALUES (1,1,'CL'),(2,1,'EL'),(3,1,'Integra'),(4,1,'MDX'),(5,1,'NSX'),(6,1,'RDX'),(7,1,'RL'),(8,1,'RSX'),(9,1,'TL'),(10,1,'TSX'),(11,2,'33'),(12,2,'75'),(13,2,'145'),(14,2,'146'),(15,2,'147'),(16,2,'155'),(17,2,'156'),(18,2,'159'),(19,2,'164'),(20,2,'166'),(21,2,'Alfetta'),(22,2,'Brera'),(23,2,'GT'),(24,2,'GTV'),(25,2,'Giulietta'),(26,2,'Spider'),(27,3,'B11'),(28,3,'B12'),(29,3,'B3'),(30,3,'B6'),(31,3,'B7'),(32,3,'Roadster S'),(33,4,'10'),(34,4,'24'),(35,5,'Rocsta'),(36,6,'DB7'),(37,6,'DB9'),(38,6,'DBS'),(39,6,'V12 Vanquish'),.......");
 
         $statement = "ALTER SEQUENCE brands_id_seq RESTART WITH 115";
         DB::unprepared($statement);
         $statement = "ALTER SEQUENCE editions_id_seq RESTART WITH 1403";
         DB::unprepared($statement);
    }
}

Laravel - 5.6
Postgres - 9.6.9
I would appreciate your help.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question