Filament•3y ago•

2 replies

Binary Ulids

Hi

I'm trying to build an admin panel for a project. It already has a DB structure with ulid as primary keys. The DB schema has a

binary(16)

binary(16)

column type. I recreated it this way:

Schema::create('admins', static function (Blueprint $table) {
    $table->ulid('id', 16)->charset('binary')->primary();
    $table->string('username')->unique();
    $table->string('email')->unique();
    $table->string('password');
    $table->string('avatar')->nullable();
    $table->rememberToken();
    $table->timestamps();
});

Schema::create('admins', static function (Blueprint $table) {
    $table->ulid('id', 16)->charset('binary')->primary();
    $table->string('username')->unique();
    $table->string('email')->unique();
    $table->string('password');
    $table->string('avatar')->nullable();
    $table->rememberToken();
    $table->timestamps();
});

So that it works for the tests (i.e. I have the correct DB structure when running test suite)

I also use the

HasUlids

HasUlids

trait and a custom cast for the primary key (as Laravel expects a

char(26)

char(26)

column type):

public function get(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromBinary($value)->toRfc4122();
}

public function set(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromString($value)->toBinary();
}

public function get(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromBinary($value)->toRfc4122();
}

public function set(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromString($value)->toBinary();
}

It seems to work when I

dd

dd

a model but I can't login to Filament, and tests fail too...

Component has errors: "data.pathway"
Failed asserting that false is true.
at vendor/livewire/livewire/src/Testing/Concerns/MakesAssertions.php:301
at tests/Admin/AdmissionResource/CreateAdmissionTest.php:36
at vendor/laravel/framework/src/Illuminate/Foundation/Testing/TestCase.php:174

Component has errors: "data.pathway"
Failed asserting that false is true.
at vendor/livewire/livewire/src/Testing/Concerns/MakesAssertions.php:301
at tests/Admin/AdmissionResource/CreateAdmissionTest.php:36
at vendor/laravel/framework/src/Illuminate/Foundation/Testing/TestCase.php:174

This is one of the errors I can have. The code is available at https://github.com/AlexandreGerault/mei-laravel/tree/refactor/ulid-primary-keys

I wonder what I can do to debug this

Filament•3y ago•

2 replies

Gunnolfson

Binary Ulids

Hi

I'm trying to build an admin panel for a project. It already has a DB structure with ulid as primary keys. The DB schema has a

binary(16)

binary(16)

column type. I recreated it this way:

Schema::create('admins', static function (Blueprint $table) {
    $table->ulid('id', 16)->charset('binary')->primary();
    $table->string('username')->unique();
    $table->string('email')->unique();
    $table->string('password');
    $table->string('avatar')->nullable();
    $table->rememberToken();
    $table->timestamps();
});

Schema::create('admins', static function (Blueprint $table) {
    $table->ulid('id', 16)->charset('binary')->primary();
    $table->string('username')->unique();
    $table->string('email')->unique();
    $table->string('password');
    $table->string('avatar')->nullable();
    $table->rememberToken();
    $table->timestamps();
});

So that it works for the tests (i.e. I have the correct DB structure when running test suite)

I also use the

HasUlids

HasUlids

trait and a custom cast for the primary key (as Laravel expects a

char(26)

char(26)

column type):

public function get(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromBinary($value)->toRfc4122();
}

public function set(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromString($value)->toBinary();
}

public function get(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromBinary($value)->toRfc4122();
}

public function set(Model $model, string $key, mixed $value, array $attributes)
{
    if ($value === null) {
        return null;
    }

    return Ulid::fromString($value)->toBinary();
}

It seems to work when I

dd

dd

a model but I can't login to Filament, and tests fail too...

Component has errors: "data.pathway"
Failed asserting that false is true.
at vendor/livewire/livewire/src/Testing/Concerns/MakesAssertions.php:301
at tests/Admin/AdmissionResource/CreateAdmissionTest.php:36
at vendor/laravel/framework/src/Illuminate/Foundation/Testing/TestCase.php:174

Component has errors: "data.pathway"
Failed asserting that false is true.
at vendor/livewire/livewire/src/Testing/Concerns/MakesAssertions.php:301
at tests/Admin/AdmissionResource/CreateAdmissionTest.php:36
at vendor/laravel/framework/src/Illuminate/Foundation/Testing/TestCase.php:174

This is one of the errors I can have. The code is available at https://github.com/AlexandreGerault/mei-laravel/tree/refactor/ulid-primary-keys

I wonder what I can do to debug this

Binary Ulids

Binary Ulids

Similar Threads

Similar Threads

Similar Threads