X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=bigscreen%2Fccbs_bigscreen.cpp;h=71bd966cc1aad8e61c331feaa313605db5713634;hp=02ed0335b93d5510fb62f7037f777decca8da30c;hb=1640d1e1125f43a22770796b24895d18d945892f;hpb=85b8d8fb245ff3a960d38f92720b1be14edbe52d

diff --git a/bigscreen/ccbs_bigscreen.cpp b/bigscreen/ccbs_bigscreen.cpp
index 02ed033..71bd966 100644
--- a/bigscreen/ccbs_bigscreen.cpp
+++ b/bigscreen/ccbs_bigscreen.cpp
@@ -3,19 +3,43 @@
 #include <pqxx/pqxx>
 #include "glwindow.h"
 
+/*
+ * A trigger that exits whenever it's trigged (used when we change big things
+ * such as starting a new tournament, and it's not really worth doing a clean
+ * change).
+ */
+class ExitTrigger : pqxx::trigger {
+public:
+	ExitTrigger(pqxx::connection_base &conn, const PGSTD::string &name)
+		: pqxx::trigger(conn, name) {}
+	virtual ~ExitTrigger() throw () {}
+	
+	virtual void operator() (int pid)
+	{
+		std::fprintf(stderr, "Received an exit trigger from pid %u\n", pid);
+		exit(0);
+	}
+};
+
 int main(int argc, char **argv)
 {
 	GLWindow glw("CCBS bigscreen", 800, 600, 32, false, 16, -1);
 	try {
 		pqxx::connection conn("dbname=ccbs host=sql.samfundet.no user=ccbs password=GeT|>>B_");
-		pqxx::transaction<> t(conn, "trx");
+		ExitTrigger et(conn, "bs_tournament_changed");
+		
+		sleep(1);
+
+		pqxx::work t(conn, "trx");
 
 		// fetch all songs
 		pqxx::result res( t.exec("SELECT * FROM songs") );
 		for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
-			std::fprintf(stderr, "%s\n", i[0].as(std::string()).c_str());
+			std::fprintf(stderr, "%s\n", i["title"].c_str());
 		}
 		t.commit();
+		conn.get_notifs();
+		sleep(1);
 	} catch (const std::exception &e) {
 		std::fprintf(stderr, "Exception: %s\n", e.what());
 		exit(1);