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; }