SourcePro® 2024.1 |
SourcePro® API Reference Guide |
Represents a sequence of zero or more RWDBTable instances. More...
#include <rw/db/result.h>
Public Member Functions | |
RWDBResult () | |
RWDBResult (const RWDBResult &result) | |
RWDBConnection | connection () const |
RWDBStatus::ErrorHandler | errorHandler () const |
bool | isReady () const |
bool | isValid () const |
RWDBResult & | operator= (const RWDBResult &result) |
long | rowCount () const |
long | rowsAffected () const |
void | setErrorHandler (RWDBStatus::ErrorHandler handler) |
RWDBStatus | status () const |
RWDBTable | table () |
RWDBResult represents a sequence of zero or more RWDBTable instances. An RWDBResult instance is returned whenever a database operation may potentially produce multiple SQL table expressions. This is obviously the case when using the RWDBConnection::executeSql() method to submit arbitrary SQL for execution. However, the DB Interface Module recognizes that some database vendors provide:
SELECT
statement.INSERT
, DELETE
, or UPDATE
statement.For this reason, execute() methods of each of the above operation returns an RWDBResult instance. An application using a database that does not provide these capabilities is not obliged to check for multiple results.
Every RWDBResult instance has an RWDBConnection. Passing an RWDBConnection to an execute() method causes the RWDBResult to acquire the passed connection. Calling execute() without an RWDBConnection causes the RWDBResult to acquire a default connection from the caller's RWDBDatabase. In each case, the connection is held by the RWDBResult until the RWDBResult is destroyed.
The RWDBTable instances produced by RWDBResult must be processed in order. Each call to RWDBResult::table() causes unprocessed rows from any previous table to be flushed.
RWDBResult is designed around the Interface/Implementation paradigm. An RWDBResult instance is an interface to a reference-counted implementation; copy constructors and assignment operators produce additional references to a shared implementation. An RWDBResult implementation is a base class from which a family of database-specific result implementations is derived.
Here is a way to process an SQL query that may return more than one table expression. The example assumes that the SQL is contained in the variable sqlString
.
RWDBResult::RWDBResult | ( | ) |
The default constructor creates an RWDBResult whose status is RWDBStatus::notInitialized. This constructor is provided as a convenience, for example, for declaring an array of RWDBResult instances. Usable RWDBResult instances are obtained from execute() methods.
RWDBResult::RWDBResult | ( | const RWDBResult & | result | ) |
Copy constructor. Self shares an implementation with result.
RWDBConnection RWDBResult::connection | ( | ) | const |
Returns self's database connection.
RWDBStatus::ErrorHandler RWDBResult::errorHandler | ( | ) | const |
Returns the error handler attached to self.
bool RWDBResult::isReady | ( | ) | const |
Returns true
if the object is in ready state, indicating that accessing the object will not block. Accessing a nonready object may potentially block.
bool RWDBResult::isValid | ( | ) | const |
Returns true
if the status of self is RWDBStatus::ok, otherwise returns false
.
RWDBResult & RWDBResult::operator= | ( | const RWDBResult & | result | ) |
Assignment operator. Self shares an implementation with result.
long RWDBResult::rowCount | ( | ) | const |
Returns the number of rows in the database affected by the most recent activity through self's connection. This method makes a direct call to the implementation. Implementations without such a call return -1
. Typically, this method returns a valid value only after updating, inserting, or deleting rows. Errors always return -1
.
The following code determines the number of rows updated through an RWDBUpdater.
long RWDBResult::rowsAffected | ( | ) | const |
Returns the number of rows in the database affected by the most recent activity through self's connection. Even if the recent activity has failed, this method would attempt to fetch the number of rows affected in spite of the failure. Returns -1
if this information cannot be fetched. Typically, this method returns a valid value only after updating, inserting, or deleting rows.
The following code determines the number of rows updated through an RWDBUpdater.
void RWDBResult::setErrorHandler | ( | RWDBStatus::ErrorHandler | handler | ) |
Installs handler as self's error handler. The supplied handler is inherited by all objects produced by self. By default, an RWDBStatus::ErrorHandler is inherited from the object which produced self; this method overrides the default.
RWDBStatus RWDBResult::status | ( | ) | const |
Returns the current status of self.
RWDBTable RWDBResult::table | ( | ) |
Returns the next RWDBTable in the sequence of tables represented by self. When there are no more tables, the status of self becomes RWDBStatus::endOfFetch. This function can behave asynchronously if executed using an asynchronous connection, or if self uses an asynchronous connection.
Copyright © 2024 Rogue Wave Software, Inc., a Perforce company. All Rights Reserved. |