#include "abstractsqlstorage.h"
+#include "logger.h"
+
#include <QSqlError>
#include <QSqlQuery>
if(!openDb()) {
qWarning() << "Unable to Open Database" << displayName();
- qWarning() << " -" << db.lastError().text();
+ qWarning() << "-" << db.lastError().text();
}
return QSqlDatabase::database("quassel_connection");
return false;
if(installedSchemaVersion() == -1) {
- qDebug() << "Storage Schema is missing!";
+ qCritical() << "Storage Schema is missing!";
return false;
}
if(installedSchemaVersion() > schemaVersion()) {
- qWarning() << "Installed Schema is newer then any known Version.";
+ qCritical() << "Installed Schema is newer then any known Version.";
return false;
}
return false;
}
- qDebug() << "Storage Backend is ready. Quassel Schema Version:" << installedSchemaVersion();
+ quInfo() << "Storage Backend is ready. Quassel Schema Version:" << installedSchemaVersion();
return true;
}
QFileInfo queryInfo(QString(":/SQL/%1/%2/%3.sql").arg(displayName()).arg(version).arg(queryName));
if(!queryInfo.exists() || !queryInfo.isFile() || !queryInfo.isReadable()) {
- qWarning() << "Unable to read SQL-Query" << queryName << "for engine" << displayName();
+ qCritical() << "Unable to read SQL-Query" << queryName << "for engine" << displayName();
return QString();
}
Q_UNUSED(settings)
QSqlDatabase db = logDb();
if(!db.isOpen()) {
- qWarning() << "Unable to setup Logging Backend!";
+ qCritical() << "Unable to setup Logging Backend!";
return false;
}
foreach(QString queryString, setupQueries()) {
QSqlQuery query = db.exec(queryString);
if(!watchQuery(&query)) {
- qWarning() << "Unable to setup Logging Backend!";
+ qCritical() << "Unable to setup Logging Backend!";
return false;
}
}
foreach(QString queryString, upgradeQueries(ver)) {
QSqlQuery query = db.exec(queryString);
if(!watchQuery(&query)) {
- qWarning() << "Unable to upgrade Logging Backend!";
+ qCritical() << "Unable to upgrade Logging Backend!";
return false;
}
}
bool AbstractSqlStorage::watchQuery(QSqlQuery *query) {
if(query->lastError().isValid()) {
- qWarning() << "unhandled Error in QSqlQuery!";
- qWarning() << " last Query:\n" << query->lastQuery();
- qWarning() << " executed Query:\n" << query->executedQuery();
- qWarning() << " bound Values:" << query->boundValues();
- qWarning() << " Error Number:" << query->lastError().number();
- qWarning() << " Error Message:" << query->lastError().text();
- qWarning() << " Driver Message:" << query->lastError().driverText();
- qWarning() << " DB Message:" << query->lastError().databaseText();
+ qCritical() << "unhandled Error in QSqlQuery!";
+ qCritical() << " last Query:\n" << query->lastQuery();
+ qCritical() << " executed Query:\n" << query->executedQuery();
+ qCritical() << " bound Values:";
+ QList<QVariant> list = query->boundValues().values();
+ for (int i = 0; i < list.size(); ++i)
+ qCritical() << i << ": " << list.at(i).toString().toAscii().data();
+ qCritical() << " Error Number:" << query->lastError().number();
+ qCritical() << " Error Message:" << query->lastError().text();
+ qCritical() << " Driver Message:" << query->lastError().driverText();
+ qCritical() << " DB Message:" << query->lastError().databaseText();
return false;
}