equal
deleted
inserted
replaced
|
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_ */ |