From db5727c479abcb45f0b3aac515002ec89ed7b6f9 Mon Sep 17 00:00:00 2001 From: Bent Bisballe Nyeng Date: Sun, 24 Apr 2022 20:25:26 +0200 Subject: First steps towards krecipes support. --- src/database_gourmet.cc | 186 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 186 insertions(+) create mode 100644 src/database_gourmet.cc (limited to 'src/database_gourmet.cc') diff --git a/src/database_gourmet.cc b/src/database_gourmet.cc new file mode 100644 index 0000000..e556440 --- /dev/null +++ b/src/database_gourmet.cc @@ -0,0 +1,186 @@ +/* -*- c++ -*- */ +/*************************************************************************** + * database_gourmet.cc + * + * Sun Apr 24 18:27:56 CEST 2022 + * Copyright 2022 Bent Bisballe Nyeng + * deva@aasimon.org + ****************************************************************************/ + +/* + * This file is part of Qookie. + * + * Qookie is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 3 of the License, or + * (at your option) any later version. + * + * Qookie is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with Qookie; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. + */ +#include "database_gourmet.h" + +#include +#include + +// https://www.tutorialspoint.com/sqlite/sqlite_c_cpp.htm + +DatabaseGourmet::DatabaseGourmet(const std::string& file) +{ + auto rc = sqlite3_open(file.data(), &db); // https://sqlite.org/c3ref/open.html + if(rc) + { + std::cerr << "Can't open database: " << sqlite3_errmsg(db) << '\n'; + return; + } + else + { + std::cout << "Opened database successfully\n"; + } +} + +DatabaseGourmet::~DatabaseGourmet() +{ + sqlite3_close(db); +} + +namespace +{ +std::string getString(sqlite3_stmt *statement, int index) +{ + int size = sqlite3_column_bytes(statement, index); + std::string str; + str.append((const char*)sqlite3_column_blob(statement, index), size); + return str; +} +} // :: + +std::deque DatabaseGourmet::getRecipes() +{ + std::deque items; + + std::string sql = "select id, title, image from recipe"; + sqlite3_stmt *statement; + if(sqlite3_prepare_v2(db, sql.data(), sql.length(), &statement, 0) != SQLITE_OK) + { + std::cerr << "sqlite3_prepare_v2 failed: " << sqlite3_errmsg(db) << '\n'; + return {}; + } + + int result = 0; + while(true) + { + RecipeItem item; + result = sqlite3_step(statement); + + if(result == SQLITE_ROW) + { + item.id = sqlite3_column_int(statement, 0); + + item.title = getString(statement, 1); + item.image = getString(statement, 2); + } + else + { + break; + } + items.push_back(item); + } + + return items; +} + +Recipe DatabaseGourmet::getRecipe(std::uint64_t id) +{ + bool found{false}; + Recipe recipe; + + { + std::string sql = + "select id, title, description, image, instructions, source, link, cuisine, cooktime, preptime, yields, yield_unit, modifications from recipe where id=" + + std::to_string(id); + sqlite3_stmt *statement; + if(sqlite3_prepare_v2(db, sql.data(), sql.length(), &statement, 0) != SQLITE_OK) + { + std::cerr << "sqlite3_prepare_v2 failed: " << sqlite3_errmsg(db) << '\n'; + return {}; + } + + int result = 0; + while(true) + { + result = sqlite3_step(statement); + + if(result == SQLITE_ROW) + { + recipe.id = sqlite3_column_int(statement, 0); + recipe.title = getString(statement, 1); + recipe.description = getString(statement, 2); + recipe.image = getString(statement, 3); + recipe.instructions = getString(statement, 4); + recipe.source = getString(statement, 5); + if(!recipe.source.empty()) + { + recipe.source += " "; + } + recipe.source += getString(statement, 6); + recipe.cuisine = getString(statement, 7); + recipe.cooktime = sqlite3_column_int(statement, 8); + recipe.preptime = sqlite3_column_int(statement, 9); + recipe.yields = sqlite3_column_double(statement, 10); + recipe.yield_unit = getString(statement, 11); + recipe.tags.push_back(getString(statement, 12)); + } + else + { + break; + } + found = true; + } + } + + if(!found) + { + std::cerr << "id " << id << " not found\n"; + return {}; + } + + { + std::string sql = + "select amount, unit, item from ingredients where recipe_id=" + + std::to_string(id) + " order by position asc"; + sqlite3_stmt *statement; + if(sqlite3_prepare_v2(db, sql.data(), sql.length(), &statement, 0) != SQLITE_OK) + { + std::cerr << "sqlite3_prepare_v2 failed: " << sqlite3_errmsg(db) << '\n'; + return {}; + } + + int result = 0; + while(true) + { + Ingredient ingredient; + result = sqlite3_step(statement); + + if(result == SQLITE_ROW) + { + ingredient.amount = sqlite3_column_double(statement, 0); + ingredient.unit = getString(statement, 1); + ingredient.item = getString(statement, 2); + recipe.ingredients.push_back(ingredient); + } + else + { + break; + } + } + } + + return recipe; +} -- cgit v1.2.3