Download the PHP package hadeluca/db-exporter without Composer

On this page you can find all versions of the php package hadeluca/db-exporter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

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 PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • 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.
Please rate this library. Is it a good library?

Example code of hadeluca/db-exporter

Informations about the package db-exporter

Hardel-Laravel-Exporter

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

This can be done via artisan commands or a controller action.

This package is a restructuring of the existing nWidart/DbExporter library

Hardel Exporter Laravel Supported version MaatWebsite
2.0.* 5.4.+, 5.5.+ 2.1.28
2.1.* 5.5.+, 5.6.+ 2.1.28
2.2.* >=5.5 <=5.8.* 3.1.*
2.3.* ^6.20 3.1.*
2.4.* ^7.29 3.1.*
2.5.* ^8.40 3.1.*

PS: When you update the library, please remember to re-publish vendor!

Changelog

see the Changelog file (created with version 2.3.0)

Installation

Add "hadeluca/db-exporter"* as a requirement to composer.json:

Update composer:

or via command line:

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.

Also here you can ignore multiple tables:

Important: This requires your database config file to be updated in config/database.php.

Next all you have to do is add the call method on the base seed class in database/seeds/DatabaseSeeder.php:

Now you can run from the commmand line:

Chaining

You can also combine the generation of the migrations & the seed:

Ignoring tables

By default the migrations table is ignored.

Export all data in .xlsx (Excel)

Now you can export all data in excel file from the command line

by default (in config.php) you can find the path where the library store the database.xlsx

also you can override this path passing path to the commmand line

automatically you can find in ~/Desktop/excelFolder/database.xlsx

TODO

Credits

Credits to @nicolaswidart for the original package Which I downloaded but was not compatible with the new version of laravel 5.4, 5.5, 5.6, 5.7, 5.8, 6.* and for these reason i modified it.

License (MIT)

Copyright (c) 2017-2021 Hernan Ariel De Luca , [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.

All versions of db-exporter with dependencies

PHP Build Version
Package Version
Requires symfony/console Version ~5.0
doctrine/inflector Version ~2.0
paragonie/random_compat Version v9.99.99
illuminate/support Version ^8.40
illuminate/console Version ^8.40
illuminate/container Version ^8.40
illuminate/contracts Version ^8.40
illuminate/database Version ^8.40
maatwebsite/excel Version ~3.1
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package hadeluca/db-exporter contains the following files

Loading the files please wait ....