/**
* Extracts information about an index from the XML element $index
*
* @param SimpleXMLElement $index
*
* @return ezcDbSchemaIndex or an inherited class
*/
private function parseIndex(SimpleXMLElement $index)
{
$indexFields = array();
foreach ($index->field as $indexField) {
$indexFieldName = (string) $indexField->name;
$indexFields[$indexFieldName] = ezcDbSchema::createNewIndexField(isset($indexField->sorting) ? (string) $indexField->sorting : null);
}
return ezcDbSchema::createNewIndex($indexFields, isset($index->primary) ? (string) $index->primary : false, isset($index->unique) ? (string) $index->unique : false);
}
/**
* Loops over all the indexes in the table $table and extracts information.
*
* This method extracts information about the table $tableName's indexes
* from the database and returns this schema as an array of
* ezcDbSchemaIndex objects. The key in the array is the index' name.
*
* @param string $tableName
* @return array(string=>ezcDbSchemaIndex)
*/
protected function fetchTableIndexes($tableName)
{
$indexBuffer = array();
$resultArray = $this->db->query("SHOW INDEX FROM `{$tableName}`");
foreach ($resultArray as $row) {
$keyName = $row['key_name'];
if ($keyName == 'PRIMARY') {
$keyName = 'primary';
}
$indexBuffer[$keyName]['primary'] = false;
$indexBuffer[$keyName]['unique'] = true;
if ($keyName == 'primary') {
$indexBuffer[$keyName]['primary'] = true;
$indexBuffer[$keyName]['unique'] = true;
} else {
$indexBuffer[$keyName]['unique'] = $row['non_unique'] ? false : true;
}
$indexBuffer[$keyName]['fields'][$row['column_name']] = ezcDbSchema::createNewIndexField();
// if ( $row['sub_part'] )
// {
// $indexBuffer[$keyName]['options']['limitations'][$row['column_name']] = $row['sub_part'];
// }
}
$indexes = array();
foreach ($indexBuffer as $indexName => $indexInfo) {
$indexes[$indexName] = ezcDbSchema::createNewIndex($indexInfo['fields'], $indexInfo['primary'], $indexInfo['unique']);
}
return $indexes;
}
/**
* Loops over all the indexes in the table $table and extracts information.
*
* This method extracts information about the table $tableName's indexes
* from the database and returns this schema as an array of
* ezcDbSchemaIndex objects. The key in the array is the index' name.
*
* @param string $tableName
* @return array(string=>ezcDbSchemaIndex)
*/
protected function fetchTableIndexes($tableName)
{
$indexBuffer = array();
$indexesArray = array();
// fetching index info from Oracle
$getIndexSQL = "SELECT uind.index_name AS name, " . " uind.index_type AS type, " . " decode( uind.uniqueness, 'NONUNIQUE', 0, 'UNIQUE', 1 ) AS is_unique, " . " uind_col.column_name AS column_name, " . " uind_col.column_position AS column_pos " . "FROM user_indexes uind, user_ind_columns uind_col " . "WHERE uind.index_name = uind_col.index_name AND uind_col.table_name = '{$tableName}'";
$indexesArray = $this->db->query($getIndexSQL)->fetchAll();
$primaryFound = false;
// getting columns to which each index related.
foreach ($indexesArray as $row) {
$keyName = $row['name'];
if ($keyName == $tableName . '_pkey') {
$keyName = 'primary';
$indexBuffer[$keyName]['primary'] = true;
$indexBuffer[$keyName]['unique'] = true;
$primaryFound = true;
} else {
$indexBuffer[$keyName]['primary'] = false;
$indexBuffer[$keyName]['unique'] = $row['is_unique'] == 1 ? true : false;
}
$indexBuffer[$keyName]['fields'][$row['column_name']] = ezcDbSchema::createNewIndexField();
}
$indexes = array();
foreach ($indexBuffer as $indexName => $indexInfo) {
$indexes[$indexName] = ezcDbSchema::createNewIndex($indexInfo['fields'], $indexInfo['primary'], $indexInfo['unique']);
}
return $indexes;
}
/**
* Loops over all the indexes in the table $table and extracts information.
*
* This method extracts information about the table $tableName's indexes
* from the database and returns this schema as an array of
* ezcDbSchemaIndex objects. The key in the array is the index' name.
*
* @param string $tableName
* @return array(string=>ezcDbSchemaIndex)
*/
protected function fetchTableIndexes($tableName)
{
$indexBuffer = array();
$resultArray = array();
// fetching index info from PostgreSQL
$getIndexSQL = "SELECT relname, pg_index.indisunique, pg_index.indisprimary, \n pg_index.indkey, pg_index.indrelid \n FROM pg_class, pg_index\n WHERE oid IN ( \n SELECT indexrelid \n FROM pg_index, pg_class \n WHERE pg_class.relname='{$tableName}' AND pg_class.oid=pg_index.indrelid \n ) \n AND pg_index.indexrelid = oid";
$indexesArray = $this->db->query($getIndexSQL)->fetchAll();
// getting columns to which each index related.
foreach ($indexesArray as $row) {
$myIndex[] = $row['relname'];
$colNumbers = explode(' ', $row['indkey']);
$colNumbersSQL = 'IN (' . join(' ,', $colNumbers) . ' )';
$indexColumns = $this->db->query("SELECT attname \n FROM pg_attribute \n WHERE attrelid={$row['indrelid']} \n AND attnum {$colNumbersSQL};");
foreach ($indexColumns as $colRow) {
$resultArray[] = array('key_name' => $row['relname'], 'column_name' => $colRow['attname'], 'non_unique' => !$row['indisunique'], 'primary' => !$row['indisprimary']);
$indexColumnNames[] = $colRow['attname'];
}
}
foreach ($resultArray as $row) {
$keyName = $row['key_name'];
if (substr($keyName, -5) == '_pkey') {
$keyName = 'primary';
}
$indexBuffer[$keyName]['primary'] = false;
$indexBuffer[$keyName]['unique'] = true;
if ($keyName == 'primary') {
$indexBuffer[$keyName]['primary'] = true;
$indexBuffer[$keyName]['unique'] = true;
} else {
$indexBuffer[$keyName]['unique'] = $row['non_unique'] ? false : true;
}
$indexBuffer[$keyName]['fields'][$row['column_name']] = ezcDbSchema::createNewIndexField();
}
$indexes = array();
foreach ($indexBuffer as $indexName => $indexInfo) {
$indexes[$indexName] = ezcDbSchema::createNewIndex($indexInfo['fields'], $indexInfo['primary'], $indexInfo['unique']);
}
return $indexes;
}
/**
* Loops over all the indexes in the table $table and extracts information.
*
* This method extracts information about the table $tableName's indexes
* from the database and returns this schema as an array of
* ezcDbSchemaIndex objects. The key in the array is the index' name.
*
* @param string $tableName
* @return array(string=>ezcDbSchemaIndex)
*/
protected function fetchTableIndexes($tableName)
{
$indexBuffer = array();
$indexNamesArray = $this->db->query("PRAGMA INDEX_LIST ('{$tableName}')");
$primaryFound = false;
foreach ($indexNamesArray as $row) {
$keyName = $row['1'];
if ($keyName == $tableName . '_pri') {
$keyName = 'primary';
$indexBuffer[$keyName]['primary'] = true;
$indexBuffer[$keyName]['unique'] = true;
$primaryFound = true;
} else {
$indexBuffer[$keyName]['primary'] = false;
$indexBuffer[$keyName]['unique'] = $row[2] ? true : false;
}
$indexArray = $this->db->query("PRAGMA INDEX_INFO ( '{$row[1]}' )");
foreach ($indexArray as $indexColumnRow) {
$indexBuffer[$keyName]['fields'][$indexColumnRow[2]] = ezcDbSchema::createNewIndexField();
}
}
// search primary index
$fieldArray = $this->db->query("PRAGMA TABLE_INFO ('{$tableName}')");
foreach ($fieldArray as $row) {
if ($row[5] == '1') {
$keyName = 'primary';
$indexBuffer[$keyName]['primary'] = true;
$indexBuffer[$keyName]['unique'] = true;
$indexBuffer[$keyName]['fields'][$row[1]] = ezcDbSchema::createNewIndexField();
}
}
$indexes = array();
foreach ($indexBuffer as $indexName => $indexInfo) {
$indexes[$indexName] = ezcDbSchema::createNewIndex($indexInfo['fields'], $indexInfo['primary'], $indexInfo['unique']);
}
return $indexes;
}
