uniquewith-validator compatibility with softDelete about uniquewith-validator HOT 7 CLOSED

uniquewith-validator is intended as a Laravel validation rule for dealing with multi-column UNIQUE definitions in your SQL database. Therefore, the database will raise an error, if you attempt to insert a new record into the table anyways.

If you don't have a UNIQUE index in your database table, there could be a flag on the uniquewith-rule that tells it to ignore the deleted_at field. I will think about that one.

In the mean time, use this as a workaround:

Route::get('users/validate', function()
{
    $rules = array(
        'first_name' => 'required|unique_with:users,last_name,deleted_at',
        'last_name' => 'required',
    );

    $input = array(
        'first_name' => 'Felix',
        'last_name' => 'Kiss',
        'deleted_at' => null,
    );

    $validator = Validator::make($input, $rules);

    // Validation will fail on every user name combination, which exists, but is not 
    // deleted while passing on all user name combination, if there already is an 
    // existing, deleted record with the same combination.
    if($validator->fails())
    {
        var_dump($validator->errors());
        exit();
    }

    return "success!";
});

from uniquewith-validator.

Have you solved it?
I really love your package and want to combine with softDelete.

Thanks.. :)

from uniquewith-validator.

I have almost same problem.
Is it possible to ignore with multiple field?
For example, i activated softDelete. So, when I update i want to ignore id and deleted_at row. How should I do that?

from uniquewith-validator.

I am using Laravel 5 and trying to ignore multiple fields validation using the rule

return [
'permission_id' => 'required',
'role_id' => 'required|unique_with:permission_role,permission_id,'.Input::get('role_id').'=role_id,'.Input::get('permission_id').'=permission_id'
];

however it turns up saying :

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' (SQL: update permission_role set permission_id = 2 where id is null)

There is no mention of id, instead i have used custom_id_column as per document,
for insert case

return [
'permission_id' => 'required',
'role_id' => 'required|unique_with:permission_role,permission_id'
];

works fine, however having trouble with the ignore case for update.

Thanks

from uniquewith-validator.

@dadhiramp

1. the error doesn't look to be referring to the validator but rather the update statement following a successful validation.

2. specifying more than one ignore column is currently not supported (I think Laravel's PresenceVerifier, which is used in the background, doesn't support multiple ignore columns either).

If you are updating a model, you can use the id as the ignore column. Something like:

'role_id' => 'required|unique_with:permission_role, permission_id, ' . $model->id . ' = id',

from uniquewith-validator.

Thanks for the prompt response felixkiss ... yes the error is indeed after the validation, seems like i need to add up extra column for it then.

Regards

👍

from uniquewith-validator.

Thanks to #41 the README now documents how to use this package with soft deletes

from uniquewith-validator.