SqlWordSource.cpp

#include "SqlWordSource.h"

#include <QSqlQuery>
#include <QSqlError>
#include <QVariant>
#include <QDebug>

SqlWordSource::SqlWordSource(const QSqlDatabase& db,
                             const QString& language)
    : m_db(db)
    , m_language(language)
{
}

QString SqlWordSource::getWord() const
{
    if (!m_db.isOpen()) {
        qWarning() << "SqlWordSource::getWord: database is not open";
        return {};
    }

    QSqlQuery query(m_db);
    // SQLite için basit ve yeterli: rastgele bir kelime seç
    query.prepare(
        "SELECT text "
        "FROM words "
        "WHERE length = :len AND language = :lang AND is_answer = 1 "
        "ORDER BY RANDOM() "
        "LIMIT 1"
    );
    query.bindValue(":len", GameConfig::WORD_LENGTH);
    query.bindValue(":lang", m_language);

    if (!query.exec()) {
        qWarning() << "SqlWordSource::getWord query failed:" << query.lastError().text();
        return {};
    }

    if (query.next()) {
        return query.value(0).toString();
    }

    // Uygun kayıt yoksa boş döndür.
    return {};
}

bool SqlWordSource::contains(const QString& word) const
{
    if (!m_db.isOpen()) {
        qWarning() << "SqlWordSource::contains: database is not open";
        return false;
    }

    QSqlQuery query(m_db);
    query.prepare(
        "SELECT 1 "
        "FROM words "
        "WHERE text = :text AND language = :lang "
        "LIMIT 1"
    );
    query.bindValue(":text", word.toUpper());
    query.bindValue(":lang", m_language);

    if (!query.exec()) {
        qWarning() << "SqlWordSource::contains query failed:" << query.lastError().text();
        return false;
    }

    return query.next();
}