1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
/*
* Copyright (c) 2012 Mark Liversedge (liversedge@gmail.com)
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the Free
* Software Foundation; either version 2 of the License, or (at your option)
* any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along
* with this program; if not, write to the Free Software Foundation, Inc., 51
* Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*/
#ifndef _GC_TrainDB_h
#define _GC_TrainDB_h 1
#include "GoldenCheetah.h"
#include <QMessageBox>
#include <QDir>
#include <QHash>
#include <QtSql>
class ErgFile;
class TrainDB : public QObject
{
Q_OBJECT
public:
// get connection name
QSqlDatabase connection() { return dbconn; }
// check the db structure is up to date
void checkDBVersion();
// get schema version
int getDBVersion();
int getCount();
// create and drop connections
TrainDB(QDir home);
~TrainDB();
void startLUW() { dbconn.transaction(); }
void endLUW() { dbconn.commit(); emit dataChanged(); }
bool importWorkout(QString pathname, ErgFile *ergFile);
bool deleteWorkout(QString pathname);
bool importVideo(QString pathname);
bool deleteVideo(QString pathname);
// drop and recreate tables
void rebuildDB();
signals:
void dataChanged();
private:
QDir home;
QSqlDatabase db;
QSqlDatabase dbconn;
void initDatabase(QDir home);
bool createDatabase();
void closeConnection();
bool createWorkoutTable();
bool dropWorkoutTable();
bool createVideoTable();
bool dropVideoTable();
};
extern TrainDB *trainDB;
#endif
|