9
|
1 |
/*
|
|
2 |
* Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
|
|
3 |
* All rights reserved.
|
|
4 |
* This component and the accompanying materials are made available
|
|
5 |
* under the terms of "Eclipse Public License v1.0"
|
|
6 |
* which accompanies this distribution, and is available
|
|
7 |
* at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
8 |
*
|
|
9 |
* Initial Contributors:
|
|
10 |
* Nokia Corporation - initial contribution.
|
|
11 |
*
|
|
12 |
* Contributors:
|
|
13 |
*
|
|
14 |
* Description:
|
|
15 |
*
|
|
16 |
*/
|
|
17 |
|
|
18 |
#ifndef ISPROVIDERDBCONSTANTS_H_
|
|
19 |
#define ISPROVIDERDBCONSTANTS_H_
|
|
20 |
|
|
21 |
// Database info
|
|
22 |
#ifdef __WINSCW__
|
|
23 |
const QString databaseName = "c:\\private\\20022f35\\providerdatabase.sq";
|
|
24 |
#else
|
|
25 |
const QString databaseName = "z:\\private\\20022f35\\providerdatabase.sq";
|
|
26 |
#endif
|
|
27 |
const QString connectionName = "providerdatabase.sq";
|
|
28 |
const QString databaseType = "QSQLITE";
|
|
29 |
|
|
30 |
// SQL Queries
|
|
31 |
const QString providerQuery = "SELECT p.ProviderId, Name, Description, Iconpath FROM Providers p INNER JOIN CountryProviderMap map ON p.ProviderId = map.ProviderId JOIN Countries ON map.CountryId = Countries.CountryId WHERE Countries.CountryCode = \'";
|
|
32 |
const QString selectedProviderQuery = "SELECT ProviderId, Name, Description, Iconpath, ProviderUrl FROM Providers WHERE Selected = 1";
|
|
33 |
const QString resetProviderSelection = "UPDATE Providers SET Selected = 0";
|
|
34 |
const QString setSelectedProvider = "UPDATE Providers SET Selected = 1 WHERE ProviderId = ";
|
|
35 |
const QString countryQuery = "SELECT Country FROM Countries";
|
|
36 |
|
|
37 |
|
|
38 |
#endif /* ISPROVIDERDBCONSTANTS_H_ */
|