From 332c0ffde6d60b7bac3cb14df31cbae3f27383a7 Mon Sep 17 00:00:00 2001 From: Aotrix Date: Tue, 18 Mar 2025 19:21:57 +0100 Subject: added postgres handler --- src/postgresHandler.cpp | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 src/postgresHandler.cpp (limited to 'src/postgresHandler.cpp') 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 +#include + +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; +} -- cgit v1.2.3