Herunterladen als
root/src/database.h @ 81c23b56
81c23b56 | Christian Ehringfeld | /*
|
|
Header File Database
|
|||
Copyright (C) 2013 Christian Ehringfeld <c.ehringfeld@t-online.de>
|
|||
This file is part of OpenTeacherTool.
|
|||
OpenTeacherTool is free software: you can redistribute it and/or modify
|
|||
it under the terms of the GNU General Public License as published by
|
|||
the Free Software Foundation, either version 3 of the License, or
|
|||
(at your option) any later version.
|
|||
OpenTeacherTool is distributed in the hope that it will be useful,
|
|||
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|||
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|||
GNU General Public License for more details.
|
|||
You should have received a copy of the GNU General Public License
|
|||
along with OpenTeacherTool. If not, see <http://www.gnu.org/licenses/>.
|
|||
*/
|
|||
#ifndef DATABASE_H
|
|||
#define DATABASE_H
|
|||
#include <QtSql/QSqlDatabase>
|
|||
#include <QtSql/QSqlDriver>
|
|||
#include <QtSql/QSqlQuery>
|
|||
#include <QDebug>
|
|||
#include <QtSql/QSqlError>
|
|||
#include <QStringList>
|
|||
#include <QList>
|
|||
#include <QString>
|
|||
#include <QDebug>
|
|||
#include "enums/databasetype.h"
|
|||
namespace OpenTeacherTool {
|
|||
class Database
|
|||
{
|
|||
private:
|
|||
QSqlDatabase database;
|
|||
QString connectionName;
|
|||
bool seqTable;
|
|||
DatabaseType databasetype;
|
|||
bool supportTransactions;
|
|||
void setSeqTable(bool seqTable);
|
|||
void init();
|
|||
void createSequenceTable();
|
|||
QString querySequenceCounter();
|
|||
QStringList *tableList;
|
|||
protected:
|
|||
inline QString pgsqlSeqTable();
|
|||
inline QString mysqlSeqTable();
|
|||
inline QString sqliteSeqTable();
|
|||
inline QString sqliteTableList();
|
|||
inline QString mysqlTableList();
|
|||
inline QString pgsqlTableList();
|
|||
public:
|
|||
Database(QSqlDatabase database);
|
|||
~Database();
|
|||
Database(QString databaseType, QString databasename);
|
|||
Database(QString databaseType, QString connectionName, QString databasename);
|
|||
Database(QString databaseType, QString connectionName= "", QString hostname="",QString databasename = "" , QString username ="", QString password="", qint64 port=0);
|
|||
QSqlDatabase getDatabase();
|
|||
QString getConnectionName();
|
|||
QSqlQuery getQuery();
|
|||
QSqlQuery getQuery(const QString &prepare);
|
|||
bool transaction(const QString &query);
|
|||
bool transaction(const QStringList &queries);
|
|||
bool transaction(QSqlQuery &query);
|
|||
bool transaction(QList<QSqlQuery> &queries);
|
|||
bool exec(QString query);
|
|||
bool exec(QStringList queries);
|
|||
bool exec(QSqlQuery query);
|
|||
bool exec(QList<QSqlQuery> queries);
|
|||
bool select(QSqlQuery &query);
|
|||
QSqlQuery select(const QString &query);
|
|||
bool isSeqTable();
|
|||
qint64 getLastId();
|
|||
void getTableListFromDatabase();
|
|||
void setTableList(QSqlQuery &q);
|
|||
void refreshTableList();
|
|||
bool containsTable(QString tblname);
|
|||
bool updateSequenceCounter(QSqlQuery &q);
|
|||
DatabaseType getDatabaseType();
|
|||
QChar escapeChar();
|
|||
};
|
|||
}
|
|||
#endif // DATABASE_H
|