HuasoFoundries / phpPgAdmin6

     *

     * @internal param \PHPPgAdmin\Database\The $name new table's owner

     */

    public function alterTableOwner($tblrs, $owner = null)

    {

        /* vars cleaned in _alterTable */

        if (!empty($owner) && ($tblrs->fields['relowner'] != $owner)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            // If owner has been changed, then do the alteration.  We are

            // careful to avoid this generally as changing owner is a

            // superuser only function.

            $sql = "ALTER TABLE \"{$f_schema}\".\"{$tblrs->fields['relname']}\" OWNER TO \"{$owner}\"";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Alter a table's tablespace

     *

     * @internal param \PHPPgAdmin\Database\The $name new table's tablespace

     */

    public function alterTableTablespace($tblrs, $tablespace = null)

    {

        /* vars cleaned in _alterTable */

        if (!empty($tablespace) && ($tblrs->fields['tablespace'] != $tablespace)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            // If tablespace has been changed, then do the alteration.  We

            // don't want to do this unnecessarily.

            $sql = "ALTER TABLE \"{$f_schema}\".\"{$tblrs->fields['relname']}\" SET TABLESPACE \"{$tablespace}\"";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Alter a table's name

     *

     * @internal param \PHPPgAdmin\Database\The $name new table's schema

     */

    public function alterTableSchema($tblrs, $schema = null)

    {

        /* vars cleaned in _alterTable */

        if (!empty($schema) && ($tblrs->fields['nspname'] != $schema)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            // If tablespace has been changed, then do the alteration.  We

            // don't want to do this unnecessarily.

            $sql = "ALTER TABLE \"{$f_schema}\".\"{$tblrs->fields['relname']}\" SET SCHEMA \"{$schema}\"";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Empties a table in the database.

     *

     * @internal param \PHPPgAdmin\Database\The $name new owner for the sequence

     */

    public function alterSequenceOwner($seqrs, $owner)

    {

        // If owner has been changed, then do the alteration.  We are

        // careful to avoid this generally as changing owner is a

        // superuser only function.

        /* vars are cleaned in _alterSequence */

        if (!empty($owner) && ($seqrs->fields['seqowner'] != $owner)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" OWNER TO \"{$owner}\"";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Alter a sequence's properties.

     *

     * @internal param \PHPPgAdmin\Database\The $name new schema for the sequence

     */

    public function alterSequenceSchema($seqrs, $schema)

    {

        /* vars are cleaned in _alterSequence */

        if (!empty($schema) && ($seqrs->fields['nspname'] != $schema)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" SET SCHEMA {$schema}";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Drops a given sequence.

     *

     * @internal param \PHPPgAdmin\Database\The $name new view's owner

     */

    public function alterViewOwner($vwrs, $owner = null)

    {

        /* $vwrs and $owner are cleaned in _alterView */

        if ((!empty($owner)) && ($vwrs->fields['relowner'] != $owner)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            // If owner has been changed, then do the alteration.  We are

            // careful to avoid this generally as changing owner is a

            // superuser only function.

            $sql = "ALTER TABLE \"{$f_schema}\".\"{$vwrs->fields['relname']}\" OWNER TO \"{$owner}\"";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Rename a view.

     *

     * @internal param \PHPPgAdmin\Database\The $name new view's schema

     */

    public function alterViewSchema($vwrs, $schema)

    {

        /* $vwrs and $schema are cleaned in _alterView */

        if (!empty($schema) && ($vwrs->fields['nspname'] != $schema)) {

            $f_schema = $this->_schema;

            $this->fieldClean($f_schema);

            // If tablespace has been changed, then do the alteration.  We

            // don't want to do this unnecessarily.

            $sql = "ALTER TABLE \"{$f_schema}\".\"{$vwrs->fields['relname']}\" SET SCHEMA \"{$schema}\"";

            return $this->execute($sql);

        }

        return 0;

    }

    /**

     * Drops a view.

         *

         * @internal param \PHPPgAdmin\Database\The $name new owner for the sequence

         */

        public function alterSequenceOwner($seqrs, $owner)

        {

            // If owner has been changed, then do the alteration.  We are

            // careful to avoid this generally as changing owner is a

            // superuser only function.

            /* vars are cleaned in _alterSequence */

            if (!empty($owner) && ($seqrs->fields['seqowner'] != $owner)) {

                $f_schema = $this->_schema;

                $this->fieldClean($f_schema);

                $sql = "ALTER TABLE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" OWNER TO \"{$owner}\"";

                return $this->execute($sql);

            }

            return 0;

        }

        // Function functions