adamkearsley / laravel-convert-migrations Goto Github PK

This is a custom command to convert your current SQL database schema into a Laravel 4 Migration file.

PHP 100.00%

laravel-convert-migrations's Introduction

Laravel Convert Migrations

This is an artisan command to convert your current SQL database schema into a Laravel 4 Migration file. It'll come really handy when you have started a Laravel project without using migrations, or if you're migrating an old app to Laravel.

Installation

Add the package to your composer.json file and run composer update:

"require": {
    "adamkearsley/convert-migrations": "dev-master"
}

Add 'Adamkearsley\ConvertMigrations\ConvertMigrationsServiceProvider' to your app/config/app.php file, inside the providers array.

Usage

Now it's as easy as running php artisan convert:migrations myDatabaseName. Wait a few seconds and, magically, you'll have a new migration in app/database/migrations.

Ignoring Tables

You can even ignore tables from the migration if you need to. Just use the ignore option and separate table names with a comma: php artisan convert:migrations --ignore="table1, table2".

Credits

Credits go to "bruceoutdoors" original class.

laravel-convert-migrations's People

Contributors

Stargazers

Watchers

laravel-convert-migrations's Issues

Does not add default for columns set with zero as default value

Any columns that are set as not null with the literal zero '0' as default do not get a "->default('0')" applied to the column creation. This creates some problems if your MySQL or MariaDB is set to "strict mode" (which is the default).

doesn't create options for the "on delete" attribute in foreign keys

It just doesn't, example:

$table->foreign('user_id')->references('id')->on('users');

should be

$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');

Error when ran on Laravel 5.4

I tried to use it but the next message appears
"[Symfony\Component\Debug\Exception\FatalErrorException]
Call to undefined method Illuminate\Foundation\Application::share() "

Primary key always converted in auto_increment column

Primary key are always converted in auto_increment, but some primary keys of my database are not A_I.

Tag releases

Title says it all, package consumers shouldn't have to rely on an ever-changing branch, would be better with tags

Doesn't work at the moment

Running composer update returns:

PHP Warning:  PHP Startup: apc.shm_size now uses M/G suffixes, please update your ini files in Unknown on line 0
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - Conclusion: remove laravel/framework v4.2.6
    - Conclusion: don't install laravel/framework v4.2.6
    - Conclusion: don't install laravel/framework v4.2.5
    - Conclusion: don't install laravel/framework v4.2.4
    - Conclusion: don't install laravel/framework v4.2.3
    - Installation request for adamkearsley/convert-migrations dev-master -> satisfiable by adamkearsley/convert-migrations[dev-master].
    - Conclusion: don't install laravel/framework v4.2.2
    - Conclusion: don't install laravel/framework v4.2.1
    - adamkearsley/convert-migrations dev-master requires illuminate/console 4.1.* -> satisfiable by illuminate/console[v4.1.0, v4.1.1, v4.1.10, v4.1.11, v4.1.12, v4.1.13, v4.1.14, v4.1.15, v4.1.16, v4.1.17, v4.1.18, v4.1.19, v4.1.2, v4.1.20, v4.1.21, v4.1.22, v4.1.23, v4.1.24, v4.1.25, v4.1.26, v4.1.27, v4.1.28, v4.1.29, v4.1.3, v4.1.30, v4.1.4, v4.1.5, v4.1.6, v4.1.7, v4.1.8, v4.1.9].
    - don't install illuminate/console v4.1.0|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.1|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.10|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.11|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.12|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.13|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.14|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.15|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.16|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.17|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.18|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.19|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.2|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.20|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.21|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.22|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.23|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.24|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.25|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.26|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.27|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.28|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.29|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.3|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.30|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.4|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.5|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.6|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.7|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.8|don't install laravel/framework v4.2.0
    - don't install illuminate/console v4.1.9|don't install laravel/framework v4.2.0
    - Installation request for laravel/framework 4.2.* -> satisfiable by laravel/framework[v4.2.0, v4.2.1, v4.2.2, v4.2.3, v4.2.4, v4.2.5, v4.2.6].

Running php artisan convert:migrations --ignore="ads, cnts, migrations, meta_location" returns:

PHP Warning:  PHP Startup: apc.shm_size now uses M/G suffixes, please update your ini files in Unknown on line 0
PHP Fatal error:  Class 'Adamkearsley\ConvertMigrations\ConvertMigrationsServiceProvider' not found in /srv/www/laravel/bootstrap/compiled.php on line 4217
PHP Stack trace:
PHP   1. {main}() /srv/www/laravel/artisan:0
PHP   2. require_once() /srv/www/laravel/artisan:30
PHP   3. require() /srv/www/laravel/bootstrap/start.php:66
PHP   4. Illuminate\Foundation\ProviderRepository->load() /srv/www/laravel/vendor/laravel/framework/src/Illuminate/Foundation/start.php:210
PHP   5. Illuminate\Foundation\ProviderRepository->compileManifest() /srv/www/laravel/bootstrap/compiled.php:4177
PHP   6. Illuminate\Foundation\ProviderRepository->createProvider() /srv/www/laravel/bootstrap/compiled.php:4203
{"error":{"type":"Symfony\\Component\\Debug\\Exception\\FatalErrorException","message":"Class 'Adamkearsley\\ConvertMigrations\\ConvertMigrationsServiceProvider' not found","file":"\/srv\/www\/laravel\/bootstrap\/compiled.php","line":4217}}

convert from liquibase XML ?

Hello, would it be possible to adapt the code in order to create a laravel migration file from a liquibase changelog XML file ?

Change version

Hi!
Current actual version of laravel - 4.2.* It causes problems with the update through the composer.
Package works fine with it, but you need to change the requirements.

p.s. I am bad know English, so sorry for mistakes )

Support plain sql

it'll be nice to support plain sql also

doesn't recognize blob type

I tried this with a DB that has a blob column in one table, the result was:

$table->('post_text')->nullable();

should be:

$table->binary('post_text')->nullable();

Does not handle ENUM column types

For any ENUM column types in the database, the output script does create the correct Laravel schema column type.

Example...

MYSQL Table column "item_type" with data type: ENUM('type1','type2')

In the migration output, the function statement becomes...
$table->('item_type');

instead of:
$table->enum('item_type', array('type1','type2'));

Fails install with laravel 5.0 due to dependency issue

Dependencies are out of date and therefore attempting to install with laravel 5.0 fails.

Composer update results in:
Your requirements could not be resolved to an installable set of packages.

Problem 1
- Installation request for adamkearsley/convert-migrations dev-master -> satisfiable by adamkearsley/convert-migrations[dev-master].
- Conclusion: remove laravel/framework v5.0.0
- adamkearsley/convert-migrations dev-master requires illuminate/console 4.2.* -> satisfiable by illuminate/console[v4.2.1, v4.2.12, v4.2.16, v4.2.2, v4.2.3, v4.2.4, v4.2.5, v4.2.6, v4.2.7, v4.2.8, v4.2.9].
- don't install illuminate/console v4.2.1|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.12|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.16|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.2|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.3|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.4|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.5|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.6|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.7|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.8|don't install laravel/framework v5.0.0
- don't install illuminate/console v4.2.9|don't install laravel/framework v5.0.0
- Installation request for laravel/framework 5.0.* -> satisfiable by laravel/framework[v5.0.0].