<?php

/**

 * Zend Framework

 *

 * LICENSE

 *

 * This source file is subject to the new BSD license that is bundled

 * with this package in the file LICENSE.txt.

 * It is also available through the world-wide-web at this URL:

 * http://framework.zend.com/license/new-bsd

 * If you did not receive a copy of the license and are unable to

 * obtain it through the world-wide-web, please send an email

 * to license@zend.com so we can send you a copy immediately.

 *

 * @category   Zend

 * @package    Zend_Amf

 * @copyright  Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)

 * @license    http://framework.zend.com/license/new-bsd     New BSD License

 * @version    $Id: DbInspector.php 24593 2012-01-05 20:35:02Z matthew $

 */

/**

 * This class implements authentication against XML file with roles for Flex Builder.

 *

 * @package    Zend_Amf

 * @subpackage Adobe

 * @copyright  Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)

 * @license    http://framework.zend.com/license/new-bsd     New BSD License

 */

class Zend_Amf_Adobe_DbInspector

{

    /**

     * Connect to the database

     *

     * @param string $dbType Database adapter type for Zend_Db

     * @param array|object $dbDescription Adapter-specific connection settings

     * @return Zend_Db_Adapter_Abstract

     * @see Zend_Db::factory()

     */

    protected function _connect($dbType, $dbDescription)

    {

        if(is_object($dbDescription)) {

            $dbDescription = get_object_vars($dbDescription);

        }

        return Zend_Db::factory($dbType, $dbDescription);

    }

    /**

     * Describe database object.

     *

     * Usage example:

     * $inspector->describeTable('Pdo_Mysql',

     *     array(

     *         'host'     => '127.0.0.1',

     *         'username' => 'webuser',

     *         'password' => 'xxxxxxxx',

     *         'dbname'   => 'test'

     *     ),

     *     'mytable'

     * );

     *

     * @param string $dbType Database adapter type for Zend_Db

     * @param array|object $dbDescription Adapter-specific connection settings

     * @param string $tableName Table name

     * @return array Table description

     * @see Zend_Db::describeTable()

     * @see Zend_Db::factory()

     */

    public function describeTable($dbType, $dbDescription, $tableName)

    {

        $db = $this->_connect($dbType, $dbDescription);

        return $db->describeTable($tableName);

    }

    /**

     * Test database connection

     *

     * @param string $dbType Database adapter type for Zend_Db

     * @param array|object $dbDescription Adapter-specific connection settings

     * @return bool

     * @see Zend_Db::factory()

     */

    public function connect($dbType, $dbDescription)

    {

        $db = $this->_connect($dbType, $dbDescription);

        $db->listTables();

        return true;

    }

    /**

     * Get the list of database tables

     *

     * @param string $dbType Database adapter type for Zend_Db

     * @param array|object $dbDescription Adapter-specific connection settings

     * @return array List of the tables

     */

    public function getTables($dbType, $dbDescription)

    {

        $db = $this->_connect($dbType, $dbDescription);

        return $db->listTables();

    }

}