コード例 #1
0
ファイル: Schema.php プロジェクト: ryosukemiyazawa/lasa
 /**
  *
  * @param DataSource $ds
  * @return Schema
  */
 public static function get(DataSource $ds)
 {
     if ($ds->getDriver() == "mysql") {
         return self::mysql($ds);
     }
     if ($ds->getDriver() == "sqlite") {
         return self::sqlite($ds);
     }
 }
コード例 #2
0
ファイル: Migration.php プロジェクト: ryosukemiyazawa/lasa
 /**
  * @param Migration[]
  * @param string $connectionName
  */
 public static function run($migrations, $connectionName = null)
 {
     if (!is_array($migrations)) {
         $migrations = array($migrations);
     }
     $dataSource = \lasa\db\DataSource::getDataSource($connectionName);
     foreach ($migrations as $migration) {
         /* @var $migration Migration */
         //変更対象
         $dropTables = array();
         $createTables = array();
         $addColumns = array();
         $modifyColumns = array();
         $deleteColumns = array();
         //テーブルの定義を取得する
         $schema = Schema::get($dataSource);
         //実行する
         $migration->execute();
         foreach ($migration->tableList as $table) {
             if ($table->delete) {
                 $dropTables[] = $table;
                 continue;
             }
             //テーブル作成時のみ
             if ($table->check && !$schema->tableExists($table->getName())) {
                 continue;
             }
             //テーブル作成
             if (!$schema->tableExists($table->getName())) {
                 $createTables[] = $table;
                 continue;
             }
             //modify column
             $currentTable = $schema->table($table->getName());
             $lastColumnName = null;
             foreach ($table->columnNames() as $columnName) {
                 $column = $table->column($columnName);
                 $column->table = $table->getName();
                 $currentColumn = $currentTable->column($columnName);
                 //削除カラム
                 if ($column->delete) {
                     if ($currentColumn) {
                         $deleteColumns[] = $column;
                     }
                     continue;
                 }
                 //追加カラム
                 if (!$currentColumn) {
                     $addColumns[] = array($column, $lastColumnName);
                     $lastColumnName = $columnName;
                     continue;
                 }
                 $lastColumnName = $columnName;
                 if ($column->changed) {
                     $modifyColumns[] = $column;
                     continue;
                 }
                 //比較する
                 if (false == $column->compare($currentColumn)) {
                     $modifyColumns[] = $column;
                     continue;
                 }
             }
         }
         foreach ($dropTables as $table) {
             $sql = $schema->buildDeleteTableQuery($table);
             $dataSource->executeUpdateQuery($sql);
         }
         foreach ($createTables as $table) {
             $sql = $schema->buildCreateTableQuery($table);
             $dataSource->executeUpdateQuery($sql);
         }
         foreach ($addColumns as $array) {
             list($column, $prevous) = $array;
             $position = "";
             if ($prevous) {
                 $position = "AFTER " . $prevous;
             }
             $sql = $schema->buildAddColumnQuery($column, $position);
             $dataSource->executeUpdateQuery($sql);
         }
         foreach ($modifyColumns as $column) {
             $sql = $schema->buildModifyColumnQuery($column);
             $dataSource->executeUpdateQuery($sql);
         }
         foreach ($deleteColumns as $column) {
             $sql = $schema->buildDeleteColumnQuery($column);
             $dataSource->executeUpdateQuery($sql);
         }
     }
 }
コード例 #3
0
 function tearDown()
 {
     DataSource::getDataSource()->executeUpdateQuery("drop table if exists " . $this->tableName);
 }