#include "hearthstoneAPIHandler.h"
#include "postgresHandler.h"
#include <iostream>
#include <pqxx/pqxx>

int main() {
    HearthstoneAPIHandler hs_handler;
    pqxx::connection cx{
        "postgresql://aotrix@localhost:5432/hearthstonegameinfo"};
    pqxx::work tx{cx};

    try {
        std::string cards = hs_handler.get_cards(
            "/?locale=fr_FR&gameMode=constructed&pageSize=40");
        std::cout << cards << std::endl;
        add_cards_to_database(cards, tx);
        tx.commit();
    } catch (pqxx::sql_error const &e) {
        std::cerr << "SQL error: " << e.what() << std::endl;
        std::cerr << "Query was: " << e.query() << std::endl;
        return 2;
    } catch (std::exception const &e) {
        std::cerr << "Error: " << e.what() << std::endl;
        return 1;
    }
    return 0;
}