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
|
/*
Copyright (C) 2006-2010 Tuomas Suutari <thsuut@utu.fi>
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 (see the file COPYING); if not, write to the
Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
MA 02110-1301 USA.
*/
#include "ConfigFileHandler.h"
#include "DatabaseAddress.h"
#include "DriverManager.h"
#include "QueryErrors.h"
#include "Settings/SettingsData.h"
#include <kconfig.h>
#include <qfileinfo.h>
#include <kconfiggroup.h>
#define DEFAULT_DRIVER QString::fromLatin1("SQLite3")
#define DEFAULT_DATABASE QString::fromLatin1("kphotoalbum")
#define DATABASE_FILE_EXTENSION QString::fromLatin1(".db")
#define DATABASE_FILE_ROOT Settings::SettingsData::instance()->imageDirectory()
SQLDB::DatabaseAddress SQLDB::readConnectionParameters(const KConfigGroup& config)
{
DatabaseAddress dbAddr;
QString driver(config.readEntry(QString::fromLatin1("dbms"),
DEFAULT_DRIVER));
DriverInfo driverInfo = DriverManager::instance().getDriverInfo(driver);
dbAddr.setDriverName(driver);
dbAddr.setFileBased(driverInfo.isFileBased());
// Could be database name for network based DBMSs or filename
// (relative to image root or absolute) for file based DBMSs
QString databaseName;
if (config.hasKey(QString::fromLatin1("database")))
databaseName = config.readEntry(QString::fromLatin1("database"), QString());
// Check if config file has empty database name or no database
// name at all
if (databaseName.isEmpty()) {
databaseName = DEFAULT_DATABASE;
if (dbAddr.isFileBased())
databaseName += DATABASE_FILE_EXTENSION;
}
if (dbAddr.isFileBased()) {
// Add image root if path is relative
QFileInfo fi(databaseName);
if (fi.isRelative())
databaseName = DATABASE_FILE_ROOT + fi.filePath();
else
databaseName = fi.filePath();
}
else {
if (config.hasKey(QString::fromLatin1("host"))) {
int port = config.readEntry<int>(QString::fromLatin1("port"), 0);
dbAddr.setHost
(config.readEntry(QString::fromLatin1("host"), QString()), port);
}
if (config.hasKey(QString::fromLatin1("username")))
dbAddr.setUserName
(config.readEntry(QString::fromLatin1("username"), QString()));
if (config.hasKey(QString::fromLatin1("password")))
dbAddr.setPassword
(config.readEntry(QString::fromLatin1("password"), QString()));
}
dbAddr.setDatabaseName(databaseName);
return dbAddr;
}
void SQLDB::writeConnectionParameters(const DatabaseAddress& address,
KConfigGroup& config)
{
const QString& databaseName = address.databaseName();
config.writeEntry(QString::fromLatin1("dbms"), address.driverName());
config.writeEntry(QString::fromLatin1("database"), databaseName);
if (!address.usesLocalConnection()) {
config.writeEntry(QString::fromLatin1("host"), address.hostName());
if (address.port() != 0)
config.writeEntry(QString::fromLatin1("port"), address.port());
}
if (!address.userName().isEmpty())
config.writeEntry(QString::fromLatin1("username"), address.userName());
if (!address.password().isEmpty())
config.writeEntry(QString::fromLatin1("password"), address.password());
}
|
