C++ (Cpp) DB::executeQuery Examples

Example #1

File: TagCatalog.cpp Project: razeghi71/OOD-2015_razeghi71_MohammadChavosh

void TagCatalog::add(Tag &tag)
{
    DB *db = DB::getInstance();
    QString query = QString("INSERT INTO `Tag` VALUES (NULL,'%1')").
            arg(tag.getText());

    QSqlQuery *res = db->executeQuery(query);
    tag.setId(res->lastInsertId().toInt());
}

Example #2

File: TagCatalog.cpp Project: razeghi71/OOD-2015_razeghi71_MohammadChavosh

bool TagCatalog::exist(Tag tag)
{
    DB *db = DB::getInstance();
    QString query = QString("SELECT * from `Tag` where `text` like '%1'").
            arg(tag.getText());

    QSqlQuery *res = db->executeQuery(query);
    if ( res->next() )
        return true;
    return false;
}

Example #3

File: TagCatalog.cpp Project: razeghi71/OOD-2015_razeghi71_MohammadChavosh

void TagCatalog::relateTagToKnowledge(Tag tag, KnowledgeItem knowledge)
{
    if ( !exist(tag) )
        add(tag);

    DB *db = DB::getInstance();
    QString query = QString("INSERT INTO `KnowledgeTag` VALUES (NULL,'%1','%2')").
            arg(knowledge.getId()).
            arg(tag.getId());

    db->executeQuery(query);
}