/**
* Obtain a list of a given type of objects
*
* @param string $type the kind of objects you want to retrieve
*
* @return array the array containing the list of objects requested
*
* @access protected
* @see DB_common::getListOf()
*/
function getSpecialQuery($type)
{
switch ($type) {
case 'databases':
$id = @msql_list_dbs($this->connection);
break;
case 'tables':
$id = @msql_list_tables($this->dsn['database'], $this->connection);
break;
default:
return null;
}
if (!$id) {
return $this->msqlRaiseError();
}
$out = array();
while ($row = @msql_fetch_row($id)) {
$out[] = $row[0];
}
return $out;
}
/**
* db::list_tables()
*
* @param $dbname
* @return
**/
function list_tables($dbname)
{
global $GonxAdmin;
switch ($GonxAdmin["dbtype"]) {
case "mysql":
$this->dbResultLine = @mysql_list_tables($dbname);
break;
case "postgresql":
$sql = "SELECT relname FROM pg_class WHERE relname !~ '^pg_'";
$this->dbResultLine = $this->query($sql);
break;
case "oracle":
$sql = "select * from user_objects where object_type = 'TABLE';";
$this->dbResultLine = $this->query($sql);
break;
case "sqlite":
break;
case "mssql":
$this->dbResultLine = @msql_list_tables($dbname);
break;
}
// switch
return $this->dbResultLine;
}
