Class AggTable {
bool connect(const char* aUserName, const char* aPassword);
bool disconnect();
bool openTable(const char* aTableName);
bool group();
void setAggType(AggType aType);
void* fetch();
int getAggValue();
bool closeTable();
}
enum AggType {
MIN,
MAX,
SUM,
AVG,
COUNT
}
AggTable Guidelines
AggTable Usage
int main() {
AggTable sTable;
sTable.connect("root", "manager");
sTable.openTable("T1");
sTable.setAggType(SUM);
sTable.group();
void* record;
printf("Grouped Records\n");
while (true) {
record = sTable.fetch();
if (record == NULL) break;
printf("Group Value %d AggValue %d\n", *(int*) record, sTable.getAggValue());
}
sTable.closeTable();
sTable.disconnect();
return 0;
}
Assumption: Table T1 with field f1 and f2, both of type integer already exists in database
%%