Query.cpp

#include "Query.h"

#include <algorithm>

namespace sqlb
{

void Query::clear()
{
    m_table.clear();
    m_rowid_columns = {"_rowid_"};
    m_selected_columns.clear();
    m_where.clear();
    m_sort.clear();
}

std::string Query::buildWherePart() const
{
    if(m_where.empty() && m_global_where.empty())
        return std::string();

    std::string where = "WHERE ";

    if(m_where.size())
    {
        for(auto i=m_where.cbegin();i!=m_where.cend();++i)
        {
            const auto it = findSelectedColumnByName(i->first);
            std::string column = sqlb::escapeIdentifier(i->first);
            if(it != m_selected_columns.cend() && it->selector != i->first)
                column = it->selector;
            where += column + " " + i->second + " AND ";
        }

        // Remove last ' AND '
        where.erase(where.size() - 5);
    }

    if(m_global_where.size())
    {
        // Connect to previous conditions if there are any
        if(m_where.size())
            where += " AND ";

        // For each condition
        for(const auto& w : m_global_where)
        {
            where += "(";

            // For each selected column
            for(const auto& c : m_column_names)
            {
                const auto it = findSelectedColumnByName(c);
                std::string column = sqlb::escapeIdentifier(c);
                if(it != m_selected_columns.cend() && it->selector != column)
                    column = it->selector;

                where += column + " " + w + " OR ";
            }

            // Remove last ' OR '
            where.erase(where.size() - 4);

            where += ") AND ";
        }

        // Remove last ' AND '
        where.erase(where.size() - 5);
    }

    return where;
}

std::string Query::buildQuery(bool withRowid) const
{
    // Selector and display formats
    std::string selector;
    if (withRowid)
    {
        // We select the rowid data into a JSON array in case there are multiple rowid columns in order to have all values at hand.
        // If there is only one rowid column, we leave it as is.
        if(m_rowid_columns.size() == 1)
        {
            // As of SQLite 3.36 when selecting rowid from a view SQLite does not return NULL anymore but instead returns "rowid" and throws
            // an error. To avoid that error (we don't actually care for the value of this column, so the value is not the issue here) we
            // explicitly select NULL (without any quotes) here.
            if(m_is_view && !hasCustomRowIdColumn())
                selector = "NULL,";
            else
                selector = sqlb::escapeIdentifier(m_rowid_columns.at(0)) + ",";
        } else {
            selector += "sqlb_make_single_value(";
            for(size_t i=0;i<m_rowid_columns.size();i++)
                selector += sqlb::escapeIdentifier(m_rowid_columns.at(i)) + ",";
            selector.pop_back();    // Remove the last comma
            selector += "),";
        }
    }

    if(m_selected_columns.empty())
    {
        selector += "*";
    } else {
        for(const auto& it : m_selected_columns)
        {
            if (it.original_column != it.selector)
                selector += it.selector + " AS " + sqlb::escapeIdentifier(it.original_column) + ",";
            else
                selector += sqlb::escapeIdentifier(it.original_column) + ",";
        }
        selector.pop_back();
    }

    // Filter
    std::string where = buildWherePart();

    // Sorting
    std::string order_by;
    for(const auto& sorted_column : m_sort)
        order_by += sorted_column.toSql() + ",";
    if(order_by.size())
    {
        order_by.pop_back();
        order_by = "ORDER BY " + order_by;
    }

    return "SELECT " + selector + " FROM " + m_table.toString() + " " + where + " " + order_by;
}

std::string Query::buildCountQuery() const
{
    // Build simplest count query for this (filtered) table
    return "SELECT COUNT(*) FROM " + m_table.toString() + " " + buildWherePart();
}

std::vector<SelectedColumn>::iterator Query::findSelectedColumnByName(const std::string& name)
{
    return std::find_if(m_selected_columns.begin(), m_selected_columns.end(), [name](const SelectedColumn& c) {
        return name == c.original_column;
    });
}

std::vector<SelectedColumn>::const_iterator Query::findSelectedColumnByName(const std::string& name) const
{
    return std::find_if(m_selected_columns.cbegin(), m_selected_columns.cend(), [name](const SelectedColumn& c) {
        return name == c.original_column;
    });
}

}