#include <format>
#include <iostream>
#include <pqxx/pqxx>

// TODO: Parser les cartes

int main() {
    // 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;
}