The WSqlResult class provides a representation of the result set from a query. More...

#include <wsqlresult.h>

Inheritance diagram for WSql::WSqlResult:

Public Member Functions
	WSqlResult (const WSqlDriver *driver)
	WSqlResult (const WSql::WSqlResult &other)
virtual	~WSqlResult ()
virtual WSqlResult &	operator= (const WSqlResult &other)
void	addRecord (WSqlRecord &r)
void	setIsCached (bool b)
void	setIsValid (bool b)
bool	isValid () const
bool	isCached () const
virtual int	size () const
virtual int	count () const
virtual bool	empty () const
virtual bool	hasOutValues () const
virtual void	clear ()
virtual WSqlRecord	current ()
virtual WSqlRecord	fetch (int i=-1)
virtual WSqlRecord	fetchFirst ()
virtual WSqlRecord	fetchLast ()
virtual WSqlRecord	fetchNext ()
virtual WSqlRecord	fetchPrevious ()
Protected Member Functions
virtual bool	seek (int i, bool relative=false)
virtual bool	next ()
virtual bool	previous ()
virtual bool	first ()
virtual bool	last ()
Protected Attributes
std::vector< WSqlRecord > ::const_iterator	const_cur_record_it
std::vector< WSqlRecord >::iterator	record_it
const WSqlDriver *	_driver
std::vector< WSqlRecord >	_records
bool	_isCached

Detailed Description

The WSqlResult class provides a representation of the result set from a query.

WSqlResult represents the results of a query to the database as a vector of WSqlRecords. By default isCached() returns true and the vector is populated by the WSqlDriver. If the query was not a select or returned no results then size() will be 0 and hasOutValues() will return false.

If you are implementing your own SQL driver (by subclassing WSqlDriver), you must also subclass WSqlResult and implement the all the pure virtual functions and other virtual functions that you need. This is mostly to support databases that allow partial retrieval of a result set - in which case the implementation will offer the ability to setIsCached() and manage the fetching of records internally.

Example usage:

std::string sql = "select * from " + tablename + " limit 2";
if(!db.execute(sql)) exit();

WSqlResult *result = db.getResult();
WSqlRecord record = result->fetchFirst();
while(!record.empty())
{
    WSqlField fld;
    for(int i = 0;i < record.size();i++)
    {
        fld = record.field(i);
        std::cout << "Field " << fld.name() << ", Origin Column "<< fld.columnName() 
        << "Value: " << fld.data<std::string>() << std::endl;
    }
    record = result->fetchNext();
}

See also:: WSqlRecord WSqlField WSqlDatabase

Definition at line 30 of file wsqlresult.h.

Constructor & Destructor Documentation

WSql::WSqlResult::WSqlResult ( const WSqlDriver * driver )

Creates an empty result object.

Definition at line 67 of file wsqlresult.cpp.

WSql::WSqlResult::WSqlResult ( const WSql::WSqlResult & other )

Definition at line 75 of file wsqlresult.cpp.

WSql::WSqlResult::~WSqlResult ( ) [virtual]

Destroys the object and frees any allocated resources.

Definition at line 97 of file wsqlresult.cpp.

Member Function Documentation

void WSql::WSqlResult::addRecord ( WSqlRecord & r ) [inline]

Todo:: virtual bool operator==(const WSqlResult& other) const;

bool WSql::WSqlResult::seek	(	int	pos,
		bool	relative = `false`
	)		`[protected, virtual]`

WSql::WSqlResult Class Reference

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation