duanbimo7212 2015-06-30 07:35
浏览 80

将SQLite设置为Laravel 5.1中的单元测试数据库

I'm trying to set-up unit testing in Laravel 5.1. Following the documentation I see this:

Laravel is built with testing in mind. In fact, support for testing with PHPUnit is included out of the box


When running tests, Laravel will automatically set the configuration environment to testing. Laravel automatically configures the session and cache to the array driver while testing, meaning no session or cache data will be persisted while testing.

which is awesome. But... how do I tell Laravel to use SQLite database connection when tests are ran?

Only thing there is in config/database.php is this commented code:

/* We might use this connection for unit tests
'sqlite' => [
    'driver'   => 'sqlite',
    'database' => storage_path().'/database.sqlite',
    'prefix'   => '',

We might use this :)

Is there a way to set this globally for all test? Do I need to set the connecton in every test case?

Any help appreciated.

  • 写回答

2条回答 默认 最新

  • dsfe167834 2015-06-30 10:57

    Actually it's pretty simple.

    Create a testing database on your storage/ folder, with the name database.sqlite or if you want another name or another location you have to change the configs on the config/database.php file, these are the default configs:

    'sqlite' => [
        'driver'   => 'sqlite',
        'database' => storage_path('database.sqlite'),
        'prefix'   => '',

    You have two options, you either edit your .env or you just specify the name of the database where you want to run your migrations:

    php artisan migrate --database=sqlite

    If you prefer editing your .env file, then we have to add a new variable:


    That's because Laravel defaults to MySQL when this variable is absent from .env file:

    //config/database.php file
    'default' => env('DB_CONNECTION', 'mysql'),

    Now that our app is pointing into our sqlite database we can now run our migrations and seeding. After that if you just want to keep running MySQL remove DB_CONNECTION=sqlite from the .env file.

    Now that you have your migrations on your testing database the last step is just to specify, your SQLite as your default database for tests.

    On your root folder you have a phpunit.xml file, open it and a new variable under <php> node:

    <env name="DB_CONNECTION" value="sqlite"/>

    Now your application is using MySQL and phpunit is using SQLite.

    Remember that if you change the .env to change it back to your default database;


    Be careful when running your migrations, if you specified a connection on the migration itself, it will try to run it on that connection.

    use Illuminate\Database\Schema\Blueprint;
    use Illuminate\Database\Migrations\Migration;
    class AdminUsersTable extends Migration
         * Run the migrations.
         * @return void
        public function up()
            Schema::connection('manage')->create('admin_users', function (Blueprint $t) {
         * Reverse the migrations.
         * @return void
        public function down()

    This migration will always run on the connection manage no matter what you specify on the .env file or in the migration command

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
  • duanlu1876 2017-04-15 17:43

    I have a bit of a different solution. I am using an in memory sqlite database.

    first I change the default and then add a new connection to the database.php in config

    'default' => env('DB_CONNECTION', 'mysql'),
    'testing' => [
        'driver' => 'sqlite',
        'database' => ':memory:',
        'prefix' => '',

    then I add the following line to the phpunit.xml

    <env name="DB_CONNECTION" value="testing"/>

    I leave the .env file untouched. That way the database connection will default to 'mysql'

    Here is the full phpunit.xml for more clarity

    <?xml version="1.0" encoding="UTF-8"?>
    <phpunit backupGlobals="false"
        <testsuite name="Application Test Suite">
            <directory suffix=".php">app/</directory>
        <log type="coverage-html" target="./report/" charset="UTF-8"
             yui="true" highlight="false" 
             lowUpperBound="50" highLowerBound="80"/>
        <env name="APP_ENV" value="testing"/>
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="DB_CONNECTION" value="testing"/>



  • ¥15 multisim电路设计(相关搜索:设计报告)
  • ¥15 从github上下载的项目到ecplise上咋运行
  • ¥15 PC-lint Plus
  • ¥15 gpl24676注释
  • ¥15 php5.3内存泄露
  • ¥15 DigSilent如何复制复合模型到自己案例?
  • ¥15 求日版华为b610s-77a 官方公版固件,有偿
  • ¥15 关于#java#的问题,请各位专家解答!(相关搜索:java程序)
  • ¥15 linux tsi721的驱动编译后 insmod 提示 报错
  • ¥20 multisim测数据