104 lines
2.9 KiB
PHP
104 lines
2.9 KiB
PHP
|
<?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-2009 Zend Technologies USA Inc. (http://www.zend.com)
|
||
|
|
* @license http://framework.zend.com/license/new-bsd New BSD License
|
||
|
|
* @version $Id: DbInspector.php 16971 2009-07-22 18:05:45Z mikaelkael $
|
||
|
|
*/
|
||
|
|
|
||
|
|
/**
|
||
|
|
* This class implements authentication against XML file with roles for Flex Builder.
|
||
|
|
*
|
||
|
|
* @package Zend_Amf
|
||
|
|
* @subpackage Adobe
|
||
|
|
* @copyright Copyright (c) 2005-2009 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();
|
||
|
|
}
|
||
|
|
}
|