#include #include #include #include #include #include #include #include const pqxx::result execute_query(pqxx::work &transaction, std::string_view query) { return transaction.exec(query); } void do_curl_request(const char *url, const char *header) { CURL *curl = curl_easy_init(); if (curl) { curl_easy_setopt(curl, CURLOPT_URL, url); curl_easy_setopt(curl, CURLOPT_SSL_VERIFYPEER, 0L); curl_easy_setopt(curl, CURLOPT_SSL_VERIFYHOST, 0L); struct curl_slist *chunk = nullptr; chunk = curl_slist_append(chunk, header); curl_easy_setopt(curl, CURLOPT_HTTPHEADER, chunk); curl_easy_perform(curl); curl_easy_cleanup(curl); } } void do_curl_request(const std::string &url, const std::string &header) { do_curl_request(url.c_str(), header.c_str()); } std::string generate_request_header(const std::string &t_access_token) { return std::format("Authorization: Bearer {}", t_access_token); } const std::string get_url() { // FIXME: not flexible return "https://eu.api.blizzard.com/hearthstone/cards/678?locale=fr_FR"; } bool is_last_generated_token_still_valid() { // TODO: return false; } size_t curl_callback_token_request(void *contents, size_t size, size_t nmemb, std::string *s) { size_t newLength = size * nmemb; try { s->append((char *)contents, newLength); } catch (std::bad_alloc &e) { // handle memory problem return 0; } return newLength; } std::string get_valid_token() { // TODO: retrieve token from output CURL *curl = curl_easy_init(); std::string output; if (curl) { curl_easy_setopt(curl, CURLOPT_URL, "https://oauth.battle.net/token"); curl_easy_setopt(curl, CURLOPT_SSL_VERIFYPEER, 0L); curl_easy_setopt(curl, CURLOPT_SSL_VERIFYHOST, 0L); curl_easy_setopt(curl, CURLOPT_WRITEFUNCTION, curl_callback_token_request); curl_easy_setopt(curl, CURLOPT_WRITEDATA, &output); curl_easy_setopt(curl, CURLOPT_USERPWD, "2b50f1123b424d5e9c21971a110fdd04:" "MrMkhVMNdOeqPL4Q4XVQAsRPR14J7Yq6"); curl_easy_setopt(curl, CURLOPT_POSTFIELDS, "grant_type=client_credentials"); curl_easy_perform(curl); curl_easy_cleanup(curl); } std::cout << output << std::endl; return ""; } void display_result(pqxx::result r) { // FIXME: not flexible for (auto row : r) { std::cout << std::format( "{}; {}; {}; {}; {}", row[0].as(), row[1].as(), row[2].as(), row[3].as(), row[4].as()); } } int main() { pqxx::connection cx{ "postgresql://aotrix@localhost:5432/hearthstonegameinfo"}; pqxx::work tx{cx}; std::string access_token = get_valid_token(); // std::string header = generate_request_header(access_token); // do_curl_request(get_url(), header); // std::cout << std::endl << std::endl; // display_result(execute_query(tx, "SELECT * FROM cards")); return 0; }