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
|
/*
* OpenRPT report writer and rendering engine
* Copyright (C) 2001-2014 by OpenMFG, LLC
*
* 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) any later version.
*
* 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, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
* Please contact info@openmfg.com with any questions on this license.
*/
#include "dbtools.h"
#include <QUrl>
void parseDatabaseURL(const QString &pDatabaseURL, QString & pProtocol, QString &pServer, QString &pDatabase, QString &pPort)
{
int location;
QUrl url(pDatabaseURL);
pProtocol = url.scheme();
pServer = url.host();
pDatabase = url.path();
if(pDatabase.startsWith("/"))
pDatabase = pDatabase.mid(1);
int port = url.port();
if(port <= 0)
{
// If the port is not specified it may be the old style so lets check
// for it in the database path like we used to do
location = pDatabase.indexOf(":");
if(-1 != location)
{
port = pDatabase.right(pDatabase.length() - location - 1).toInt();
pDatabase = pDatabase.left(location);
}
}
if(port <= 0)
port = 5432;
pPort = QString().setNum(port);
}
void buildDatabaseURL(QString &pTarget, const QString & pProtocol, const QString &pServer, const QString &pDatabase, const QString &pPort)
{
pTarget = pProtocol + "://" + pServer + ":" + pPort + "/" + pDatabase;
}
QSqlDatabase databaseFromURL( const QString& databaseURL )
{
QString protocol;
QString hostName;
QString dbName;
QString port;
parseDatabaseURL( databaseURL, protocol, hostName, dbName, port );
QSqlDatabase db;
if( "odbc" == protocol )
db = QSqlDatabase::addDatabase("QODBC");
else if ( "pgsql" == protocol || "psql" == protocol )
db = QSqlDatabase::addDatabase("QPSQL");
else if ( "db2" == protocol )
db = QSqlDatabase::addDatabase("QDB2");
else if ( "ibase" == protocol )
db = QSqlDatabase::addDatabase("QIBASE");
else if ( "mysql" == protocol )
db = QSqlDatabase::addDatabase("QMYSQL");
else if ( "oracle" == protocol )
db = QSqlDatabase::addDatabase("QOCI");
else if ( "sqlite" == protocol )
db = QSqlDatabase::addDatabase("QSQLITE");
else if ( "sqlite2" == protocol )
db = QSqlDatabase::addDatabase("QSQLITE2");
else if ( "sybase" == protocol )
db = QSqlDatabase::addDatabase("QTDS");
else
db = QSqlDatabase::addDatabase( protocol.toUpper() ); // third-party or custom qt SQL drivers
if ( db.isValid() )
{
db.setDatabaseName(dbName);
db.setHostName(hostName);
// Check if port was provided. If not, let Qt decide, it knows default values.
bool ok;
int iport = port.toInt( &ok );
if ( ok )
db.setPort( iport );
}
return db;
}
|
