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;
}