1 | /* |
---|
2 | * Copyright (C) 2010 Ixonos Plc. |
---|
3 | * Copyright (C) 2011-2021 Philipp Spitzer, gregor herrmann, Stefan Stahl |
---|
4 | * |
---|
5 | * This file is part of ConfClerk. |
---|
6 | * |
---|
7 | * ConfClerk is free software: you can redistribute it and/or modify it |
---|
8 | * under the terms of the GNU General Public License as published by the Free |
---|
9 | * Software Foundation, either version 2 of the License, or (at your option) |
---|
10 | * any later version. |
---|
11 | * |
---|
12 | * ConfClerk is distributed in the hope that it will be useful, but |
---|
13 | * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY |
---|
14 | * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for |
---|
15 | * more details. |
---|
16 | * |
---|
17 | * You should have received a copy of the GNU General Public License along with |
---|
18 | * ConfClerk. If not, see <http://www.gnu.org/licenses/>. |
---|
19 | */ |
---|
20 | |
---|
21 | #include "room.h" |
---|
22 | |
---|
23 | QString const Room::sTableName = QString("room"); |
---|
24 | int const Room::sTableColCount = 2; |
---|
25 | const QString Room::NAME = "name"; |
---|
26 | |
---|
27 | QSqlRecord const Room::sColumns = Room::toRecord(QList<QSqlField>() |
---|
28 | << QSqlField("id", QVariant::Int) |
---|
29 | << QSqlField(NAME, QVariant::String)); |
---|
30 | |
---|
31 | Room Room::retrieveByName(QString name) |
---|
32 | { |
---|
33 | QSqlQuery query; |
---|
34 | query.prepare( |
---|
35 | selectQuery() |
---|
36 | + QString("WHERE %1.name = :name").arg(sTableName)); |
---|
37 | query.bindValue(":name", name); |
---|
38 | return loadOne(query); |
---|
39 | } |
---|
40 | |
---|
41 | QList<Room> Room::getAll() |
---|
42 | { |
---|
43 | QSqlQuery query; |
---|
44 | query.prepare(selectQuery()); |
---|
45 | return load(query); |
---|
46 | } |
---|
47 | |
---|
48 | Room Room::retrieve(int id) |
---|
49 | { |
---|
50 | QSqlQuery query; |
---|
51 | query.prepare(selectQuery() |
---|
52 | + QString("WHERE %1.id = :id").arg(sTableName)); |
---|
53 | query.bindValue(":id", id); |
---|
54 | return loadOne(query); |
---|
55 | } |
---|
56 | |
---|
57 | QString Room::retrieveRoomName(int id) |
---|
58 | { |
---|
59 | Room room = retrieve(id); |
---|
60 | return room.name(); |
---|
61 | } |
---|
62 | |
---|