4 * Created on: Dec 27, 2009
10 QString const Room::sTableName = QString("room");
11 int const Room::sTableColCount = 3;
12 const QString Room::NAME = "name";
14 QSqlRecord const Room::sColumns = Room::toRecord(QList<QSqlField>()
15 << QSqlField("id", QVariant::Int)
16 << QSqlField(NAME, QVariant::String)
17 << QSqlField("picture", QVariant::String));
19 Room Room::retrieveByName(QString name)
24 + QString("WHERE %1.name = :name").arg(sTableName));
25 query.bindValue(":name", name);
26 return loadOne(query);
29 QList<Room> Room::getAll()
32 query.prepare(selectQuery());
36 Room Room::retrieve(int id)
39 query.prepare(selectQuery()
40 + QString("WHERE %1.id = :id").arg(sTableName));
41 query.bindValue(":id", id);
42 return loadOne(query);
45 QString Room::retrieveRoomName(int id)
47 Room room = retrieve(id);