QList<SchoolClass> SchoolClass::classesInSchool(School school)
{
QList<SchoolClass> res;
QSqlQuery query;
query.prepare("SELECT school_class_key, class_label, school_fk "
"FROM school_class "
"WHERE school_fk = :key");
query.bindValue(":key", school.getKey().toString());
if (!query.exec()) {
qDebug() << "SchoolClass::classesInSchool SQL error: "
<< query.lastError().driverText()
<< " school key: "
<< school.getKey().toString();
}
while(query.next()) {
SchoolClass schoolClass(QUuid(query.value("school_class_key").toString()),
query.value("class_label").toString(), school.getKey());
res.append(schoolClass);
}
return res;
}
