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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
/*
* This file is part of the KDE Baloo Project
* Copyright (C) 2013 Vishesh Handa <me@vhanda.in>
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) version 3, or any
* later version accepted by the membership of KDE e.V. (or its
* successor approved by the membership of KDE e.V.), which shall
* act as a proxy defined in Section 6 of version 3 of the license.
*
* This library 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
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library. If not, see <http://www.gnu.org/licenses/>.
*
*/
#include "db.h"
#include <KDebug>
#include <KStandardDirs>
#include <QSqlQuery>
#include <QSqlError>
#include <QFile>
std::string fileIndexDbPath()
{
return QFile::encodeName(KGlobal::dirs()->localxdgdatadir() + QLatin1String("baloo/file")).constData();
}
QSqlDatabase fileMappingDb() {
const QString path = KGlobal::dirs()->localxdgdatadir() + QLatin1String("baloo/file/fileMap.sqlite3");
return fileMappingDb(path);
}
QSqlDatabase fileMappingDb(const QString& path)
{
QSqlDatabase sqlDb = QSqlDatabase::database(QLatin1String("fileMappingDb"));
if (!sqlDb.isValid()) {
sqlDb = QSqlDatabase::addDatabase(QLatin1String("QSQLITE"), QLatin1String("fileMappingDb"));
sqlDb.setDatabaseName(path);
}
if (!sqlDb.open()) {
kDebug() << "Failed to open db" << sqlDb.lastError().text();
return sqlDb;
}
const QStringList tables = sqlDb.tables();
if (tables.contains(QLatin1String("files"))) {
return sqlDb;
}
QSqlQuery query(sqlDb);
bool ret = query.exec(QLatin1String("CREATE TABLE files("
"id INTEGER PRIMARY KEY AUTOINCREMENT, "
"url TEXT NOT NULL UNIQUE)"));
if (!ret) {
kDebug() << "Could not create tags table" << query.lastError().text();
return sqlDb;
}
ret = query.exec(QLatin1String("CREATE INDEX fileUrl_index ON files (url)"));
if (!ret) {
kDebug() << "Could not create tags index" << query.lastError().text();
return sqlDb;
}
return sqlDb;
}
QSqlDatabase fileMetadataDb()
{
const QString path = KGlobal::dirs()->localxdgdatadir() + QLatin1String("baloo/file/fileMetaData.sqlite3");
QSqlDatabase sqlDb = QSqlDatabase::database(QLatin1String("fileMetadataDb"));
if (!sqlDb.isValid()) {
sqlDb = QSqlDatabase::addDatabase(QLatin1String("QSQLITE"), QLatin1String("fileMetadataDb"));
sqlDb.setDatabaseName(path);
}
if (!sqlDb.open()) {
kDebug() << "Failed to open db" << sqlDb.lastError().text();
return sqlDb;
}
const QStringList tables = sqlDb.tables();
if (tables.contains(QLatin1String("files"))) {
return sqlDb;
}
QSqlQuery query(sqlDb);
bool ret = query.exec(QLatin1String("CREATE TABLE files("
"id INTEGER NOT NULL, "
"property TEXT NOT NULL, "
"value TEXT NOT NULL, "
"UNIQUE(id, property) ON CONFLICT REPLACE)"));
if (!ret) {
kDebug() << "Could not create tags table" << query.lastError().text();
return sqlDb;
}
ret = query.exec(QLatin1String("CREATE INDEX fileprop_index ON files (property)"));
if (!ret) {
kDebug() << "Could not create tags index" << query.lastError().text();
return sqlDb;
}
return sqlDb;
}
|
