Fetch the list of current active rounds and display it.

[ccbs] / bigscreen / fetch_list_of_active_groups.cpp

diff --git a/bigscreen/fetch_list_of_active_groups.cpp b/bigscreen/fetch_list_of_active_groups.cpp
new file mode 100644 (file)
index 0000000..1df6758
--- /dev/null
+++ b/bigscreen/fetch_list_of_active_groups.cpp
@@ -0,0 +1,19 @@
+#include "fetch_list_of_active_groups.h"
+
+FetchListOfActiveGroups::FetchListOfActiveGroups(std::vector<Group> *active) : active(active) {}
+void FetchListOfActiveGroups::operator() (pqxx::transaction<> &t)
+{
+       // make sure we start with an empty list
+       active->erase(active->begin(), active->end());
+       
+       pqxx::result res( t.exec("SELECT * FROM bigscreen.active_groups") );
+       for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
+               Group g;
+
+               g.tournament = i["tournament"].as(g.tournament);
+               g.round = i["round"].as(g.round);
+               g.parallel = i["parallel"].as(g.parallel);
+
+               active->push_back(g);
+       }
+}