Row

A row in a result set from a query.

You can access this as either an array or associative array:

foreach(Row row; db.query("SELECT id, name FROM mytable")) {
	// can access by index or by name
	row[0] == row["id"];
	row[1] == row["name"];

	// can also iterate over the results
	foreach(name, data; row) {
		 // will send name = "id", data = the thing
		 // and then next loop will be name = "name", data = the thing
	}
}

struct Row {

DatabaseDatum opIndex(size_t idx, string file, int line);

DatabaseDatum opIndex(string name, string file, int line);

string toString();

int opApply(int delegate(string, DatabaseDatum) dg);

int opApply(int delegate(DatabaseDatum) dg);

string[] toStringArray();

string[string] toAA();

}

Members

Functions

opApply int opApply(int delegate(string, DatabaseDatum) dg)
int opApply(int delegate(DatabaseDatum) dg): Allows iteration over the columns with the foreach statement.
opIndex DatabaseDatum opIndex(size_t idx, string file, int line)
DatabaseDatum opIndex(string name, string file, int line): Allows for access by index or column name.
toAA string[string] toAA(): Hacky conversion to simpler types.
toString string toString(): Provides a string representation of the row, for quick eyeball debugging. You probably won't want the format this prints in (and don't rely upon it, as it is subject to change at any time without notice!), but it might be useful for use with writeln.
toStringArray string[] toStringArray(): Hacky conversion to simpler types.

The OpenD Programming Language

Row

Members

Functions

Meta

Source