From fcc01ff5818babff17de1daffacb84ecf4ef7d03 Mon Sep 17 00:00:00 2001 From: chriskl Date: Fri, 17 Oct 2003 07:33:49 +0000 Subject: [PATCH] stop pretending we support mysql --- HISTORY | 1 + classes/Misc.php | 8 +- classes/database/MySQL.php | 310 ------------------------------------- 3 files changed, 2 insertions(+), 317 deletions(-) delete mode 100644 classes/database/MySQL.php diff --git a/HISTORY b/HISTORY index 608acb11..1876df41 100644 --- a/HISTORY +++ b/HISTORY @@ -14,6 +14,7 @@ Features * Table info - shows table that reference the table, parent tables, and child tables. * Choice of operator when performing a Select +* Removed any trace of MySQL support Bugs * Added legal DOCTYPE diff --git a/classes/Misc.php b/classes/Misc.php index be0603a2..bcdcc837 100644 --- a/classes/Misc.php +++ b/classes/Misc.php @@ -2,7 +2,7 @@ /** * Class to hold various commonly used functions * - * $Id: Misc.php,v 1.45 2003/10/09 06:39:10 chriskl Exp $ + * $Id: Misc.php,v 1.46 2003/10/17 07:33:49 chriskl Exp $ */ class Misc { @@ -199,12 +199,6 @@ else return 'Postgres'; - break; - case 'mysql': - // Check functions are loaded - $description = 'MySQL'; - if (!function_exists('mysql_connect')) return -1; - return 'MySQL'; break; default: return -2; diff --git a/classes/database/MySQL.php b/classes/database/MySQL.php deleted file mode 100644 index 6419da8f..00000000 --- a/classes/database/MySQL.php +++ /dev/null @@ -1,310 +0,0 @@ - 'Database'); - var $tbFields = array('tbname' => 'Name', 'tbowner' => ''); - - // MySQL doesn't have object IDs - var $id = ''; - - /** - * Constructor - * @param $host The hostname to connect to - * @param $post The port number to connect to - * @param $database The database to connect to. NULL for default - * @param $user The user to connect as - * @param $password The password to use - */ - function MySQL($host, $port, $database, $user, $password) { - $this->BaseDB('mysql'); - - $myhost = "{$host}:{$port}"; - if ($database === null) $database = 'mysql'; - - $this->conn->connect($myhost, $user, $password, $database); - } - - /** - * Cleans (escapes) an object name (eg. table, field) - * @param $str The string to clean, by reference - * @return The cleaned string - */ - function fieldClean(&$str) { - return $str; - } - - /** - * Return all database available on the server - * @return A list of databases, sorted alphabetically - */ - function &getDatabases() { - $sql = "SHOW DATABASES"; - return $this->selectSet($sql); - } - - /** - * Return all information about a particular database - * @param $database The name of the database to retrieve - * @return The database info - */ - function &getDatabase($database) { - $this->clean($database); - $sql = "SHOW DATABASES LIKE '{$database}'"; - return $this->selectRow($sql); - } - - /** - * Drops a database - * @param $database The name of the database to retrieve - * @return 0 success - */ - function dropDatabase($database) { - $this->clean($database); - $sql = "DROP DATABASE {$database}"; - } - - // Table functions - - /** - * Return all tables in current database - * @return All tables, sorted alphabetically - */ - function &getTables() { - $sql = "SHOW TABLE STATUS"; - return $this->selectSet($sql); - } - - /** - * Return all information relating to a table - * @param $table The name of the table - * @return Table information - */ - function &getTableByName($table) { - $this->clean($table); - $sql = "SHOW TABLE STATUS LIKE '{$table}'"; - return $this->selectRow($sql); - } - - // @@ Need create table - tricky!! - - /** - * Removes a table from the database - * @param $table - * @return 0 success - */ - function dropTable($table) { - $this->clean($table); - - $sql = "DROP TABLE {$table}"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Renames a table - * @param $table The table to be renamed - * @param $newName The new name for the table - * @return 0 success - */ - function renameTable($table, $newName) { - $this->clean($table); - $this->clean($newName); - $sql = "ALTER TABLE {$table} RENAME {$newName}"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Adds a unique constraint to a table - * @param $table The table to which to add the unique - * @param $fields (array) An array of fields over which to add the unique - * @param $name (optional) The name to give the unique, otherwise default name is assigned - * @return 0 success - */ - function addUniqueConstraint($table, $fields, $name = '') { - $this->clean($table); - $this->arrayClean($fields); - $this->clean($name); - - if ($name != '') - $sql = "ALTER TABLE {$table} ADD UNIQUE {$name} (\"" . join('","', $fields) . "\")"; - else - $sql = "ALTER TABLE {$table} ADD UNIQUE (\"" . join('","', $fields) . "\")"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Drops a unique constraint from a table - * @param $table The table from which to drop the unique - * @param $name The name of the unique - * @return 0 success - */ - function dropUniqueConstraint($table, $name) { - $this->clean($table); - $this->clean($name); - - $sql = "ALTER TABLE {$table} DROP INDEX {$name}"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Adds a primary key constraint to a table - * @param $table The table to which to add the primery key - * @param $fields (array) An array of fields over which to add the primary key - * @param $name (optional) The name to give the key, otherwise default name is assigned - * @return 0 success - */ - function addPrimaryKeyConstraint($table, $fields, $name = '') { - $this->clean($table); - $this->arrayClean($fields); - $this->clean($name); - - if ($name != '') - return -99; - else - $sql = "ALTER TABLE {$table} ADD PRIMARY KEY (\"" . join('","', $fields) . "\")"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Drops a primary key constraint from a table - * @param $table The table from which to drop the primary key - * @param $name The name of the primary key - * @return 0 success - */ - function dropPrimaryKeyConstraint($table, $name = '') { - $this->clean($table); - $this->clean($name); - - $sql = "ALTER TABLE {$table} DROP PRIMARY KEY"; - - // @@ How do you do this? - return $this->execute($sql); - } - - // Column Functions - - /** - * Add a new column to a table - * @param $table The table to add to - * @param $column The name of the new column - * @param $type The type of the column - * @param $size (optional) The optional size of the column (ie. 30 for varchar(30)) - * @return 0 success - */ - function addColumnToTable($table, $column, $type, $size = '') { - $this->clean($table); - $this->clean($column); - $this->clean($type); - $this->clean($size); - // @@ How the heck do you properly clean type and size? - - if ($size == '') - $sql = "ALTER TABLE {$table} ADD COLUMN {$column} {$type}"; - else - $sql = "ALTER TABLE {$table} ADD COLUMN {$column} {$type}({$size})"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Drops a column from a table - * @param $table The table from which to drop - * @param $column The column name to drop - * @return 0 success - */ - function dropColumnFromTable($table, $column) { - $this->clean($table); - $this->clean($column); - - $sql = "ALTER TABLE {$table} DROP COLUMN {$column}"; - - return $this->execute($sql); - } - - /** - * Sets default value of a column - * @param $table The table from which to drop - * @param $column The column name to set - * @param $default The new default value - * @return 0 success - */ - function setColumnDefault($table, $column, $default) { - $this->clean($table); - $this->clean($column); - // @@ How the heck do you clean default clause? - - $sql = "ALTER TABLE {$table} ALTER COLUMN {$column} SET DEFAULT {$default}"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Drops default value of a column - * @param $table The table from which to drop - * @param $column The column name to drop default - * @return 0 success - */ - function dropColumnDefault($table, $column) { - $this->clean($table); - $this->clean($column); - - $sql = "ALTER TABLE {$table} ALTER COLUMN {$column} DROP DEFAULT"; - - // @@ How do you do this? - return $this->execute($sql); - } - - /** - * Sets whether or not a column can contain NULLs - * @param $table The table that contains the column - * @param $column The column to alter - * @param $state True to set null, false to set not null - * @return 0 success - * @return -1 attempt to set not null, but column contains nulls - * @return -2 transaction error - * @return -3 lock error - * @return -4 update error - */ - function setColumnNull($table, $column, $state) { - // Not implemented without knowing column type - return -99; - } - - /** - * Renames a column in a table - * @param $table The table containing the column to be renamed - * @param $column The column to be renamed - * @param $newName The new name for the column - * @return 0 success - */ - function renameColumn($table, $column, $newName) { - // Not implemented without knowing column type - return -99; - } - - // Capabilities - function hasTables() { return true; } - -} - -?> -- 2.39.5