/
NeoChapay
/
telegraf
Обзор
Документация
Войти
/
NeoChapay
/
telegraf
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/emojisearchworker.cpp
52 строки
2 KB
Mikhail Barashkov
refactor: update some paths to telegraf; remove commneted out migrateSettings method
07 сен 2024, 16:55
07 сен 2024, 16:55
d111e90
Код
Авторство
О чём код?
#include "emojisearchworker.h" #define DEBUG_MODULE EmojiSearchWorker #include "debuglog.h" EmojiSearchWorker::~EmojiSearchWorker() { LOG("Destroying myself..."); database.close(); } EmojiSearchWorker::EmojiSearchWorker(QObject *parent) : QThread(parent) { LOG("Initializing Emoji database"); QSqlDatabase::removeDatabase("emojis"); database = QSqlDatabase::addDatabase("QSQLITE", "emojis"); database.setDatabaseName("/usr/share/ru.telegrafaurora.telegraf/db/emojis.db"); } void EmojiSearchWorker::setParameters(const QString &queryString) { this->queryString = queryString; } void EmojiSearchWorker::performSearch() { LOG("Performing emoji search" << this->queryString); QVariantList resultList; if (database.open()) { QSqlQuery query(database); query.prepare("select * from emojis where description match (:queryString) limit 25"); query.bindValue(":queryString", queryString + "*"); query.exec(); while (query.next()) { if (isInterruptionRequested()) { break; } QVariantMap foundEmoji; foundEmoji.insert("file_name", query.value(0).toString()); foundEmoji.insert("emoji", query.value(1).toString()); foundEmoji.insert("emoji_version", query.value(2).toString()); foundEmoji.insert("description", query.value(3).toString()); resultList.append(foundEmoji); } database.close(); } else { LOG("Unable to perform a query on database" << database.lastError().databaseText()); } emit searchCompleted(queryString, resultList); }