Home | Classes | Modules | Annotated | Functions | Files

PgSQLResultSet.php

Go to the documentation of this file.

<?php
/*
 *  $Id: PgSQLResultSet.php,v 1.2 2004/05/06 19:39:16 micha Exp $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://creole.phpdb.org>.
 */
 
require_once 'creole/ResultSet.php';
require_once 'creole/common/ResultSetCommon.php';

class PgSQLResultSet extends ResultSetCommon
{
  function seek($rownum)
  {
    if ($rownum < 0) {
        return false;
    }
    
    // PostgreSQL rows start w/ 0, but this works, because we are
    // looking to move the position _before_ the next desired position
    $this->cursorPos = $rownum;
    return true;
  }
  
  function next()
  {
    // must suppress errors here because we are jumping to rownum that may not exist w/ fetch_array command
    $this->fields = @pg_fetch_array($this->result, $this->cursorPos, $this->fetchmode);

    if (!$this->fields) {
      $err = @pg_result_error($this->result);
      if (!$err) {
        // We've advanced beyond end of recordset.
        $this->afterLast();
        return false;
      } else {
        return new SQLException(CREOLE_ERROR, "Error fetching result", $err);                
      }
    }
    
    // Advance cursor position
    $this->cursorPos++;    
    return true;
  }

  function getRecordCount()
  {
    $rows = @pg_num_rows($this->result);
    if ($rows === null) {
      return new SQLException(CREOLE_ERROR, "Error fetching num rows", pg_result_error($this->result));
    }
    return (int) $rows;
  }

  function close()
  {
    $this->fields = array();
    @pg_free_result($this->result);
  }
  
  function strToArray($str)
  {
    $str = substr($str, 1, -1); // remove { }
    $res = array();
    
    $subarr = array();
    $in_subarr = 0;
    
    $toks = explode(',', $str);
    foreach($toks as $tok) {                    
      if ($in_subarr > 0) { // already in sub-array?
        $subarr[$in_subarr][] = $tok;
        if ('}' === substr($tok, -1, 1)) { // check to see if we just added last component                    
          $res[] = $this->strToArray(implode(',', $subarr[$in_subarr]));
          $in_subarr--;
        }
      } elseif ($tok{0} === '{') { // we're inside a new sub-array                               
        if ('}' !== substr($tok, -1, 1)) {
          $in_subarr++;
          // if sub-array has more than one element
          $subarr[$in_subarr] = array();
          $subarr[$in_subarr][] = $tok;                    
        } else {
          $res[] = $this->strToArray($tok);
        }
      } else { // not sub-array
        $val = trim($tok, '"'); // remove " (surrounding strings)
        // perform type castng here?
        $res[] = $val;
      }
    }
    
    return $res;
  }

  function & getArray($column) 
  {
    if (is_int($column)) { $column--; } // because Java convention is to start at 1 
    if (!array_key_exists($column, $this->fields)) { 
      return new SQLException(CREOLE_ERROR_INVALID, "Invalid resultset column: " . (is_int($column) ? $column + 1 : $column)); 
    }
    if ($this->fields[$column] === null) { return null; }
    return $this->strToArray($this->fields[$column]);
  } 
  
  function & getBlob($column) 
  {
    if (is_int($column)) { $column--; } // because Java convention is to start at 1 
    if (!array_key_exists($column, $this->fields)) { 
      return new SQLException(CREOLE_ERROR_INVALID, "Invalid resultset column: " . (is_int($column) ? $column + 1 : $column)); 
    }
    if ($this->fields[$column] === null) { return null; }
    require_once 'creole/util/Blob.php';
    $b =& new Blob();
    $b->setContents(pg_unescape_bytea($this->fields[$column]));
    return $b;
  }     

  function getBoolean($column) 
  {
      if (is_int($column)) { $column--; } // because Java convention is to start at 1 
      if (!array_key_exists($column, $this->fields)) { 
        return new SQLException(CREOLE_ERROR_INVALID, "Invalid resultset column: " . (is_int($column) ? $column + 1 : $column)); 
      }
      if ($this->fields[$column] === null) { return null; }
      return ($this->fields[$column] === 't');
  }
          
}

---

This file is part of the Creole[php4] library.