Duplicating with unique fields

[jerome2710]

Description

I am getting an error when duplicating an item with a unique value. I found that Statamic has Unique Entry/User/Term Value validation rules which I can set on a field. Hopefully this will make sure a unique value is used while duplicating, but which one should I use for Runway resources?

Environment

Environment
Application Name: ----
Laravel Version: 12.21.0
PHP Version: 8.4.6
Composer Version: 2.8.8
Environment: dev
Debug Mode: ENABLED
URL: ----
Maintenance Mode: OFF
Timezone: UTC
Locale: nl

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: file
Database: mariadb
Logs: stack / single
Mail: smtp
Queue: sync
Session: file

Storage
public/storage: NOT LINKED

Sentry
Enabled: MISSING DSN
Environment: dev
Laravel SDK Version: 4.15.1
PHP SDK Version: 4.14.2
Release: NOT SET
Sample Rate Errors: 100%
Sample Rate Performance Monitoring: NOT SET
Sample Rate Profiling: NOT SET
Send Default PII: DISABLED

Statamic
Addons: 3
Sites: 1
Stache Watcher: Disabled (auto)
Static Caching: Disabled
Version: 5.61.0 PRO

Statamic Addons
ryanmitchell/statamic-translation-manager: 2.2.1
statamic-rad-pack/runway: 8.5.2
statamic/eloquent-driver: 4.30.0

Statamic Eloquent Driver
Asset Containers: file
Assets: eloquent
Blueprints: file
Collection Trees: eloquent
Collections: file
Entries: eloquent
Fieldsets: file
Form Submissions: eloquent
Forms: file
Global Sets: file
Global Variables: file
Navigation Trees: eloquent
Navigations: file
Revisions: eloquent
Sites: file
Taxonomies: file
Terms: file
Tokens: eloquent

[duncanmcclean]

I'm not entirely sure I'm understanding what you mean...

If you want to make sure a field isn't copied when duplicating a model, you can disable the "Duplicate" toggle on the field:

If you want to ensure a field's value is unique across all models, you can use Laravel's unique validation rule.

[jerome2710]

For example, I have an item with a slug, which I have set to be unique in the database. When I use the copy action in cp/runway/my-resource, I get an error message with a constraint error, as the item is duplicated with the same slug.

I don't think I should disable the duplicate option, as the slug is required. I was hoping the slug would be adjusted with like my-item-2 to preserve uniqueness.

As per your suggestion, where should I put the Laravel's unique validation rule? I can only find Unique Entry/User/Term Value validation rules when editing the blueprint on cp/fields/blueprints/runway/my-resource.

[duncanmcclean]

For example, I have an item with a slug, which I have set to be unique in the database. When I use the copy action in cp/runway/my-resource, I get an error message with a constraint error, as the item is duplicated with the same slug.

I don't think I should disable the duplicate option, as the slug is required. I was hoping the slug would be adjusted with like my-item-2 to preserve uniqueness.

Ahh, I understand you now.

Runway doesn't really have a concept of "slugs" in the same way that entries do. You can add a slug field to a blueprint, but it doesn't get treated differently to any other field.

This is why Runway doesn't do the "appending" stuff out-of-the-box. However, you can achieve it yourself pretty easily. Add a listener for Eloquent's replicating event to your model:

public static function booted()
{
    static::replicating(function ($model) {
        $originalSlug = $model->slug;
        $slug = $originalSlug;
        $attempt = 1;

        while (self::query()->where('slug', $slug)->exists()) {
            $slug = $originalSlug.'-'.$attempt++;
        }

        $model->slug = $slug;
    });
}

As per your suggestion, where should I put the Laravel's unique validation rule? I can only find Unique Entry/User/Term Value validation rules when editing the blueprint on cp/fields/blueprints/runway/my-resource.

It won't show in the validation dropdown (because the unique rule doesn't work for entries, terms, users), but you can type it into the input manually and hit enter:

[jerome2710]

This is perfect, thank you so much.

Unfortunately Runway doesn't support uniques natively, but the event listener is fine and I could copy your code 1-on-1.

but you can type it into the input manually and hit enter

Good to know! I thought I always needed to make a choice from the dropdown, but this is perfect.