source: src/sql/sqlengine.h @ 526128c

Last change on this file since 526128c was e6ab8a2, checked in by Philipp Spitzer <philipp@…>, 11 years ago

Removed the ability to show "pictures" (maps) of rooms and maps of conferences.
The XML file does not contain picture/map/image information of conferences or rooms.
We left the room.picture definition in the database SQL because there is no "drop column"
in sqlite.

  • Property mode set to 100644
File size: 1.9 KB
2 * Copyright (C) 2010 Ixonos Plc.
[68b2df2]3 * Copyright (C) 2011 Philipp Spitzer, gregor herrmann
[ca90cb1]4 *
[6df32f2]5 * This file is part of ConfClerk.
[ca90cb1]6 *
[6df32f2]7 * ConfClerk is free software: you can redistribute it and/or modify it
[ca90cb1]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 *
[6df32f2]12 * ConfClerk is distributed in the hope that it will be useful, but
[ca90cb1]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
[6df32f2]18 * ConfClerk.  If not, see <>.
[ca90cb1]19 */
[72f6fe4]20#ifndef SQLENGINE_H
21#define SQLENGINE_H
23#include <QObject>
24#include <QHash>
26class QSqlDatabase;
28class SqlEngine : public QObject
30    Q_OBJECT
31    public:
32        SqlEngine(QObject *aParent = NULL);
33        ~SqlEngine();
[05afe5f]34        static void initialize();
[3a8dc71]35        static void addConferenceToDB(QHash<QString,QString> &aConference);
36        static void addEventToDB(QHash<QString,QString> &aEvent);
37        static void addPersonToDB(QHash<QString,QString> &aPerson);
38        static void addLinkToDB(QHash<QString,QString> &aLink);
39        static void addRoomToDB(QHash<QString,QString> &aRoom);
[d97bcab]40        static void deleteConference(int id);
[1bad318]42        static bool beginTransaction();
43        static bool commitTransaction();
[990afd5]45        // search Events for ....
[3a8dc71]46        static int searchEvent(int conferenceId, const QHash<QString,QString> &columns, const QString &keyword);
[72f6fe4]47    private:
[05afe5f]48        static QString login(const QString &aDatabaseType, const QString &aDatabaseName);
[3a8dc71]49        static bool execQuery(QSqlDatabase &aDatabase, const QString &aQuery);
[d97bcab]50        static bool execQueryWithParameter(QSqlDatabase &aDatabase, const QString &aQuery, const QHash<QString, QVariant>& params);
53#endif /* SQLENGINE_H */
Note: See TracBrowser for help on using the repository browser.