Download the PHP package nwidart/db-exporter without Composer
On this page you can find all versions of the php package nwidart/db-exporter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package db-exporter
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.
Please note that I've only tested this package on a MySQL database. It has been confirmed it does not work with Postgres.
Installation
Add the service provider to app/config/app.php:
(Optional) Publish the configuration file.
Use dev-master as version requirement to be on the cutting edge
Documentation
From the commandline
Export database to migration
Basic usage
Specify a database
Ignoring tables
You can ignore multiple tables by seperating them with a comma.
Export database table data to seed class
This command will export all your database table data into a seed class.
Important: This requires your database config file to be updated in app/config/database.php.
Uploading migrations/seeds to remote server
Important: This requires your app/config/remote.php to be configured.
Important: The package configuration remote key needs to be configured to correspond to your remotes directory structure.
You can with the following command, upload migrations and / or seeds to a remote host with php artisan dbe:remote remoteName [--migrations] [--seeds]
For instance to upload the migrations to the production server:
Or upload the seeds to the production server:
Or even combine the two:
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.
Make a export route on your development environment
Export a custom database
Database to seed
This will write a seeder class with all the data of the current database.
Next all you have to do is add the call method on the base seed class:
Now you can run from the commmand line:
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:
Or with:
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.
Ignoring tables
By default the migrations table is ignored. You can add tabled to ignore with the following syntax:
You can also pass an array of tables to ignore.
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/13Deploy the migration directly to the production server ready to be migrated. (as an option)5/1/13Make commands to do the same thing (export db to migration)4/1/13Make 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.
License (MIT)
Copyright (c) 2013 Nicolas Widart , [email protected]
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:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
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.
