PHP Classes

File: tests/Unit/Doctor/Rules/DuplicateIndexTest.php

Recommend this page to a friend!
  Packages of Alberto Arena   Laravel Truss   tests/Unit/Doctor/Rules/DuplicateIndexTest.php   Download  
File: tests/Unit/Doctor/Rules/DuplicateIndexTest.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Laravel Truss
View a diagram of a Laravel application models
Author: By
Last change:
Date: 9 days ago
Size: 1,191 bytes
 

Contents

Class file image Download
<?php

declare(strict_types=1);

use AlbertoArena\Truss\Doctor\Rules\Index\DuplicateIndex;
use AlbertoArena\Truss\Tests\Support\SchemaBuilder;

it('flags a second index on the same columns', function () {
    $snapshot = SchemaBuilder::make()
        ->table('posts', fn ($t) => $t->id()->string('slug')
            ->index('slug', 'posts_slug_index')
            ->index('slug', 'posts_slug_index_copy'))
        ->build();

    expect(doctorCheck(new DuplicateIndex, $snapshot))
        ->toHaveFinding('TRUSS-IDX-002', table: 'posts');
});

it('is clean when indexes cover different columns', function () {
    $snapshot = SchemaBuilder::make()
        ->table('posts', fn ($t) => $t->id()->string('slug')->string('title')
            ->index('slug')->index('title'))
        ->build();

    expect(doctorCheck(new DuplicateIndex, $snapshot))->toBeClean();
});

it('treats a different column order as not a duplicate', function () {
    $snapshot = SchemaBuilder::make()
        ->table('events', fn ($t) => $t->id()->string('a')->string('b')
            ->index(['a', 'b'])->index(['b', 'a']))
        ->build();

    expect(doctorCheck(new DuplicateIndex, $snapshot))->toBeClean();
});