1 /***************************************************************************
2 * Copyright (C) 2005-07 by the Quassel Project *
3 * devel@quassel-irc.org *
5 * This program is free software; you can redistribute it and/or modify *
6 * it under the terms of the GNU General Public License as published by *
7 * the Free Software Foundation; either version 2 of the License, or *
8 * (at your option) version 3. *
10 * This program is distributed in the hope that it will be useful, *
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
13 * GNU General Public License for more details. *
15 * You should have received a copy of the GNU General Public License *
16 * along with this program; if not, write to the *
17 * Free Software Foundation, Inc., *
18 * 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. *
19 ***************************************************************************/
21 #ifndef ABSTRACTSQLSTORAGE_H
22 #define ABSTRACTSQLSTORAGE_H
26 #include <QSqlDatabase>
30 class AbstractSqlStorage : public Storage {
34 AbstractSqlStorage(QObject *parent = 0);
35 virtual ~AbstractSqlStorage();
38 virtual State init(const QVariantMap &settings = QVariantMap());
39 inline virtual void sync() {};
43 QString queryString(const QString &queryName, int version);
44 inline QString queryString(const QString &queryName) { return queryString(queryName, 0); }
46 QStringList setupQueries();
47 bool setup(const QVariantMap &settings = QVariantMap());
49 QStringList upgradeQueries(int ver);
52 bool watchQuery(QSqlQuery &query);
55 virtual int installedSchemaVersion() { return -1; };
56 virtual bool updateSchemaVersion(int newVersion) = 0;
57 virtual bool setupSchemaVersion(int version) = 0;
59 virtual QString driverName() = 0;
60 inline virtual QString hostName() { return QString(); }
61 virtual QString databaseName() = 0;
62 inline virtual QString userName() { return QString(); }
63 inline virtual QString password() { return QString(); }
66 void connectionDestroyed();
69 void addConnectionToPool();
73 int _nextConnectionId;
74 QMutex _connectionPoolMutex;
75 // we let a Connection Object manage each actual db connection
76 // those objects reside in the thread the connection belongs to
77 // which allows us thread safe termination of a connection
79 QHash<QThread *, Connection *> _connectionPool;
82 // ========================================
83 // AbstractSqlStorage::Connection
84 // ========================================
85 class AbstractSqlStorage::Connection : public QObject {
89 Connection(const QString &name, QObject *parent = 0);
92 inline QLatin1String name() const { return QLatin1String(_name); }