11 class widestring : public std::basic_string<unsigned>
14 void operator= (const char *from)
16 unsigned bytes = std::strlen(from);
17 char *from_buf = strdup(from);
18 unsigned *to_buf = new unsigned[bytes + 1];
20 char *inptr = from_buf, *outptr = reinterpret_cast<char *> (to_buf);
22 size_t in_left = bytes;
23 size_t out_left = bytes * sizeof(unsigned);
25 size_t ret = iconv(ucs4_iconv, NULL, NULL, &outptr, &out_left);
26 if (ret == (size_t)(-1)) {
27 throw std::runtime_error("Error in iconv during initialization");
30 ret = iconv(ucs4_iconv, &inptr, &in_left, &outptr, &out_left);
31 if (ret == (size_t)(-1)) {
33 throw std::runtime_error("Error in iconv during conversion");
36 erase(begin(), end());
37 std::copy(to_buf, reinterpret_cast<unsigned *> (outptr), std::back_inserter(*this));
45 void std::char_traits<unsigned>::assign(unsigned &to, unsigned const &from)
51 unsigned *std::char_traits<unsigned>::copy(unsigned *to, unsigned const *from, unsigned n)
53 return static_cast<unsigned *>(memcpy(to, from, n * sizeof(unsigned)));
57 unsigned *std::char_traits<unsigned>::move(unsigned *to, unsigned const *from, unsigned n)
59 return static_cast<unsigned *>(memmove(to, from, n * sizeof(unsigned)));
63 unsigned *std::char_traits<unsigned>::assign(unsigned *to, size_t n, unsigned a)
65 for (unsigned i = 0; i < n; ++i)
72 void pqxx::from_string<widestring>(const char *from, widestring &to)
83 Tournament active_tournament;
85 /* A trigger that sets a flag whenever it's trigged. */
86 class FlagTrigger : pqxx::trigger {
91 FlagTrigger(pqxx::connection_base &conn, const PGSTD::string &name)
92 : pqxx::trigger(conn, name), flag(false) {}
93 virtual ~FlagTrigger() throw () {}
95 virtual void operator() (int pid)
98 std::fprintf(stderr, "Received a flag trigger from pid %u\n", pid);
101 bool get_flag() const
112 /* A transactor that fetches the current tournament and some information about it. */
113 class FetchCurrentTournament : public pqxx::transactor<> {
118 FetchCurrentTournament(Tournament *tourn) : tourn(tourn) {}
119 void operator() (pqxx::transaction<> &t)
121 pqxx::result res( t.exec("SELECT * FROM bigscreen.active_tournament NATURAL JOIN tournaments") );
123 pqxx::result::tuple tournament = res.at(0);
125 tourn->id = tournament["tournament"].as(tourn->id);
126 tourn->name = tournament["tournamentname"].as(tourn->name);
127 } catch (PGSTD::out_of_range &e) {
134 void init(pqxx::connection &conn)
136 conn.perform(FetchCurrentTournament(&active_tournament));
138 if (active_tournament.id == -1) {
139 std::fprintf(stderr, "No active tournament\n");
141 std::fprintf(stderr, "Current tournament is %d (name: '%s')\n",
142 active_tournament.id, active_tournament.name.c_str());
146 void main_loop(pqxx::connection &conn)
148 if (active_tournament.id == -1) {
149 // No active tournament, sleep a second or so and exit
154 pqxx::work t(conn, "trx");
157 pqxx::result res( t.exec("SELECT * FROM songs") );
158 for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
159 std::fprintf(stderr, "%s\n", i["title"].c_str());
166 int main(int argc, char **argv)
168 ucs4_iconv = iconv_open("ucs-4", "utf-8");
170 GLWindow glw("CCBS bigscreen", 800, 600, 32, false, 16, -1);
172 pqxx::connection conn("dbname=ccbs host=altersex.samfundet.no user=ccbs password=GeT|>>B_");
173 FlagTrigger tournament_changed(conn, "active_tournament");
175 // when active_tournament is changed, we destroy everything and start from scratch
177 tournament_changed.reset_flag();
182 } while (!tournament_changed.get_flag());
183 std::fprintf(stderr, "active_tournament changed, resetting...\n");
185 } catch (const std::exception &e) {
186 std::fprintf(stderr, "Exception: %s\n", e.what());