From afbca22035804f7fc65032d0c66bf198e7739bd5 Mon Sep 17 00:00:00 2001
From: Aotrix <aotrix56@gmail.com>
Date: Tue, 4 Mar 2025 02:59:53 +0100
Subject: we can now connect to the database!

---
 src/main.cpp | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'src/main.cpp')

diff --git a/src/main.cpp b/src/main.cpp
index 57dd2d7..4282118 100644
--- a/src/main.cpp
+++ b/src/main.cpp
@@ -1,10 +1,20 @@
+#include <format>
 #include <iostream>
 #include <pqxx/pqxx>
 
 // TODO: Parser les cartes
 
 int main() {
-    std::cout << "Decomposer le problème en des sous-problèmes" << std::endl;
     // TODO: Récupérer le nombre de cartes
+    pqxx::connection cx{
+        "postgresql://aotrix@localhost:5432/hearthstonegameinfo"};
+    pqxx::work tx{cx};
+    pqxx::result r{tx.exec("SELECT * FROM cards")};
+    for (auto row : r) {
+        std::cout << std::format(
+            "{}; {}; {}; {}; {}", row[0].as<std::string>(),
+            row[1].as<std::string>(), row[2].as<std::string>(),
+            row[3].as<std::string>(), row[4].as<std::string>());
+    }
     return 0;
 }
-- 
cgit v1.2.3