laravel-batch-validation

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

laravel-batch-validation

(★ 21)

Batch validate arrays in Laravel and optimize database unique rules using whereIn to avoid N+1 query issues.

laravel-batch-validation 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Laravel Batch Validation

When performing array validations in Laravel with unique rules, Laravel validates one record at a time, causing an N+1 query problem. This is a common issue when importing data from an Excel file and validating it before inserting it into the database. This package solves the problem by batching the unique validations and using whereIn to prevent the N+1 problem.

## Install

```bash
composer require dazza-dev/laravel-batch-validation
```

## Usage

This package is easy to use. Here's an example of how to apply it:

```php
use Illuminate\Support\Facades\Validator;

$data = [
    ['name' => 'User 1', 'email' => 'user1@example.com'],
    ['name' => 'User 2', 'email' => 'user2@example.com'],
    ['name' => 'User 3', 'email' => 'user3@example.com'],
];

// Validator Instance
$validator = Validator::make($data, [
    '*.name' => 'required',
    '*.email' => 'email:strict|unique:contacts,email',
]);

// Validate in Batches (this prevent n+1 problem)
$validator->validateInBatches();

// Validation fails
if ($validator->fails()) {
    throw new \Exception(json_encode($validator->errors()->messages()));
}
```

## Batch Size

You can change the batch size by passing the `batchSize` parameter to the `validateInBatches` method. The default batch size is 10.

```php
$validator->validateInBatches(batchSize: 20);
```

## Database Rules

This package also supports database rules like `unique`, `exists`.

```php
$validator = Validator::make($data, [
    '*.name' => 'required',
    '*.email' => 'email:strict|unique:contacts,email',
]);
```

## Form Request

You can use the `validateInBatches` method in a form request.

```php
use Illuminate\Foundation\Http\FormRequest;
use Illuminate\Support\Facades\Validator;

class StoreContactRequest extends FormRequest
{
    public function rules(): array
    {
        return [
            '*.name' => 'required',
            '*.email' => 'email:strict|unique:contacts,email',
        ];
    }

public function withValidator(Validator $validator)
    {
        if (method_exists($validator, 'validateInBatches')) {
            $validator->validateInBatches(batchSize: 100);
        }
    }
}
```

## Before and After Optimization

### Before (N+1 problem)

![Before Optimization](https://github.com/user-attachments/assets/e1c8c3a6-d7eb-423b-8448-8d5cc6e2d968)

### After (Optimized)

![After Optimization](https://github.com/user-attachments/assets/4c2353a1-4571-440c-90a4-d7221ec64a44)

## Contributions

Contributions are welcome. If you find any bugs or have ideas for improvements, please open an issue or send a pull request. Make sure to follow the contribution guidelines.

## Author

Laravel Batch Validation was created by [DAZZA](https://github.com/dazza-dev).

## License

This project is licensed under the [MIT License](https://opensource.org/licenses/MIT).

laravel-batch-validation

laravel-batch-validation 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

laravel-batch-validation

laravel-batch-validation 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README