git.sesse.net Git - pkanalytics/blob - main.cpp

   1 #include <QMediaPlayer>
   2 #include <QMainWindow>
   3 #include <QApplication>
   4 #include <QGridLayout>
   5 #include <QVideoWidget>
   6 #include <QShortcut>
   7 #include <QInputDialog>
   8 #include <algorithm>
   9 #include <string>
  10 #include <map>
  11 #include <vector>
  12 #include <optional>
  13 #include <sqlite3.h>
  14 #include "mainwindow.h"
  15 #include "ui_mainwindow.h"
  16 #include "events.h"
  17 #include "players.h"
  18
  19 using namespace std;
  20
  21 string format_timestamp(uint64_t pos)
  22 {
  23         int ms = pos % 1000;
  24         pos /= 1000;
  25         int sec = pos % 60;
  26         pos /= 60;
  27         int min = pos % 60;
  28         int hour = pos / 60;
  29
  30         char buf[256];
  31         snprintf(buf, sizeof(buf), "%d:%02d:%02d.%03d", hour, min, sec, ms);
  32         return buf;
  33 }
  34
  35 MainWindow::MainWindow(EventsModel *events, PlayersModel *players) : events(events), players(players)
  36 {
  37         video = new QMediaPlayer;
  38         //video->setSource(QUrl::fromLocalFile("/home/sesse/dev/stats/ultimate.mkv"));
  39         video->setSource(QUrl::fromLocalFile("/home/sesse/dev/stats/ultimate-prores.mkv"));
  40         video->play();
  41
  42         ui = new Ui::MainWindow;
  43         ui->setupUi(this);
  44
  45         ui->event_view->setModel(events);
  46         connect(ui->event_view->selectionModel(), &QItemSelectionModel::currentRowChanged,
  47                 [this, events](const QModelIndex &current, const QModelIndex &previous) {
  48                         uint64_t t = events->get_time(current.row());
  49                         if (t != video->position()) {
  50                                 video->setPosition(events->get_time(current.row()));
  51                         } else {
  52                                 // Selection could have changed, so we still need to update.
  53                                 // (Just calling setPosition() would not give us the signal
  54                                 // in this case.)
  55                                 update_ui_from_time(t);
  56                         }
  57                 });
  58
  59         ui->player_view->setModel(players);
  60         ui->player_view->setColumnWidth(0, 30);
  61         ui->player_view->setColumnWidth(1, 20);
  62         ui->player_view->horizontalHeader()->setStretchLastSection(true);
  63
  64         connect(video, &QMediaPlayer::positionChanged, [this](uint64_t pos) {
  65                 position_changed(pos);
  66         });
  67
  68         video->setVideoOutput(ui->video);
  69
  70         // It's not really clear whether PgUp should be forwards or backwards,
  71         // but mpv does at least up = forwards, so that's probably standard.
  72         QShortcut *pgdown = new QShortcut(QKeySequence(Qt::Key_PageDown), this);
  73         connect(pgdown, &QShortcut::activated, [this]() { seek(-120000); });
  74         QShortcut *pgup = new QShortcut(QKeySequence(Qt::Key_PageUp), this);
  75         connect(pgup, &QShortcut::activated, [this]() { seek(120000); });
  76
  77         connect(ui->minus10s, &QPushButton::clicked, [this]() { seek(-10000); });
  78         connect(ui->plus10s, &QPushButton::clicked, [this]() { seek(10000); });
  79
  80         connect(ui->minus2s, &QPushButton::clicked, [this]() { seek(-2000); });
  81         connect(ui->plus2s, &QPushButton::clicked, [this]() { seek(2000); });
  82
  83         // TODO: Would be nice to actually have a frame...
  84         connect(ui->minus1f, &QPushButton::clicked, [this]() { seek(-20); });
  85         connect(ui->plus1f, &QPushButton::clicked, [this]() { seek(20); });
  86
  87         connect(ui->play_pause, &QPushButton::clicked, [this]() {
  88                 if (playing) {
  89                         video->pause();
  90                         ui->play_pause->setText("Play (space)");
  91                 } else {
  92                         video->setPlaybackRate(1.0);
  93                         video->play();
  94                         ui->play_pause->setText("Pause (space)");
  95                 }
  96                 playing = !playing;
  97
  98                 // Needs to be set anew when we modify setText(), evidently.
  99                 ui->play_pause->setShortcut(QCoreApplication::translate("MainWindow", "Space", nullptr));
 100         });
 101
 102         connect(ui->player_1, &QPushButton::clicked, [this]() { insert_player_event(0); });
 103         connect(ui->player_2, &QPushButton::clicked, [this]() { insert_player_event(1); });
 104         connect(ui->player_3, &QPushButton::clicked, [this]() { insert_player_event(2); });
 105         connect(ui->player_4, &QPushButton::clicked, [this]() { insert_player_event(3); });
 106         connect(ui->player_5, &QPushButton::clicked, [this]() { insert_player_event(4); });
 107         connect(ui->player_6, &QPushButton::clicked, [this]() { insert_player_event(5); });
 108         connect(ui->player_7, &QPushButton::clicked, [this]() { insert_player_event(6); });
 109
 110         // Offensive events
 111         connect(ui->offense_label, &ClickableLabel::clicked, [this]() { insert_noplayer_event("set_offense"); });
 112         connect(ui->catch_, &QPushButton::clicked, [this]() { set_current_event_type("catch"); });
 113         connect(ui->throwaway, &QPushButton::clicked, [this, events]() {
 114                 EventsModel::Status s = events->get_status_at(video->position());
 115                 if (s.attack_state == EventsModel::Status::DEFENSE && s.pull_state == EventsModel::Status::PULL_IN_AIR) {
 116                         insert_noplayer_event("pull_oob");
 117                 } else {
 118                         set_current_event_type("throwaway");
 119                 }
 120         });
 121         connect(ui->drop, &QPushButton::clicked, [this]() { set_current_event_type("drop"); });
 122         connect(ui->goal, &QPushButton::clicked, [this]() { set_current_event_type("goal"); });
 123         connect(ui->offensive_soft_plus, &QPushButton::clicked, [this]() { set_current_event_type("offensive_soft_plus"); });
 124         connect(ui->offensive_soft_minus, &QPushButton::clicked, [this]() { set_current_event_type("offensive_soft_minus"); });
 125         connect(ui->pull, &QPushButton::clicked, [this, events]() {
 126                 EventsModel::Status s = events->get_status_at(video->position());
 127                 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
 128                         set_current_event_type("pull");
 129                 } else if (EventsModel::Status::PULL_IN_AIR) {
 130                         insert_noplayer_event("pull_landed");
 131                 }
 132         });
 133
 134         // Defensive events (TODO add more)
 135         connect(ui->interception, &QPushButton::clicked, [this]() { set_current_event_type("interception"); });
 136         connect(ui->defense_label, &ClickableLabel::clicked, [this]() { insert_noplayer_event("set_defense"); });
 137         connect(ui->their_throwaway, &QPushButton::clicked, [this]() { insert_noplayer_event("their_throwaway"); });
 138         connect(ui->their_goal, &QPushButton::clicked, [this]() { insert_noplayer_event("their_goal"); });
 139         connect(ui->their_pull, &QPushButton::clicked, [this, events]() {
 140                 EventsModel::Status s = events->get_status_at(video->position());
 141                 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
 142                         insert_noplayer_event("their_pull");
 143                 }
 144         });
 145         connect(ui->our_defense, &QPushButton::clicked, [this]() { set_current_event_type("defense"); });
 146         connect(ui->defensive_soft_plus, &QPushButton::clicked, [this]() { set_current_event_type("defensive_soft_plus"); });
 147         connect(ui->defensive_soft_minus, &QPushButton::clicked, [this]() { set_current_event_type("defensive_soft_minus"); });
 148
 149         // Misc. events
 150         connect(ui->substitution, &QPushButton::clicked, [this]() { make_substitution(); });
 151         connect(ui->stoppage, &QPushButton::clicked, [this, events]() {
 152                 EventsModel::Status s = events->get_status_at(video->position());
 153                 if (s.stoppage) {
 154                         insert_noplayer_event("restart");
 155                 } else {
 156                         insert_noplayer_event("stoppage");
 157                 }
 158         });
 159         connect(ui->unknown, &QPushButton::clicked, [this]() { insert_noplayer_event("unknown"); });
 160
 161         QShortcut *key_delete = new QShortcut(QKeySequence(Qt::Key_Delete), this);
 162         connect(key_delete, &QShortcut::activated, [this]() { ui->delete_->animateClick(); });
 163         connect(ui->delete_, &QPushButton::clicked, [this]() { delete_current_event(); });
 164 }
 165
 166 void MainWindow::position_changed(uint64_t pos)
 167 {
 168         ui->timestamp->setText(QString::fromUtf8(format_timestamp(pos)));
 169         if (buffered_seek) {
 170                 video->setPosition(*buffered_seek);
 171                 buffered_seek.reset();
 172         }
 173         if (!playing) {
 174                 video->pause();  // We only played to get a picture.
 175         }
 176         if (playing) {
 177                 QModelIndex row = events->get_last_event_qt(video->position());
 178                 ui->event_view->scrollTo(row, QAbstractItemView::PositionAtCenter);
 179         }
 180         update_ui_from_time(pos);
 181 }
 182
 183 void MainWindow::seek(int64_t delta_ms)
 184 {
 185         int64_t current_pos = buffered_seek ? *buffered_seek : video->position();
 186         uint64_t pos = max<int64_t>(current_pos + delta_ms, 0);
 187         buffered_seek = pos;
 188         if (!playing) {
 189                 video->setPlaybackRate(0.01);
 190                 video->play();  // Or Qt won't show the seek.
 191         }
 192 }
 193
 194 void MainWindow::insert_player_event(int button_id)
 195 {
 196         uint64_t t = video->position();
 197         vector<int> team = events->sort_team(events->get_team_at(t));
 198         if (button_id >= team.size()) {
 199                 return;
 200         }
 201         int player_id = team[button_id];
 202
 203         EventsModel::Status s = events->get_status_at(t);
 204
 205         ui->event_view->selectionModel()->blockSignals(true);
 206         if (s.attack_state == EventsModel::Status::OFFENSE) {
 207                 // TODO: Perhaps not if that player already did the last catch?
 208                 ui->event_view->selectRow(events->insert_event(t, player_id, "catch"));
 209         } else {
 210                 ui->event_view->selectRow(events->insert_event(t, player_id));
 211         }
 212         ui->event_view->selectionModel()->blockSignals(false);
 213
 214         update_ui_from_time(t);
 215 }
 216
 217 void MainWindow::insert_noplayer_event(const string &type)
 218 {
 219         uint64_t t = video->position();
 220
 221         ui->event_view->selectionModel()->blockSignals(true);
 222         ui->event_view->selectRow(events->insert_event(t, nullopt, type));
 223         ui->event_view->selectionModel()->blockSignals(false);
 224
 225         update_ui_from_time(t);
 226 }
 227
 228 void MainWindow::set_current_event_type(const string &type)
 229 {
 230         QItemSelectionModel *select = ui->event_view->selectionModel();
 231         if (!select->hasSelection()) {
 232                 return;
 233         }
 234         int row = select->selectedRows().front().row();  // Should only be one, due to our selection behavior.
 235         events->set_event_type(row, type);
 236         update_ui_from_time(video->position());
 237 }
 238
 239 void MainWindow::delete_current_event()
 240 {
 241         QItemSelectionModel *select = ui->event_view->selectionModel();
 242         if (!select->hasSelection()) {
 243                 return;
 244         }
 245         int row = select->selectedRows().front().row();  // Should only be one, due to our selection behavior.
 246         ui->event_view->selectionModel()->blockSignals(true);
 247         events->delete_event(row);
 248         ui->event_view->selectionModel()->blockSignals(false);
 249         update_ui_from_time(video->position());
 250 }
 251
 252 void MainWindow::make_substitution()
 253 {
 254         QItemSelectionModel *select = ui->player_view->selectionModel();
 255         set<int> new_team;
 256         for (QModelIndex row : select->selectedRows()) {
 257                 new_team.insert(players->get_player_id(row.row()));
 258         }
 259         events->set_team_at(video->position(), new_team);
 260 }
 261
 262 void MainWindow::update_ui_from_time(uint64_t t)
 263 {
 264         update_status(t);
 265         update_player_buttons(t);
 266         update_action_buttons(t);
 267 }
 268
 269 void MainWindow::update_status(uint64_t t)
 270 {
 271         EventsModel::Status s = events->get_status_at(t);
 272         char buf[256];
 273         const char *offense = "not started";
 274         if (s.attack_state == EventsModel::Status::OFFENSE) {
 275                 offense = "offense";
 276         } else if (s.attack_state == EventsModel::Status::DEFENSE) {
 277                 offense = "defense";
 278         }
 279
 280         snprintf(buf, sizeof(buf), "%d–%d | %s | %d passes, %d sec possession",
 281                 s.our_score, s.their_score, offense, s.num_passes, s.possession_sec);
 282         if (s.stoppage_sec > 0) {
 283                 char buf2[256];
 284                 snprintf(buf2, sizeof(buf2), "%s (plus %d sec stoppage)", buf, s.stoppage_sec);
 285                 ui->status->setText(buf2);
 286         } else {
 287                 ui->status->setText(buf);
 288         }
 289 }
 290
 291 void MainWindow::update_player_buttons(uint64_t t)
 292 {
 293         QPushButton *buttons[] = {
 294                 ui->player_1,
 295                 ui->player_2,
 296                 ui->player_3,
 297                 ui->player_4,
 298                 ui->player_5,
 299                 ui->player_6,
 300                 ui->player_7
 301         };
 302         const char shortcuts[] = "qweasdf";
 303         int num_players = 0;
 304         for (int player_id : events->sort_team(events->get_team_at(t))) {
 305                 QPushButton *btn = buttons[num_players];
 306                 string label = players->get_player_name_by_id(player_id) + " (&" + shortcuts[num_players] + ")";
 307                 char shortcut[2] = "";
 308                 shortcut[0] = toupper(shortcuts[num_players]);
 309                 btn->setText(QString::fromUtf8(label));
 310                 btn->setShortcut(QCoreApplication::translate("MainWindow", shortcut, nullptr));
 311                 btn->setEnabled(true);
 312                 if (++num_players == 7) {
 313                         break;
 314                 }
 315         }
 316         for (int i = num_players; i < 7; ++i) {
 317                 QPushButton *btn = buttons[i];
 318                 btn->setText("No player");
 319                 btn->setEnabled(false);
 320         }
 321 }
 322
 323 void MainWindow::update_action_buttons(uint64_t t)
 324 {
 325         EventsModel::Status s = events->get_status_at(t);
 326
 327         bool has_selection = false;
 328         bool has_selection_with_player = false;
 329
 330         QItemSelectionModel *select = ui->event_view->selectionModel();
 331         if (select->hasSelection()) {
 332                 has_selection = true;
 333                 int row = select->selectedRows().front().row();  // Should only be one, due to our selection behavior.
 334                 has_selection_with_player = events->get_player_id(row).has_value();
 335         }
 336         ui->delete_->setEnabled(has_selection);
 337
 338         if (s.stoppage) {
 339                 ui->stoppage->setText("Restart (&v)");
 340                 ui->stoppage->setShortcut(QCoreApplication::translate("MainWindow", "V", nullptr));
 341                 ui->catch_->setEnabled(false);
 342                 ui->throwaway->setEnabled(false);
 343                 ui->drop->setEnabled(false);
 344                 ui->goal->setEnabled(false);
 345                 ui->offensive_soft_plus->setEnabled(false);
 346                 ui->offensive_soft_minus->setEnabled(false);
 347                 ui->pull->setEnabled(false);
 348                 ui->interception->setEnabled(false);
 349                 ui->their_throwaway->setEnabled(false);
 350                 ui->our_defense->setEnabled(false);
 351                 ui->their_goal->setEnabled(false);
 352                 ui->defensive_soft_plus->setEnabled(false);
 353                 ui->defensive_soft_minus->setEnabled(false);
 354                 ui->their_pull->setEnabled(false);
 355                 return;
 356         } else {
 357                 ui->stoppage->setText("Stoppage (&v)");
 358                 ui->stoppage->setShortcut(QCoreApplication::translate("MainWindow", "V", nullptr));
 359         }
 360
 361         // Defaults for pull-related buttons.
 362         ui->pull->setText("Pull (&p)");
 363         ui->their_pull->setText("Their pull (&p)");
 364         ui->pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
 365         ui->their_pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
 366         ui->throwaway->setText("Throwaway (&t)");
 367         ui->throwaway->setShortcut(QCoreApplication::translate("MainWindow", "T", nullptr));
 368
 369         if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
 370                 ui->pull->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
 371                 ui->their_pull->setEnabled(s.attack_state == EventsModel::Status::OFFENSE);
 372
 373                 ui->catch_->setEnabled(false);
 374                 ui->throwaway->setEnabled(false);
 375                 ui->drop->setEnabled(false);
 376                 ui->goal->setEnabled(false);
 377                 ui->offensive_soft_plus->setEnabled(false);
 378                 ui->offensive_soft_minus->setEnabled(false);
 379                 ui->interception->setEnabled(false);
 380                 ui->their_throwaway->setEnabled(false);
 381                 ui->our_defense->setEnabled(false);
 382                 ui->their_goal->setEnabled(false);
 383                 ui->defensive_soft_plus->setEnabled(false);
 384                 ui->defensive_soft_minus->setEnabled(false);
 385                 return;
 386         }
 387         if (s.pull_state == EventsModel::Status::PULL_IN_AIR) {
 388                 if (s.attack_state == EventsModel::Status::DEFENSE) {
 389                         ui->pull->setText("Pull landed (&p)");
 390                         ui->pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
 391                         ui->pull->setEnabled(true);
 392
 393                         ui->throwaway->setText("Pull OOB (&t)");
 394                         ui->throwaway->setShortcut(QCoreApplication::translate("MainWindow", "T", nullptr));
 395                         ui->throwaway->setEnabled(true);
 396                 } else {
 397                         ui->pull->setEnabled(false);
 398                         ui->throwaway->setEnabled(false);
 399                 }
 400                 ui->their_pull->setEnabled(false);  // We don't track their pull landings; only by means of catch etc.
 401
 402                 ui->catch_->setEnabled(false);
 403                 ui->drop->setEnabled(false);
 404                 ui->goal->setEnabled(false);
 405                 ui->offensive_soft_plus->setEnabled(false);
 406                 ui->offensive_soft_minus->setEnabled(false);
 407                 ui->interception->setEnabled(false);
 408                 ui->their_throwaway->setEnabled(false);
 409                 ui->our_defense->setEnabled(false);
 410                 ui->their_goal->setEnabled(false);
 411                 ui->defensive_soft_plus->setEnabled(false);
 412                 ui->defensive_soft_minus->setEnabled(false);
 413                 return;
 414         }
 415
 416         ui->catch_->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
 417         ui->throwaway->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
 418         ui->drop->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
 419         ui->goal->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
 420         ui->offensive_soft_plus->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
 421         ui->offensive_soft_minus->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
 422         ui->pull->setEnabled(false);
 423
 424         ui->interception->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
 425         ui->their_throwaway->setEnabled(s.attack_state == EventsModel::Status::DEFENSE);
 426         ui->our_defense->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
 427         ui->their_goal->setEnabled(s.attack_state == EventsModel::Status::DEFENSE);
 428         ui->defensive_soft_plus->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
 429         ui->defensive_soft_minus->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
 430         ui->their_pull->setEnabled(false);
 431 }
 432
 433 sqlite3 *open_db(const char *filename)
 434 {
 435         sqlite3 *db;
 436         int ret = sqlite3_open(filename, &db);
 437         if (ret != SQLITE_OK) {
 438                 fprintf(stderr, "%s: %s\n", filename, sqlite3_errmsg(db));
 439                 exit(1);
 440         }
 441
 442         sqlite3_exec(db, R"(
 443                 CREATE TABLE IF NOT EXISTS player (player INTEGER PRIMARY KEY, number VARCHAR, name VARCHAR, gender VARCHAR(1));
 444         )", nullptr, nullptr, nullptr);  // Ignore errors.
 445
 446         sqlite3_exec(db, R"(
 447                 CREATE TABLE IF NOT EXISTS match (match INTEGER PRIMARY KEY, description VARCHAR);
 448         )", nullptr, nullptr, nullptr);  // Ignore errors.
 449
 450         sqlite3_exec(db, R"(
 451                 CREATE TABLE IF NOT EXISTS event (event INTEGER PRIMARY KEY, match INTEGER, t INTEGER, player INTEGER, type VARCHAR, FOREIGN KEY (player) REFERENCES player(player), FOREIGN KEY (match) REFERENCES match (match));
 452         )", nullptr, nullptr, nullptr);  // Ignore errors.
 453
 454         sqlite3_exec(db, "PRAGMA journal_mode=WAL", nullptr, nullptr, nullptr);  // Ignore errors.
 455         sqlite3_exec(db, "PRAGMA synchronous=NORMAL", nullptr, nullptr, nullptr);  // Ignore errors.
 456         sqlite3_exec(db, "PRAGMA foreign_keys=ON", nullptr, nullptr, nullptr);  // Ignore errors.
 457         return db;
 458 }
 459
 460 int get_match_id(sqlite3 *db, QWidget *parent)
 461 {
 462         QStringList items;
 463         vector<int> ids;
 464
 465         // Read the list of matches already in the database.
 466         sqlite3_stmt *stmt;
 467         int ret = sqlite3_prepare_v2(db, "SELECT match, description FROM match ORDER BY match", -1, &stmt, 0);
 468         if (ret != SQLITE_OK) {
 469                 fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
 470                 abort();
 471         }
 472         for ( ;; ) {
 473                 ret = sqlite3_step(stmt);
 474                 if (ret == SQLITE_ROW) {
 475                         char buf[256];
 476                         snprintf(buf, sizeof(buf), "%s (%d)", sqlite3_column_text(stmt, 1), sqlite3_column_int(stmt, 0));
 477                         ids.push_back(sqlite3_column_int(stmt, 0));
 478                         items.push_back(buf);
 479                 } else if (ret == SQLITE_DONE) {
 480                         break;
 481                 } else {
 482                         fprintf(stderr, "SELECT step: %s\n", sqlite3_errmsg(db));
 483                         abort();
 484                 }
 485         }
 486         ret = sqlite3_finalize(stmt);
 487         if (ret != SQLITE_OK) {
 488                 fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
 489                 abort();
 490         }
 491         items.push_back("Add new…");
 492
 493         QString chosen_str;
 494         {
 495                 QInputDialog dialog(parent, Qt::WindowFlags());
 496                 dialog.setWindowTitle("Open game");
 497                 dialog.setLabelText("Choose game to analyze:");
 498                 dialog.setComboBoxItems(items);
 499                 dialog.setTextValue(items[items.size() - 2]);
 500                 dialog.setOption(QInputDialog::UseListViewForComboBoxItems, true);
 501                 if (!dialog.exec()) {
 502                         return -1;
 503                 }
 504                 chosen_str = dialog.textValue();
 505         }
 506
 507         for (unsigned i = 0; i < ids.size(); ++i) {
 508                 if (chosen_str == items[i]) {
 509                         return ids[i];
 510                 }
 511         }
 512
 513         // Must be a new game. Get its name and insert it into the database.
 514         bool ok;
 515         QString new_game_str = QInputDialog::getText(parent, "New game", "Choose name for new game:", QLineEdit::Normal, "", &ok);
 516         if (!ok || new_game_str.isEmpty()) {
 517                 return -1;
 518         }
 519
 520         // Insert the new row into the database.
 521         ret = sqlite3_prepare_v2(db, "INSERT INTO match (description) VALUES (?)", -1, &stmt, 0);
 522         if (ret != SQLITE_OK) {
 523                 fprintf(stderr, "INSERT prepare: %s\n", sqlite3_errmsg(db));
 524                 abort();
 525         }
 526
 527         QByteArray new_game_utf8 = new_game_str.toUtf8();
 528         sqlite3_bind_text(stmt, 1, (const char *)new_game_utf8.data(), new_game_utf8.size(), SQLITE_STATIC);
 529
 530         ret = sqlite3_step(stmt);
 531         if (ret == SQLITE_ROW) {
 532                 fprintf(stderr, "INSERT step: %s\n", sqlite3_errmsg(db));
 533                 abort();
 534         }
 535
 536         ret = sqlite3_finalize(stmt);
 537         if (ret != SQLITE_OK) {
 538                 fprintf(stderr, "INSERT finalize: %s\n", sqlite3_errmsg(db));
 539                 abort();
 540         }
 541
 542         return sqlite3_last_insert_rowid(db);
 543 }
 544
 545 int main(int argc, char *argv[])
 546 {
 547         QApplication app(argc, argv);
 548         sqlite3 *db = open_db("ultimate.db");
 549
 550         int match_id = get_match_id(db, nullptr);
 551         if (match_id <= 0) {  // Cancel.
 552                 return 0;
 553         }
 554
 555         MainWindow mainWindow(new EventsModel(db, match_id), new PlayersModel(db));
 556         mainWindow.resize(QSize(1280, 720));
 557         mainWindow.show();
 558
 559         return app.exec();
 560
 561 }