blob: fd19b11e533b935f5f4a4feb377b95ac63eac888 (
plain)
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
/*
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.
*/
#ifndef DBANALYZER_H
#define DBANALYZER_H
#include <QThread>
#include <QVariant>
#include <QList>
#include <QDialog>
#include <QSqlDatabase>
#include <QMutex>
#include <QModelIndex>
class QSqlQuery;
class QTabWidget;
class QTreeView;
class QPushButton;
class SmTreeModel;
class DbAnalyzer;
class QLabel;
class DbAnalyzerDialog : public QDialog {
Q_OBJECT
public:
enum DeleteMode { Actors, Genres };
explicit DbAnalyzerDialog(QWidget *parent = 0, Qt::WindowFlags f = 0);
public slots:
void refresh();
signals:
void partClicked(int seriesPartId, int seriesId);
void delItems(int mode, QList<int> &ids);
private slots:
void cancelAnalyzer();
void analyzerStarted();
void analyzerFinished();
void noActorsDoubleClicked(const QModelIndex &);
void deleteItems();
void tabChanged(int index);
private:
void populate(QTreeView *view ,SmTreeModel *model, const QList<QList<QVariant> > &data);
QTabWidget *mTab;
QTreeView *mNoActorsV;
QTreeView *mStrayActorsV;
QTreeView *mStrayGenresV;
SmTreeModel *mNoActorsM;
SmTreeModel *mStrayActorsM;
SmTreeModel *mStrayGenresM;
QPushButton *mClose;
QPushButton *mCancel;
QPushButton *mDelete;
QPushButton *mRefresh;
QLabel *mTotal;
QList<QString> mTotals;
DbAnalyzer *mAnalyzer;
};
class DbAnalyzer : public QThread {
Q_OBJECT
public:
enum Status { Ok, Fail };
explicit DbAnalyzer(QObject *parent = 0);
~DbAnalyzer();
int status() { return mStatus; }
const QList<QList<QVariant> > noActors() { return mNoActorR; }
const QList<QList<QVariant> > strayActors() { return mStrayActorR; }
const QList<QList<QVariant> > strayGenres() { return mStrayGenresR; }
public slots:
void setCancel(bool canceled);
signals:
void message(const QString &);
protected:
void run();
private:
void noActorsCheck();
const QList<QList<QVariant> > strayCheck(QSqlQuery *query);
QSqlDatabase mDb;
QSqlQuery *mNoActorQuery;
QSqlQuery *mStrayActorsQuery;
QSqlQuery *mStrayGenresQuery;
QList<QList<QVariant> > mNoActorR;
QList<QList<QVariant> > mStrayActorR;
QList<QList<QVariant> > mStrayGenresR;
QMutex mCancelMutex;
QMutex mStatusMutex;
bool mCanceled;
int mStatus;
};
#endif // DBANALYZER_H
|
