Method bindValues

YACReaderLibrary/db/query_parser.cpp:98–148

}

int QueryParser::TreeNode::bindValues(QSqlQuery &selectQuery, int bindPosition) const
{
    if (t == "expression") {
        std::string bind_string(":bindPosition" + std::to_string(++bindPosition));
        if (isIn(fieldType(children[0].t), { FieldType::numeric })) {
            selectQuery.bindValue(QString::fromStdString(bind_string), std::stoi(children[1].t));
        } else if (isIn(fieldType(children[0].t), { FieldType::boolean, FieldType::booleanFolder })) {
            auto value = toLower(children[1].t);
            if (value == "true") {
                selectQuery.bindValue(QString::fromStdString(bind_string), 1);
            } else if (value == "false") {
                selectQuery.bindValue(QString::fromStdString(bind_string), 0);
            } else {
                selectQuery.bindValue(QString::fromStdString(bind_string), std::stoi(value));
            }
        } else if ((isIn(fieldType(children[0].t), { FieldType::enumField, FieldType::enumFieldFolder }))) {
            auto enumType = children[0].t;
            auto value = toLower(children[1].t);
            if (enumType == "type" || enumType == "foldertype") {
                if (value == "comic") {
                    selectQuery.bindValue(QString::fromStdString(bind_string), 0);
                } else if (value == "manga") {
                    selectQuery.bindValue(QString::fromStdString(bind_string), 1);
                } else if (value == "westernmanga") {
                    selectQuery.bindValue(QString::fromStdString(bind_string), 2);
                } else if (value == "webcomic" || value == "web") {
                    selectQuery.bindValue(QString::fromStdString(bind_string), 3);
                } else if (value == "4koma" || value == "yonkoma") {
                    selectQuery.bindValue(QString::fromStdString(bind_string), 4);
                }
            } else {
                selectQuery.bindValue(QString::fromStdString(bind_string), std::stoi(children[1].t));
            }
        } else if ((isIn(fieldType(children[0].t), { FieldType::date, FieldType::dateFolder }))) {
            selectQuery.bindValue(QString::fromStdString(bind_string), QString::fromStdString(parseDate(children[1].t, expOperator)));
        } else {
            if (expOperator == "=" || expOperator == ":" || expOperator == "") {
                selectQuery.bindValue(QString::fromStdString(bind_string), QString::fromStdString("%%" + children[1].t + "%%"));
            } else {
                selectQuery.bindValue(QString::fromStdString(bind_string), QString::fromStdString(children[1].t));
            }
        }
    } else if (t == "not") {
        bindPosition = children[0].bindValues(selectQuery, bindPosition);
    } else {
        bindPosition = children[0].bindValues(selectQuery, bindPosition);
        bindPosition = children[1].bindValues(selectQuery, bindPosition);
    }

    return bindPosition;
}

QueryParser::QueryParser()
{