QList<NoteSubFolder> NoteSubFolder::fetchAll(int limit) { QSqlDatabase db = QSqlDatabase::database("memory"); QSqlQuery query(db); QList<NoteSubFolder> noteSubFolderList; QString sql = "SELECT * FROM noteSubFolder " "ORDER BY file_last_modified DESC"; if (limit >= 0) { sql += " LIMIT :limit"; } query.prepare(sql); if (limit >= 0) { query.bindValue(":limit", limit); } if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else { for (int r = 0; query.next(); r++) { NoteSubFolder noteSubFolder = noteSubFolderFromQuery(query); noteSubFolderList.append(noteSubFolder); } } return noteSubFolderList; }
NoteSubFolder NoteSubFolder::fetch(int id) { QSqlDatabase db = QSqlDatabase::database("memory"); QSqlQuery query(db); NoteSubFolder noteSubFolder; query.prepare("SELECT * FROM noteSubFolder WHERE id = :id"); query.bindValue(":id", id); if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else { if (query.first()) { noteSubFolder = noteSubFolderFromQuery(query); } } return noteSubFolder; }
QList<int> NoteSubFolder::fetchAllIds() { QSqlDatabase db = QSqlDatabase::database("memory"); QSqlQuery query(db); QList<int> idList; QString sql = "SELECT * FROM noteSubFolder"; query.prepare(sql); if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else { for (int r = 0; query.next(); r++) { NoteSubFolder noteSubFolder = noteSubFolderFromQuery(query); idList.append(noteSubFolder.getId()); } } return idList; }
NoteSubFolder NoteSubFolder::fetchByNameAndParentId( QString name, int parentId) { QSqlDatabase db = QSqlDatabase::database("memory"); QSqlQuery query(db); NoteSubFolder noteSubFolder; query.prepare("SELECT * FROM noteSubFolder WHERE name = :name " "AND parent_id = :parent_id"); query.bindValue(":name", name); query.bindValue(":parent_id", parentId); if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else { if (query.first()) { noteSubFolder = noteSubFolderFromQuery(query); } } return noteSubFolder; }
QList<NoteSubFolder> NoteSubFolder::fetchAllByParentId(int parentId) { QSqlDatabase db = QSqlDatabase::database("memory"); QSqlQuery query(db); QList<NoteSubFolder> noteSubFolderList; QString sql = "SELECT * FROM noteSubFolder WHERE parent_id = " ":parent_id ORDER BY file_last_modified DESC"; query.prepare(sql); query.bindValue(":parent_id", parentId); if (!query.exec()) { qWarning() << __func__ << ": " << query.lastError(); } else { for (int r = 0; query.next(); r++) { NoteSubFolder noteSubFolder = noteSubFolderFromQuery(query); noteSubFolderList.append(noteSubFolder); } } return noteSubFolderList; }