apps-inteligentes/laravel-multi-database-commands

This package is abandoned and no longer maintained. The author suggests using the henryavila/laravel-multi-database-commands package instead.

This package provides an abstraction to efficiently manage multiple database application commands, like: migrate

v2.1.0 2024-04-11 19:31 UTC

Requires

• php: ^8.0
• illuminate/contracts: ^8.0|^9.0|^10.0|^11.0
• spatie/laravel-package-tools: ^1.4.3

Requires (Dev)

• brianium/paratest: ^6.2
• nunomaduro/collision: ^5.3|^6.1|^8.1
• orchestra/testbench: ^6.15|^7.0|^8.0|^9.0
• phpunit/phpunit: ^9.5|^10.5
• spatie/laravel-ray: ^1.36.0
• vimeo/psalm: ^4.4

MIT

• Henry Ávila

• laravel
• laravel_multi_database_commands
• henryavila

README

Version 2.0 Upgrade

This package has been migrated from apps-inteligentes/laravel-multi-database-commands to henryavila/laravel-multi-database-commands The namespace has been moved from AppsInteligentes\LaravelMultiDatabaseCommands to HenryAvila\LaravelMultiDatabaseCommands

To update this package, update your composer.json file to

{
    "require": {
        "henryavila/laravel-multi-database-commands": "^2.0.0"
    }
}

If you overwrite some contente of this pacakge, make sure to run a global search a replace on your code looking for AppsInteligentes\LaravelMultiDatabaseCommands and replacing with HenryAvila\LaravelMultiDatabaseCommands

Installation

You can install the package via composer:

composer require henryavila/laravel-multi-database-commands

You can publish the config file with:

php artisan vendor:publish --provider="HenryAvila\LaravelMultiDatabaseCommands\LaravelMultiDatabaseCommandsServiceProvider" --tag="laravel_multi_database_commands-config"

This is the contents of the published config file:

return [

    /*
     * Add here the list of all database connection.
     * You can find the connection names in config file: database.connections
     */
    'databases' => [

    ]
];

Usage

All new migration, created by this package will be organized this way: each database present in multi_database_commands.databases will have their own migration folder.

Ex: All migrations for DB tenant will be stored in database/migration/tenant. All migrate command executed by this package will isolate all DB.

Create Migration Files

To create the migration add_active_column_on_users_table on tenant db connection, run the command:

php artisan multi-db:make-migration add_active_column_on_users_table tenant

Just like php artisan make:migration command, you can use the options --create theTableToBeCreated and --table theTableToBeMigrated

Running Migrations

To execute a migrate command in all DB. The list of all databases, must be defined in config file multi_database_commands

# Run migration in all dbs defined in multi_database_commands config file 
php artisan multi-db:migrate

# Run migration:status in all dbs defined in multi_database_commands config file 
php artisan multi-db:migrate -C status


# Run migration:rollback in teannt db  
php artisan multi-db:migrate tenant -C rollback

Just like php artisan migrate command, you can use all laravel variations fresh, install, refresh, reset, rollback and status`

To execute the command in on DB, just inform the db connection name

#Execute the migrate:status just on log db
php artisan multi-db:migrate log -C status

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Henry Ávila

License

The MIT License (MIT). Please see License File for more information.