11 class widestring : public std::basic_string<unsigned>
17 void std::char_traits<unsigned>::assign(unsigned &to, unsigned const &from)
23 unsigned *std::char_traits<unsigned>::copy(unsigned *to, unsigned const *from, unsigned n)
25 return static_cast<unsigned *>(memcpy(to, from, n * sizeof(unsigned)));
29 unsigned *std::char_traits<unsigned>::move(unsigned *to, unsigned const *from, unsigned n)
31 return static_cast<unsigned *>(memmove(to, from, n * sizeof(unsigned)));
35 unsigned *std::char_traits<unsigned>::assign(unsigned *to, size_t n, unsigned a)
37 for (unsigned i = 0; i < n; ++i)
44 void pqxx::from_string<widestring>(const char *from, widestring &to)
46 unsigned bytes = std::strlen(from);
47 char *from_buf = strdup(from);
48 unsigned *to_buf = new unsigned[bytes + 1];
50 char *inptr = from_buf, *outptr = reinterpret_cast<char *> (to_buf);
52 size_t in_left = bytes;
53 size_t out_left = bytes * sizeof(unsigned);
55 size_t ret = iconv(ucs4_iconv, NULL, NULL, &outptr, &out_left);
56 if (ret == (size_t)(-1)) {
57 throw std::runtime_error("Error in iconv during initialization");
60 ret = iconv(ucs4_iconv, &inptr, &in_left, &outptr, &out_left);
61 if (ret == (size_t)(-1)) {
63 throw std::runtime_error("Error in iconv during conversion");
66 to.erase(to.begin(), to.end());
67 std::copy(to_buf, reinterpret_cast<unsigned *> (outptr), std::back_inserter(to));
79 Tournament active_tournament;
81 /* A trigger that sets a flag whenever it's trigged. */
82 class FlagTrigger : pqxx::trigger {
87 FlagTrigger(pqxx::connection_base &conn, const PGSTD::string &name)
88 : pqxx::trigger(conn, name), flag(false) {}
89 virtual ~FlagTrigger() throw () {}
91 virtual void operator() (int pid)
94 std::fprintf(stderr, "Received a flag trigger from pid %u\n", pid);
108 /* A transactor that fetches the current tournament and some information about it. */
109 class FetchCurrentTournament : public pqxx::transactor<> {
114 FetchCurrentTournament(Tournament *tourn) : tourn(tourn) {}
115 void operator() (pqxx::transaction<> &t)
117 pqxx::result res( t.exec("SELECT * FROM bigscreen.active_tournament NATURAL JOIN tournaments") );
119 pqxx::result::tuple tournament = res.at(0);
121 tourn->id = tournament["tournament"].as(tourn->id);
122 tourn->name = tournament["tournamentname"].as(tourn->name);
123 } catch (PGSTD::out_of_range &e) {
130 void init(pqxx::connection &conn)
132 conn.perform(FetchCurrentTournament(&active_tournament));
134 if (active_tournament.id == -1) {
135 std::fprintf(stderr, "No active tournament\n");
137 std::fprintf(stderr, "Current tournament is %d (name: '%s')\n",
138 active_tournament.id, active_tournament.name.c_str());
142 void main_loop(pqxx::connection &conn)
144 if (active_tournament.id == -1) {
145 // No active tournament, sleep a second or so and exit
150 pqxx::work t(conn, "trx");
153 pqxx::result res( t.exec("SELECT * FROM songs") );
154 for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
155 std::fprintf(stderr, "%s\n", i["title"].c_str());
162 int main(int argc, char **argv)
164 ucs4_iconv = iconv_open("ucs-4", "utf-8");
166 // GLWindow glw("CCBS bigscreen", 800, 600, 32, false, 16, -1);
168 pqxx::connection conn("dbname=ccbs host=altersex.samfundet.no user=ccbs password=GeT|>>B_");
169 FlagTrigger tournament_changed(conn, "active_tournament");
171 // when active_tournament is changed, we destroy everything and start from scratch
173 tournament_changed.reset_flag();
178 } while (!tournament_changed.get_flag());
179 std::fprintf(stderr, "active_tournament changed, resetting...\n");
181 } catch (const std::exception &e) {
182 std::fprintf(stderr, "Exception: %s\n", e.what());