web/lib/Zend/Amf/Adobe/DbInspector.php
changeset 64 162c1de6545a
parent 19 1c2f13fd785c
child 68 ecaf28ffe26e
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/lib/Zend/Amf/Adobe/DbInspector.php	Fri Mar 11 15:05:35 2011 +0100
@@ -0,0 +1,103 @@
+<?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-2010 Zend Technologies USA Inc. (http://www.zend.com)
+ * @license    http://framework.zend.com/license/new-bsd     New BSD License
+ * @version    $Id: DbInspector.php 20096 2010-01-06 02:05:09Z bkarwin $
+ */
+
+/**
+ * This class implements authentication against XML file with roles for Flex Builder.
+ *
+ * @package    Zend_Amf
+ * @subpackage Adobe
+ * @copyright  Copyright (c) 2005-2010 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();
+    }
+}