#include <QApplication>
#include <QGridLayout>
#include <QShortcut>
+#include <QFileDialog>
#include <QInputDialog>
#include <QTimer>
#include <algorithm>
return buf;
}
+string get_video_filename(sqlite3 *db, int match_id)
+{
+ sqlite3_stmt *stmt;
+
+ int ret = sqlite3_prepare_v2(db, "SELECT video_filename FROM match WHERE match=?", -1, &stmt, 0);
+ if (ret != SQLITE_OK) {
+ fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
+ abort();
+ }
+
+ sqlite3_bind_int64(stmt, 1, match_id);
+
+ ret = sqlite3_step(stmt);
+ if (ret != SQLITE_ROW) {
+ fprintf(stderr, "SELECT step: %s\n", sqlite3_errmsg(db));
+ abort();
+ }
+
+ if (sqlite3_column_type(stmt, 0) != SQLITE_TEXT) {
+ return "";
+ }
+ string filename = (const char *)sqlite3_column_text(stmt, 0);
+
+ ret = sqlite3_finalize(stmt);
+ if (ret != SQLITE_OK) {
+ fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
+ abort();
+ }
+ return filename;
+}
+
+void save_video_filename(sqlite3 *db, int match_id, const string &filename)
+{
+ sqlite3_stmt *stmt;
+
+ int ret = sqlite3_prepare_v2(db, "UPDATE match SET video_filename=? WHERE match=?", -1, &stmt, 0);
+ if (ret != SQLITE_OK) {
+ fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
+ abort();
+ }
+
+ sqlite3_bind_text(stmt, 1, filename.data(), filename.size(), SQLITE_STATIC);
+ sqlite3_bind_int64(stmt, 2, match_id);
+
+ ret = sqlite3_step(stmt);
+ if (ret == SQLITE_ROW) {
+ fprintf(stderr, "INSERT step: %s\n", sqlite3_errmsg(db));
+ abort();
+ }
+
+ ret = sqlite3_finalize(stmt);
+ if (ret != SQLITE_OK) {
+ fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
+ abort();
+ }
+}
+
MainWindow::MainWindow(EventsModel *events, PlayersModel *players,
- FormationsModel *offensive_formations, FormationsModel *defensive_formations)
- : events(events), players(players), offensive_formations(offensive_formations), defensive_formations(defensive_formations)
+ FormationsModel *offensive_formations, FormationsModel *defensive_formations,
+ sqlite3 *db, int match_id)
+ : events(events), players(players), offensive_formations(offensive_formations), defensive_formations(defensive_formations), db(db), match_id(match_id)
{
ui = new Ui::MainWindow;
ui->setupUi(this);
- ui->video->open("/home/sesse/dev/stats/ultimate-prores.mkv");
+ string filename = get_video_filename(db, match_id);
+ bool need_save_filename = false;
+ for ( ;; ) {
+ if (!filename.empty() && ui->video->open(filename.c_str())) {
+ break;
+ }
+
+ // TODO: Probably relativize this path, so that we can move the .db
+ // more easily with the videos.
+ filename = QFileDialog::getOpenFileName(this, "Open video").toUtf8();
+ need_save_filename = true;
+ }
+ if (need_save_filename) {
+ save_video_filename(db, match_id, filename);
+ }
ui->video->play();
ui->event_view->setModel(events);