//
// Created by Adarion on 2024/2/18.
//

#include <stdexcept>
#include "PlayerDAO.h"

namespace Mika {
    std::vector<Player> PlayerDAO::getAllPlayers() {
        auto db = DatabaseManager::getInstance();
        constexpr auto query = R"(SELECT * FROM player ORDER BY country ASC, last_name ASC)";

        return db->executeQuery<Player>(query);
    }
}