summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/database.cc127
-rw-r--r--src/database.h48
-rw-r--r--src/mainwindow.cc111
-rw-r--r--src/mainwindow.h48
-rw-r--r--src/qookie.cc45
-rw-r--r--src/recipe.h47
6 files changed, 426 insertions, 0 deletions
diff --git a/src/database.cc b/src/database.cc
new file mode 100644
index 0000000..5ae045a
--- /dev/null
+++ b/src/database.cc
@@ -0,0 +1,127 @@
+/* -*- c++ -*- */
+/***************************************************************************
+ * database.cc
+ *
+ * Sat Apr 23 19:09:12 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 2 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.h"
+
+#include <sqlite3.h>
+#include <iostream>
+
+// https://www.tutorialspoint.com/sqlite/sqlite_c_cpp.htm
+
+Database::Database(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";
+ }
+}
+
+Database::~Database()
+{
+ sqlite3_close(db);
+}
+
+std::deque<RecipeItem> Database::getRecipes()
+{
+ std::deque<RecipeItem> 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 << "Open database failed\n";
+ return {};
+ }
+
+ int result = 0;
+ while(true)
+ {
+ RecipeItem item;
+ result = sqlite3_step(statement);
+
+ if(result == SQLITE_ROW)
+ {
+ item.id = sqlite3_column_int(statement, 0);
+
+ int title_size = sqlite3_column_bytes(statement, 1);
+ item.title.append((const char*)sqlite3_column_blob(statement, 1), title_size);
+
+ int image_size = sqlite3_column_bytes(statement, 2);
+ item.image.append((const char*)sqlite3_column_blob(statement, 2), image_size);
+ }
+ else
+ {
+ break;
+ }
+ items.push_back(item);
+ }
+
+ return items;
+}
+
+Recipe Database::getRecipe(int id)
+{
+ // TODO
+
+ std::string sql = "select id, title, image from recipe where id=" + id;
+ sqlite3_stmt *statement;
+ if(sqlite3_prepare_v2(db, sql.data(), sql.length(), &statement, 0) != SQLITE_OK)
+ {
+ std::cerr << "Open database failed\n";
+ return {};
+ }
+
+ int result = 0;
+ while(true)
+ {
+ Recipe item;
+ result = sqlite3_step(statement);
+
+ if(result == SQLITE_ROW)
+ {
+ item.id = sqlite3_column_int(statement, 0);
+
+ int title_size = sqlite3_column_bytes(statement, 1);
+ item.title.append((const char*)sqlite3_column_blob(statement, 1), title_size);
+
+ int image_size = sqlite3_column_bytes(statement, 2);
+ item.image.append((const char*)sqlite3_column_blob(statement, 2), image_size);
+ }
+ else
+ {
+ break;
+ }
+ return item;
+ }
+
+ return {}; // Not found
+}
diff --git a/src/database.h b/src/database.h
new file mode 100644
index 0000000..1235551
--- /dev/null
+++ b/src/database.h
@@ -0,0 +1,48 @@
+/* -*- c++ -*- */
+/***************************************************************************
+ * database.h
+ *
+ * Sat Apr 23 19:09:12 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 2 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.
+ */
+#pragma once
+
+#include <string>
+#include <deque>
+#include <string>
+
+#include "recipe.h"
+
+struct sqlite3;
+
+class Database
+{
+public:
+ Database(const std::string& file);
+ ~Database();
+
+ std::deque<RecipeItem> getRecipes();
+ Recipe getRecipe(int id);
+
+private:
+ sqlite3 *db{nullptr};
+};
diff --git a/src/mainwindow.cc b/src/mainwindow.cc
new file mode 100644
index 0000000..c1b05f7
--- /dev/null
+++ b/src/mainwindow.cc
@@ -0,0 +1,111 @@
+/* -*- c++ -*- */
+/***************************************************************************
+ * mainwindow.cc
+ *
+ * Sat Apr 23 18:59:48 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 2 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 "mainwindow.h"
+
+#include <QToolBar>
+#include <QDockWidget>
+#include <QLabel>
+#include <QPixmap>
+#include <QListWidget>
+
+#include "database.h"
+
+MainWindow::MainWindow(Database& db)
+ : db(db)
+{
+ //connect(document, SIGNAL(documentStatusChanged(bool)), this, SLOT(updateDocumentStatus(bool)));
+ //updateDocumentStatus(document->hasChanged());
+
+ //
+ // Create the toolbar
+ //
+ QToolBar *toolbar = new QToolBar("A toolbar");
+
+ QAction *act_load = toolbar->addAction("Load");
+ // connect(act_load, SIGNAL(triggered()), &document, SLOT(load()));
+
+ QAction *act_save = toolbar->addAction("Save");
+ // connect(act_save, SIGNAL(triggered()), &document, SLOT(save()));
+
+ //
+ // Create the browser docking widget
+ //
+ QDockWidget *browser = new QDockWidget("Browser");
+ listWidget = new QListWidget(this);
+ listWidget->setIconSize({128, 128});
+ browser->setWidget(listWidget);
+
+ //
+ // Create the viewer
+ //
+// viewer = new Viewer();
+// setCentralWidget(viewer);
+
+ addToolBar(Qt::TopToolBarArea, toolbar);
+ addDockWidget(Qt::LeftDockWidgetArea, browser);
+
+// connect signal:
+// void itemChanged(QListWidgetItem *item) in listWidget to itemchanged slot
+
+ readDatabase();
+}
+
+MainWindow::~MainWindow()
+{
+}
+
+//void MainWindow::updateDocumentStatus(bool changed)
+//{
+// setWindowTitle(QString("foo bar") + (changed?"*":""));
+//}
+
+void MainWindow::readDatabase()
+{
+ auto items = db.getRecipes();
+ for(const auto& item : items)
+ {
+ QListWidgetItem* listItem = new QListWidgetItem();
+ listItem->setText(QString::fromUtf8(item.title.data()));
+ if(!item.image.empty())
+ {
+ QIcon icon;
+ QImage image = QImage::fromData((const uchar*)item.image.data(), item.image.size());
+ icon.addPixmap(QPixmap::fromImage(image));
+ listItem->setIcon(icon);
+ }
+ listItem->setData(Qt::UserRole, item.id);
+ //listItem->setSizeHint({200,200});
+ listWidget->addItem(listItem);
+ }
+}
+
+//itemchanged slot(item*)
+//{
+// id = item->data(Qt::UserRole);
+// auto recipe = db.getRecipe(id);
+// viewer->show(recipe);
+//}
diff --git a/src/mainwindow.h b/src/mainwindow.h
new file mode 100644
index 0000000..210bf5e
--- /dev/null
+++ b/src/mainwindow.h
@@ -0,0 +1,48 @@
+/* -*- c++ -*- */
+/***************************************************************************
+ * mainwindow.h
+ *
+ * Sat Apr 23 18:59:48 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 2 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.
+ */
+#pragma once
+
+#include <QMainWindow>
+class QListWidget;
+class Database;
+
+class MainWindow :
+ public QMainWindow
+{
+Q_OBJECT
+public:
+ MainWindow(Database& db);
+ ~MainWindow();
+
+public slots:
+// void updateDocumentStatus(bool changed);
+
+private:
+ void readDatabase();
+ QListWidget *listWidget;
+ Database& db;
+};
diff --git a/src/qookie.cc b/src/qookie.cc
new file mode 100644
index 0000000..2a75a63
--- /dev/null
+++ b/src/qookie.cc
@@ -0,0 +1,45 @@
+/* -*- c++ -*- */
+/***************************************************************************
+ * qookie.cc
+ *
+ * Sat Apr 23 18:40:39 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 2 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 <QApplication>
+
+#include <iostream>
+
+#include "mainwindow.h"
+#include "database.h"
+
+int main(int argc, char *argv[])
+{
+ QApplication qapp(argc, argv);
+
+ Database db("/mnt/atuin/docs/tine/Fritid/Mad/recipes.db");
+ //Database db("/mnt/atuin/docs/tine/Fritid/Mad/krecipes.krecdb");
+
+ MainWindow mainwindow(db);
+ mainwindow.show();
+
+ return qapp.exec();
+}
diff --git a/src/recipe.h b/src/recipe.h
new file mode 100644
index 0000000..8e4b579
--- /dev/null
+++ b/src/recipe.h
@@ -0,0 +1,47 @@
+/* -*- c++ -*- */
+/***************************************************************************
+ * recipe.h
+ *
+ * Sat Apr 23 21:29:02 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 2 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.
+ */
+#pragma once
+
+#include <string>
+
+struct RecipeItem
+{
+ int id;
+ std::string title;
+ std::string image;
+};
+
+struct Recipe
+{
+ int id;
+ std::string title;
+ std::string image;
+
+ // .
+ // .
+ // .
+};
generated by cgit v1.2.3 (git 2.25.1) at 2025-10-30 06:24:40 +0000