HuasoFoundries /
phpPgAdmin6
| @@ 105-122 (lines=18) @@ | ||
| 102 | * |
|
| 103 | * @return int|\PHPPgAdmin\Database\A -1 Failed |
|
| 104 | */ |
|
| 105 | public function alterViewName($vwrs, $name) |
|
| 106 | { |
|
| 107 | // Rename (only if name has changed) |
|
| 108 | /* $vwrs and $name are cleaned in _alterView */ |
|
| 109 | if (!empty($name) && ($name != $vwrs->fields['relname'])) { |
|
| 110 | $f_schema = $this->_schema; |
|
| 111 | $this->fieldClean($f_schema); |
|
| 112 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$vwrs->fields['relname']}\" RENAME TO \"{$name}\""; |
|
| 113 | $status = $this->execute($sql); |
|
| 114 | if ($status == 0) { |
|
| 115 | $vwrs->fields['relname'] = $name; |
|
| 116 | } else { |
|
| 117 | return $status; |
|
| 118 | } |
|
| 119 | } |
|
| 120 | ||
| 121 | return 0; |
|
| 122 | } |
|
| 123 | ||
| 124 | // Trigger functions |
|
| 125 | ||
| @@ 77-93 (lines=17) @@ | ||
| 74 | * |
|
| 75 | * @return int|\PHPPgAdmin\Database\A 0 success |
|
| 76 | */ |
|
| 77 | public function alterSequenceName($seqrs, $name) |
|
| 78 | { |
|
| 79 | /* vars are cleaned in _alterSequence */ |
|
| 80 | if (!empty($name) && ($seqrs->fields['seqname'] != $name)) { |
|
| 81 | $f_schema = $this->_schema; |
|
| 82 | $this->fieldClean($f_schema); |
|
| 83 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" RENAME TO \"{$name}\""; |
|
| 84 | $status = $this->execute($sql); |
|
| 85 | if ($status == 0) { |
|
| 86 | $seqrs->fields['seqname'] = $name; |
|
| 87 | } else { |
|
| 88 | return $status; |
|
| 89 | } |
|
| 90 | } |
|
| 91 | ||
| 92 | return 0; |
|
| 93 | } |
|
| 94 | ||
| 95 | // View functions |
|
| 96 | ||
| @@ 2801-2819 (lines=19) @@ | ||
| 2798 | * |
|
| 2799 | * @return int|\PHPPgAdmin\Database\A 0 success |
|
| 2800 | */ |
|
| 2801 | public function alterTableName($tblrs, $name = null) |
|
| 2802 | { |
|
| 2803 | /* vars cleaned in _alterTable */ |
|
| 2804 | // Rename (only if name has changed) |
|
| 2805 | if (!empty($name) && ($name != $tblrs->fields['relname'])) { |
|
| 2806 | $f_schema = $this->_schema; |
|
| 2807 | $this->fieldClean($f_schema); |
|
| 2808 | ||
| 2809 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$tblrs->fields['relname']}\" RENAME TO \"{$name}\""; |
|
| 2810 | $status = $this->execute($sql); |
|
| 2811 | if ($status == 0) { |
|
| 2812 | $tblrs->fields['relname'] = $name; |
|
| 2813 | } else { |
|
| 2814 | return $status; |
|
| 2815 | } |
|
| 2816 | } |
|
| 2817 | ||
| 2818 | return 0; |
|
| 2819 | } |
|
| 2820 | ||
| 2821 | // Row functions |
|
| 2822 | ||
| @@ 4092-4108 (lines=17) @@ | ||
| 4089 | * |
|
| 4090 | * @return int|\PHPPgAdmin\Database\A 0 success |
|
| 4091 | */ |
|
| 4092 | public function alterSequenceName($seqrs, $name) |
|
| 4093 | { |
|
| 4094 | /* vars are cleaned in _alterSequence */ |
|
| 4095 | if (!empty($name) && ($seqrs->fields['seqname'] != $name)) { |
|
| 4096 | $f_schema = $this->_schema; |
|
| 4097 | $this->fieldClean($f_schema); |
|
| 4098 | $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" RENAME TO \"{$name}\""; |
|
| 4099 | $status = $this->execute($sql); |
|
| 4100 | if ($status == 0) { |
|
| 4101 | $seqrs->fields['seqname'] = $name; |
|
| 4102 | } else { |
|
| 4103 | return $status; |
|
| 4104 | } |
|
| 4105 | } |
|
| 4106 | ||
| 4107 | return 0; |
|
| 4108 | } |
|
| 4109 | ||
| 4110 | /** |
|
| 4111 | * Alter a sequence's schema. |
|
| @@ 4401-4418 (lines=18) @@ | ||
| 4398 | * |
|
| 4399 | * @return int|\PHPPgAdmin\Database\A 0 success |
|
| 4400 | */ |
|
| 4401 | public function alterViewName($vwrs, $name) |
|
| 4402 | { |
|
| 4403 | // Rename (only if name has changed) |
|
| 4404 | /* $vwrs and $name are cleaned in _alterView */ |
|
| 4405 | if (!empty($name) && ($name != $vwrs->fields['relname'])) { |
|
| 4406 | $f_schema = $this->_schema; |
|
| 4407 | $this->fieldClean($f_schema); |
|
| 4408 | $sql = "ALTER VIEW \"{$f_schema}\".\"{$vwrs->fields['relname']}\" RENAME TO \"{$name}\""; |
|
| 4409 | $status = $this->execute($sql); |
|
| 4410 | if ($status == 0) { |
|
| 4411 | $vwrs->fields['relname'] = $name; |
|
| 4412 | } else { |
|
| 4413 | return $status; |
|
| 4414 | } |
|
| 4415 | } |
|
| 4416 | ||
| 4417 | return 0; |
|
| 4418 | } |
|
| 4419 | ||
| 4420 | /** |
|
| 4421 | * Alter a view's schema. |
|
