QDebug operator<<(QDebug dbg, const TrashItem &trashItem) { NoteSubFolder noteSubFolder = NoteSubFolder::fetchByPathData(trashItem.noteSubFolderPathData); dbg.nospace() << "TrashItem: <id>" << trashItem.id << " <fileName>" << trashItem.fileName << " <noteSubFolderId>" << trashItem.noteSubFolderId << " <_fullNoteFilePath>" << trashItem._fullNoteFilePath << " <relativePath>" << noteSubFolder.relativePath(); return dbg.space(); }
QDebug operator<<(QDebug dbg, const Note ¬e) { NoteSubFolder noteSubFolder = NoteSubFolder::fetch(note.noteSubFolderId); dbg.nospace() << "Note: <id>" << note.id << " <name>" << note.name << " <fileName>" << note.fileName << " <noteSubFolderId>" << note.noteSubFolderId << " <relativePath>" << noteSubFolder.relativePath() << " <hasDirtyData>" << note.hasDirtyData; return dbg.space(); }
/** * Returns the relative path of the trashItem file */ QString TrashItem::relativeNoteFilePath(QString separator) { QString fullFileName = fileName; if (separator.isEmpty()) { separator = Utils::Misc::dirSeparator(); } if (noteSubFolderId > 0) { NoteSubFolder noteSubFolder = getNoteSubFolder(); if (noteSubFolder.isFetched()) { fullFileName.prepend(noteSubFolder.relativePath() + separator); } } return fullFileName; }
/** * Returns the relative path of the note file */ QString Note::relativeNoteFilePath(QString separator) { QString fullFileName = fileName; if (separator.isEmpty()) { separator = QDir::separator(); } if (noteSubFolderId > 0) { NoteSubFolder noteSubFolder = getNoteSubFolder(); if (noteSubFolder.isFetched()) { fullFileName.prepend(noteSubFolder.relativePath() + separator); } } return fullFileName; }
/** * 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 TrashItem::setNoteSubFolder(NoteSubFolder noteSubFolder) { this->noteSubFolderPathData = noteSubFolder.pathData(); }
NoteSubFolder NoteSubFolder::noteSubFolderFromQuery(QSqlQuery query) { NoteSubFolder noteSubFolder; noteSubFolder.fillFromQuery(query); return noteSubFolder; }
void Note::setNoteSubFolder(NoteSubFolder noteSubFolder) { setNoteSubFolderId(noteSubFolder.getId()); }