Testing with Transactions

Test Transactions

Wrap each test in a transaction and roll back after — isolates tests from each other without truncating tables.

Example

-- Per-test transaction wrap (PHPUnit / pytest approach)
-- Before test:   START TRANSACTION;
-- After test:    ROLLBACK;
-- Benefits: fast, isolated, no fixture cleanup
-- Laravel: use DatabaseTransactions trait
use Illuminate\Foundation\Testing\DatabaseTransactions;

class OrderTest extends TestCase {
    use DatabaseTransactions; // wraps each test in a transaction
    public function test_order_creation(): void {
        $order = Order::factory()->create();
        $this->assertDatabaseHas("orders", ["id" => $order->id]);
    } // rolled back automatically
}

PHP

Full Editor

Pro Tip

DatabaseTransactions is faster than RefreshDatabase for read-write tests on existing data.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned