util.h

Go to the documentation of this file.

/**********************************************************************
 * LeechCraft - modular cross-platform feature rich internet client.
 * Copyright (C) 2006-2014  Georg Rudoy
 *
 * Distributed under the Boost Software License, Version 1.0.
 * (See accompanying file LICENSE or copy at https://www.boost.org/LICENSE_1_0.txt)
 **********************************************************************/
 
#pragma once
 
#include <QVariant>
#include <QSqlQuery>
#include <QtDebug>
#include "dbconfig.h"
 
class QSqlDatabase;
class QString;
 
namespace LC::Util
{
    UTIL_DB_API QSqlQuery RunTextQuery (const QSqlDatabase& db, const QString& text);

    UTIL_DB_API QString LoadQuery (const QString& plugin, const QString& filename);

    UTIL_DB_API void RunQuery (const QSqlDatabase& db, const QString& plugin, const QString& filename);

    template<typename T = int>
    T GetLastId (const QSqlQuery& query)
    {
        const auto& lastVar = query.lastInsertId ();
        if (lastVar.isNull ())
            throw std::runtime_error { "No last ID has been reported." };
 
        if (!lastVar.canConvert<T> ())
        {
            qWarning () << Q_FUNC_INFO
                    << "cannot convert"
                    << lastVar;
            throw std::runtime_error { "Cannot convert last ID." };
        }
 
        return lastVar.value<T> ();
    }

    UTIL_DB_API QString GenConnectionName (const QString& base);
 
    enum class UserDir;
 
    struct SqliteDatabaseConfig
    {
        QString Connection_;
        UserDir DirKind_;
        QString Dir_;
        QString Filename_;
    };
 
    UTIL_DB_API QSqlDatabase OpenSqliteDatabase (const SqliteDatabaseConfig&);
}