SQLite不支持drop; 什么用于Laravel单元测试

Question

So it seems SQLite does not support dropping column. I have dropped/re-added columns over the time I build my application. I changed my database to. So right now, in my migration folder, there are folders that use $table->dropColumn('someColumn'). When I use SQLite, I get an error on that line (which was explained in the link above).

This tells me that I cannot use SQLite. So I decided to use MySQL:

<?php

return [

    'fetch' => PDO::FETCH_CLASS,

    'default' => 'mysql',

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

];

But I get an error: PDOException: SQLSTATE[HY000] [2002] No such file or directory

What connection should I then use for my unit testing?

Answer 1

MySQL doesn't have an in-memory feature like SQLite, so 'database' => ':memory:' won't work (short of starting a mysql server instance to write specifically in memory). Just setup a test database configuration in app/config/testing/database.php:

'mysql' => array(
    'driver'    => 'mysql',
    'host'      => 'localhost',
    'database'  => 'test_database',
    'username'  => '*******',
    'password'  => '*******',
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix'    => '',
)

And run the migrations on setUp and reset the migrations on tearDown.