when I use PHPUnit in laravel and add a factory to my own test class after running PHPUnit appear this error in the console:
SQLSTATE[HY000]: General error: 1 no such table: users
my test class method:
public function testExistSomeTextsInIndexPage()
{
$users= factory(User::class)->create();
$this->get('/')->assertSee($users->name);
}
this factory code work correctly in other parts of my project just show the error in the test class
You should include the Illuminate\Foundation\Testing\DatabaseMigrations as a trait. There is documentation about this.
use Illuminate\Foundation\Testing\DatabaseMigrations;
use Tests\TestCase;
class ExampleTest extends TestCase
{
use DatabaseMigrations;
}
Note: Set the correct DB credentials. If you use your credentials for you existing DB, it will override the DB. I would advise you to use a in-memory DB with SQLite, see example here
it worked for me when i insert use RefreshDatabase;
Like this:
use Illuminate\Foundation\Testing\RefreshDatabase;
use Tests\TestCase;
class ExampleTest extends TestCase
{
use RefreshDatabase;
}
Note: Just be careful in my case I use Laravel :memory database, this function deletes all the data that was created
