tod/mysql-to-sqlite

v1.2.1 2017-04-12 05:20 UTC

This package is not auto-updated.

Last update: 2024-03-16 17:26:10 UTC


README

This is a Laravel wrapper for esperlu's mysql2sqlite.sh which converts a mysqldump to an Sqlite 3 compatible file.

Latest Stable Version Total Downloads Build Status

Usage

You can run the default configuration

php artisan db:mysql-to-sqlite

Running a single, default conversion configuration:

php artisan db:mysql-to-sqlite customerServiceDBForCI

Configuration

  • Publish the config...

For Laravel

Publish the config...

php artisan vendor:publish --provider="MysqlToSqlite\ServiceProvider"

Add the following to app/Providers/AppServiceProvider.php

public function register()
{
    // Class may not be there if it was loaded as a dev dependency
    if (class_exists('MysqlToSqlite\ServiceProvider')) {
        $this->app->register(MysqlToSqlite\ServiceProvider::class),
    }
}

For Lumen

Publish the config...

cp vendor/realpagelouisville/mysql-to-sqlite/config/mysql-to-sqlite.php config/mysql-to-sqlite.php

Add the following to app/bootstrap/app.php

// Class may not be there if it was loaded as a dev dependency
if(class_exists('MysqlToSqlite\ServiceProvider')) {
    $app->register(MysqlToSqlite\ServiceProvider::class);
}

Installation

You're probably only using this for development, so we'll use require-dev:

composer require --dev realpagelouisville/mysql-to-sqlite:~1.*