From 4aaddb32e1bd1a7833478f1fd4194507dba2c924 Mon Sep 17 00:00:00 2001 From: thomascube Date: Thu, 18 May 2006 17:49:20 +0000 Subject: Removed MDB2 classes; install seperately --- program/lib/MDB2/Driver/Reverse/mysql.php | 298 ------------------------------ 1 file changed, 298 deletions(-) delete mode 100644 program/lib/MDB2/Driver/Reverse/mysql.php (limited to 'program/lib/MDB2/Driver/Reverse/mysql.php') diff --git a/program/lib/MDB2/Driver/Reverse/mysql.php b/program/lib/MDB2/Driver/Reverse/mysql.php deleted file mode 100644 index c17e4f6d4..000000000 --- a/program/lib/MDB2/Driver/Reverse/mysql.php +++ /dev/null @@ -1,298 +0,0 @@ - | -// +----------------------------------------------------------------------+ -// -// $Id$ -// - -require_once 'MDB2/Driver/Reverse/Common.php'; - -/** - * MDB2 MySQL driver for the schema reverse engineering module - * - * @package MDB2 - * @category Database - * @author Lukas Smith - */ -class MDB2_Driver_Reverse_mysql extends MDB2_Driver_Reverse_Common -{ - // {{{ getTableFieldDefinition() - - /** - * get the stucture of a field into an array - * - * @param string $table name of table that should be used in method - * @param string $field_name name of field that should be used in method - * @return mixed data array on success, a MDB2 error on failure - * @access public - */ - function getTableFieldDefinition($table, $field_name) - { - $db =& $this->getDBInstance(); - if (PEAR::isError($db)) { - return $db; - } - - $result = $db->loadModule('Datatype'); - if (PEAR::isError($result)) { - return $result; - } - $columns = $db->queryAll("SHOW COLUMNS FROM $table", null, MDB2_FETCHMODE_ASSOC); - if (PEAR::isError($columns)) { - return $columns; - } - foreach ($columns as $column) { - if ($db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) { - if ($db->options['field_case'] == CASE_LOWER) { - $column['field'] = strtolower($column['field']); - } else { - $column['field'] = strtoupper($column['field']); - } - } else { - $column = array_change_key_case($column, $db->options['field_case']); - } - if ($field_name == $column['field']) { - list($types, $length) = $db->datatype->mapNativeDatatype($column); - $notnull = false; - if (array_key_exists('null', $column) && $column['null'] != 'YES') { - $notnull = true; - } - $default = false; - if (array_key_exists('default', $column)) { - $default = $column['default']; - if (is_null($default) && $notnull) { - $default = ''; - } - } - $autoincrement = false; - if (array_key_exists('extra', $column) && $column['extra'] == 'auto_increment') { - $autoincrement = true; - } - $definition = array(); - foreach ($types as $key => $type) { - $definition[$key] = array( - 'type' => $type, - 'notnull' => $notnull, - ); - if ($length > 0) { - $definition[$key]['length'] = $length; - } - if ($default !== false) { - $definition[$key]['default'] = $default; - } - if ($autoincrement !== false) { - $definition[$key]['autoincrement'] = $autoincrement; - } - } - return $definition; - } - } - - return $db->raiseError(MDB2_ERROR, null, null, - 'getTableFieldDefinition: it was not specified an existing table column'); - } - - // }}} - // {{{ getTableIndexDefinition() - - /** - * get the stucture of an index into an array - * - * @param string $table name of table that should be used in method - * @param string $index_name name of index that should be used in method - * @return mixed data array on success, a MDB2 error on failure - * @access public - */ - function getTableIndexDefinition($table, $index_name) - { - $db =& $this->getDBInstance(); - if (PEAR::isError($db)) { - return $db; - } - - $result = $db->query("SHOW INDEX FROM $table"); - if (PEAR::isError($result)) { - return $result; - } - $definition = array(); - while (is_array($row = $result->fetchRow(MDB2_FETCHMODE_ASSOC))) { - if (!($db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) - || $db->options['field_case'] != CASE_LOWER - ) { - $row = array_change_key_case($row, CASE_LOWER); - } - $key_name = $row['key_name']; - if ($db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) { - if ($db->options['field_case'] == CASE_LOWER) { - $key_name = strtolower($key_name); - } else { - $key_name = strtoupper($key_name); - } - } - if ($index_name == $key_name) { - if ($row['key_name'] == 'PRIMARY') { - $definition['primary'] = true; - } elseif (!$row['non_unique']) { - $definition['unique'] = true; - } - $column_name = $row['column_name']; - if ($db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) { - if ($db->options['field_case'] == CASE_LOWER) { - $column_name = strtolower($column_name); - } else { - $column_name = strtoupper($column_name); - } - } - $definition['fields'][$column_name] = array(); - if (array_key_exists('collation', $row)) { - $definition['fields'][$column_name]['sorting'] = ($row['collation'] == 'A' - ? 'ascending' : 'descending'); - } - } - } - $result->free(); - if (!array_key_exists('fields', $definition)) { - return $db->raiseError(MDB2_ERROR, null, null, - 'getTableIndexDefinition: it was not specified an existing table index'); - } - return $definition; - } - - // }}} - // {{{ tableInfo() - - /** - * Returns information about a table or a result set - * - * @param object|string $result MDB2_result object from a query or a - * string containing the name of a table. - * While this also accepts a query result - * resource identifier, this behavior is - * deprecated. - * @param int $mode a valid tableInfo mode - * - * @return array an associative array with the information requested. - * A MDB2_Error object on failure. - * - * @see MDB2_Driver_Common::setOption() - */ - function tableInfo($result, $mode = null) - { - $db =& $this->getDBInstance(); - if (PEAR::isError($db)) { - return $db; - } - - if (is_string($result)) { - /* - * Probably received a table name. - * Create a result resource identifier. - */ - $connected = $db->connect(); - if (PEAR::isError($connected)) { - return $connected; - } - $id = @mysql_list_fields($db->database_name, $result, $db->connection); - $got_string = true; - } elseif (MDB2::isResultCommon($result)) { - /* - * Probably received a result object. - * Extract the result resource identifier. - */ - $id = $result->getResource(); - $got_string = false; - } else { - /* - * Probably received a result resource identifier. - * Copy it. - * Deprecated. Here for compatibility only. - */ - $id = $result; - $got_string = false; - } - - if (!is_resource($id)) { - return $db->raiseError(MDB2_ERROR_NEED_MORE_DATA); - } - - if ($db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) { - if ($db->options['field_case'] == CASE_LOWER) { - $case_func = 'strtolower'; - } else { - $case_func = 'strtoupper'; - } - } else { - $case_func = 'strval'; - } - - $count = @mysql_num_fields($id); - $res = array(); - - if ($mode) { - $res['num_fields'] = $count; - } - - for ($i = 0; $i < $count; $i++) { - $res[$i] = array( - 'table' => $case_func(@mysql_field_table($id, $i)), - 'name' => $case_func(@mysql_field_name($id, $i)), - 'type' => @mysql_field_type($id, $i), - 'len' => @mysql_field_len($id, $i), - 'flags' => @mysql_field_flags($id, $i), - ); - if ($mode & MDB2_TABLEINFO_ORDER) { - $res['order'][$res[$i]['name']] = $i; - } - if ($mode & MDB2_TABLEINFO_ORDERTABLE) { - $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i; - } - } - - // free the result only if we were called on a table - if ($got_string) { - @mysql_free_result($id); - } - return $res; - } -} -?> \ No newline at end of file -- cgit v1.2.3