Suggestion: Laravel validation sugar syntax for unique + ignore this + ignore case

[robsontenorio]

Yes, I know I can create a custom RULE.

A good addition to the framework would be introduce a sugar syntax validation for this scenario:

1. Unique value
2. Ignoring the record itself
3. Case INSENSITIVE

Today we can do this ...

But it misses the ability to ignore the record itself and ignore the string case. Some database are string case sensitive. So, "Joe" is different from "JOE"

    'name' => ['required', 'unique:users']

Maybe something like this?

   'name'  => ['required', 'unique:users', 'ignore_this', 'ignore_case']

[shaedrich]

You don't need to add a custom rule to make the rule case insensitive, you can just expand Rule::unique()

framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php

Lines 987 to 1032 in 6a08dbd

	/**
	* Validate the uniqueness of an attribute value on a given database table.
	*
	* If a database column is not specified, the attribute will be used.
	*
	* @param string $attribute
	* @param mixed $value
	* @param array<int, int|string> $parameters
	* @return bool
	*/
	public function validateUnique($attribute, $value, $parameters)
	{
	$this->requireParameterCount(1, $parameters, 'unique');
	[$connection, $table, $idColumn] = $this->parseTable($parameters[0]);
	// The second parameter position holds the name of the column that needs to
	// be verified as unique. If this parameter isn't specified we will just
	// assume that this column to be verified shares the attribute's name.
	$column = $this->getQueryColumn($parameters, $attribute);
	$id = null;
	if (isset($parameters[2])) {
	[$idColumn, $id] = $this->getUniqueIds($idColumn, $parameters);
	if (! is_null($id)) {
	$id = stripslashes($id);
	}
	}
	// The presence verifier is responsible for counting rows within this store
	// mechanism which might be a relational database or any other permanent
	// data store like Redis, etc. We will use it to determine uniqueness.
	$verifier = $this->getPresenceVerifier($connection);
	$extra = $this->getUniqueExtra($parameters);
	if ($this->currentRule instanceof Unique) {
	$extra = array_merge($extra, $this->currentRule->queryCallbacks());
	}
	return $verifier->getCount(
	$table, $column, $value, $id, $idColumn, $extra
	) == 0;
	}

This then could be defined as

'name'  => ['required', 'unique:users,name,ignore_case']
// or
'name'  => ['required', Rule::unique('users', 'name')->ignoreCase()]

Ignoring the record itself is already possible:

framework/src/Illuminate/Validation/Rules/Unique.php

Lines 27 to 44 in 6a08dbd

	/**
	* Ignore the given ID during the unique check.
	*
	* @param mixed $id
	* @param string|null $idColumn
	* @return $this
	*/
	public function ignore($id, $idColumn = null)
	{
	if ($id instanceof Model) {
	return $this->ignoreModel($id, $idColumn);
	}
	$this->ignore = $id;
	$this->idColumn = $idColumn ?? 'id';
	return $this;
	}

'name'  => ['required', Rule::unique('users', 'name')->ignore($this->name, 'name')]

[robsontenorio]

Yeah... I know a could use the Rule::unique(), but I am using Livewire and it does not support that syntax when using attributes.

// I can't put Rule::unique(...)->ignore(...) here

#[Rule('required|unique:users')] 
public string $name = ''

[shaedrich]

You don't have to, as outlined in my reply.

[robsontenorio]

@shaedrich It does not work, I have tried.

['required', 'unique:users,name,ignore_case']

I can't see where in the outlined code the unique rule could be combined with ignore_case.

The ignore_case works only for this situation, not for unique
https://laravel.com/docs/12.x/validation#rule-distinct

May be this only works for MySQL that is case INSENSITIVE. Other databases like SQLITE and PGSQL are not.

['required', 'unique:users,name']

But, this discussion here is more like a suggestion for future addition to the framework.

[shaedrich]

As I said: You would have to implement it