kdbv
is Compare the structure of old database and latest database structure and make required queries to migrate old database
kdbv
database
make
functionupgrade
function is Compare the contents of your old databases with kdbv
file ( witch contains latest database structure ) and Automate your data migrations from old to latestquery
function you can get all sql queries. that need to migrate database
PHP 5.3+ and PDO extension installed
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
To add in in your dependencies
php composer.phar require ganeshkandu/kdbv
This library requires an autoloader, if you aren't already using one you can include Composers autoloader.
require('vendor/autoload.php');
kdbv database
using make
function of your latest database
kdbv database
with your applicationkdbv database
and kdbv library
)upgrade
your database using upgrade
function// Using kdbv namespace
namespace kanduganesh;
// just use this code to require auto loader on the top of your projects.
require 'vendor/autoload.php';
// Initialize
$obj = new kdbv(array(
'HOST' => '<mysql_host>',
'DATABASE' => '<mysql_database>',
'USER' => '<database_user>',
'PASS' => '<database_password>',
'PORT' => '<mysql_port>',
'KDBV' => '<kdbv_database_name>', //name of kdbv database
'PREFIX' => '<table prefix>', //table prefix
));
<kdbv_database_name>
is a name ofkdbv database
which to be deploy with your application ( kdbv database contain database structure of your latest application )
use
$obj
of step 1
kdbv database
/*
Create kdbv database
notes :- during calling make function your mysql database should contain latest version database so it can store latest structure of database
*/
$obj->make();
use
$obj
of step 1
$sqls_queries = $obj->query();
foreach($sqls_queries as $query){
echo $query."\n";
}
/*
upgrade mysql database
notes :- during calling upgrade function your kdbv database should be deployed with your application
Upgrade your old mysql database to your latest mysql database structure
*/
$obj->upgrade();
$obj->make();
all time you when you release new application version with change database structure