HuasoFoundries / phpPgAdmin6

     * @param string $name       (optional) The name to give the check, otherwise default name is assigned

     * @return \PHPPgAdmin\Database\A 0 success

     */

    public function addCheckConstraint($table, $definition, $name = '')

    {

        $f_schema = $this->_schema;

        $this->fieldClean($f_schema);

        $this->fieldClean($table);

        $this->fieldClean($name);

        // @@ How the heck do you clean a definition???

        $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD ";

        if ($name != '') {

            $sql .= "CONSTRAINT \"{$name}\" ";

        }

        $sql .= "CHECK ({$definition})";

        return $this->execute($sql);

    }

    /**

     * Drops a check constraint from a table

     * @param string $name       (optional) The name to give the check, otherwise default name is assigned

     * @return \PHPPgAdmin\Database\A 0 success

     */

    public function addDomainCheckConstraint($domain, $definition, $name = '')

    {

        $f_schema = $this->_schema;

        $this->fieldClean($f_schema);

        $this->fieldClean($domain);

        $this->fieldClean($name);

        $sql = "ALTER DOMAIN \"{$f_schema}\".\"{$domain}\" ADD ";

        if ($name != '') {

            $sql .= "CONSTRAINT \"{$name}\" ";

        }

        $sql .= "CHECK ({$definition})";

        return $this->execute($sql);

    }

    /**

     * Drops a domain constraint