2 * Copyright (C) 2010 Ixonos Plc.
4 * This file is part of ConfClerk.
6 * ConfClerk is free software: you can redistribute it and/or modify it
7 * under the terms of the GNU General Public License as published by the Free
8 * Software Foundation, either version 2 of the License, or (at your option)
11 * ConfClerk is distributed in the hope that it will be useful, but
12 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 * You should have received a copy of the GNU General Public License along with
17 * ConfClerk. If not, see <http://www.gnu.org/licenses/>.
23 #include <ormrecord.h>
25 class Room : public OrmRecord<Room>
28 static const QSqlRecord sColumns;
29 static QString const sTableName;
30 static const int sTableColCount;
31 static const QString NAME;
33 int id() const { return value("id").toInt(); }
34 void setId(int id) { setValue("id", id); }
35 QString name() const { return value("name").toString(); }
36 void setName(const QString & type) { setValue("name", type); }
37 // TODO: make naming consistent - either "picture" or "map"
38 QVariant map() const { return value("picture"); }
41 // empty strings also treasted as NULL,
42 // as storing NULLs requires rewrite of storing code and DB scheme
43 return !isNull("picture") and !value("picture").toString().isEmpty();
47 static QList<Room> getAll();
48 static Room retrieve(int id);
49 static QString retrieveRoomName(int id);
50 static Room retrieveByName(QString name);