db2Sequence.php

Go to the documentation of this file.

<?php

/**
 * DB2 database sequence class
 *
 * @package objSQL
 * @version 2.1.0
 * @author MT Jordan <mtjo62@gmail.com>
 * @link http://objsql.sourceforge.net
 * @copyright 2004-2010 openSource Partners
 * @license LGPL
 * @revision $Id: db2Sequence.php,v 1.7 2008-01-27 12:52:19-05 mt_jordan Exp $
 */

class db2Sequence
{
    /**********************************************
     * Internal variables
     *********************************************/

    /**
     * Database connection object
     *
     * @access private
     * @var    mixed
     */
    private $objConnection;

    /**
     * Sequence maximum value
     *
     * @access private
     * @var    int
     */
    private $objMax;

    /**
     * Sequence name
     *
     * @access private
     * @var    str
     */
    private $objSequence;

    /**********************************************
     * Class methods
     *********************************************/

    /**
     * Constructor
     *
     * @access public
     * @param  str   $sequence
     * @param  int   $max
     * @param  mixed $connection
     */
    public function __construct( $sequence, $max, $connection )
    {
        $this->objConnection = $connection;
        $this->objMax        = $max;
        $this->objSequence   = $sequence;
    }

    /**
     * Return int value for named sequence
     *
     * @access public
     * @return int
     */
    public function getSequence()
    {
        $objStmt = db2_exec( $this->objConnection, 'SELECT NEXTVAL FOR ' . $this->objSequence . ' FROM SYSIBM.SYSDUMMY1' )
        or trigger_error( db2_stmt_errormsg(), E_USER_WARNING );

        $objResult = db2_fetch_array( $objStmt );
        return $objResult[0];
    }

    /**
     * Create sequence
     *
     * @access public
     * @return mixed
     */
    public function setSequence()
    {
        //make sure $this->objMax is an unsigned int > 0
        $objMax   = ( is_numeric( $this->objMax ) && $this->objMax > 0 ) ? ' MAXVALUE ' . ( int )$this->objMax : '';
        $objQuery = 'CREATE SEQUENCE ' . $this->objSequence . ' INCREMENT BY 1 START WITH 1 MINVALUE 1' . $objMax . ' NO CACHE';

        return db2_exec( $this->objConnection, $objQuery )
        or trigger_error( db2_stmt_errormsg(), E_USER_WARNING );
    }
}

?>