@@ 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 |