Member MemberMapper::getMemberByID(int membershipID) const
{
DBControl db;
db.connect();
stringstream id;
id << membershipID;
string SQL = "SELECT * FROM member "
"WHERE membershipID = " + id.str();
MYSQL_RES* result = db.query(SQL);
if(mysql_num_rows(result) > 0)
{
MYSQL_ROW row = mysql_fetch_row(result);
return fromRow(row); // Just copies row data to member and returns the object
}
else
{
throw InvalidMemberException()
}
}