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
|
/****************************************************************************************
* Copyright (c) 2007 Maximilian Kossick <maximilian.kossick@googlemail.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, see <http://www.gnu.org/licenses/>. *
****************************************************************************************/
#ifndef AMAROK_DATABASEUPDATER_H
#define AMAROK_DATABASEUPDATER_H
#include <QHash>
#include <QString>
class SqlCollection;
class DatabaseUpdater {
public:
DatabaseUpdater( SqlCollection *collection );
~DatabaseUpdater();
bool needsUpdate() const;
void update();
void createTemporaryTables();
void prepareTemporaryTables(); //copies data into temporary tables
void prepareTemporaryTablesForFullScan(); //copies data to temporary urls table
void removeTemporaryTables();
void copyToPermanentTables();
void cleanPermanentTables();
void upgradeVersion1to2();
void upgradeVersion2to3();
void upgradeVersion3to4();
void upgradeVersion4to5();
void upgradeVersion5to6();
void upgradeVersion6to7();
void deleteAllRedundant( const QString &type ); //type is artist,album,genre,composer or year
void removeFilesInDir( int deviceid, const QString &rdir );
void removeFilesInDirFromTemporaryTables( int deviceid, const QString &rdir );
void cleanupDatabase();
void writeCSVFile( const QString &table, const QString &filename, bool forceDebug = false );
private:
/** creates all the necessary tables, indexes etc. for the database */
void createTables() const;
int adminValue( const QString &key ) const;
SqlCollection *m_collection;
bool m_debugDatabaseContent;
};
#endif
|