void searchNode() {
Node *current = dataList.head;
clearQNode();
while (current) {
if (checkQuery(current->data)) {
appendQNode(current->data);
}
current = current->next;
}
}
bool guFolderInspector::inLibGen(QString MD5)
{
QSqlQuery checkQuery(libGenDb);
checkQuery.prepare("SELECT ID from updated WHERE MD5 = :MD5;");
checkQuery.bindValue(":MD5", MD5);
checkQuery.exec();
if (checkQuery.first()) //если запись обнаружена
{
return true;
}else
{
return false;
}
}
bool ProfileDB::profileExists(int profileID) const
{
bool exists = false;
QSqlQuery checkQuery(QSqlDatabase::database(connectionName));
checkQuery.prepare("SELECT ProfileID FROM Profiles WHERE ProfileID = (:ProfileID)");
checkQuery.bindValue(":ProfileID", profileID);
if (checkQuery.exec())
{
if (checkQuery.next())
{
exists = true;
}
}
else
{
//qDebug() << "profile exists failed: " << checkQuery.lastError();
}
return exists;
}
void mysqlQuery::execute(QString const& sql)
{
Query = createQuery(sql);
checkQuery();
}
void mysqlQuery::execute(void)
{
Query = createQuery(query()->sql());
checkQuery();
}
