From c05901c38c6a77779807a6b224b9b624bfcaa5d3 Mon Sep 17 00:00:00 2001 From: Aotrix <9aotrix@protonmail.com> Date: Thu, 1 Jan 2026 03:35:41 +0100 Subject: removed useless files --- src/postgresHandler.cpp | 182 ------------------------------------------------ 1 file changed, 182 deletions(-) delete mode 100644 src/postgresHandler.cpp (limited to 'src/postgresHandler.cpp') diff --git a/src/postgresHandler.cpp b/src/postgresHandler.cpp deleted file mode 100644 index 8ca3c20..0000000 --- a/src/postgresHandler.cpp +++ /dev/null @@ -1,182 +0,0 @@ -#include "postgresHandler.hpp" -#include "cardTypeHandlerInfo.hpp" -#include "hearthstoneAPI.hpp" -#include -#include -#include -#include -#include -#include -#include - -#define KEY_ID 1 - -const std::map aCardValueTypeToRegex = {{"INT", "[0-9]+"}, - {"STRING", "\"[^\"?]*\""}, - {"LIST_OF_INT", "\\[[0-9,]*\\]"}, - {"NULL", "null"}, - {"BOOL", "true|false"}}; - -const pqxx::result executeQuery(pqxx::work &aTransaction, std::string_view aQuery) { return aTransaction.exec(aQuery); } - -std::ostream &operator<<(std::ostream &aOstream, const pqxx::result &kResult) { - const int kNbColumnsInResult = kResult.columns(); - aOstream << "| "; - for (const auto &kResultRow : kResult) { - for (int i = 0; i < kNbColumnsInResult; i++) { - aOstream << kResultRow[i].c_str() << " | "; - } - } - return aOstream; -} - -const unsigned int getTypeIndexOfRegexIterator(const std::sregex_iterator &kSregexIt) { - // TODO: remove hardcoded variable because it is... weird. - // The input should already be the "value" part? - const unsigned int offset = 2; - for (size_t aCardInfoType = 0; aCardInfoType < aCardValueTypeToRegex.size(); aCardInfoType++) { - if ((*kSregexIt)[aCardInfoType] != "") { - return offset + aCardInfoType; - } - } - throw std::invalid_argument("regex iterator input is invalid"); -} - -const std::string format_json_value_to_sql(const std::string &kTypeOfValue, const std::string &kValueFromJSON) { - // TODO: show an error if a type is no longer here, - // to avoid having useless conditions - // FIXME: it does not scale well, a bit ugly... should be a single line - if (kTypeOfValue == "BOOL" || kTypeOfValue == "INT") { - return kValueFromJSON; - } else if (kTypeOfValue == "STRING") { - std::string aCopyOfJSONValue = kValueFromJSON; - *aCopyOfJSONValue.begin() = '\''; - *std::prev(aCopyOfJSONValue.end()) = '\''; - return aCopyOfJSONValue; - } else if (kTypeOfValue == "NULL") { - return "NULL"; - } else if (kTypeOfValue == "LIST_OF_INT") { - std::string aCopyOfJSONValue = kValueFromJSON; - aCopyOfJSONValue.append("\'"); - aCopyOfJSONValue.insert(aCopyOfJSONValue.begin(), '\''); - return aCopyOfJSONValue; - } else { - throw std::invalid_argument("ERROR: type of value is invalid"); - } -} - -std::string format_key(const std::string &key) { - std::string key_copy(key); - std::stack uppercase_indexes; - for (size_t i = 0; i < key.length(); i++) { - if (std::isupper(key[i])) { - uppercase_indexes.push(i); - } - } - while (!uppercase_indexes.empty()) { - size_t top_index = uppercase_indexes.top(); - uppercase_indexes.pop(); - key_copy[top_index] = std::tolower(key_copy[top_index]); - key_copy.insert(std::next(key_copy.begin(), top_index), '_'); - } - return key_copy; -} - -static void add_single_card_to_database(const std::string &kCards, pqxx::work &aTransaction, - const std::regex &kKeyRegex, const std::string::size_type &kIdPos, - const std::string::size_type &kClosingBracketPos) { - auto words_begin = std::sregex_iterator(std::next(kCards.begin(), kIdPos), - std::next(kCards.begin(), kClosingBracketPos), kKeyRegex); - auto words_end = std::sregex_iterator(); - if (words_begin != words_end) { - std::string insert_columns("INSERT INTO cards ("); - std::string values(" VALUES ("); - for (std::sregex_iterator kSregexIt = words_begin; kSregexIt != words_end; ++kSregexIt) { - insert_columns.append(format_key((*kSregexIt)[KEY_ID].str()) + ","); // key - const unsigned int kTypeIndexOfValue = getTypeIndexOfRegexIterator(kSregexIt); - const std::string kTypeNameOfValue = std::next(aCardValueTypeToRegex.begin(), kTypeIndexOfValue)->first; - values.append(format_json_value_to_sql(kTypeNameOfValue, (*kSregexIt)[kTypeIndexOfValue].str()) + ","); - } - *std::prev(insert_columns.end()) = ')'; - *std::prev(values.end()) = ')'; - - insert_columns.append(values); - insert_columns.append(" ON CONFLICT (id) DO NOTHING;"); - executeQuery(aTransaction, insert_columns); - } -} - -const std::regex regexKeyValueInJSON() { - std::string aRegexString = "\"([^\"?]+)\":("; - for (auto &[fieldName, regex] : aCardValueTypeToRegex) { - aRegexString += "(" + regex + ")|"; - } - aRegexString[aRegexString.length() - 1] = ')'; - return std::regex(aRegexString); -} - -const std::string::size_type startPosOfCardJSON(const std::string &kCardsPageJSON, - const std::string::size_type kSearchStartPos = 0) { - return kCardsPageJSON.find("{\"id", kSearchStartPos); -} - -const std::string::size_type endPosOfCardJSON(const std::string &kCardsPageJSON, - const std::string::size_type kSearchStartPos = 0) { - return kCardsPageJSON.find("}", kSearchStartPos); -} - -void addCardsToDatabase(HearthstoneAPI &aAPIIntermediate, pqxx::work &aTransaction, - const std::string &kURLOfCardsPage) { - const std::regex aRegexKeyValueInJSON = regexKeyValueInJSON(); - const std::string &kCardsPageJSON = aAPIIntermediate.get_cards(kURLOfCardsPage); - std::string::size_type aCardStartPos = startPosOfCardJSON(kCardsPageJSON); - std::string::size_type aCardEndPos = endPosOfCardJSON(kCardsPageJSON); - while (aCardStartPos != std::string::npos && aCardEndPos != std::string::npos) { - add_single_card_to_database(kCardsPageJSON, aTransaction, aRegexKeyValueInJSON, aCardStartPos, aCardEndPos); - aCardStartPos = startPosOfCardJSON(kCardsPageJSON, aCardStartPos + 1); - aCardEndPos = endPosOfCardJSON(kCardsPageJSON, aCardEndPos + 1); - } -} - -void clearCardDatabase(pqxx::work &aTransaction) { executeQuery(aTransaction, "DELETE FROM cards"); } - -const uint32_t numberOfPagesInSetOfCards(const std::string &cards) { - std::regex key_regex("\"pageCount\":([0-9]+)"); - auto nb_pages_begin = std::sregex_iterator(cards.begin(), cards.end(), key_regex); - auto nb_pages_end = std::sregex_iterator(); - if (nb_pages_begin != nb_pages_end) { - return std::stoi((*nb_pages_begin)[1].str()); - } - return 0; -} - -void refresh_cards_table() { - try { - pqxx::connection aConnection{ - "postgresql://aotrix@localhost:5432/hearthstonegameinfo"}; // FIXME: load a .xml file instead - pqxx::work aTransaction{aConnection}; - HearthstoneAPI aAPIConnector; - std::string aCards = - aAPIConnector.get_cards("/?locale=fr_FR&gameMode=constructed"); // FIXME: use a struct as a parameter - clearCardDatabase(aTransaction); - addCardsToDatabase(aAPIConnector, aTransaction, - "/?locale=fr_FR&gameMode=constructed"); // FIXME: To which - // table? to a more generic function - const uint32_t kNbPages = numberOfPagesInSetOfCards(aCards); - - // FIXME: [Process exited 139] - // for (int i = 2; i < kNbPages; i++) { - for (uint32_t i = 2; i < 3; i++) { - const std::string kCardsPageURL{std::format("/?locale=fr_FR&gameMode=constructed&page={}", i)}; - addCardsToDatabase(aAPIConnector, aTransaction, kCardsPageURL); - } - std::cout << "number of cards in database: " << executeQuery(aTransaction, "SELECT COUNT(*) FROM cards") - << std::endl; - aTransaction.commit(); - } catch (pqxx::sql_error const &kSqlError) { - std::cerr << "SQL error: " << kSqlError.what() << std::endl; - std::cerr << "Query was: " << kSqlError.query() << std::endl; - } catch (std::exception const &kException) { - std::cerr << "Error: " << kException.what() << std::endl; - } -} -- cgit v1.2.3