复合唯一密钥验证 laravel

发布于08月24日

seems it's not possible with built-in validators, how I should implement this feature in the model?

 $rules = [

            'user_id' => 'required|unique:service_details,user_id',
            'service_id'=>'required|unique:service_details,service_id'
         ];

以上将防止user_id和service_id的独立复制，这不是我的要求

it will reject

(1,2)
(1,3)

因为%1重复，但它应该被接受，因为我想要复合唯一密钥

推荐答案

Composite unique field validation is provided out-of-the-box in 5.0+. I can't speak for earlier versions.

实际上，您可以为应用唯一验证规则时指定WHERE子句.例如.

'term'  => 'unique:terms,term,NULL,id,taxonomy,category'

这条规则规定，在terms表中，term应该是唯一的，但只有在taxonomy等于"类别"的情况下.

例如，它将防止"新闻"类别被复制，但我仍然可以拥有"新闻"标签.

I don't know your schema but in your case it'd be something like this:

$user_id = Request::get('user_id', $default);
$service_id = Request::get('service_id', $default);  
// or another way of specifying the accompanying service/user ID for the where clauses

$rules = [
    'user_id' => 'unique:service_details,user_id,NULL,id,service_id,' . $service_id;
    'service_id' => 'unique:service_details,service_id,NULL,id,user_id,' . $user_id;
];