abmundi/database-commands-bundle

Provides a series of database commands for your Symfony application, one for the console and 5 capifony tasks.

Abmundi Database Commands Bundle

This bundle provides a way to run a series of cdatabase commands in your Symfony application. It provides one command line for our console, and 5 capifony tasks., _(*1)

Installation

Step 1

Using Composer

Add the following code to your composer.json:, _(*2)

"require": {
    ...
    "abmundi/database-commands-bundle": "dev-master",
    ...
},

Run a Composer update, _(*3)

$ php composer.phar update

Using vendor deps

Add the following code to your deps file:, _(*4)

[ABMundiDatabaseCommandsBundle]
    git=git://github.com/ABMundi/DatabaseCommands.git
    target=bundles/Abmundi/DatabaseCommandsBundle

And then run the vendors install command:, _(*5)

$ ./bin/vendors install

Then register the autoloader in the autoload.php file:, _(*6)

$loader->registerNamespaces(array(
    ...
    'Abmundi'                       => __DIR__.'/../vendor/bundles',
    ...
));

Step 2

Register the bundle in the AppKernel.php file:, _(*7)

public function registerBundles()
{
    $bundles = array(
        ...
        new Abmundi\DatabaseCommandsBundle\AbmundiDatabaseCommandsBundle(),
        ...
    );

    return $bundles;
}

Requirements

This bundle needs (in local and remote server), _(*8)

• mysql (command line)
• mysqldump (commandline)
• bunzip2 (commandline)

Command line

Now from your console you can run, _(*9)

./app/console db:dump

and see that a new file has been saved in folder /app/tmp/dump with an hard link to the newest one., _(*10)

Capifony

If you have installed capifony (http://capifony.org/) this bundle provides to you 6 nice tasks:, _(*11)

• cap db:init - Set remote folders (run it first time)
• cap db:dump - Create a dump of db in remote folder
• cap db:download - Download last dump file in local folder
• cap db:import:production - Import remote db in local production db
• cap db:import:testing - Import remote db in local testing db