mazbaul/comp

Custom Laravel Validator For Composite Key Validation

dev-master 2020-07-27 07:09 UTC

Requires

• php: ^7.1.3
• illuminate/support: 5.*|^6.0
• illuminate/validation: 5.*|^6.0

Requires (Dev)

• bossa/phpspec2-expect: ^3.0
• phpspec/phpspec: ^5.0

MIT

• Mazbaul Alam

• laravel

README

This package contains composite key validation rule for Laravel, that allows for validation of multi-column UNIQUE indexes.

Installation

Install the package through Composer. On the command line:

composer require mazbaul/comp

Configuration

Add the following to your providers array in config/app.php:

'providers' => [
    // ...

    Mazbaul\Comp\CompServiceProvider::class,
],

Usage

Use it like any Validator rule:

$validator = Validator::make($request->all(), [
      
      "<field1>" =>'required|composite_unique:<table>,<field1>,<field2>',
    ]);

See the Validation documentation of Laravel.

Ignore existing row (useful when updating)

You can also specify a row id to ignore (useful to solve unique constraint when updating)

This will ignore row with id 2

$validator = Validator::make($request->all(), [
      
      "<field1>" =>'required|composite_unique:<table>,<field1>,<field2>,ignore-<primaryKey>-'.$id,
    ]);

License

MIT