Added withSkipDuplicates import concern (SpartnerNL#230)

frknakk · web-flow · commit 47b974e9272b · 2024-08-19T11:51:09.000+02:00
diff --git a/3.1/imports/batch-inserts.md b/3.1/imports/batch-inserts.md
@@ -70,3 +70,26 @@ In the example above, if a user already exists with the same email, the row will
 :::warning
 All databases except SQL Server require the `uniqueBy` columns to have a "primary" or "unique" index.
 :::
+
+## Skipping duplicate rows
+
+For skipping duplicate models, you can additionally implement the `WithSkipDuplicates` concern.
+
+```php
+class UsersImport implements ToModel, WithBatchInserts, WithSkipDuplicates
+{
+    public function model(array $row)
+    {
+        return new User([
+            'name' => $row[0],
+        ]);
+    }
+    
+    public function batchSize(): int
+    {
+        return 1000;
+    }
+}
+```
+
+In the example above, if a user already exists with the same primary or unique key, the row will be ignored. Behind the scenes, this feature uses the Laravel `insertOrIgnore` method to insert records while ignoring duplicates, preventing any errors that would normally occur due to duplicate entries.
diff --git a/3.1/imports/model.md b/3.1/imports/model.md
@@ -69,6 +69,18 @@ class UsersImport implements ToModel, WithUpserts, WithUpsertColumns
 
 In this example, if a user already exists, only "name" and "role" columns will be updated.
 
+## Skipping duplicate rows
+
+In case you want to skip duplicate models, you can implement the `WithSkipDuplicates` concern. 
+
+```php
+class UsersImport implements ToModel, WithSkipDuplicates
+{
+    // No additional methods are required for this concern
+}
+```
+
+In the example above, if a user already exists with the same primary or unique key, the row will be ignored. Behind the scenes, this feature uses the Laravel `insertOrIgnore` method to insert records while ignoring duplicates, preventing any errors that would normally occur due to duplicate entries.
 
 ## Skipping rows
 
