4 QString const Room::sTableName = QString("room");
5 int const Room::sTableColCount = 3;
6 const QString Room::NAME = "name";
8 QSqlRecord const Room::sColumns = Room::toRecord(QList<QSqlField>()
9 << QSqlField("id", QVariant::Int)
10 << QSqlField(NAME, QVariant::String)
11 << QSqlField("picture", QVariant::String));
13 Room Room::retrieveByName(QString name)
18 + QString("WHERE %1.name = :name").arg(sTableName));
19 query.bindValue(":name", name);
20 return loadOne(query);
23 QList<Room> Room::getAll()
26 query.prepare(selectQuery());
30 Room Room::retrieve(int id)
33 query.prepare(selectQuery()
34 + QString("WHERE %1.id = :id").arg(sTableName));
35 query.bindValue(":id", id);
36 return loadOne(query);
39 QString Room::retrieveRoomName(int id)
41 Room room = retrieve(id);