X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fabstractsqlstorage.cpp;h=c6eeeec3fa56695b903bdc6446b3be59598d696a;hp=b20d1dcdcbe9f31d1c03eb6ddeff50a972e5f6db;hb=99934fe47293f61e1e62ecc0f0d49f958a992c32;hpb=0c9cd0eef379e1d3e10a75cc8506a7e65f95fd67 diff --git a/src/core/abstractsqlstorage.cpp b/src/core/abstractsqlstorage.cpp index b20d1dcd..c6eeeec3 100644 --- a/src/core/abstractsqlstorage.cpp +++ b/src/core/abstractsqlstorage.cpp @@ -20,6 +20,8 @@ #include "abstractsqlstorage.h" +#include "logger.h" + #include #include @@ -51,7 +53,7 @@ QSqlDatabase AbstractSqlStorage::logDb() { if(!openDb()) { qWarning() << "Unable to Open Database" << displayName(); - qWarning() << " -" << db.lastError().text(); + qWarning() << "-" << db.lastError().text(); } return QSqlDatabase::database("quassel_connection"); @@ -83,12 +85,12 @@ bool AbstractSqlStorage::init(const QVariantMap &settings) { 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; } @@ -98,7 +100,7 @@ bool AbstractSqlStorage::init(const QVariantMap &settings) { return false; } - qDebug() << "Storage Backend is ready. Quassel Schema Version:" << installedSchemaVersion(); + quInfo() << "Storage Backend is ready. Quassel Schema Version:" << installedSchemaVersion(); return true; } @@ -118,7 +120,7 @@ QString AbstractSqlStorage::queryString(const QString &queryName, int version) { 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(); } @@ -162,14 +164,14 @@ bool AbstractSqlStorage::setup(const QVariantMap &settings) { 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; } } @@ -195,7 +197,7 @@ bool AbstractSqlStorage::upgradeDb() { 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; } } @@ -229,14 +231,17 @@ int AbstractSqlStorage::schemaVersion() { 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 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; }