PHP Classes

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

Recommend this page to a friend!
  Packages of Alberto Arena   Laravel Truss   tests/Unit/Doctor/Rules/IndexDuplicatingPrimaryKeyTest.php   Download  
File: tests/Unit/Doctor/Rules/IndexDuplicatingPrimaryKeyTest.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: 8 days ago
Size: 915 bytes
 

Contents

Class file image Download
<?php

declare(strict_types=1);

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

it('flags an index that duplicates the primary key', function () {
    $snapshot = SchemaBuilder::make()
        ->table('team_user', fn ($t) => $t
            ->integer('team_id')->integer('user_id')
            ->primary(['team_id', 'user_id'])
            ->index(['team_id', 'user_id'], 'team_user_redundant'))
        ->build();

    expect(doctorCheck(new IndexDuplicatingPrimaryKey, $snapshot))
        ->toHaveFinding('TRUSS-IDX-004', table: 'team_user');
});

it('is clean when no index matches the primary key', function () {
    $snapshot = SchemaBuilder::make()
        ->table('users', fn ($t) => $t->id()->string('email')->unique('email'))
        ->build();

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