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 #ifndef HSACTIVITY_H

    18 #define HSACTIVITY_H

    19 

    20 

    21 const char ActivityOrganization [] = "nokia";

    22 

    23 const char ActivityApplication [] = "hsactivitydbserver";

    24 

    25 const char ActivityStorageDriver [] = "QSQLITE";

    26 

    27 const char ActivityStorageName [] = "ActivitySQLClient";

    28 

    29 const char ActivityStorageProperty [] = "activitydatabase";

    30 

    31 const char ActivityDefaultStorage [] = "activitydatabase.db";

    32 

    33 const char ActivityTableKeyword [] = ":Table";

    34 const char ActivityDataKeyword [] = ":Data";

    35 

    36 

    37 

    38 const char ActivityCreateQuery [] = "CREATE TABLE Activities(" \

    39                                     "ApplicationId INTEGER NOT NULL," \

    40                                     "ActivityName TEXT NOT NULL," \

    41                                     "Data BLOB NOT NULL," \

    42                                     "PRIMARY KEY ( ApplicationId, ActivityName ) )";

    43 

    44 const char ActivityDropQuery [] = "DROP TABLE :Table";

    45 

    46 const char ActivitySelectActivityQuery [] = "SELECT ApplicationId FROM Activities WHERE " \

    47                                             "ApplicationId = :ApplicationId AND " \

    48                                             "ActivityName = :ActivityName";

    49 

    50 const char ActivityUpdateActivityQuery [] = "UPDATE Activities SET Data = :Data WHERE " \

    51                                             "ApplicationId = :ApplicationId AND " \

    52                                             "ActivityName = :ActivityName";

    53 

    54 const char ActivityInsertActivityQuery [] = "INSERT INTO Activities( ApplicationId, ActivityName, Data ) VALUES " \

    55                                             "( :ApplicationId, :ActivityName, :Data )";

    56 

    57 const char ActivitySelectActiveQuery [] = "SELECT ActivityName FROM Activities WHERE " \

    58                                           "ApplicationId = :ApplicationId";

    59 

    60 const char ActivityActivitiesQuery [] = "SELECT Data FROM Activities";

    61 

    62 const char ActivityApplicationActivitiesQuery [] = "SELECT Data FROM Activities " \

    63                                                    "WHERE ApplicationId = :ApplicationId";

    64 

    65 const char ActivityDeleteActivityQuery [] = "DELETE FROM Activities WHERE " \

    66                                             "ApplicationId = :ApplicationId AND " \

    67                                             "ActivityName = :ActivityName";

    68 

    69 const char ActivityDeleteApplicationActivitiesQuery [] = "DELETE FROM Activities WHERE " \

    70                                                          "ApplicationId = :ApplicationId";

    71 

    72 #endif //HSACTIVITY_H