Validating composite unique key using WithValidation

[Magiczne]

I have a table like this:

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

    $table->string('col_1');
    $table->string('col_2');
    
    $table->unique([ 'col_1', 'col_2' ]);
});

When i need to validate unique key in laravel i can do it like so in the request:

class TableRequest extends FormRequest
{
    public function rules(): array 
    {
        $col2 = $this->post('col_2'); // or $this->col_2, or $this->get('col_2'). It depends, how the request is handled but I can access it and use later.

        return [
            'col_1' => [ 'required', Rule::unique('table', 'col_1')->where(function (Builder $query) use ($col2) {
                return $query->where('col_2', $col2);
            }) ]
        ]
    }
}

But since laravel excel imports data in batches i cannot access the data in the rules method like so:

class TableImport implements ToModel, WithValidation, WithBatchInserts 
{
    // ...

    public function rules(): array
    {
        return [
            'col_1' => [ 'required', Rule::unique('table', 'col_1')->where(function (Builder $query) {
                // TODO: ???
            }) ]
        ]
    }
}

How would you approach something like that? Thanks in advance.

[Magiczne]

@patrickbrouwers is behavior like that even possible, or should I forget about it in the rules method?

[patrickbrouwers]

Try with *.col_2

[Magiczne]

Sorry, but this is not an answer to my question.
I can't do something like that:

return [
    'col_1' => [ 'required', Rule::unique('table', 'col_1')->where(function (Builder $query) use ($col2) {
        return $query->where('col_2', '*.col_2');
    }) ]
]

or

return [
    '*.col_1' => 'required|unique:table,*.col_2',

because the unique key is made up from 2 columns. I need to check unique where other column is different than the current value in the row. Your answer does nothing for my case.

I need to access the col_2 value inside the validator. That's all what I'm asking. Is it possible?

[patrickbrouwers]

Sorry, I'm not sure then, I've never used it in that way. Perhaps someone else knows

[neoacevedo]

Running the validation return [ '*.col_1' => 'required|unique:table,*.col_2', raises a not found column.