Exemplo n.º 1
0
 private function readIndexes(Table $def)
 {
     $res = $this->database->select()->select('t.relname as table_name, i.relname as index_name, a.attname as column_name')->select('ix.indisunique::int as is_unique,ix.indisprimary::int as is_primary')->from('pg_class t, pg_class i, pg_index ix, pg_attribute a')->where('t.oid = ix.indrelid')->where('i.oid = ix.indexrelid')->where('a.attrelid = t.oid')->where('a.attnum = ANY(ix.indkey)')->where('t.relkind = \'r\'')->where('t.relname = ?', $def->schemaName)->order('t.relname, i.relname, ix.indnatts')->query()->fetchAll();
     $indexData = array();
     foreach ($res as $row) {
         if ($row['is_primary']) {
             $row['index_name'] = 'PRIMARY';
         }
         $indexData[$row['index_name']]['columns'][$row['column_name']] = $row['column_name'];
         $indexData[$row['index_name']]['is_unique'] = $row['is_unique'];
         $indexData[$row['index_name']]['is_primary'] = $row['is_unique'];
     }
     $columns = $def->getColumns();
     if (isset($indexData['PRIMARY'])) {
         $primaryKey = array();
         foreach ($indexData['PRIMARY']['columns'] as $columnName) {
             $primaryKey[] = $columns->{$columnName};
         }
         $def->setPrimaryKey($primaryKey);
         unset($indexData['PRIMARY']);
     }
     foreach ($indexData as $indexName => $indexInfo) {
         $indexColumns = array();
         foreach ($indexInfo['columns'] as $columnName) {
             $indexColumns[] = $columns->{$columnName};
         }
         $index = new Index($indexColumns);
         $index->setType($indexInfo['is_unique'] ? Index::TYPE_UNIQUE : Index::TYPE_KEY);
         $index->setName($indexName);
         $def->addIndex($index);
     }
 }
Exemplo n.º 2
0
 public function getTableDefinition($tableName)
 {
     $tableSymbol = new Symbol($tableName);
     $res = $this->database->query("DESC ?", $tableSymbol);
     $columns = new \stdClass();
     while ($row = $res->fetchRow()) {
         $type = $row['Type'];
         $field = $row['Field'];
         $phpType = $this->getTypeByString($type);
         if ('auto_increment' === $row['Extra']) {
             $phpType += Column::AUTO_ID;
         }
         $column = new Column($phpType);
         $columns->{$field} = $column;
         $column->schemaName = $field;
         $notNull = $row['Null'] === 'NO';
         if ($row['Default'] !== null || !$notNull) {
             $column->setDefault($row['Default']);
         }
         $column->setFlag(Column::NOT_NULL, $notNull);
     }
     $definition = new Table($columns, $this->database, $tableName);
     $res = $this->database->query("SHOW INDEX FROM ?", $tableSymbol);
     $indexes = array();
     $uniqueIndex = array();
     foreach ($res as $row) {
         $indexes[$row['Key_name']][$row['Seq_in_index']] = $columns->{$row['Column_name']};
         $uniqueIndex[$row['Key_name']] = !$row['Non_unique'];
     }
     foreach ($indexes as $indexName => $indexData) {
         ksort($indexData);
         $index = new Index(array_values($indexData));
         $index->setName($indexName);
         $index->setType($uniqueIndex[$indexName] ? Index::TYPE_UNIQUE : Index::TYPE_KEY);
         if ($indexName === self::_PRIMARY) {
             $definition->setPrimaryKey($index->columns);
         } else {
             $definition->addIndex($index);
         }
     }
     return $definition;
 }
Exemplo n.º 3
0
 private function buildIndexes()
 {
     foreach ($this->indexes as $indexData) {
         $type = $indexData[0];
         $name = $indexData[1];
         $columns = array();
         foreach ($indexData[2] as $columnName) {
             $columns[] = $this->columns->{$columnName};
         }
         $index = new Index($columns);
         $index->setName($name);
         $index->setType($type);
         $this->table->addIndex($index);
     }
 }