HuasoFoundries /
phpPgAdmin6
| @@ 2819-2831 (lines=13) @@ | ||
| 2816 | * @param $cascade True to cascade drop, false to restrict |
|
| 2817 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 2818 | */ |
|
| 2819 | public function dropTable($table, $cascade) |
|
| 2820 | { |
|
| 2821 | $f_schema = $this->_schema; |
|
| 2822 | $this->fieldClean($f_schema); |
|
| 2823 | $this->fieldClean($table); |
|
| 2824 | ||
| 2825 | $sql = "DROP TABLE \"{$f_schema}\".\"{$table}\""; |
|
| 2826 | if ($cascade) { |
|
| 2827 | $sql .= ' CASCADE'; |
|
| 2828 | } |
|
| 2829 | ||
| 2830 | return $this->execute($sql); |
|
| 2831 | } |
|
| 2832 | ||
| 2833 | /** |
|
| 2834 | * Add a new column to a table |
|
| @@ 3079-3089 (lines=11) @@ | ||
| 3076 | * @param $default The new default value |
|
| 3077 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 3078 | */ |
|
| 3079 | public function setColumnDefault($table, $column, $default) |
|
| 3080 | { |
|
| 3081 | $f_schema = $this->_schema; |
|
| 3082 | $this->fieldClean($f_schema); |
|
| 3083 | $this->fieldClean($table); |
|
| 3084 | $this->fieldClean($column); |
|
| 3085 | ||
| 3086 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ALTER COLUMN \"{$column}\" SET DEFAULT {$default}"; |
|
| 3087 | ||
| 3088 | return $this->execute($sql); |
|
| 3089 | } |
|
| 3090 | ||
| 3091 | /** |
|
| 3092 | * Sets whether or not a column can contain NULLs |
|
| @@ 3119-3132 (lines=14) @@ | ||
| 3116 | * @param $cascade True to cascade drop, false to restrict |
|
| 3117 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 3118 | */ |
|
| 3119 | public function dropColumn($table, $column, $cascade) |
|
| 3120 | { |
|
| 3121 | $f_schema = $this->_schema; |
|
| 3122 | $this->fieldClean($f_schema); |
|
| 3123 | $this->fieldClean($table); |
|
| 3124 | $this->fieldClean($column); |
|
| 3125 | ||
| 3126 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" DROP COLUMN \"{$column}\""; |
|
| 3127 | if ($cascade) { |
|
| 3128 | $sql .= ' CASCADE'; |
|
| 3129 | } |
|
| 3130 | ||
| 3131 | return $this->execute($sql); |
|
| 3132 | } |
|
| 3133 | ||
| 3134 | /** |
|
| 3135 | * Drops default value of a column |
|
| @@ 3141-3151 (lines=11) @@ | ||
| 3138 | * @param $column The column name to drop default |
|
| 3139 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 3140 | */ |
|
| 3141 | public function dropColumnDefault($table, $column) |
|
| 3142 | { |
|
| 3143 | $f_schema = $this->_schema; |
|
| 3144 | $this->fieldClean($f_schema); |
|
| 3145 | $this->fieldClean($table); |
|
| 3146 | $this->fieldClean($column); |
|
| 3147 | ||
| 3148 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ALTER COLUMN \"{$column}\" DROP DEFAULT"; |
|
| 3149 | ||
| 3150 | return $this->execute($sql); |
|
| 3151 | } |
|
| 3152 | ||
| 3153 | /** |
|
| 3154 | * Sets up the data object for a dump. eg. Starts the appropriate |
|
| @@ 3650-3660 (lines=11) @@ | ||
| 3647 | * @param $sequence Sequence name |
|
| 3648 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 3649 | */ |
|
| 3650 | public function restartSequence($sequence) |
|
| 3651 | { |
|
| 3652 | $f_schema = $this->_schema; |
|
| 3653 | $this->fieldClean($f_schema); |
|
| 3654 | $this->fieldClean($sequence); |
|
| 3655 | ||
| 3656 | $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$sequence}\" RESTART;"; |
|
| 3657 | ||
| 3658 | return $this->execute($sql); |
|
| 3659 | } |
|
| 3660 | ||
| 3661 | /** |
|
| 3662 | * Resets a given sequence to min value of sequence |
|
| 3663 | * |
|
| @@ 4054-4066 (lines=13) @@ | ||
| 4051 | * @param $cascade True to cascade drop, false to restrict |
|
| 4052 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 4053 | */ |
|
| 4054 | public function dropSequence($sequence, $cascade) |
|
| 4055 | { |
|
| 4056 | $f_schema = $this->_schema; |
|
| 4057 | $this->fieldClean($f_schema); |
|
| 4058 | $this->fieldClean($sequence); |
|
| 4059 | ||
| 4060 | $sql = "DROP SEQUENCE \"{$f_schema}\".\"{$sequence}\""; |
|
| 4061 | if ($cascade) { |
|
| 4062 | $sql .= ' CASCADE'; |
|
| 4063 | } |
|
| 4064 | ||
| 4065 | return $this->execute($sql); |
|
| 4066 | } |
|
| 4067 | ||
| 4068 | /** |
|
| 4069 | * Returns a list of all views in the database |
|
| @@ 4355-4367 (lines=13) @@ | ||
| 4352 | * @param $cascade True to cascade drop, false to restrict |
|
| 4353 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 4354 | */ |
|
| 4355 | public function dropView($viewname, $cascade) |
|
| 4356 | { |
|
| 4357 | $f_schema = $this->_schema; |
|
| 4358 | $this->fieldClean($f_schema); |
|
| 4359 | $this->fieldClean($viewname); |
|
| 4360 | ||
| 4361 | $sql = "DROP VIEW \"{$f_schema}\".\"{$viewname}\""; |
|
| 4362 | if ($cascade) { |
|
| 4363 | $sql .= ' CASCADE'; |
|
| 4364 | } |
|
| 4365 | ||
| 4366 | return $this->execute($sql); |
|
| 4367 | } |
|
| 4368 | ||
| 4369 | // Domain functions |
|
| 4370 | ||
| @@ 4458-4470 (lines=13) @@ | ||
| 4455 | * @param $cascade True to cascade drop, false to restrict |
|
| 4456 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 4457 | */ |
|
| 4458 | public function dropIndex($index, $cascade) |
|
| 4459 | { |
|
| 4460 | $f_schema = $this->_schema; |
|
| 4461 | $this->fieldClean($f_schema); |
|
| 4462 | $this->fieldClean($index); |
|
| 4463 | ||
| 4464 | $sql = "DROP INDEX \"{$f_schema}\".\"{$index}\""; |
|
| 4465 | if ($cascade) { |
|
| 4466 | $sql .= ' CASCADE'; |
|
| 4467 | } |
|
| 4468 | ||
| 4469 | return $this->execute($sql); |
|
| 4470 | } |
|
| 4471 | ||
| 4472 | /** |
|
| 4473 | * Rebuild indexes |
|
| @@ 4848-4861 (lines=14) @@ | ||
| 4845 | * @param $cascade True to cascade drop, false to restrict |
|
| 4846 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 4847 | */ |
|
| 4848 | public function dropConstraint($constraint, $relation, $type, $cascade) |
|
| 4849 | { |
|
| 4850 | $f_schema = $this->_schema; |
|
| 4851 | $this->fieldClean($f_schema); |
|
| 4852 | $this->fieldClean($constraint); |
|
| 4853 | $this->fieldClean($relation); |
|
| 4854 | ||
| 4855 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$relation}\" DROP CONSTRAINT \"{$constraint}\""; |
|
| 4856 | if ($cascade) { |
|
| 4857 | $sql .= ' CASCADE'; |
|
| 4858 | } |
|
| 4859 | ||
| 4860 | return $this->execute($sql); |
|
| 4861 | } |
|
| 4862 | ||
| 4863 | /** |
|
| 4864 | * A function for getting all columns linked by foreign keys given a group of tables |
|
| @@ 5225-5237 (lines=13) @@ | ||
| 5222 | * @param $cascade True to cascade drop, false to restrict |
|
| 5223 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 5224 | */ |
|
| 5225 | public function dropDomain($domain, $cascade) |
|
| 5226 | { |
|
| 5227 | $f_schema = $this->_schema; |
|
| 5228 | $this->fieldClean($f_schema); |
|
| 5229 | $this->fieldClean($domain); |
|
| 5230 | ||
| 5231 | $sql = "DROP DOMAIN \"{$f_schema}\".\"{$domain}\""; |
|
| 5232 | if ($cascade) { |
|
| 5233 | $sql .= ' CASCADE'; |
|
| 5234 | } |
|
| 5235 | ||
| 5236 | return $this->execute($sql); |
|
| 5237 | } |
|
| 5238 | ||
| 5239 | /** |
|
| 5240 | * Adds a check constraint to a domain |
|
| @@ 5272-5285 (lines=14) @@ | ||
| 5269 | * @param $cascade True to cascade, false otherwise |
|
| 5270 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 5271 | */ |
|
| 5272 | public function dropDomainConstraint($domain, $constraint, $cascade) |
|
| 5273 | { |
|
| 5274 | $f_schema = $this->_schema; |
|
| 5275 | $this->fieldClean($f_schema); |
|
| 5276 | $this->fieldClean($domain); |
|
| 5277 | $this->fieldClean($constraint); |
|
| 5278 | ||
| 5279 | $sql = "ALTER DOMAIN \"{$f_schema}\".\"{$domain}\" DROP CONSTRAINT \"{$constraint}\""; |
|
| 5280 | if ($cascade) { |
|
| 5281 | $sql .= ' CASCADE'; |
|
| 5282 | } |
|
| 5283 | ||
| 5284 | return $this->execute($sql); |
|
| 5285 | } |
|
| 5286 | ||
| 5287 | // Rule functions |
|
| 5288 | ||
| @@ 5751-5763 (lines=13) @@ | ||
| 5748 | * @param $cascade True to cascade drop, false to restrict |
|
| 5749 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 5750 | */ |
|
| 5751 | public function dropType($typname, $cascade) |
|
| 5752 | { |
|
| 5753 | $f_schema = $this->_schema; |
|
| 5754 | $this->fieldClean($f_schema); |
|
| 5755 | $this->fieldClean($typname); |
|
| 5756 | ||
| 5757 | $sql = "DROP TYPE \"{$f_schema}\".\"{$typname}\""; |
|
| 5758 | if ($cascade) { |
|
| 5759 | $sql .= ' CASCADE'; |
|
| 5760 | } |
|
| 5761 | ||
| 5762 | return $this->execute($sql); |
|
| 5763 | } |
|
| 5764 | ||
| 5765 | /** |
|
| 5766 | * Creates a new enum type in the database |
|
| @@ 6106-6119 (lines=14) @@ | ||
| 6103 | * @param $cascade True to cascade drop, false to restrict |
|
| 6104 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 6105 | */ |
|
| 6106 | public function dropRule($rule, $relation, $cascade) |
|
| 6107 | { |
|
| 6108 | $f_schema = $this->_schema; |
|
| 6109 | $this->fieldClean($f_schema); |
|
| 6110 | $this->fieldClean($rule); |
|
| 6111 | $this->fieldClean($relation); |
|
| 6112 | ||
| 6113 | $sql = "DROP RULE \"{$rule}\" ON \"{$f_schema}\".\"{$relation}\""; |
|
| 6114 | if ($cascade) { |
|
| 6115 | $sql .= ' CASCADE'; |
|
| 6116 | } |
|
| 6117 | ||
| 6118 | return $this->execute($sql); |
|
| 6119 | } |
|
| 6120 | ||
| 6121 | /** |
|
| 6122 | * Grabs a single trigger |
|
| @@ 6383-6396 (lines=14) @@ | ||
| 6380 | * @param $cascade True to cascade drop, false to restrict |
|
| 6381 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 6382 | */ |
|
| 6383 | public function dropTrigger($tgname, $table, $cascade) |
|
| 6384 | { |
|
| 6385 | $f_schema = $this->_schema; |
|
| 6386 | $this->fieldClean($f_schema); |
|
| 6387 | $this->fieldClean($tgname); |
|
| 6388 | $this->fieldClean($table); |
|
| 6389 | ||
| 6390 | $sql = "DROP TRIGGER \"{$tgname}\" ON \"{$f_schema}\".\"{$table}\""; |
|
| 6391 | if ($cascade) { |
|
| 6392 | $sql .= ' CASCADE'; |
|
| 6393 | } |
|
| 6394 | ||
| 6395 | return $this->execute($sql); |
|
| 6396 | } |
|
| 6397 | ||
| 6398 | /** |
|
| 6399 | * Enables a trigger |
|
| @@ 6405-6415 (lines=11) @@ | ||
| 6402 | * @param $table The table in which to enable the trigger |
|
| 6403 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 6404 | */ |
|
| 6405 | public function enableTrigger($tgname, $table) |
|
| 6406 | { |
|
| 6407 | $f_schema = $this->_schema; |
|
| 6408 | $this->fieldClean($f_schema); |
|
| 6409 | $this->fieldClean($tgname); |
|
| 6410 | $this->fieldClean($table); |
|
| 6411 | ||
| 6412 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ENABLE TRIGGER \"{$tgname}\""; |
|
| 6413 | ||
| 6414 | return $this->execute($sql); |
|
| 6415 | } |
|
| 6416 | ||
| 6417 | /** |
|
| 6418 | * Disables a trigger |
|
| @@ 6424-6434 (lines=11) @@ | ||
| 6421 | * @param $table The table in which to disable the trigger |
|
| 6422 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 6423 | */ |
|
| 6424 | public function disableTrigger($tgname, $table) |
|
| 6425 | { |
|
| 6426 | $f_schema = $this->_schema; |
|
| 6427 | $this->fieldClean($f_schema); |
|
| 6428 | $this->fieldClean($tgname); |
|
| 6429 | $this->fieldClean($table); |
|
| 6430 | ||
| 6431 | $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" DISABLE TRIGGER \"{$tgname}\""; |
|
| 6432 | ||
| 6433 | return $this->execute($sql); |
|
| 6434 | } |
|
| 6435 | ||
| 6436 | /** |
|
| 6437 | * Returns a list of all operators in the database |
|
| @@ 6785-6797 (lines=13) @@ | ||
| 6782 | * @param $cascade Cascade to dependenced objects |
|
| 6783 | * @return \PHPPgAdmin\Database\A 0 on success |
|
| 6784 | */ |
|
| 6785 | public function dropFtsConfiguration($ftscfg, $cascade) |
|
| 6786 | { |
|
| 6787 | $f_schema = $this->_schema; |
|
| 6788 | $this->fieldClean($f_schema); |
|
| 6789 | $this->fieldClean($ftscfg); |
|
| 6790 | ||
| 6791 | $sql = "DROP TEXT SEARCH CONFIGURATION \"{$f_schema}\".\"{$ftscfg}\""; |
|
| 6792 | if ($cascade) { |
|
| 6793 | $sql .= ' CASCADE'; |
|
| 6794 | } |
|
| 6795 | ||
| 6796 | return $this->execute($sql); |
|
| 6797 | } |
|
| 6798 | ||
| 6799 | /** |
|
| 6800 | * Drops FTS dictionary |
|
| @@ 6807-6820 (lines=14) @@ | ||
| 6804 | * @return \PHPPgAdmin\Database\A 0 on success |
|
| 6805 | * @todo Support of dictionary templates dropping |
|
| 6806 | */ |
|
| 6807 | public function dropFtsDictionary($ftsdict, $cascade) |
|
| 6808 | { |
|
| 6809 | $f_schema = $this->_schema; |
|
| 6810 | $this->fieldClean($f_schema); |
|
| 6811 | $this->fieldClean($ftsdict); |
|
| 6812 | ||
| 6813 | $sql = 'DROP TEXT SEARCH DICTIONARY'; |
|
| 6814 | $sql .= " \"{$f_schema}\".\"{$ftsdict}\""; |
|
| 6815 | if ($cascade) { |
|
| 6816 | $sql .= ' CASCADE'; |
|
| 6817 | } |
|
| 6818 | ||
| 6819 | return $this->execute($sql); |
|
| 6820 | } |
|
| 6821 | ||
| 6822 | /** |
|
| 6823 | * Alters FTS configuration |
|
| @@ 7260-7273 (lines=14) @@ | ||
| 7257 | * @param $cascade True to cascade drop, false to restrict |
|
| 7258 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 7259 | */ |
|
| 7260 | public function dropAggregate($aggrname, $aggrtype, $cascade) |
|
| 7261 | { |
|
| 7262 | $f_schema = $this->_schema; |
|
| 7263 | $this->fieldClean($f_schema); |
|
| 7264 | $this->fieldClean($aggrname); |
|
| 7265 | $this->fieldClean($aggrtype); |
|
| 7266 | ||
| 7267 | $sql = "DROP AGGREGATE \"{$f_schema}\".\"{$aggrname}\" (\"{$aggrtype}\")"; |
|
| 7268 | if ($cascade) { |
|
| 7269 | $sql .= ' CASCADE'; |
|
| 7270 | } |
|
| 7271 | ||
| 7272 | return $this->execute($sql); |
|
| 7273 | } |
|
| 7274 | ||
| 7275 | /** |
|
| 7276 | * Gets all information for an aggregate |
|
| @@ 7413-7422 (lines=10) @@ | ||
| 7410 | * @param $newaggrowner The new owner of the aggregate |
|
| 7411 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 7412 | */ |
|
| 7413 | public function changeAggregateOwner($aggrname, $aggrtype, $newaggrowner) |
|
| 7414 | { |
|
| 7415 | $f_schema = $this->_schema; |
|
| 7416 | $this->fieldClean($f_schema); |
|
| 7417 | $this->fieldClean($aggrname); |
|
| 7418 | $this->fieldClean($newaggrowner); |
|
| 7419 | $sql = "ALTER AGGREGATE \"{$f_schema}\".\"{$aggrname}\" (\"{$aggrtype}\") OWNER TO \"{$newaggrowner}\""; |
|
| 7420 | ||
| 7421 | return $this->execute($sql); |
|
| 7422 | } |
|
| 7423 | ||
| 7424 | /** |
|
| 7425 | * Changes the schema of an aggregate function |
|
| @@ 7432-7441 (lines=10) @@ | ||
| 7429 | * @param $newaggrschema The new schema for the aggregate |
|
| 7430 | * @return \PHPPgAdmin\Database\A 0 success |
|
| 7431 | */ |
|
| 7432 | public function changeAggregateSchema($aggrname, $aggrtype, $newaggrschema) |
|
| 7433 | { |
|
| 7434 | $f_schema = $this->_schema; |
|
| 7435 | $this->fieldClean($f_schema); |
|
| 7436 | $this->fieldClean($aggrname); |
|
| 7437 | $this->fieldClean($newaggrschema); |
|
| 7438 | $sql = "ALTER AGGREGATE \"{$f_schema}\".\"{$aggrname}\" (\"{$aggrtype}\") SET SCHEMA \"{$newaggrschema}\""; |
|
| 7439 | ||
| 7440 | return $this->execute($sql); |
|
| 7441 | } |
|
| 7442 | ||
| 7443 | /** |
|
| 7444 | * Renames an aggregate function |
|
| @@ 8503-8516 (lines=14) @@ | ||
| 8500 | * @param $table (optional) The table to analyze |
|
| 8501 | * @return \PHPPgAdmin\Database\A |
|
| 8502 | */ |
|
| 8503 | public function analyzeDB($table = '') |
|
| 8504 | { |
|
| 8505 | if ($table != '') { |
|
| 8506 | $f_schema = $this->_schema; |
|
| 8507 | $this->fieldClean($f_schema); |
|
| 8508 | $this->fieldClean($table); |
|
| 8509 | ||
| 8510 | $sql = "ANALYZE \"{$f_schema}\".\"{$table}\""; |
|
| 8511 | } else { |
|
| 8512 | $sql = 'ANALYZE'; |
|
| 8513 | } |
|
| 8514 | ||
| 8515 | return $this->execute($sql); |
|
| 8516 | } |
|
| 8517 | ||
| 8518 | /** |
|
| 8519 | * Vacuums a database |
|
