Database Manager

Database Manager helps developers manage their dev/test/prod databases., _(*1)

Features:, _(*2)

Load database connection configuration
Instantiate PDO connections

Database Manager can be used both as a command-line utility as a PHP library., _(*3)

Suggestions

https://github.com/dbtk/schema-loader - to load schemas
https://github.com/linkorb/haigha - to load alice fixtures

Installation

Composer

Use this installation path if you wish to use Database Manager in your PHP project., _(*4)

Add the following to your composer.json file, in the require section:, _(*5)

"linkorb/database-manager": "~2.0"

Then run composer update to install the new dependency, _(*6)

Git

Use this installation path if you wish to use Database Manager as a stand-alone utility., _(*7)

Checkout the code from Github:, _(*8)

git clone git@github.com:linkorb/database-manager.git
cd database-manager
composer install # install dependencies
./bin/database-manager # list command-line options

Database configuration files

Database connection information is stored in a simple .ini file. Here's a working example:, _(*9)

name = mydb
server = localhost
port = 3306
username = my_username
password = my_password

Note that port key is optional., _(*10)

Store your database in /share/config/database/[databasename].conf, _(*11)

Command-line options

bin/database-manager connection:config [dbname], _(*12)

This will load the configuration from /share/config/database/[databasename].conf, and display it on the console., _(*13)

Examples

Please refer to the examples/ directory for:, _(*14)

Example database .conf file

Testing

Install phpunit and copy phpunit.xml.dist to phpunit.xml:, _(*15)

cp phpunit.xml.dist phpunit.xml

Type phpunit in terminal to run tests., _(*16)

Contributing

Ready to build and improve on this repo? Excellent! Go ahead and fork/clone this repo and we're looking forward to your pull requests! Be sure to update the unit tests in tests/., _(*17)

If you are unable to implement changes you like yourself, don't hesitate to open a new issue report so that we or others may take care of it., _(*18)