2017 © Pedro Peláez
 

library db-exporter

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

image

nwidart/db-exporter

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  • Saturday, July 23, 2016
  • by nWidart
  • Repository
  • 17 Watchers
  • 305 Stars
  • 22,345 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 69 Forks
  • 16 Open issues
  • 13 Versions
  • 3 % Grown

The README.md

Scrutinizer Quality Score Latest Stable Version Total Downloads Latest Unstable Version License, (*1)

Database Exporter

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class. This can be done via artisan commands or a controller action., (*2)

Please note that I've only tested this package on a MySQL database. It has been confirmed it does not work with Postgres., (*3)

Installation


$ composer require nwidart/db-exporter

Add the service provider to app/config/app.php:, (*4)

'Nwidart\DbExporter\DbExportHandlerServiceProvider'

(Optional) Publish the configuration file., (*5)

php artisan config:publish nwidart/db-exporter

Use dev-master as version requirement to be on the cutting edge, (*6)

Documentation

From the commandline

Export database to migration

Basic usage, (*7)

php artisan dbe:migrations

Specify a database, (*8)

php artisan dbe:migrations otherDatabaseName

Ignoring tables, (*9)

You can ignore multiple tables by seperating them with a comma., (*10)

php artisan dbe:migrations --ignore="table1,table2"

Export database table data to seed class

This command will export all your database table data into a seed class., (*11)

php artisan dbe:seeds

Important: This requires your database config file to be updated in app/config/database.php., (*12)

Uploading migrations/seeds to remote server

Important: This requires your app/config/remote.php to be configured., (*13)

Important: The package configuration remote key needs to be configured to correspond to your remotes directory structure., (*14)

You can with the following command, upload migrations and / or seeds to a remote host with php artisan dbe:remote remoteName [--migrations] [--seeds], (*15)

For instance to upload the migrations to the production server:, (*16)

php artisan dbe:remote production --migrations

Or upload the seeds to the production server:, (*17)

php artisan dbe:remote production --seeds

Or even combine the two:, (*18)

php artisan dbe:remote production --migrations --seeds

From a controller / route

Database to migration

Export current database

This requires your database config file to be updated. The class will export the database name from your app/config/database.php file, based on your 'default' option., (*19)

Make a export route on your development environment, (*20)


Route::get('export', function()
{
    DbExportHandler::migrate();
});
Export a custom database

Route::get('export', function()
{
    DbExportHandler::migrate('otherDatabaseName');
});

Database to seed

This will write a seeder class with all the data of the current database., (*21)


Route::get('exportSeed', function()
{
    DbExportHandler::seed();
});

Next all you have to do is add the call method on the base seed class:, (*22)


$this->call('nameOfYourSeedClass');

Now you can run from the commmand line:, (*23)

  • php artisan db:seed,
  • or, without having to add the call method: php artisan db:seed --class=nameOfYourSeedClass

Chaining

You can also combine the generation of the migrations & the seed:, (*24)


DbExportHandler::migrate()->seed();

Or with:, (*25)


DbExportHandler::migrateAndSeed();

Important : Please note you cannot set a external seed database. If you know of a way to connect to a external DB with laravel without writing in the app/database.php file let me know., (*26)

Ignoring tables

By default the migrations table is ignored. You can add tabled to ignore with the following syntax:, (*27)


DbExportHandler::ignore('tableToIgnore')->migrate();
DbExportHandler::ignore('tableToIgnore')->seed();

You can also pass an array of tables to ignore., (*28)

TODO

  • ~~Export data too. It would be cool if it could also generate a seed file based of the data in the tables. This would be more usefull to run on the production server to get the seed on the development server.~~ 3/1/13
  • ~~Deploy the migration directly to the production server ready to be migrated. (as an option)~~ 5/1/13
  • ~~Make commands to do the same thing (export db to migration)~~ 4/1/13
  • ~~Make commands to do the same thing (export db to seed)~~ 4/1/13
  • Making the upload to remote available directly when generating the migrations/seeds

Credits

Credits to @michaeljcalkins for the original class on paste.laravel.com (which goal was to generate migrations from a database). Sadly I couldn't get it working as-is, so I debugged it and decided to make a package out of it, and added a couple a features of my own., (*29)

License (MIT)

Copyright (c) 2013 Nicolas Widart , n.widart@gmail.com, (*30)

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:, (*31)

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software., (*32)

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE., (*33)

The Versions

23/07 2016

dev-master

9999999-dev

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

24/04 2015

1.1

1.1.0.0

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

02/04 2015

dev-develop

dev-develop

Export your database quickly and easely as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

14/08 2014

1.0

1.0.0.0

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

13/08 2014

0.9

0.9.0.0

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

07/08 2014

0.8

0.8.0.0

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

06/08 2014

0.7

0.7.0.0

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

05/08 2014

0.6

0.6.0.0

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

05/01 2014

0.5

0.5.0.0

Export your database quickly and easely as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

04/01 2014

0.4

0.4.0.0

Export your database quickly and easely as a Laravel Migration and all the data as a Seeder class.

  Sources   Download

MIT

The Requires

 

by Nicolas Widart

database laravel migrations php command export artisan seed

03/01 2014

v0.3

0.3.0.0

Export your database as a Laravel Migration

  Sources   Download

The Requires

 

by Nicolas Widart

database laravel migrations php export

03/01 2014

v0.2

0.2.0.0

Export your database as a Laravel Migration

  Sources   Download

The Requires

 

by Nicolas Widart

database laravel migrations php export

03/01 2014

v0.1

0.1.0.0

Export your database as a Laravel Migration

  Sources   Download

The Requires

 

by Nicolas Widart

database laravel migrations php export