Migration issue while running unit test

[webbati]

When running unit tests the down method of update migrations throw a missing column exception

Doctrine\DBAL\Schema\SchemaException: There is no column with name '[column_name]' on table '[table_name]'.

I did a PR in the builder plugin repository to add "hasColumn" method that wrap any "dropColumn" call but i don't know if is this correct, doesn't do all plugin migrations before running tests?

This exception happen only if there are more than one method in the test class, did I miss something to define in the MyPluginTestCase initialization class?

namespace My\Plugin\Tests;

  if (class_exists('System\Tests\Bootstrap\PluginTestCase')) {
      class BaseTestCase extends \System\Tests\Bootstrap\PluginTestCase
      {
      }
  } else {
      class BaseTestCase extends \PluginTestCase
      {
      }
  }
  
  abstract class MyPluginTestCase extends BaseTestCase
  {
      protected $refreshPlugins = [
        'My.Plugin',
      ];
  
      public function setUp(): void
      {
          parent::setUp();
      }
  
      public function tearDown(): void
      {
          parent::tearDown();
      }
  
  }

[mjauvin]

Please, include the test methods above that run your migrations so we can help.

[webbati]

Hi @mjauvin, they are just simple creations of new models.

class ReservationTest extends MyPluginTestCase
{

    public function testCreateFirstReservation()
    {
        $from = Carbon::now();
        $to   = Carbon::now()->addHours(3);

        $reservation = Reservation::create([
            'from' => $from,
            'to'   => $to
        ]);

        $reservation->refresh();
        $this->assertEquals(1, $reservation->qty);
        $this->assertNull($reservation->viewed_at);
        $this->assertNull($reservation->user_id);
        $this->assertLessThan($reservation->to, $reservation->from, 'The reservation ends earlier than when it starts!');
        $reservation->setViewed();
        $this->assertInstanceOf(\Carbon\Carbon::class, $reservation->viewed_at);
    }

    public function testAssignReservableObject()
    {
        $from = Carbon::now();
        $to     = Carbon::now()->addHours(3);

        $appointment = Appointment::create([
            'from' => $from,
            'to'   => $to,
            'user_id' => 1,
            'state' => 'pending'
        ]);

        $reservation = Reservation::create([
            'from' => $from,
            'to'   => $to
        ]);

        $appointment->reservation()->add($reservation);
        $this->assertInstanceOf(Appointment::class, $reservation->reservable);
        $this->assertEquals($reservation->reservable->state, 'pending');
    }
}