HuasoFoundries /
phpPgAdmin6
| @@ 481-497 (lines=17) @@ | ||
| 478 | * |
|
| 479 | * @return int 0 if operation was successful |
|
| 480 | */ |
|
| 481 | public function alterSequenceName($seqrs, $name) |
|
| 482 | { |
|
| 483 | /* vars are cleaned in _alterSequence */ |
|
| 484 | if (!empty($name) && ($seqrs->fields['seqname'] != $name)) { |
|
| 485 | $f_schema = $this->_schema; |
|
| 486 | $this->fieldClean($f_schema); |
|
| 487 | $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" RENAME TO \"{$name}\""; |
|
| 488 | $status = $this->execute($sql); |
|
| 489 | if ($status == 0) { |
|
| 490 | $seqrs->fields['seqname'] = $name; |
|
| 491 | } else { |
|
| 492 | return $status; |
|
| 493 | } |
|
| 494 | } |
|
| 495 | ||
| 496 | return 0; |
|
| 497 | } |
|
| 498 | ||
| 499 | /** |
|
| 500 | * Alter a sequence's schema. |
|
| @@ 1185-1203 (lines=19) @@ | ||
| 1182 | * |
|
| 1183 | * @return int 0 if operation was successful |
|
| 1184 | */ |
|
| 1185 | public function alterTableName($tblrs, $name = null) |
|
| 1186 | { |
|
| 1187 | /* vars cleaned in _alterTable */ |
|
| 1188 | // Rename (only if name has changed) |
|
| 1189 | if (!empty($name) && ($name != $tblrs->fields['relname'])) { |
|
| 1190 | $f_schema = $this->_schema; |
|
| 1191 | $this->fieldClean($f_schema); |
|
| 1192 | ||
| 1193 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$tblrs->fields['relname']}\" RENAME TO \"{$name}\""; |
|
| 1194 | $status = $this->execute($sql); |
|
| 1195 | if ($status == 0) { |
|
| 1196 | $tblrs->fields['relname'] = $name; |
|
| 1197 | } else { |
|
| 1198 | return $status; |
|
| 1199 | } |
|
| 1200 | } |
|
| 1201 | ||
| 1202 | return 0; |
|
| 1203 | } |
|
| 1204 | ||
| 1205 | // Row functions |
|
| 1206 | ||
| @@ 84-100 (lines=17) @@ | ||
| 81 | * |
|
| 82 | * @return int 0 if operation was successful |
|
| 83 | */ |
|
| 84 | public function alterSequenceName($seqrs, $name) |
|
| 85 | { |
|
| 86 | /* vars are cleaned in _alterSequence */ |
|
| 87 | if (!empty($name) && ($seqrs->fields['seqname'] != $name)) { |
|
| 88 | $f_schema = $this->_schema; |
|
| 89 | $this->fieldClean($f_schema); |
|
| 90 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" RENAME TO \"{$name}\""; |
|
| 91 | $status = $this->execute($sql); |
|
| 92 | if ($status == 0) { |
|
| 93 | $seqrs->fields['seqname'] = $name; |
|
| 94 | } else { |
|
| 95 | return $status; |
|
| 96 | } |
|
| 97 | } |
|
| 98 | ||
| 99 | return 0; |
|
| 100 | } |
|
| 101 | ||
| 102 | // View functions |
|
| 103 | ||
| @@ 112-129 (lines=18) @@ | ||
| 109 | * |
|
| 110 | * @return int -1 if Failed |
|
| 111 | */ |
|
| 112 | public function alterViewName($vwrs, $name) |
|
| 113 | { |
|
| 114 | // Rename (only if name has changed) |
|
| 115 | /* $vwrs and $name are cleaned in _alterView */ |
|
| 116 | if (!empty($name) && ($name != $vwrs->fields['relname'])) { |
|
| 117 | $f_schema = $this->_schema; |
|
| 118 | $this->fieldClean($f_schema); |
|
| 119 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$vwrs->fields['relname']}\" RENAME TO \"{$name}\""; |
|
| 120 | $status = $this->execute($sql); |
|
| 121 | if ($status == 0) { |
|
| 122 | $vwrs->fields['relname'] = $name; |
|
| 123 | } else { |
|
| 124 | return $status; |
|
| 125 | } |
|
| 126 | } |
|
| 127 | ||
| 128 | return 0; |
|
| 129 | } |
|
| 130 | ||
| 131 | // Trigger functions |
|
| 132 | ||
