ResultSet

A Random access range of Rows.

This is the entity that is returned by the Command methods execSQLResult and execPreparedResult

MySQL result sets can be up to 2^^64 rows, and the 32 bit implementation of the MySQL C API accomodates such potential massive result sets by storing the rows in a doubly linked list. I have taken the view that users who have a need for result sets up to this size should be working with a 64 bit system, and as such the 32 bit implementation will throw if the number of rows exceeds the 32 bit size_t.max.

struct ResultSet {

bool empty [@property getter];

ResultSet save [@property getter];

Row front [@property getter];

Row back [@property getter];

void popFront();

void popBack();

Row opIndex(size_t i);

size_t length [@property getter];

void revert();

Column[string] asAA();

}

Members

Functions

asAA Column[string] asAA(): Get a row as an associative array by column name
opIndex Row opIndex(size_t i): Make the ResultSet behave as a random access range - opIndex
popBack void popBack(): Make the ResultSet behave as a random access range - popBack
popFront void popFront(): Make the ResultSet behave as a random access range - popFront()
revert void revert(): Restore the range to its original span.

Properties

back Row back [@property getter]: Make the ResultSet behave as a random access range - back
empty bool empty [@property getter]: Make the ResultSet behave as a random access range - empty
front Row front [@property getter]: Make the ResultSet behave as a random access range - front
length size_t length [@property getter]: Make the ResultSet behave as a random access range - length
save ResultSet save [@property getter]: Make the ResultSet behave as a random access range - save

ResultSet

Members

Functions

Properties

Meta

Source