sql.h

/*
 * SPDX-FileCopyrightText: (C) 2015-2022 Daniel Nicoletti <dantti12@gmail.com>
 * SPDX-License-Identifier: BSD-3-Clause
 */
#ifndef CSQL_H
#define CSQL_H
 
#include <Cutelyst/cutelyst_global.h>
#include <Cutelyst/paramsmultimap.h>
 
#include <QtCore/QVariant>
#include <QtSql/QSqlDatabase>
 
namespace Cutelyst {
 
namespace Sql {

class CUTELYST_PLUGIN_UTILS_SQL_EXPORT Transaction
{
public:
    explicit Transaction(const QString &databaseName = QString());
    Transaction(const QSqlDatabase &database);
    ~Transaction();
 
    bool transaction() const;
    bool commit();
    bool rollback();
 
private:
    QSqlDatabase m_db;
    bool m_transactionRunning;
};

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QVariantHash queryToHashObject(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QVariantList queryToHashList(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QVariantMap queryToMapObject(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QJsonObject queryToJsonObject(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QVariantList queryToMapList(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QJsonArray queryToJsonObjectArray(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QVariantList queryToList(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QJsonArray queryToJsonArray(QSqlQuery &query);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QVariantHash queryToIndexedHash(QSqlQuery &query,
                                                                 const QString &key);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QJsonObject queryToIndexedJsonObject(QSqlQuery &query,
                                                                      const QString &key);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT void bindParamsToQuery(QSqlQuery &query,
                                                        const Cutelyst::ParamsMultiMap &params,
                                                        bool htmlEscaped = true);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QSqlQuery preparedQuery(const QString &query,
                                                         QSqlDatabase db  = QSqlDatabase(),
                                                         bool forwardOnly = false);

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QString databaseNameThread(const QString &dbName = QString());

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QSqlDatabase databaseThread(const QString &dbName = QString());

CUTELYST_PLUGIN_UTILS_SQL_EXPORT QSqlQuery preparedQueryThread(const QString &query,
                                                               const QString &dbName = QString(),
                                                               bool forwardOnly      = false);
} // namespace Sql
 
} // namespace Cutelyst
 
#define CPreparedSqlQueryForDatabase(str, db) \
    ([]() -> QSqlQuery { \
        static thread_local QSqlQuery query_temp = Cutelyst::Sql::preparedQuery(str, db); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQuery(str) \
    ([]() -> QSqlQuery { \
        static QSqlQuery query_temp = Cutelyst::Sql::preparedQuery(str); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQueryThread(str) \
    ([]() -> QSqlQuery { \
        static thread_local QSqlQuery query_temp = Cutelyst::Sql::preparedQueryThread(str); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQueryThreadForDB(str, db) \
    ([]() -> QSqlQuery { \
        static thread_local QSqlQuery query_temp = Cutelyst::Sql::preparedQueryThread(str, db); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQueryForDatabaseFO(str, db) \
    ([]() -> QSqlQuery { \
        static thread_local QSqlQuery query_temp = Cutelyst::Sql::preparedQuery(str, db, true); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQueryFO(str) \
    ([]() -> QSqlQuery { \
        static QSqlQuery query_temp = Cutelyst::Sql::preparedQuery(str, QSqlDatabase(), true); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQueryThreadFO(str) \
    ([]() -> QSqlQuery { \
        static thread_local QSqlQuery query_temp = \
            Cutelyst::Sql::preparedQueryThread(str, QString(), true); \
        return query_temp; \
    }()) /**/
 
#define CPreparedSqlQueryThreadForDBFO(str, db) \
    ([]() -> QSqlQuery { \
        static thread_local QSqlQuery query_temp = \
            Cutelyst::Sql::preparedQueryThread(str, db, true); \
        return query_temp; \
    }()) /**/
 
#endif // CSQL_H