FolderList get_bookmark_folders() {
FolderList folders;
sqlite3 *db;
sqlite3_stmt *stmt;
std::string sql = "SELECT folderId, folder FROM folders ORDER BY folder";
if (!run_statement(sql, &db, &stmt))
goto exit;
{
int res = sqlite3_step(stmt);
while (res == SQLITE_ROW) {
Folder f;
f.id = sqlite3_column_string(stmt, 0, "-1");
f.name = sqlite3_column_string(stmt, 1, "");
folders.emplace_back(f);
res = sqlite3_step(stmt);
}
if (res != SQLITE_DONE) {
std::cerr << "Error reading rows: " << sqlite3_errmsg(db) << std::endl;
}
}
exit:
sqlite3_close(db);
return folders;
}
