| @@ 57-66 (lines=10) @@ | ||
| 54 | * |
|
| 55 | * @return array |
|
| 56 | */ |
|
| 57 | public function getDropColumn(TableNodeInterface $table, $column) |
|
| 58 | { |
|
| 59 | return [ |
|
| 60 | $this->format( |
|
| 61 | 'ALTER TABLE {table:schema|q}.{table:table|q} DROP COLUMN {column|q}', |
|
| 62 | ['table' => $table, 'column' => $column,] |
|
| 63 | ), |
|
| 64 | [], |
|
| 65 | ]; |
|
| 66 | } |
|
| 67 | ||
| 68 | /** |
|
| 69 | * @param TableNodeInterface $table |
|
| @@ 96-109 (lines=14) @@ | ||
| 93 | * |
|
| 94 | * @return array |
|
| 95 | */ |
|
| 96 | public function getDeleteFromTable(TableNodeInterface $table, $where = null) |
|
| 97 | { |
|
| 98 | return [ |
|
| 99 | $this->format( |
|
| 100 | 'DELETE FROM {table:schema|q}.{table:table|q} |
|
| 101 | {where}', |
|
| 102 | [ |
|
| 103 | 'table' => $table, |
|
| 104 | 'where' => ($where ? 'WHERE ' . $where : ''), |
|
| 105 | ] |
|
| 106 | ), |
|
| 107 | [], |
|
| 108 | ]; |
|
| 109 | } |
|
| 110 | ||
| 111 | /** |
|
| 112 | * @param TableNodeInterface $from |
|