11 string format_timestamp(uint64_t pos);
13 QVariant EventsModel::headerData(int section, Qt::Orientation orientation, int role) const
15 if (role != Qt::DisplayRole) {
18 if (orientation == Qt::Horizontal) {
21 } else if (section == 1) {
31 QVariant EventsModel::data(const QModelIndex &index, int role) const
33 if (role != Qt::DisplayRole) {
37 if (index.column() == 0) {
38 return QString::fromUtf8(format_timestamp(events[index.row()].t));
39 } else if (index.column() == 1) {
40 optional<int> player_id = events[index.row()].player_id;
42 const Player &p = players[*player_id];
43 return QString::fromUtf8(p.name + " (" + p.number + ")");
47 } else if (index.column() == 2) {
48 return QString::fromUtf8(events[index.row()].type);
53 void EventsModel::refresh_if_needed() const
65 int ret = sqlite3_prepare_v2(db, "SELECT player, number, name FROM player", -1, &stmt, 0);
66 if (ret != SQLITE_OK) {
67 fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
71 ret = sqlite3_step(stmt);
72 if (ret == SQLITE_ROW) {
74 p.player_id = sqlite3_column_int(stmt, 0);
75 p.number = (const char *)sqlite3_column_text(stmt, 1);
76 p.name = (const char *) sqlite3_column_text(stmt, 2);
77 players[p.player_id] = std::move(p);
78 } else if (ret == SQLITE_DONE) {
81 fprintf(stderr, "SELECT step: %s\n", sqlite3_errmsg(db));
85 ret = sqlite3_finalize(stmt);
86 if (ret != SQLITE_OK) {
87 fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
92 ret = sqlite3_prepare_v2(db, "SELECT event, t, player, type FROM event", -1, &stmt, 0);
93 if (ret != SQLITE_OK) {
94 fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
98 ret = sqlite3_step(stmt);
99 if (ret == SQLITE_ROW) {
101 e.event_id = sqlite3_column_int(stmt, 0);
102 e.t = sqlite3_column_int(stmt, 1);
103 e.player_id = sqlite3_column_int(stmt, 2);
104 e.type = (const char *)sqlite3_column_text(stmt, 3);
105 events.push_back(std::move(e));
106 } else if (ret == SQLITE_DONE) {
109 fprintf(stderr, "SELECT step: %s\n", sqlite3_errmsg(db));
113 ret = sqlite3_finalize(stmt);
114 if (ret != SQLITE_OK) {
115 fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
119 // TODO what if data changes externally?
120 //emit dataChanged(QModelIndex(
123 int EventsModel::insert_event(uint64_t t, int player_id)
125 auto it = lower_bound(events.begin(), events.end(), t,
126 [](const Event &e, uint64_t t) { return e.t < t; });
127 int pos = distance(events.begin(), it);
128 beginInsertRows(QModelIndex(), pos, pos);
132 e.player_id = player_id;
134 events.insert(events.begin() + pos, e);
138 // Insert the new row into the database.
140 int ret = sqlite3_prepare_v2(db, "INSERT INTO event (t, player, type) VALUES (?, ?, ?)", -1, &stmt, 0);
141 if (ret != SQLITE_OK) {
142 fprintf(stderr, "INSERT prepare: %s\n", sqlite3_errmsg(db));
146 sqlite3_bind_int64(stmt, 1, t);
147 sqlite3_bind_int64(stmt, 2, player_id);
148 sqlite3_bind_text(stmt, 3, e.type.data(), e.type.size(), SQLITE_STATIC);
150 ret = sqlite3_step(stmt);
151 if (ret == SQLITE_ROW) {
152 fprintf(stderr, "INSERT step: %s\n", sqlite3_errmsg(db));
156 ret = sqlite3_finalize(stmt);
157 if (ret != SQLITE_OK) {
158 fprintf(stderr, "INSERT finalize: %s\n", sqlite3_errmsg(db));
162 events[pos].event_id = sqlite3_last_insert_rowid(db);
166 void EventsModel::set_event_type(unsigned pos, const string &type)
168 events[pos].type = type;
169 emit dataChanged(createIndex(pos, 0), createIndex(pos, 2));
172 int ret = sqlite3_prepare_v2(db, "UPDATE event SET type=? WHERE event=?", -1, &stmt, 0);
173 if (ret != SQLITE_OK) {
174 fprintf(stderr, "INSERT prepare: %s\n", sqlite3_errmsg(db));
178 sqlite3_bind_text(stmt, 1, type.data(), type.size(), SQLITE_STATIC);
179 sqlite3_bind_int64(stmt, 2, events[pos].event_id);
181 ret = sqlite3_step(stmt);
182 if (ret == SQLITE_ROW) {
183 fprintf(stderr, "UPDATE step: %s\n", sqlite3_errmsg(db));
187 ret = sqlite3_finalize(stmt);
188 if (ret != SQLITE_OK) {
189 fprintf(stderr, "UPDATE finalize: %s\n", sqlite3_errmsg(db));