/**
* 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());
}
