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