Can't use sqlite in memory DB for pest test

@tykus Hi! Sorry new to pest.

Are you using the RefreshDatabase or LazilyRefreshDatabase trait in the Test class?

How do I know this?

@Brainmaniac follow the link to the Pest docs that I shared above.

@tykus a just saw it srry. Yes I have now made sure I refresh the db before each test... I think you might be right that I am missing the categories... I will make a factory for it. Thanks for the help

@Brainmaniac

I think you might be right that I am missing the categories

That's not what I was suggesting; the error message says there is no database table

no such table: categories

If you examine the stack trace further, you will see what application code is initiating the query; that will point us to the reason for the error message.

@tykus aa okok cotcha. I did find it after all. There was one of my migrations that did stuff that was not supported in sqlite but is in mysql as I am running normally.. I probably should not run sqlite as test db (i know) but I kinda just want to get this started for now. I modified the migration and I believe that the migration works now.

But I get another issue when I try to create an instance with my factory:

<?php

use App\Models\MyModel;
use Illuminate\Foundation\Testing\RefreshDatabase;

// Uses the given trait in the current file
uses(RefreshDatabase::class);

beforeAll(function(){
    MyModel::factory()->create();
});

it('has welcome page')->get('/')->assertStatus(200);

The error:

  • Tests\Feature\ExampleTest > it has welcome page
   Illuminate\Contracts\Container\BindingResolutionException 

  Target class [config] does not exist.

  at vendor/laravel/framework/src/Illuminate/Container/Container.php:879
    875▕ 
    876▕         try {
    877▕             $reflector = new ReflectionClass($concrete);
    878▕         } catch (ReflectionException $e) {
  ➜ 879▕             throw new BindingResolutionException("Target class [$concrete] does not exist.", 0, $e);
    880▕         }
    881▕ 
    882▕         // If the type is not instantiable, the developer is attempting to resolve
    883▕         // an abstract type such as an Interface or Abstract Class and there is

      +19 vendor frames 
  20  tests/Feature/ExampleTest.php:10
      Illuminate\Database\Eloquent\Factories\Factory::create()

I have dumped composer-autoload and all the various caches...

@Brainmaniac are you using the Tests\TestCase class in the Pest tests:

// tests/Pest.php
uses(\Tests\TestCase::class)->in('Feature');