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_ */