mysqlquery.cpp

#include "mysqlquery.h"
using namespace SqlUtil4;

MySqlQuery::MySqlQuery():SqlQuery( )
{

}


QString MySqlQuery::toString()
{
    QString query;
    if (!selectFields.isEmpty()) {
        query += QStringLiteral("SELECT %1 FROM %2").arg(selectFields, fromTable);
    } else if (!deleteFromTable.isEmpty()) {
         query+= QStringLiteral("DELETE FROM %1").arg(deleteFromTable);
    }

    for(int i=0;i<joinTables.size();i++) {
        query+=joinTables.at(i);
    }

    if (!conditions.empty()) {
        query+= QStringLiteral(" WHERE ");


        for(const QString &cond: conditions) {
            query += cond;
        }
    }

    if(!orderByExpression.isEmpty()) {
        query += QStringLiteral(" ORDER BY %1").arg(orderByExpression);
    }

    if (group.size()>0) {
        query += QStringLiteral(" GROUP BY %1").arg(group.at(0));
        for(int i=1;i<group.size();i++) {
            query += QStringLiteral(", %1").arg(group.at(i));
        }
    }
    if (limitResults>0) {
        query += QStringLiteral("LIMIT %1").arg( limitResults);
    }
    return query;

}