ResultStatement.php 6.21 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<?php
/*
 * 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
Benjamin Eberlei's avatar
Benjamin Eberlei committed
16
 * and is licensed under the MIT license. For more information, see
17 18 19 20 21 22 23 24 25 26
 * <http://www.doctrine-project.org>.
 */

namespace Doctrine\DBAL\Driver;

/**
 * Interface for the reading part of a prepare statement only.
 *
 * @author Benjamin Eberlei <kontakt@beberlei.de>
 */
27
interface ResultStatement extends \Traversable
28 29 30 31
{
    /**
     * Closes the cursor, enabling the statement to be executed again.
     *
32
     * @return bool TRUE on success or FALSE on failure.
33
     */
Benjamin Morel's avatar
Benjamin Morel committed
34
    public function closeCursor();
35 36 37 38

    /**
     * Returns the number of columns in the result set
     *
39
     * @return int The number of columns in the result set represented
Benjamin Morel's avatar
Benjamin Morel committed
40 41
     *                 by the PDOStatement object. If there is no result set,
     *                 this method should return 0.
42
     */
Benjamin Morel's avatar
Benjamin Morel committed
43
    public function columnCount();
44

45
    /**
Benjamin Morel's avatar
Benjamin Morel committed
46
     * Sets the fetch mode to use while iterating this statement.
47
     *
48
     * @param int   $fetchMode The fetch mode must be one of the {@link \Doctrine\DBAL\FetchMode} constants.
49 50
     * @param mixed $arg2
     * @param mixed $arg3
Benjamin Morel's avatar
Benjamin Morel committed
51
     *
52
     * @return bool
53
     */
Benjamin Morel's avatar
Benjamin Morel committed
54
    public function setFetchMode($fetchMode, $arg2 = null, $arg3 = null);
55

56
    /**
Steve Müller's avatar
Steve Müller committed
57
     * Returns the next row of a result set.
Benjamin Morel's avatar
Benjamin Morel committed
58
     *
59
     * @param int|null $fetchMode         Controls how the next row will be returned to the caller.
60 61
     *                                    The value must be one of the {@link \Doctrine\DBAL\FetchMode} constants,
     *                                    defaulting to {@link \Doctrine\DBAL\FetchMode::MIXED}.
62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
     * @param int      $cursorOrientation For a ResultStatement object representing a scrollable cursor,
     *                                    this value determines which row will be returned to the caller.
     *                                    This value must be one of the \PDO::FETCH_ORI_* constants,
     *                                    defaulting to \PDO::FETCH_ORI_NEXT. To request a scrollable
     *                                    cursor for your ResultStatement object, you must set the \PDO::ATTR_CURSOR
     *                                    attribute to \PDO::CURSOR_SCROLL when you prepare the SQL statement with
     *                                    \PDO::prepare().
     * @param int      $cursorOffset      For a ResultStatement object representing a scrollable cursor for which the
     *                                    cursorOrientation parameter is set to \PDO::FETCH_ORI_ABS, this value
     *                                    specifies the absolute number of the row in the result set that shall be
     *                                    fetched.
     *                                    For a ResultStatement object representing a scrollable cursor for which the
     *                                    cursorOrientation parameter is set to \PDO::FETCH_ORI_REL, this value
     *                                    specifies the row to fetch relative to the cursor position before
     *                                    ResultStatement::fetch() was called.
Steve Müller's avatar
Steve Müller committed
77 78 79
     *
     * @return mixed The return value of this method on success depends on the fetch mode. In all cases, FALSE is
     *               returned on failure.
80
     */
81
    public function fetch($fetchMode = null, $cursorOrientation = \PDO::FETCH_ORI_NEXT, $cursorOffset = 0);
82 83

    /**
Benjamin Morel's avatar
Benjamin Morel committed
84
     * Returns an array containing all of the result set rows.
85
     *
86
     * @param int|null   $fetchMode     Controls how the next row will be returned to the caller.
87 88
     *                                  The value must be one of the {@link \Doctrine\DBAL\FetchMode} constants,
     *                                  defaulting to {@link \Doctrine\DBAL\FetchMode::MIXED}.
89
     * @param int|null   $fetchArgument This argument has a different meaning depending on the value of the $fetchMode parameter:
90 91 92 93 94
     *                                  * {@link \Doctrine\DBAL\FetchMode::COLUMN}:
     *                                    Returns the indicated 0-indexed column.
     *                                  * {@link \Doctrine\DBAL\FetchMode::CUSTOM_OBJECT}:
     *                                    Returns instances of the specified class, mapping the columns of each row
     *                                    to named properties in the class.
95
     *                                  * \PDO::FETCH_FUNC: Returns the results of calling the specified function, using each row's
96
     *                                    columns as parameters in the call.
97
     * @param array|null $ctorArgs      Controls how the next row will be returned to the caller.
98 99
     *                                  The value must be one of the {@link \Doctrine\DBAL\FetchMode} constants,
     *                                  defaulting to {@link \Doctrine\DBAL\FetchMode::MIXED}.
100 101 102
     *
     * @return array
     */
103
    public function fetchAll($fetchMode = null, $fetchArgument = null, $ctorArgs = null);
104 105

    /**
Benjamin Morel's avatar
Benjamin Morel committed
106
     * Returns a single column from the next row of a result set or FALSE if there are no more rows.
107
     *
108 109 110
     * @param int $columnIndex 0-indexed number of the column you wish to retrieve from the row.
     *                         If no value is supplied, PDOStatement->fetchColumn()
     *                         fetches the first column.
111
     *
Benjamin Morel's avatar
Benjamin Morel committed
112
     * @return string|boolean A single column in the next row of a result set, or FALSE if there are no more rows.
113
     */
Benjamin Morel's avatar
Benjamin Morel committed
114
    public function fetchColumn($columnIndex = 0);
115
}