Migrations fail when SQLite database file does not exist?

Question

It seems that migrations (sort of) fail silently when the database file does not exist. The migration executes but no db file is created and I can run the migration again. (It never says "nothing to migrate") If I create a blank file then it works.

This is odd because I thought SQLite always created the db file if it was not found so I'm not sure if this is a bug or something I've done wrong. Maybe it's a permissions problem? But everything else is working so I don't know. I'm using Windows 7 and the project is in my

Daniel A.A. Pelsmaeker · Accepted Answer · 2014-02-27 14:32:44Z

16

User blamh suggested to add the following snippet to app/start/artisan.php to automatically recreate the database when it doesn't exist, instead of throwing an exception.

if (Config::get('database.default') === 'sqlite') {
    $path = Config::get('database.connections.sqlite.database');
    if (!file_exists($path) && is_dir(dirname($path))) {
        touch($path);
    }
}

With this, you can safely delete the SQLite database and then re-migrate and re-seed it, if you wish.

edited Feb 27, 2014 at 14:32

answered Feb 17, 2014 at 23:48

Daniel A.A. Pelsmaeker

50.8k21 gold badges118 silver badges162 bronze badges

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

Comments

Dwight · Accepted Answer · 2013-07-26 06:40:11Z

6

I've issued this bug against laravel/framework.

Hopefully future versions will give an error if the database doesn't exist, or automatically create one.

answered Jul 26, 2013 at 6:40

Dwight

12.5k6 gold badges53 silver badges67 bronze badges

2 Comments

Brian Ortiz Over a year ago

I just created an artisan script that creates one if it doesn't exist.

Nicekiwi Over a year ago

@BrianOrtiz, would you share it? :)

Community · Accepted Answer · 2017-05-23 12:32:42Z

0

This is an updated and more flexible solution from Virtlinks answer

<?php

namespace App\Providers;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\ServiceProvider;

class SqliteServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        if (DB::getDriverName() === 'sqlite') {
            $path = DB::getConfig('database');
            if (!file_exists($path) && is_dir(dirname($path))) {
                touch($path);
            }
        }
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Jun 13, 2016 at 9:08

Gummibeer

1973 silver badges14 bronze badges

Comments

Parziphal · Accepted Answer · 2017-05-24 21:43:09Z

Here's yet another way to automatically create the database file, tested on Laravel 5.4.

This is the same as Gummibeer's answer except that I moved the logic to the App\Console\Kernel class (app/Console/Kernel.php), and the check will be performed only when running the migrate command.

<?php

use Illuminate\Support\Facades\DB;

class Kernel extends ConsoleKernel
{
    /**
     * @param  \Symfony\Component\Console\Input\InputInterface  $input
     * @param  \Symfony\Component\Console\Output\OutputInterface  $output
     * @return int
     */
    public function handle($input, $output = null)
    {
        $this->touchSQLiteDatabase($input);

        return parent::handle($input, $output);
    }

    protected function touchSQLiteDatabase($input)
    {
        $this->bootstrap();

        if (substr((string)$input, 0, 7) == 'migrate' && DB::getDriverName() === 'sqlite') {
            $path = DB::getConfig('database');

            if (!file_exists($path) && is_dir(dirname($path))) {
                touch($path);
            }
        }
    }
}

Collectives™ on Stack Overflow

Migrations fail when SQLite database file does not exist?

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related