abmundi/database-commands-bundle

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

dev-master 2012-06-03 13:08 UTC

Requires

• php: >=5.3.2
• symfony/framework-bundle: 2.*

MIT

• Fabio Fabbrucci

• database
• mysql
• doctrine
• backup
• capifony

README

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.

Installation

Step 1

Using Composer

Add the following code to your composer.json:

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

Run a Composer update

$ php composer.phar update

Using vendor deps

Add the following code to your deps file:

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

And then run the vendors install command:

$ ./bin/vendors install

Then register the autoloader in the autoload.php file:

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

Step 2

Register the bundle in the AppKernel.php file:

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

    return $bundles;
}

Requirements

This bundle needs (in local and remote server)

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

Command line

Now from your console you can run

./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.

Capifony

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

• 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