Hello there,
I want to test that a great set of permissions are created with a function. With pest, I did this :
it('should have these permissions defined for backend', function () {
$this->assertDatabaseHas(
'permissions',
[
'name' => $role,
'guard_name' => 'backpack'
]
);
})
->with('my_great_array_here');
My test is passing fine ! The issue is that I have 140 permissions and it will grow and the test took ages !
Is there a way to optimise this ?
One way to optimize assertDatabaseHas is to use the where method to filter the results before checking if the record exists. This can be done by passing an array of conditions to the where method. For example:
it('should have these permissions defined for backend', function () {
$permissions = [
'name' => $role,
'guard_name' => 'backpack'
];
$this->assertDatabaseHas('permissions', function ($query) use ($permissions) {
foreach ($permissions as $column => $value) {
$query->where($column, $value);
}
});
})
->with('my_great_array_here');
This will only check if a record exists in the "permissions" table where the "name" and "guard_name" columns match the values in the $permissions array. This can significantly reduce the number of records that need to be checked, and therefore improve the performance of the test.
This is an odd test. Are you testing against data in your live database?
The only way I can think to optimise this test is to build a count query to check that the number of results returned matches the number of elements in the result. This would be based on building a query like:
SELECT COUNT(*)
FROM `permissions`
WHERE (
(`name` = "admin" AND `guard_name` = "backpack") OR
(`name` = "other" AND `guard_name` = "backpack") OR
-- ...
);
It is trivial to build the query in PHP; however, it will not tell you which permission might be missing.
