如何验证Laravel BelongsToMany关联中附加UUID外键的存在性

问题场景 #

当使用Laravel的attach方法附加多对多关联时，传入的数组键为Language模型的UUID，需要验证这些UUID是否真实存在于Language表中：

$user->languages()->attach([
    '9a347a21-b6db-42ae-85a5-24a270946eec' => [ // Language的UUID
        'additional_field' => 2,
        'additional_field2' => '',
    ],
    '9a347a21-e0b8-4475-a262-e63042d1a6f6' => [ // Language的UUID
        'additional_field' => 321,
        'additional_field2' => 'aaa bb c',
    ],
]);

User模型的关联定义如下：

public function languages(): BelongsToMany
{
    return $this->belongsToMany(Language::class)
        ->using(UserLanguage::class)
        ->withPivot(['additional_field', 'additional_field2']);
}

目前已可验证languages、languages.*.additional_field、languages.*.additional_field2字段，但需验证作为数组键的UUID是否存在于Language模型中。

解决方案 #

方法1：提取UUID键并使用exists规则验证 #

直接提取attach数组的键（即UUID），用Laravel内置的exists规则验证：

// 假设要附加的关联数据为$languagesData
$languageUuids = array_keys($languagesData);

$validator = \Illuminate\Support\Facades\Validator::make(
    ['language_ids' => $languageUuids],
    [
        'language_ids' => 'required|array',
        'language_ids.*' => 'uuid|exists:languages,id' // 假设Language表主键为id且是UUID类型
    ]
);

if ($validator->fails()) {
    // 处理验证失败逻辑，比如返回错误信息
    return redirect()->back()->withErrors($validator);
}

// 验证通过后执行关联附加
$user->languages()->attach($languagesData);

方法2：自定义验证规则 #

如果需要更贴合业务的验证逻辑，可以自定义规则直接验证整个attach数组：

1. 生成自定义规则类：

php artisan make:rule ValidLanguageUuids

2. 实现规则的验证逻辑：

namespace App\Rules;

use Illuminate\Contracts\Validation\Rule;
use App\Models\Language;

class ValidLanguageUuids implements Rule
{
    public function passes($attribute, $value)
    {
        if (!is_array($value)) {
            return false;
        }

        $uuids = array_keys($value);
        // 统计数据库中存在的UUID数量，需与传入的UUID数量一致
        $existingCount = Language::whereIn('id', $uuids)->count();

        return count($uuids) === $existingCount;
    }

    public function message()
    {
        return '存在无效的语言UUID，请检查后重试。';
    }
}

3. 使用自定义规则验证：

$validator = \Illuminate\Support\Facades\Validator::make(
    ['languages' => $languagesData],
    [
        'languages' => ['required', 'array', new \App\Rules\ValidLanguageUuids],
        'languages.*.additional_field' => 'required|integer',
        'languages.*.additional_field2' => 'nullable|string'
    ]
);

if ($validator->fails()) {
    // 处理验证失败
}

$user->languages()->attach($languagesData);

方法3：在表单请求中整合验证 #

如果使用表单请求类管理验证逻辑，可以将规则整合到请求类中：

namespace App\Http\Requests;

use Illuminate\Foundation\Http\FormRequest;
use App\Rules\ValidLanguageUuids;

class AttachUserLanguagesRequest extends FormRequest
{
    public function authorize()
    {
        return true; // 根据实际业务调整权限判断
    }

    public function rules()
    {
        return [
            'languages' => ['required', 'array', new ValidLanguageUuids],
            'languages.*.additional_field' => 'required|integer',
            'languages.*.additional_field2' => 'nullable|string'
        ];
    }
}

在控制器中使用该请求类：

public function attachLanguages(AttachUserLanguagesRequest $request, \App\Models\User $user)
{
    $user->languages()->attach($request->input('languages'));

    return response()->json(['message' => '语言关联成功']);
}

内容的提问来源于stack exchange，提问作者kicaj