Test/DbStatement.php

category: Zend
copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
license: http://framework.zend.com/license/new-bsd New BSD License
package: Zend_Test
subpackage: PHPUnit
version: $Id: DbStatement.php 20096 2010-01-06 02:05:09Z bkarwin $
Classes: Zend_Test_DbStatement

Description

Zend Framework

LICENSE

This source file is subject to the new BSD license that is bundled with this package in the file LICENSE.txt. It is also available through the world-wide-web at this URL: http://framework.zend.com/license/new-bsd If you did not receive a copy of the license and are unable to obtain it through the world-wide-web, please send an email to license@zend.com so we can send you a copy immediately.

Zend_Test_DbStatement
jump to top

Implements: Zend_Db_Statement_Interface
category: Zend
copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
license: http://framework.zend.com/license/new-bsd New BSD License
package: Zend_Test
subpackage: PHPUnit
Properties: $_fetchStack; $_columnCount; $_rowCount; $_queryProfile
Methods: createSelectStatement; createInsertStatement; createDeleteStatement; createUpdateStatement; _createRowCountStatement; setQueryProfile; setRowCount; append; bindColumn; bindParam; bindValue; closeCursor; columnCount; errorCode; errorInfo; execute; fetch; fetchAll; fetchColumn; fetchObject; getAttribute; nextRowset; rowCount; setAttribute; setFetchMode

Description

Testing Database Statement that acts as a stack to SQL resultsets.

Properties

$_columnCount
jump to class

int $_columnCount = '0'

Details

$_columnCount: int
visibility: protected
default: 0
final: false
static: false

$_fetchStack
jump to class

array $_fetchStack = 'array'

Details

$_fetchStack: array
visibility: protected
default: array
final: false
static: false

$_queryProfile
jump to class

Zend_Db_Profiler_Query $_queryProfile = 'null'

Details

$_queryProfile: Zend_Db_Profiler_Query
visibility: protected
default: null
final: false
static: false

$_rowCount
jump to class

int $_rowCount = '0'

Details

$_rowCount: int
visibility: protected
default: 0
final: false
static: false

Methods

_createRowCountStatement
jump to class

_createRowCountStatement(
          int $affectedRows
          )
        
        :
        Zend_Test_DbStatement

Create a Row Count Statement

Arguments

$affectedRows: int

Output

Zend_Test_DbStatement

Details

visibility: protected
final: false
static: true

append
jump to class

append(
          array $row
          )
        
        :

Append a new row to the fetch stack.

Arguments

$row: array

Details

visibility: public
final: false
static: false

bindColumn
jump to class

bindColumn(
          string $column, mixed $param, mixed $type
              =
              null
          )
        
        :
        bool

Bind a column of the statement result set to a PHP variable.

Arguments

$column: string
Name the column in the result set, either by position or by name.
$param: mixed
Reference to the PHP variable containing the value.
$type: mixed
OPTIONAL

Output

bool

Details

visibility: public
final: false
static: false
throws

bindParam
jump to class

bindParam(
          mixed $parameter, mixed $variable, mixed $type
              =
              null, mixed $length
              =
              null, mixed $options
              =
              null
          )
        
        :
        bool

Binds a parameter to the specified variable name.

Arguments

$parameter: mixed
Name the parameter, either integer or string.
$variable: mixed
Reference to PHP variable containing the value.
$type: mixed
OPTIONAL Datatype of SQL parameter.
$length: mixed
OPTIONAL Length of SQL parameter.
$options: mixed
OPTIONAL Other options.

Output

bool

Details

visibility: public
final: false
static: false
throws

bindValue
jump to class

bindValue(
          mixed $parameter, mixed $value, mixed $type
              =
              null
          )
        
        :
        bool

Binds a value to a parameter.

Arguments

$parameter: mixed
Name the parameter, either integer or string.
$value: mixed
Scalar value to bind to the parameter.
$type: mixed
OPTIONAL Datatype of the parameter.

Output

bool

Details

visibility: public
final: false
static: false
throws

closeCursor
jump to class

closeCursor(
          
          )
        
        :
        bool

Closes the cursor, allowing the statement to be executed again.

Output

bool

Details

visibility: public
final: false
static: false
throws

columnCount
jump to class

columnCount(
          
          )
        
        :
        int

Returns the number of columns in the result set.

Returns null if the statement has no result set metadata.

Output

int: The number of columns.

Details

visibility: public
final: false
static: false
throws

createDeleteStatement
jump to class

createDeleteStatement(
          int $affectedRows
              =
              0
          )
        
        :
        Zend_Test_DbStatement

Create an Delete Statement

Arguments

$affectedRows: int

Output

Zend_Test_DbStatement

Details

visibility: public
final: false
static: true

createInsertStatement
jump to class

createInsertStatement(
          int $affectedRows
              =
              0
          )
        
        :
        Zend_Test_DbStatement

Create an Insert Statement

Arguments

$affectedRows: int

Output

Zend_Test_DbStatement

Details

visibility: public
final: false
static: true

createSelectStatement
jump to class

createSelectStatement(
          array $rows
              =
              array
          )
        
        :
        Zend_Test_DbStatement

Create a Select statement which returns the given array of rows.

Arguments

$rows: array

Output

Zend_Test_DbStatement

Details

visibility: public
final: false
static: true

createUpdateStatement
jump to class

createUpdateStatement(
          int $affectedRows
              =
              0
          )
        
        :
        Zend_Test_DbStatement

Create an Update Statement

Arguments

$affectedRows: int

Output

Zend_Test_DbStatement

Details

visibility: public
final: false
static: true

errorCode
jump to class

errorCode(
          
          )
        
        :
        string

Retrieves the error code, if any, associated with the last operation on the statement handle.

Output

string: error code.

Details

visibility: public
final: false
static: false
throws

errorInfo
jump to class

errorInfo(
          
          )
        
        :
        array

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

Output

array

Details

visibility: public
final: false
static: false
throws

execute
jump to class

execute(
          array $params
              =
              array
          )
        
        :
        bool

Executes a prepared statement.

Arguments

$params: array
OPTIONAL Values to bind to parameter placeholders.

Output

bool

Details

visibility: public
final: false
static: false
throws

fetch
jump to class

fetch(
          int $style
              =
              null, int $cursor
              =
              null, int $offset
              =
              null
          )
        
        :
        mixed

Fetches a row from the result set.

Arguments

$style: int
OPTIONAL Fetch mode for this fetch operation.
$cursor: int
OPTIONAL Absolute, relative, or other.
$offset: int
OPTIONAL Number for absolute or relative cursors.

Output

mixed: Array, object, or scalar depending on fetch mode.

Details

visibility: public
final: false
static: false
throws

fetchAll
jump to class

fetchAll(
          int $style
              =
              null, int $col
              =
              null
          )
        
        :
        array

Returns an array containing all of the result set rows.

Arguments

$style: int
OPTIONAL Fetch mode.
$col: int
OPTIONAL Column number, if fetch mode is by column.

Output

array: Collection of rows, each in a format by the fetch mode.

Details

visibility: public
final: false
static: false
throws

fetchColumn
jump to class

fetchColumn(
          int $col
              =
              0
          )
        
        :
        string

Returns a single column from the next row of a result set.

Arguments

$col: int
OPTIONAL Position of the column to fetch.

Output

string

Details

visibility: public
final: false
static: false
throws

fetchObject
jump to class

fetchObject(
          string $class
              =
              stdClass, array $config
              =
              array
          )
        
        :
        mixed

Fetches the next row and returns it as an object.

Arguments

$class: string
OPTIONAL Name of the class to create.
$config: array
OPTIONAL Constructor arguments for the class.

Output

mixed: One object instance of the specified class.

Details

visibility: public
final: false
static: false
throws

getAttribute
jump to class

getAttribute(
          string $key
          )
        
        :
        mixed

Retrieve a statement attribute.

Arguments

$key: string
Attribute name.

Output

mixed: Attribute value.

Details

visibility: public
final: false
static: false
throws

nextRowset
jump to class

nextRowset(
          
          )
        
        :
        bool

Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.

Output

bool

Details

visibility: public
final: false
static: false
throws

rowCount
jump to class

rowCount(
          
          )
        
        :
        int

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

Output

int: The number of rows affected.

Details

visibility: public
final: false
static: false
throws

setAttribute
jump to class

setAttribute(
          string $key, mixed $val
          )
        
        :
        bool

Set a statement attribute.

Arguments

$key: string
Attribute name.
$val: mixed
Attribute value.

Output

bool

Details

visibility: public
final: false
static: false
throws

setFetchMode
jump to class

setFetchMode(
          int $mode
          )
        
        :
        bool

Set the default fetch mode for this statement.

Arguments

$mode: int
The fetch mode.

Output

bool

Details

visibility: public
final: false
static: false
throws

setQueryProfile
jump to class

setQueryProfile(
          Zend_Db_Profiler_Query $qp
          )
        
        :

Arguments

$qp: Zend_Db_Profiler_Query

Details

visibility: public
final: false
static: false

setRowCount
jump to class

setRowCount(
          int $rowCount
          )
        
        :

Arguments

$rowCount: int

Details

visibility: public
final: false
static: false

API Documentation

Test/DbStatement.php

Description

Zend_Test_DbStatementjump to top

Description

Properties

$_columnCountjump to class

Details

$_fetchStackjump to class

Details

$_queryProfilejump to class

Details

$_rowCountjump to class

Details

Methods

_createRowCountStatementjump to class

Arguments

Output

Details

appendjump to class

Arguments

Details

bindColumnjump to class

Arguments

Output

Details

bindParamjump to class

Arguments

Output

Details

bindValuejump to class

Arguments

Output

Details

closeCursorjump to class

Output

Details

columnCountjump to class

Output

Details

createDeleteStatementjump to class

Arguments

Output

Details

createInsertStatementjump to class

Arguments

Output

Details

createSelectStatementjump to class

Arguments

Output

Details

createUpdateStatementjump to class

Arguments

Output

Details

errorCodejump to class

Output

Details

errorInfojump to class

Output

Details

executejump to class

Arguments

Output

Details

fetchjump to class

Arguments

Output

Details

fetchAlljump to class

Arguments

Output

Details

fetchColumnjump to class

Arguments

Output

Details

fetchObjectjump to class

Arguments

Zend_Test_DbStatement
jump to top

$_columnCount
jump to class

$_fetchStack
jump to class

$_queryProfile
jump to class

$_rowCount
jump to class

_createRowCountStatement
jump to class

append
jump to class

bindColumn
jump to class

bindParam
jump to class

bindValue
jump to class

closeCursor
jump to class

columnCount
jump to class

createDeleteStatement
jump to class

createInsertStatement
jump to class

createSelectStatement
jump to class

createUpdateStatement
jump to class

errorCode
jump to class

errorInfo
jump to class

execute
jump to class

fetch
jump to class

fetchAll
jump to class

fetchColumn
jump to class

fetchObject
jump to class

getAttribute
jump to class

nextRowset
jump to class

rowCount
jump to class

setAttribute
jump to class

setFetchMode
jump to class

setQueryProfile
jump to class

setRowCount
jump to class