added postgres handler

1 files changed, 25 insertions, 0 deletions

diff --git a/src/postgresHandler.cpp b/src/postgresHandler.cpp
new file mode 100644
index 0000000..212202e
--- /dev/null
+++ b/src/postgresHandler.cpp
@@ -0,0 +1,25 @@
+#include "postgresHandler.h"
+#include <iostream>
+#include <regex>
+
+const pqxx::result execute_query(pqxx::work &t_transaction,
+                                 std::string_view t_query) {
+    return t_transaction.exec(t_query);
+}
+
+void display_query_result(const pqxx::result &t_r) {
+    const int nb_columns = t_r.columns();
+    for (const auto &row : t_r) {
+        for (int i = 0; i < nb_columns; i++) {
+            std::cout << row[i].c_str() << " | ";
+        }
+        std::cout << std::endl;
+    }
+}
+
+void add_cards_to_database(std::string_view t_cards, pqxx::work &t_tx) {
+    // TODO: to complete
+    std::cout << "adding cards..." << std::endl;
+    std::regex key_regex; // TODO: to define
+    std::cout << t_cards.substr(1, 6) << std::endl;
+}