Tag Tag::fetch(int id) { QSqlDatabase db = QSqlDatabase::database("note_folder"); QSqlQuery query(db); Tag tag; query.prepare("SELECT * FROM tag WHERE id = :id"); query.bindValue(":id", id); if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else if (query.first()) { tag.fillFromQuery(query); } return tag; }
Tag Tag::fetchByName(QString name) { QSqlDatabase db = QSqlDatabase::database("note_folder"); QSqlQuery query(db); Tag tag; query.prepare("SELECT * FROM tag WHERE LOWER(name) = :name"); query.bindValue(":name", name.toLower()); if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else if (query.first()) { tag.fillFromQuery(query); } return tag; }
Tag Tag::tagFromQuery(QSqlQuery query) { Tag tag; tag.fillFromQuery(query); return tag; }