auto databade upgrade tool

auto databade upgrade tool to reduce development database versioning task

 https://github.com/GaneshKandu/kdbv

Features

• Upgrade - Database Upgrade
  
• Easy - Extremely easy to learn and use, friendly construction
  

Requirement

PHP 5.3+ and PDO extension installed

Get Started

Install

This library is designed to be installed via Composer.
Add the dependency into your projects composer.json.

{
  "require": {
    "ganeshkandu/kdbv": "*"
  }
}

Download the composer.phar

curl -sS https://getcomposer.org/installer | php

Install the library.

php composer.phar install

or

To add in in your dependencies

php composer.phar require ganeshkandu/kdbv

Autoloading

This library requires an autoloader, if you aren't already using one you can include Composers autoloader.

require('vendor/autoload.php');

Usage

create kdbv databade

// Using kdbv namespace
namespace kanduganesh;

// If you installed via composer, just use this code to require auto loader on the top of your projects.
require 'vendor/autoload.php';

// Initialize

/*
<host> database hostname
<database> database name
<user> database user
<password> database password
<port> database port
kdbv database stores database structure of latest database
<kdbvdb> database kdbv database
*/

$obj = new kdbv(array(
    'HOST' => '<host>',
    'DATABASE' => '<database>',
    'USER' => '<user>',
    'PASS' => '<password>',
    'PORT' => '<port>',
    'KDBV' => '<kdbvdb>',
));

// Enjoy
/*
Create kdbv database
*/
$obj->make();

get mysql queries in array

// Using kdbv namespace
namespace kanduganesh;

require 'vendor/autoload.php';

// Initialize

/*
<host> database hostname
<database> database name
<user> database user
<password> database password
<port> database port
kdbv database stores database structure of latest database
<kdbvdb> database kdbv database
*/

$obj = new kdbv(array(
    'HOST' => '<host>',
    'DATABASE' => '<database>',
    'USER' => '<user>',
    'PASS' => '<password>',
    'PORT' => '<port>',
    'KDBV' => '<kdbvdb>',
));
/*
get array of mysql upgrade queries
*/

$sql = $obj->query();

Upgrade mysql database

// Using kdbv namespace
namespace kanduganesh;

require 'vendor/autoload.php';

// Initialize

/*
<host> database hostname
<database> database name
<user> database user
<password> database password
<port> database port
kdbv database stores database structure of latest database
<kdbvdb> database kdbv database
*/

$obj = new kdbv(array(
    'HOST' => '<host>',
    'DATABASE' => '<database>',
    'USER' => '<user>',
    'PASS' => '<password>',
    'PORT' => '<port>',
    'KDBV' => '<kdbvdb>',
));

/*
upgrading database
*/

$obj->upgrade();

Maintainers

• Ganesh Kandu
  • Google+
  • Linkedin