Postgres::alterSequenceProps PHP Method

alterSequenceProps() public method

Alter a sequence's properties
public alterSequenceProps ( $seqrs, $increment, $minvalue, $maxvalue, $restartvalue, $cachevalue, $cycledvalue, $startvalue )
$seqrs The sequence RecordSet returned by getSequence()
$increment The sequence incremental value
$minvalue The sequence minimum value
$maxvalue The sequence maximum value
$restartvalue The sequence current value
$cachevalue The sequence cache value
$cycledvalue Sequence can cycle ?
$startvalue The sequence start value when issueing a restart
    function alterSequenceProps($seqrs, $increment, $minvalue, $maxvalue, $restartvalue, $cachevalue, $cycledvalue, $startvalue)
    {
        $sql = '';
        /* vars are cleaned in _alterSequence */
        if (!empty($increment) && $increment != $seqrs->fields['increment_by']) {
            $sql .= " INCREMENT {$increment}";
        }
        if (!empty($minvalue) && $minvalue != $seqrs->fields['min_value']) {
            $sql .= " MINVALUE {$minvalue}";
        }
        if (!empty($maxvalue) && $maxvalue != $seqrs->fields['max_value']) {
            $sql .= " MAXVALUE {$maxvalue}";
        }
        if (!empty($restartvalue) && $restartvalue != $seqrs->fields['last_value']) {
            $sql .= " RESTART {$restartvalue}";
        }
        if (!empty($cachevalue) && $cachevalue != $seqrs->fields['cache_value']) {
            $sql .= " CACHE {$cachevalue}";
        }
        if (!empty($startvalue) && $startvalue != $seqrs->fields['start_value']) {
            $sql .= " START {$startvalue}";
        }
        // toggle cycle yes/no
        if (!is_null($cycledvalue)) {
            $sql .= (!$cycledvalue ? ' NO ' : '') . " CYCLE";
        }
        if ($sql != '') {
            $f_schema = $this->_schema;
            $this->fieldClean($f_schema);
            $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" {$sql}";
            return $this->execute($sql);
        }
        return 0;
    }
Postgres