Esempio n. 1
0
 protected function dropColumn()
 {
     $restore = $this->getRestoreFileName();
     if (Sabel_Db_Migration_Manager::isUpgrade()) {
         if (is_file($restore)) {
             unlink($restore);
         }
         $columns = $this->getReader()->readDropColumn()->getColumns();
         $schema = $this->getSchema()->getTable($this->tblName);
         $sColumns = $schema->getColumns();
         $writer = new Sabel_Db_Migration_Writer($restore);
         $writer->writeColumns($schema, $columns);
         $writer->close();
         foreach ($columns as $column) {
             if (isset($sColumns[$column])) {
                 unset($sColumns[$column]);
             } else {
                 $warning = "column '{$column}' does not exist. (SKIP)";
                 Sabel_Console::warning($warning);
             }
         }
         $this->dropColumnsAndRemakeTable($sColumns, $schema);
     } else {
         $columns = $this->getReader($restore)->readAddColumn()->getColumns();
         $this->execAddColumn($columns);
     }
 }
Esempio n. 2
0
 public function create($dir = null)
 {
     if ($dir === null) {
         $dir = $this->skeletonDir . DS . self::DEFAULT_LANGUAGE;
     }
     foreach (scandir($dir) as $item) {
         if ($item[0] === "." && $item !== ".htaccess") {
             continue;
         }
         $fullPath = $dir . DS . $item;
         $targetItem = substr($fullPath, $this->basedirNameLength + 1);
         $targetPath = $this->targetDir . DS . $targetItem;
         if (is_dir($fullPath)) {
             if (isset($this->ignore[$targetItem])) {
                 Sabel_Console::message("ignore '{$targetItem}'.");
             } else {
                 if (is_dir($targetPath)) {
                     Sabel_Console::warning("'{$targetItem}' already exists.");
                 } else {
                     Sabel_Console::success("create {$targetItem}");
                     mkdir($targetPath);
                 }
                 $this->create($fullPath);
             }
         } else {
             if ($this->lang !== self::DEFAULT_LANGUAGE) {
                 $_target = substr($fullPath, strlen($this->skeletonDir) + 4);
                 // DS(1) + lang(2) + DS(1)
                 $_target = $this->skeletonDir . DS . $this->lang . DS . $_target;
                 if (is_dir($_target) || is_file($_target)) {
                     $fullPath = $_target;
                 }
             }
             if (isset($this->ignore[$targetItem])) {
                 Sabel_Console::message("ignore '{$targetItem}'.");
             } elseif (is_file($targetPath)) {
                 Sabel_Console::warning("'{$targetItem}' already exists.");
             } else {
                 Sabel_Console::success("create {$targetItem}");
                 copy($fullPath, $targetPath);
             }
         }
     }
 }
Esempio n. 3
0
 public function testMessage()
 {
     $_SERVER["IS_WINDOWS"] = true;
     ob_start();
     Sabel_Console::success("success");
     $result = ob_get_clean();
     $this->assertEquals("[SUCCESS] success", rtrim($result));
     ob_start();
     Sabel_Console::warning("warning");
     $result = ob_get_clean();
     $this->assertEquals("[WARNING] warning", rtrim($result));
     ob_start();
     Sabel_Console::error("failure");
     $result = ob_get_clean();
     $this->assertEquals("[FAILURE] failure", rtrim($result));
     ob_start();
     Sabel_Console::message("message");
     $result = ob_get_clean();
     $this->assertEquals("[MESSAGE] message", rtrim($result));
 }
Esempio n. 4
0
 protected function create()
 {
     $tblName = convert_to_tablename($this->mdlName);
     $schema = $this->getSchema();
     $tables = $schema->getTableList();
     if (Sabel_Db_Migration_Manager::isUpgrade()) {
         if (in_array($tblName, $tables)) {
             Sabel_Console::warning("table '{$tblName}' already exists. (SKIP)");
         } else {
             $this->createTable($this->filePath);
         }
     } else {
         if (in_array($tblName, $tables)) {
             $this->dropSequence($schema->getTable($tblName)->getSequenceColumn());
             $this->executeQuery("DROP TABLE " . $this->quoteIdentifier($tblName));
         } else {
             Sabel_Console::warning("unknown table '{$tblName}'. (SKIP)");
         }
     }
 }
Esempio n. 5
0
 public function warning($msg)
 {
     echo Sabel_Console::warning($msg);
 }
Esempio n. 6
0
 protected function alterChange($column, $current)
 {
     $line = array();
     $line[] = $column->name;
     if ($current->isText() && $column->type !== null && !$column->isText()) {
         Sabel_Console::warning("cannot modify lob column '{$current->name}'. (SKIP)");
     } elseif (!$current->isText()) {
         $col = $column->type === null ? $current : $column;
         $type = $this->getTypeDefinition($col, false);
         if ($col->isString()) {
             $max = $column->max === null ? $current->max : $column->max;
             $line[] = $type . "({$max})";
         } else {
             $line[] = $type;
         }
     }
     if (($d = $column->default) === _NULL) {
         $line[] = "DEFAULT NULL";
     } else {
         $cd = $current->default;
         if ($d === $cd) {
             $line[] = $this->getDefaultValue($current);
         } else {
             $this->valueCheck($column, $d);
             $line[] = $this->getDefaultValue($column);
         }
     }
     if ($current->nullable === true && $column->nullable === false) {
         $line[] = "NOT NULL";
     } elseif ($current->nullable === false && $column->nullable === true) {
         $line[] = "NULL";
     }
     return implode(" ", $line);
 }
Esempio n. 7
0
 protected function dropColumn()
 {
     $restore = $this->getRestoreFileName();
     if (Sabel_Db_Migration_Manager::isUpgrade()) {
         if (is_file($restore)) {
             unlink($restore);
         }
         $columns = $this->getReader()->readDropColumn()->getColumns();
         $schema = $this->getSchema()->getTable($this->tblName);
         $colNames = $schema->getColumnNames();
         $writer = new Sabel_Db_Migration_Writer($restore);
         $writer->writeColumns($schema, $columns)->close();
         $quotedTblName = $this->quoteIdentifier($this->tblName);
         foreach ($columns as $column) {
             if (in_array($column, $colNames)) {
                 $colName = $this->quoteIdentifier($column);
                 $this->executeQuery("ALTER TABLE {$quotedTblName} DROP COLUMN {$colName}");
             } else {
                 Sabel_Console::warning("column '{$column}' does not exist. (SKIP)");
             }
         }
     } else {
         $columns = $this->getReader($restore)->readAddColumn()->getColumns();
         $this->execAddColumn($columns);
     }
 }