Method Remove

src/openboardview/Annotations.cpp:197–225

}

bool Annotations::Remove(int id) {
	static const char sql[] = "UPDATE annotations SET visible = 0 WHERE id=?;";

	sqlite3_stmt *stmt;
	int r = sqlite3_prepare_v2(sqldb, sql, -1, &stmt, NULL);
	if (r != SQLITE_OK) {
		SDL_LogError(SDL_LOG_CATEGORY_ERROR, "Annotations UPDATE statement could not be prepared: %s", sqlite3_errmsg(sqldb));
		return false;
	}

	r = sqlite3_bind_int(stmt, 1, id);

	if (r != SQLITE_OK) {
		SDL_LogError(SDL_LOG_CATEGORY_ERROR, "Annotations UPDATE statement parameter could not be bound: %s", sqlite3_errmsg(sqldb));
		r = sqlite3_finalize(stmt);
		return false;
	}

	r = sqlite3_step(stmt);

	r = sqlite3_finalize(stmt);

	if (r != SQLITE_DONE && r != SQLITE_OK) {
		SDL_LogError(SDL_LOG_CATEGORY_ERROR, "Annotations UPDATE statement failed: %s", sqlite3_errmsg(sqldb));
		return false;
	}

	return true;
}

bool Annotations::Update(int id, const std::string &note) {
	static const char sql[] = "UPDATE annotations SET note = ? WHERE id=?;";