Laravel testing, no such table, sqlite

Question

I am running Laravel, on OS X using MAMP, and I am trying to do some unit testing, using PHPUnit, and sqlite, however when I run my tests, I get the error

General error: 1 no such table: users

I've tried running the artisan, to manually migrate the database, using the --env=testing, which runs fine, however I still get the error. I even call Artisan::call('migrate'); in the SetUp method.

/app/config/testing/database.php

return [
    'default' => 'sqlite',

    'connections' => [
        'sqlite' => [
            'driver'   => 'sqlite',
            'database' => ':memory:',
            'prefix'   => ''
        ],
    ]
];

EDIT: Migration file:

Schema::create('users', function($table) {
    $table->increments('id');
    $table->string('email', 32)->unique();
    $table->string('password', 64);
    $table->string('username', 32)->unique();
    $table->dateTime('birthdate');
    $table->enum('status', array('ACTIVE', 'INACTIVE'));
    $table->timestamps();
});

Schema::create('roles', function($table) {
    $table->increments('id');
    $table->string('name', 32);
});

Schema::create('role_user', function ($table) {
    $table->increments('id');

    $table->unsignedInteger('user_id');
    $table->unsignedInteger('role_id');

    $table->foreign('user_id')->references('id')->on('users');
    $table->foreign('role_id')->references('id')->on('roles');

});

Can you show us your migration that create the table users ? Which DB do you use in the rest of your app ? MySQL ? — Alexandre Butynski
– Alexandre Butynski, Commented Feb 21, 2014 at 7:47
Yes, it's mysql, I will add the migration file when i get back to work. — Kao
– Kao, Commented Feb 22, 2014 at 0:02

Alexandre Butynski · Accepted Answer · 2014-02-24 07:24:46Z

10

SQLite doesn't support the ENUM type : http://www.sqlite.org/datatype3.html

That's why the users table isn't created. You will have to run your tests on a classic MySQL table or remove all the ENUM types.

answered Feb 24, 2014 at 7:24

Alexandre Butynski

6,7562 gold badges33 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kao Over a year ago

Solved my problem, went with a "Enum" table instead. Thank you.

Samuel Aiala Ferreira Over a year ago

I've been struggling with this for the past 2 years

marcanuy · Accepted Answer · 2014-02-21 20:16:45Z

Running migrations before running the test doesn't work because, as your config shows, you db is in memory, so every time you run a new test, it runs migrations for each testing session and completely destroys all testing data when it finishes.

To use the memory database, run your migrations each time you run your tests, extend your classes from TestCase with something like:

<?php

class TestCase extends Illuminate\Foundation\Testing\TestCase {

  public function createApplication()
  {
      $unitTesting = true;
      $testEnvironment = 'testing';
      return require __DIR__.'/../../bootstrap/start.php';
  }

  public function setUp()
  {
      parent::setUp();
      $this->prepareForTests();
  }
  private function prepareForTests()
  {
      Artisan::call('migrate');
      Artisan::call('db:seed');
  }
  public function tearDown()
  {
      parent::tearDown();
  }
}

Collectives™ on Stack Overflow

Laravel testing, no such table, sqlite

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related