[Question] Duplicate insertion with custom primary key

[amirasyraf]

Hi,

Lets say I have the following model:

<?php class Order extends Model { use HasFactory; protected $connection = 'mongodb'; protected $primaryKey = 'customKey'; protected $guarded = []; } 

Then,

// First insert $order = Order::create([ 'customKey' => 'key1', 'data' => $data, ]); // Second insert $order = Order::create([ 'customKey' => 'key1', 'data' => $data, ]); 

The second insert is still successful despite it having the same customKey key1 which already exists. I thought with the primary key defined, it would throw an error (or ignore) when inserting a duplicate key? Is this not the case?

I don't think insertOrIgnore is supported either. Any alternative solution to this?

[divine]

Hello,

Have you created correct index within mongodb itself?

Thanks!

[amirasyraf]

I wasn't aware I needed to create the index manually first. But I have tried it just now and I'm still able to insert the duplicate key.

Thank you.

[divine]

This is a database, you should create indexes (or in laravel schemas and import it).

Have you created a unique index or just plain one?

[amirasyraf]

Yep, I did create a unique index:

db.mycollection.createIndex({customKey: 1}, {unique: true}) 

Definitely can still insert duplicate keys.

[divine]

Double check that you've created correctly it.

If you're still able to create duplicate keys then you're doing something wrong with your database.

Not related to this library at all.