/** * Fetches a note sub folder by it's path data */ NoteSubFolder NoteSubFolder::fetchByPathData(QString pathData) { QStringList pathList = pathData.split("\n"); NoteSubFolder noteSubFolder; QStringListIterator itr(pathList); // loop through all names to fetch the deepest note sub folder while (itr.hasNext()) { QString name = itr.next(); noteSubFolder = NoteSubFolder::fetchByNameAndParentId( name, noteSubFolder.getId()); if (!noteSubFolder.isFetched()) { return NoteSubFolder(); } } return noteSubFolder; }
/** * Fetches a note sub folder by its path data */ NoteSubFolder NoteSubFolder::fetchByPathData(QString pathData, QString separator) { pathData = Utils::Misc::removeIfStartsWith(pathData, separator); QStringList pathList = pathData.split(separator); NoteSubFolder noteSubFolder; QStringListIterator itr(pathList); // loop through all names to fetch the deepest note sub folder while (itr.hasNext()) { QString name = itr.next(); noteSubFolder = NoteSubFolder::fetchByNameAndParentId( name, noteSubFolder.getId()); if (!noteSubFolder.isFetched()) { return NoteSubFolder(); } } 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; }
void Note::setNoteSubFolder(NoteSubFolder noteSubFolder) { setNoteSubFolderId(noteSubFolder.getId()); }