factory:App\Album syntax doesn't work. it said 'Integrity Constrain Violation' message.

[sithuaung]

$factory('App\Song', [
    'album_id' => 'factory:App\Album',
    'name' => $faker->sentence
]);

[ddelnano]

What do your database tables look like? Your having some foreign key constraint fail probably

[sithuaung]

Thanks @ddelnano
but I don't think my database is wrong coz I can make it work with normal database seeder. (not with model factory). for example. when I save [ user_id ] to posts table it saves like [ user_id = factory:App\User ]. I'm on Laravel v 5.1.16.

[ddelnano]

Unless you show the tables and migrations we won't be able to tell.

[sithuaung]

hi @ddelnano

I have Goods table & Imports table and others table similar like that.

// Goods Schema ...

        Schema::create('goods', function(Blueprint $table) {
            $table->increments('id');

            $table->integer('import_id')->unsigned();
            $table->foreign('import_id')->references('id')->on('imports');

            $table->integer('car_type_id')->unsigned();
            $table->foreign('car_type_id')->references('id')->on('car_types');

            $table->integer('brand_id')->unsigned();
            $table->foreign('brand_id')->references('id')->on('brands');

            $table->timestamp('model_year');

            $table->string('engine_power');
            $table->string('consignor_name')->nullable();
            $table->decimal('unit_price', 12, 2); // 100,000,000

            $table->integer('permit_type_id')->unsigned();
            $table->foreign('permit_type_id')->references('id')->on('permit_types');

            $table->string('port_of_landing');

            $table->integer('import_method_id')->unsigned();
            $table->foreign('import_method_id')->references('id')->on('import_methods');

            $table->timestamps();
        });

// and Import Table ....

        Schema::create('imports', function(Blueprint $table) {
            $table->increments('id');
            $table->integer('voucher_no');
            $table->timestamp('licence_date');
            $table->decimal('fees', 12, 2); // 100,000,000
            $table->string('licence_no');
            $table->timestamp('last_date_import');
            $table->integer('registration_no');
            $table->integer('hs_code');
            $table->timestamps();
        });

Bty thanks for ur time.

And my full error message is...

  [Illuminate\Database\QueryException]                                                                                              
  SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`account  
  ing`.`goods`, CONSTRAINT `goods_import_id_foreign` FOREIGN KEY (`import_id`) REFERENCES `imports` (`id`)) (SQL: insert into `goo  
  ds` (`import_id`, `car_type_id`, `brand_id`, `model_year`, `engine_power`, `consignor_name`, `unit_price`, `permit_type_id`, `po  
  rt_of_landing`, `import_method_id`, `updated_at`, `created_at`) values (factory:App\Import, factory:App\CarType, factory:App\Bra  
  nd, 2015-09-14 13:37:03, 1032cc, Priscilla Reichert MD, 1316, factory:App\PermitType, Israel, factory:App\ImportMethod, 2015-09-  
  14 13:37:03, 2015-09-14 13:37:03))  

[PDOException]                                                                                                                    
  SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`account  
  ing`.`goods`, CONSTRAINT `goods_import_id_foreign` FOREIGN KEY (`import_id`) REFERENCES `imports` (`id`)) 

And my database seeder file is

$this->call('ImportsTableSeeder');
factory(App\Good::class, 50)->create();

[ddelnano]

Yea so the import_id is not getting set when you are trying to seed the database you need in your factory definition

$factory('Good`, [
// other columns....
     'import_id' => 'factory:Import'
]);

[sithuaung]

Yeah I've test with

'import_id' => 'factory:Import',

// and 

'import_id' => 'factory:App\Import',

both not work.