Welcome to Tarun Kumar Singhal's Blog

Monday, December 12, 2016

PIMCore : Use of Codeception

Hi,

Recently, I used the Codeception inside PIMCore in one of my project. And i found that it's very easy to implement and helpful for the code-coverage report. Before that i also used the PHPUnit tool for the Unit testing and code-coverage analysis.

Yes, Codeception is build on top of the PHPUnit and it makes some handy work to implement it.

I used the codeception inside the PIMCore, PIMCore is a tool for the CMS, CRM, E-Commerce development.

Although, PIMCore is built on Zend framework, So you can use the below steps to enable the codeception there.

Please follow the steps to enable and run the codeception inside PIMCore.
Step 1: Install the codeception through the composer like below

# composer require "codeception/codeception"

Step 2: Check codeception is working or not, run the below command

# php vendor/codeception/codeception/codecept

Step 3: Install the codeception tests dir into your application

1	# php vendor/codeception/codeception/codecept bootstrap

It will create the codeception.yml file and tests directory where you have to write the test cases.

Step 4: Run the below command to create files for the functional testing

1	# php vendor/codeception/codeception/codecept generate:cept functional dummytest

It will create files for the functional testing.

Step 5: Write up the test case assertions for all the functional logics.
class DummyTest extends \Codeception\Test\Unit
{
protected function _before()
{
}
protected function _after()
{
}

// tests
public function testDataBridge()
{
}
}

Step 6: Run the codeception with the below command:
# php vendor/codeception/codeception/codecept run

It will run the written functional unit cases and give you a report either no of pass or fail assertions.

Step 7. Install the xdebug module to get the code coverage report
# apt-get install
# /etc/init.d/apache2 restart

Enable the xdebug module
# phpenmod xdebug
# /etc/init.d/apache2 restart

Install the c3 module to get the code-coverage report
# composer require "codeception/c3"
Include c3.php in your index.php like
include "c3.php"

Step 8: Now you are ready to get the code-coverage report
Edit you codeception.yml file and add the below line to enable the coverage

coverage:
    enabled: true

For your further setting please have a look the below url

http://codeception.com/docs/11-Codecoverage

# php vendor/codeception/codeception/codecept run --coverage --coverage-html

It will give you a code-coverage report with html format.

Thanks.
Cheers

Wednesday, April 15, 2015

ZF2: Cache your application

Step-by-step guide

Enable the Application cache in your ZF2 application:

Open your index.php file
Please below code:
/** Is development environment or not */
define('DEVELOPMENT_ENV', (getenv('APP_ENV') === 'development') ? false : true);
Open your public/.htaccess file and place below line at end of the file:
SetEnv "APP_ENV" "development"
Open your application.config.php file
Please below code in your file after module_path array:

        // An array of paths from which to glob configuration files after
        // modules are loaded. These effectively override configuration
        // provided by modules themselves. Paths may use GLOB_BRACE notation.
        'config_glob_paths' => array(
            'config/autoload/{,*.}{global,local,app}.php',
        ),

        // Whether or not to enable a configuration cache.
        // If enabled, the merged configuration will be cached and used in
        // subsequent requests.
        'config_cache_enabled' => DEVELOPMENT_ENV ? false : true,

        // The key used to create the configuration cache file name.
        'config_cache_key' => 'app-config',

        // Whether or not to enable a module class map cache.
        // If enabled, creates a module class map cache which will be used
        // by in future requests, to reduce the autoloading process.
        'module_map_cache_enabled' => DEVELOPMENT_ENV ? false : true,

        // The key used to create the class map cache file name.
        'module_map_cache_key' => 'module-map',

        // The path in which to cache merged configuration.
        'cache_dir' => 'data/cache',

        // Whether or not to enable modules dependency checking.
        // Enabled by default, prevents usage of modules that depend on other modules
        // that weren't loaded.
        'check_dependencies' => DEVELOPMENT_ENV ? true : false

        6. Provide full permission to data/cache dir

That's it. Now run your application, after that you will see 2 files will be created inside data/cache dir that contains the

your application configuration at single place and
Your all class-map

It improves your application performance.
Suggestion : Please make enable cache configuration at your production/staging servers only, better to disable cache at development server.

Tuesday, March 31, 2015

Zend Framework 2: API Logger

Hi,

When you create REST-API then that API may consumed at Web or Mobile.
So, Its become important to capture the API information which was called from Web-User or Mobile-User.
API developer always want to know which method type, version, IP-Address and param used in consumed API.
So, I like to share the ZF2 Plugin that will help you to monitor the API calls.

You can download the plugin from git-hub:

https://github.com/tarun-singhal/AppLogger

OR
You can install the AppLogger plugin via composer.json file

Include the below line in your comoser.json file:

"tarun-singhal/applogger": "dev-master"

Then run the

# php composer.phar update

It will install the AppLogger module in your ZF2 application.

After this please follow the Git-hub readme file at

https://github.com/tarun-singhal/AppLogger/blob/master/README.md

Once you setup the plugin in your application then your view will be:

Thanks

Friday, October 17, 2014

Zend Framework 2 : Console based application

Hi,

Console based application has significant role for the users rather to use in web based apps.
In ZF2, there is a way to set console based application.

I like to address you guys on setting of console application inside Zend-Framework 2 in step-wise manner:

Step 1: Open your Module.php file for console based settings and place the below code:

1
2
3

use Zend\ModuleManager\Feature\ConsoleBannerProviderInterface;
use Zend\ModuleManager\Feature\ConsoleUsageProviderInterface;
use Zend\Console\Adapter\AdapterInterface as Console;

and implements the below interface on your Module class i.e.

1	class Module implements ConsoleBannerProviderInterface, ConsoleUsageProviderInterface

Place the below function for the console banner and console usage inside Module.php file:

/**
     * To show the console banner
     * @see \Zend\ModuleManager\Feature\ConsoleBannerProviderInterface::getConsoleBanner()
     */
    public function getConsoleBanner(Console $console){
        return
        "==------------------------------------------------------==\n" .
        "        Welcome to my ZF2 Console-enabled app             \n" .
        "==------------------------------------------------------==\n" .
        "Version 0.0.1\n"
            ;
    }
    
    /**
     * This method is defined in ConsoleUsageProviderInterface
     */
    public function getConsoleUsage(Console $console){
        return array(
            'show logs'             => 'Show application statistics',
            'run cron'               => 'Run automated jobs',
            '(enable|disable) debug' => 'Enable or disable debug mode for the application.',
            'show users'             => 'Show active users',
            'show all users'               => 'show all users',
            'show enable|disable users' => 'show enable|disable users'
        );
    }

Step 2: Now if you run the application from console, then your have to run the below command where your application reside:

1	# php public/index.php

Then will get the below information:

If you get the same as above screen then this will give you some energy that you are on right track :)

Step 3: Now you have to set the routing for the console i.e. passing route name after index.php file like:

1	# php public/index.php show logs

To get this, we need to set that in module.config.php file of that Application module:

// Placeholder for console routes
    'console' => array(
        'router' => array(
            'routes' => array(
                'show-logs' => array(
                    'options' => array(
                        'route'    => 'show logs [--verbose|-v]',
                        'defaults' => array(
                            'controller' => 'Application\Controller\Index',
                            'action'     => 'show-logs'
                        )
                    )
                )
            ),
        ),
    ),

Step 4: Now your are on final destination to run the trigger of gun :)
Place the below code in your application controller file i.e. IndexController.php file:

    public function showLogsAction() {
        $request = $this->getRequest();
        // Make sure that we are running in a console and the user has not tricked our
        // application into running this action from a public web server.
        if (!$request instanceof ConsoleRequest) {
            throw new RuntimeException('You can only use this action from a console!');
        }
        return "App Calling from the Console\n";
    }

Now run the below command:

Simple... :)

If you want to learn more on this please follow the below URL:

http://framework.zend.com/manual/2.0/en/modules/zend.console.modules.html

I hope you enjoy to setup console based app... Bye..

Monday, October 13, 2014

Zend Framework 2 : How to set Multiple Database connectivity

Hi,

In Zend Framework 2, you can set multiple database connection in your project.

I accomplish it via creating a common plugin. I like to address all the process to manage multiple connection step wise manner:

Step 1: Create directory inside vendor i.e. "multiDB".

Step 2: Create src, Controller, Model and other directory as specified below:

Step 3: Create Module.php file inside "multiDB" directory.

<?php

namespace multiDB;

use Zend\Mvc\ModuleRouteListener;
use Zend\Mvc\MvcEvent;
use multiDB\Model\ClientDetailsTable;
use multiDB\Controller\multiDbActionController;
use multiDB\Adapter\MyAdapterFactory;

class Module
{
    public function onBootstrap(MvcEvent $e)
    {
        $eventManager        = $e->getApplication()->getEventManager();
        $moduleRouteListener = new ModuleRouteListener();
        $moduleRouteListener->attach($eventManager);
    }

    public function getConfig()
    {
        return array();
    }

    public function getAutoloaderConfig()
    {
        return array(
            'Zend\Loader\StandardAutoloader' => array(
                'namespaces' => array(
                    __NAMESPACE__ => __DIR__ . '/src/' . __NAMESPACE__
                )
            )
        );
    }
    
    /**
     * Get service configuration
     *
     * @access public
     * @return array
     */
    public function getServiceConfig()
    {
        return array(
            'factories' => array(
                'master' => new MyAdapterFactory('master'),
                'client' => new MyAdapterFactory('client'),
                'multiDB\Model\ClientDetailsTable' => function ($serviceManager) {
                    return new ClientDetailsTable($serviceManager->get(multiDbActionController::getDb()));
                },
            )
        );
    }
}

Step 4: Create multiDbActionController.php file inside multidb's controller directory.

<?php


namespace multiDB\Controller;


use Zend\Mvc\Controller\AbstractActionController;
use multiDB\Model\ClientDetailsTable;
use Zend\Session\Container;

/**
 * Basic action controller
 *
 * @category Zend
 * @package multiDB
 * @subpackage Controller
 */
class multiDbActionController extends AbstractActionController
{

    /**
     * Get client Creadentials on the behalf of selected clients
     * @param string $masterDB
     * @param string $masterHost
     * @param string $masterUser
     * @param string $masterPassword
     * @param int $client_id
     * @return array
     */
    public function getClientDb($masterDB, $masterHost, $masterUser, $masterPassword, $client_id) {
        $adapter = new \Zend\Db\Adapter\Adapter(array(
            'driver' => 'pdo',
            'dsn' => "mysql:dbname=$masterDB;host=$masterHost",
            'username' => $masterUser,
            'password' => $masterPassword
        ));

        if($client_id != '') {
            $clientDb = new ClientDetailsTable($adapter);
            $clientcredential = $clientDb->getClientDetails(array(
                "id" => $client_id
            ), array(
                'client_name',
                'db_name',
                'db_user',
                'db_host',
                'db_password'
            ));
            return $clientcredential[0];
        }else {
            echo "";
        }       
    }
    
    /**
     * To set the adaptor for the specific client's OR Master database
     * @return string
     */
    public static function getDb()
    {
        $session = new Container('client');
        if($session->offsetExists('client_id')) {
            return 'client';
        } else {
            return 'master';
        }
    }
}

Step 5: Create "ClientDetailsTable.php" file inside multiDB's Model directory.

<?php
namespace multiDB\Model;

use Zend\Db\Adapter\Adapter;
use Zend\Db\ResultSet\ResultSet;
use Zend\Db\TableGateway\AbstractTableGateway;
use Zend\ServiceManager\ServiceLocatorAwareInterface;
use Zend\ServiceManager\ServiceLocatorInterface;
use Zend\Db\Sql\Sql;

class ClientDetailsTable extends AbstractTableGateway implements ServiceLocatorAwareInterface
{
    protected $_serviceLocator;
    public $table = 'client_schema';
    
    public function __construct(Adapter $adapter)
    {
        $this->adapter = $adapter;
        $this->resultSetPrototype = new ResultSet(ResultSet::TYPE_ARRAY);
        $this->initialize();
    }
    
    /**
     * Set $_serviceLocator
     *
     * @access pubic
     * @param ServiceLocatorInterface $serviceLocator
     *            // ServiceLocatorInterface instance
     * @see \Zend\ServiceManager\ServiceLocatorAwareInterface::setServiceLocator()
     */
    public function setServiceLocator(ServiceLocatorInterface $serviceLocator)
    {
        $this->_serviceLocator = $serviceLocator;
    }
    
    /**
     * Get $_serviceLocator
     *
     * @access pubic
     * @return \Zend\ServiceManager\ServiceLocatorAwareInterface
     * @see \Zend\ServiceManager\ServiceLocatorAwareInterface::getServiceLocator()
     */
    public function getServiceLocator()
    {
        return $this->_serviceLocator;
    }
    
    public function getClientDetails($where, $columns) {
        $sql = new Sql($this->adapter);
        $select = $sql->select()->from(array(
            'cd' => $this->table
        ));
        
        if (count($columns) > 0) {
            $select->columns($columns);
        }
        if (count($where) > 0) {
            $select->where($where);
        }
        
        if (! empty($orderBy)) {
            $select->order($orderBy);
        }
        
        $statement = $sql->prepareStatementForSqlObject($select);
        $clients = $this->resultSetPrototype->initialize($statement->execute())
        ->toArray();
        return $clients;
    }
    
    
}

Step 6: Create "MyAdapterFactory.php" inside multiDB's Adapter directory.

<?php
namespace multiDB\Adapter;

use Zend\ServiceManager\FactoryInterface;
use Zend\ServiceManager\ServiceLocatorInterface;
use Zend\Db\Adapter\Adapter;

class MyAdapterFactory implements FactoryInterface
{

    protected $configKey;

    public function __construct($key)
    {
        $this->configKey = $key;
    }

    public function createService(ServiceLocatorInterface $serviceLocator)
    {
        $config = $serviceLocator->get('Config');
        
        return new Adapter($config[$this->configKey]);
    }
}

Step 7: Now you have create all the files for the multiDB module inside your vendor directory. Now you just have to club it with your running modules.

Here, Some changes required in your global.php file where you mentioned the connection settings. Please see the demo file settings for the global.php file.

<?php
use Zend\Session\Container;

/**
 * Global Configuration Override
 *
 * You can use this file for overriding configuration values from modules, etc.
 * You would place values in here that are agnostic to the environment and not
 * sensitive to security.
 *
 * @NOTE: In practice, this file will typically be INCLUDED in your source
 * control, so do not include passwords or other sensitive information in this
 * file.
 */

$masterDB = "master_db";
$masterHost = "localhost";
$masterUser = "root";
$masterPassword = "root";

$session = new Container('client');

if(isset($_REQUEST['id']))
$session->offsetSet('client_id', $_REQUEST['id']);

$con = new \multiDB\Controller\multiDbActionController();
$client = $con->getClientDb($masterDB, $masterHost, $masterUser, 
    $masterPassword, $session->offsetGet('client_id'));



$clientDB = $client['db_name'];
$clientHost = $client['db_host'];
$clientUser = $client['db_user'];
$clientPass = $client['db_password'];
$session->offsetSet('client_name', $client['client_name']);

return array(
    'master' => array('driver' => 'Pdo',
        'dsn' => "mysql:dbname=$masterDB;host=$masterHost",
        'username' => $masterUser, 'password' => $masterPassword),
    'client' => array('driver' => 'Pdo',
        'dsn' => "mysql:dbname=$clientDB;host=$clientHost",
        'username' => $clientUser, 'password' => $clientPass)
    
);

Step 8: Now you have to include multiDB module in application.config.php file

<?php
return array(
    // This should be an array of module namespaces used in the application.
    'modules' => array(
        'Application',
        'multiDB' //To handle multiple database on the fly
    ),

Step 9: Now you have setup everything for the multi db connection. now you just call the services for the model.
For example: i use the default module "Application", where i change in the Module.php.

/**
    * Get service configuration
    *
    * @access public
    * @return array
    */
    public function getServiceConfig()
    {
        return array(
                'factories' => array(
                        'Application\Model\ClientModel' => function ($serviceManager)
                        {
                            return new ClientModel($serviceManager->get(multiDbActionController::getDb()));
                        },
                        'Application\Model\TestModel' => function($serviceManager) {
                            return new TestModel($serviceManager->get('master'));
                        }
                )
        );
    }

Step 10: Now create the controller class inside module's controller directory i.e. IndexController.php file

<?php
/**
 * Zend Framework (http://framework.zend.com/)
 *
 * @link      http://github.com/zendframework/ZendSkeletonApplication for the canonical source repository
 * @copyright Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
 * @license   http://framework.zend.com/license/new-bsd New BSD License
 */

namespace Application\Controller;

use Zend\Mvc\Controller\AbstractActionController;
use Zend\View\Model\ViewModel;
use Zend\Mvc\Application;
use Zend\Session\Container;
use Zend\EventManager\SharedEventManager;
use Application\Listener\ExampleEventsListener;
use Application\Entity\Product;
use Application\Form\CreateProduct;


class IndexController extends AbstractActionController
{
    /**
     * Use to handle multiple database on the fly
     */
    public function dbswitchAction() {
        $dataset = $this->getServiceLocator()->get('Application\Model\TestModel');
        $emp = $dataset->getClientData();
        return new ViewModel(array(
           'data' => $emp
        ));
    }
    
    public function clientSetAction() {
        $view = new ViewModel();
        $session = new Container('client');
        
        $clientData = "";
        if(isset($_REQUEST['id']) && $_REQUEST['id'] != '') {
            echo $clientData =  "Connected to the client ".$_REQUEST['id']." Client NAME: ".$session->offsetGet('client_name');
            
            $dataset = $this->getServiceLocator()->get('Application\Model\ClientModel');
            $data = $dataset->getClientDataSet();
            $session->offsetUnset('client_id');
            print_r($data);
        }
        $view->setTerminal(true);
        $session->offsetUnset('client_id');
        return $view;
    }
}

Step 11: Create view file for the same action inside module... i.e. db-switch.phtml file inside application->index directory.

<pre>
<?php 
print_r($this->data);

?>
</pre>
<select id="client_name_id">
<option value="" onclick=onSelect();>Select</option>
<?php foreach($this->data as $key => $value) {?>
    <?php echo "<option value=".$value['id']." onclick=onSelect();>".$value['client_name']."</option>";?>
<?php }?>
</select>

<script>
function onSelect() {
    var val = $("#client_name_id option:selected").val();
    console.log(val);
    if(val != '') {
        $.ajax({
              url : "http://zf.local.com/client-set/",
              type : 'GET',
              data : {'id' : val},
              success : function(resp) {
                  console.log(resp);
                  $("#client-set-id").text(resp);
              }    
        });
    } else {
        $("#client-set-id").text('');
    }    
}
</script>

<pre>
<div id="client-set-id"></div>
<?php echo $this->clientData;?>
</pre>

Step 12: Now when you run your application with your local URL i.e.
http://localhost/db-switch then you will see the below output:

Here, you will see the dropdown where you can select the desired client and adepter auto connect with respective database.

Here, are the database mysql query for the application testing...
master_db

-- MySQL dump 10.13  Distrib 5.5.38, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: master_db
-- ------------------------------------------------------
-- Server version    5.5.38-0ubuntu0.14.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `client_schema`
--

DROP TABLE IF EXISTS `client_schema`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_schema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_name` varchar(45) NOT NULL,
  `db_name` varchar(45) NOT NULL,
  `db_user` varchar(45) NOT NULL,
  `db_password` varchar(45) NOT NULL,
  `db_host` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client_schema`
--

LOCK TABLES `client_schema` WRITE;
/*!40000 ALTER TABLE `client_schema` DISABLE KEYS */;
INSERT INTO `client_schema` VALUES (1,'zend','zfskel','root','root','localhost'),(2,'test db 1','test_db1','root','root','localhost');
/*!40000 ALTER TABLE `client_schema` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2014-10-13 20:14:22

Another database i used it i.e. test_db1, dump of this database is:

-- MySQL dump 10.13  Distrib 5.5.38, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: test_db1
-- ------------------------------------------------------
-- Server version    5.5.38-0ubuntu0.14.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee`
--

LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES (0,'kaushal',27),(1,'tarun',26),(2,'varun',34);
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2014-10-13 20:16:09

That's It......