@@ 467-474 (lines=8) @@ | ||
464 | } |
|
465 | } |
|
466 | ||
467 | public function columnExists() |
|
468 | { |
|
469 | foreach ($this->columns as $column) { |
|
470 | list($tableName, $columnName) = explode('.', $column); |
|
471 | $exists = $this->conn->executeQuery("SELECT count(*) AS count FROM information_schema.columns WHERE table_name = '${tableName}' AND column_name = '${columnName}';")->fetch()['count'] == 1; |
|
472 | $this->I->assertTrue($exists, 'カラムがあるはず '.$column); |
|
473 | } |
|
474 | } |
|
475 | ||
476 | public function columnNotExists() |
|
477 | { |
|
@@ 476-483 (lines=8) @@ | ||
473 | } |
|
474 | } |
|
475 | ||
476 | public function columnNotExists() |
|
477 | { |
|
478 | foreach ($this->columns as $column) { |
|
479 | list($tableName, $columnName) = explode('.', $column); |
|
480 | $exists = $this->conn->executeQuery("SELECT count(*) AS count FROM information_schema.columns WHERE table_name = '${tableName}' AND column_name = '${columnName}';")->fetch()['count'] == 1; |
|
481 | $this->I->assertFalse($exists, 'カラムがないはず '.$column); |
|
482 | } |
|
483 | } |
|
484 | ||
485 | public function traitExists() |
|
486 | { |