Download the PHP package jpswade/laravel-database-tools without Composer

Laravel Database Tools

The "missing" database toolset for Laravel. A set of commonly used Database Tools for Laravel.

With this package you can:

• Create a database (if it does not exist)
• Dump from another database to file
• Get and unzip from a database backup created by the Spatie Backup package
• Import from file
• Update the charset and collation
• Fixes the "no such function" error by giving SQLite MySQL compatibility by creating the missing function using PDO for SQLite using PHP functions.
• Uses MySQL commands to optimize database tables (using OPTIMIZE TABLE)

Install

Install the package into your Laravel application:

• composer require --dev jpswade/laravel-database-tools

Note: It's wise to only install these tools in development by default, as it's rare you should need them in a production environment.

Configure

Publish and customise your own dbtools.php file:

• php artisan vendor:publish --provider="Jpswade\LaravelDatabaseTools\ServiceProvider" --tag="config"

This allows you to set the source database and/or filesystem for the backup.

• dbtools.database - Define the source database for the db:dump command, similar to Laravel databases config.
• dbtools.filesystem - Define the source filesystem for the db:getFromBackup command, similar to Laravel filesystems config.
• dbtools.filesystem.path - Define the path for the db:getFromBackup command.
• dbtools.import - Here you can define the method (command or normal) for the db:importFromFile command.

Note:

• The db:getFromBackup command falls back to the spatie/laravel-backup package for configuration.

Usage

The commands are:

• db:create - Creates the database schema.
• db:dump - Fetch a copy of the latest database from the configured server.
• db:getFromBackup - Download database backup file from backup.
• db:importFromFile {file?} - Import data from a sql file into a database.
• db:charset - Changes the charset and collation to whatever the database is set to use.
• db:optimize - Optimizes your database tables.

SQLite MySQL Compatability Provider

For testing you can add the provider to your Test:

In production, follow the usual Registering Providers instructions:

In config/app.php, find the providers array and add:

Limitations

These are limitations you'll come across if you use certain commands:

• The db:getFromBackup command relies on the league/flysystem-aws-s3-v3 "^1.0" package, when you use the Amazon S3 Driver as per the Laravel docs.
• The db:dump command depends on spatie/db-dumper.
• The commands have only been tested to work with MySQL at the moment, but could be extended to others.
• The db:importFromFile command can only import .sql files.
• The db:optimize command only works with MySQL (at the moment).

Troubleshooting

Class 'League\Flysystem\AwsS3v3\AwsS3Adapter' not found

Note: Needed for db:getFromBackup command to use the S3 Driver.

Class 'Spatie\DbDumper\Databases\MySql' not found

Note: Needed by the db:dump command.