contentstorage/castorage/src/casqlitestorage.cpp
author hgs
Tue, 23 Mar 2010 23:28:12 +0200
changeset 86 e492551a0d54
parent 85 7feec50967db
child 88 7f0462e8c3da
permissions -rw-r--r--
201005
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
85
7feec50967db 201003_02
hgs
parents:
diff changeset
     1
/*
7feec50967db 201003_02
hgs
parents:
diff changeset
     2
 * Copyright (c) 2008 Nokia Corporation and/or its subsidiary(-ies).
7feec50967db 201003_02
hgs
parents:
diff changeset
     3
 * All rights reserved.
7feec50967db 201003_02
hgs
parents:
diff changeset
     4
 * This component and the accompanying materials are made available
7feec50967db 201003_02
hgs
parents:
diff changeset
     5
 * under the terms of "Eclipse Public License v1.0"
7feec50967db 201003_02
hgs
parents:
diff changeset
     6
 * which accompanies this distribution, and is available
7feec50967db 201003_02
hgs
parents:
diff changeset
     7
 * at the URL "http://www.eclipse.org/legal/epl-v10.html".
7feec50967db 201003_02
hgs
parents:
diff changeset
     8
 *
7feec50967db 201003_02
hgs
parents:
diff changeset
     9
 * Initial Contributors:
7feec50967db 201003_02
hgs
parents:
diff changeset
    10
 * Nokia Corporation - initial contribution.
7feec50967db 201003_02
hgs
parents:
diff changeset
    11
 *
7feec50967db 201003_02
hgs
parents:
diff changeset
    12
 * Contributors:
7feec50967db 201003_02
hgs
parents:
diff changeset
    13
 *
7feec50967db 201003_02
hgs
parents:
diff changeset
    14
 * Description:
7feec50967db 201003_02
hgs
parents:
diff changeset
    15
 *
7feec50967db 201003_02
hgs
parents:
diff changeset
    16
 */
86
hgs
parents: 85
diff changeset
    17
#include "casqlitestorage.h"
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    18
#include "caconsts.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    19
#include "casqlcommands.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    20
#include "casqlquery.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    21
#include "casqlquerycreator.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    22
#include "cainnerentry.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    23
#include "cainnerquery.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    24
#include "caarraycleanup.inl"
7feec50967db 201003_02
hgs
parents:
diff changeset
    25
#include "calocalizationentry.h"
7feec50967db 201003_02
hgs
parents:
diff changeset
    26
7feec50967db 201003_02
hgs
parents:
diff changeset
    27
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
    28
// CCASqLiteStorage::CCpStorageEngine()
7feec50967db 201003_02
hgs
parents:
diff changeset
    29
//
7feec50967db 201003_02
hgs
parents:
diff changeset
    30
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
    31
//
7feec50967db 201003_02
hgs
parents:
diff changeset
    32
CCaSqLiteStorage::CCaSqLiteStorage()
7feec50967db 201003_02
hgs
parents:
diff changeset
    33
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
    34
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
    35
7feec50967db 201003_02
hgs
parents:
diff changeset
    36
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
    37
// CCASqLiteStorage::ConstructL()
7feec50967db 201003_02
hgs
parents:
diff changeset
    38
//
7feec50967db 201003_02
hgs
parents:
diff changeset
    39
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
    40
//
7feec50967db 201003_02
hgs
parents:
diff changeset
    41
void CCaSqLiteStorage::ConstructL()
7feec50967db 201003_02
hgs
parents:
diff changeset
    42
    {
86
hgs
parents: 85
diff changeset
    43
    User::LeaveIfError( iRfs.Connect() );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    44
86
hgs
parents: 85
diff changeset
    45
    User::LeaveIfError( CreatePrivateDirPath( iPrivatePathCDriveDb, KCDrive,
hgs
parents: 85
diff changeset
    46
            KDbName ) );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    47
86
hgs
parents: 85
diff changeset
    48
    User::LeaveIfError( CreatePrivateDirPath( iPrivatePathZDriveDb, KZDrive,
hgs
parents: 85
diff changeset
    49
            KDbName ) );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    50
86
hgs
parents: 85
diff changeset
    51
    User::LeaveIfError( CreatePrivateDirPath( iPrivatePathCDrive, KCDrive,
hgs
parents: 85
diff changeset
    52
            KNullDesC ) );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    53
86
hgs
parents: 85
diff changeset
    54
    if( iSqlDb.Open( iPrivatePathCDriveDb, &KSqlDbConfig ) )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    55
        {
86
hgs
parents: 85
diff changeset
    56
        //we could not load data base from C-drive lets try Rom
hgs
parents: 85
diff changeset
    57
        LoadDataBaseFromRomL();
hgs
parents: 85
diff changeset
    58
        }
hgs
parents: 85
diff changeset
    59
    }
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    60
86
hgs
parents: 85
diff changeset
    61
// ---------------------------------------------------------------------------
hgs
parents: 85
diff changeset
    62
// CCASqLiteStorage::NewL()
hgs
parents: 85
diff changeset
    63
//
hgs
parents: 85
diff changeset
    64
// ---------------------------------------------------------------------------
hgs
parents: 85
diff changeset
    65
//
hgs
parents: 85
diff changeset
    66
void CCaSqLiteStorage::LoadDataBaseFromRomL()
hgs
parents: 85
diff changeset
    67
    {
hgs
parents: 85
diff changeset
    68
    if( ( BaflUtils::FileExists( iRfs, iPrivatePathCDriveDb ) ) )
hgs
parents: 85
diff changeset
    69
        {
hgs
parents: 85
diff changeset
    70
        iSqlDb.Close();
hgs
parents: 85
diff changeset
    71
        User::LeaveIfError( BaflUtils::DeleteFile( iRfs,
hgs
parents: 85
diff changeset
    72
                iPrivatePathCDriveDb ) );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    73
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
    74
86
hgs
parents: 85
diff changeset
    75
    if( !( BaflUtils::FileExists( iRfs, iPrivatePathZDriveDb ) ) )
hgs
parents: 85
diff changeset
    76
        {
hgs
parents: 85
diff changeset
    77
        User::Panic( _L("fatal error - castoragedb not exists in ROM"),
hgs
parents: 85
diff changeset
    78
                KErrNotFound );
hgs
parents: 85
diff changeset
    79
        }
hgs
parents: 85
diff changeset
    80
    else
hgs
parents: 85
diff changeset
    81
        {
hgs
parents: 85
diff changeset
    82
        if( !( BaflUtils::FolderExists( iRfs, iPrivatePathCDrive ) ) )
hgs
parents: 85
diff changeset
    83
            {
hgs
parents: 85
diff changeset
    84
            User::LeaveIfError( iRfs.CreatePrivatePath( EDriveC ) );
hgs
parents: 85
diff changeset
    85
            }
hgs
parents: 85
diff changeset
    86
        User::LeaveIfError( BaflUtils::CopyFile( iRfs,
hgs
parents: 85
diff changeset
    87
                iPrivatePathZDriveDb, iPrivatePathCDrive ) );
hgs
parents: 85
diff changeset
    88
        User::LeaveIfError( iRfs.SetAtt( iPrivatePathCDriveDb,
hgs
parents: 85
diff changeset
    89
                KEntryAttNormal, KEntryAttReadOnly ) );
hgs
parents: 85
diff changeset
    90
        User::LeaveIfError( iSqlDb.Open( iPrivatePathCDriveDb,
hgs
parents: 85
diff changeset
    91
                &KSqlDbConfig ) );
hgs
parents: 85
diff changeset
    92
        }
85
7feec50967db 201003_02
hgs
parents:
diff changeset
    93
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
    94
7feec50967db 201003_02
hgs
parents:
diff changeset
    95
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
    96
// CCASqLiteStorage::NewL()
7feec50967db 201003_02
hgs
parents:
diff changeset
    97
//
7feec50967db 201003_02
hgs
parents:
diff changeset
    98
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
    99
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   100
CCaSqLiteStorage* CCaSqLiteStorage::NewL()
7feec50967db 201003_02
hgs
parents:
diff changeset
   101
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   102
    CCaSqLiteStorage* self = CCaSqLiteStorage::NewLC();
7feec50967db 201003_02
hgs
parents:
diff changeset
   103
    CleanupStack::Pop( self );
7feec50967db 201003_02
hgs
parents:
diff changeset
   104
    return self;
7feec50967db 201003_02
hgs
parents:
diff changeset
   105
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   106
7feec50967db 201003_02
hgs
parents:
diff changeset
   107
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   108
// CCASqLiteStorage::NewLC()
7feec50967db 201003_02
hgs
parents:
diff changeset
   109
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   110
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   111
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   112
CCaSqLiteStorage* CCaSqLiteStorage::NewLC()
7feec50967db 201003_02
hgs
parents:
diff changeset
   113
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   114
    CCaSqLiteStorage* self = new ( ELeave ) CCaSqLiteStorage();
7feec50967db 201003_02
hgs
parents:
diff changeset
   115
    CleanupStack::PushL( self );
7feec50967db 201003_02
hgs
parents:
diff changeset
   116
    self->ConstructL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   117
    return self;
7feec50967db 201003_02
hgs
parents:
diff changeset
   118
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   119
7feec50967db 201003_02
hgs
parents:
diff changeset
   120
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   121
// CCASqLiteStorage::~CCpStorageEngine()
7feec50967db 201003_02
hgs
parents:
diff changeset
   122
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   123
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   124
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   125
CCaSqLiteStorage::~CCaSqLiteStorage()
7feec50967db 201003_02
hgs
parents:
diff changeset
   126
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   127
    iSqlDb.Close();
86
hgs
parents: 85
diff changeset
   128
    iRfs.Close();
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   129
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   130
7feec50967db 201003_02
hgs
parents:
diff changeset
   131
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   132
// CCaSqLiteStorage::CreatePrivateDirPath()
7feec50967db 201003_02
hgs
parents:
diff changeset
   133
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   134
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   135
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   136
TInt CCaSqLiteStorage::CreatePrivateDirPath( TFileName& aPrivatePath,
86
hgs
parents: 85
diff changeset
   137
        const TDesC& aDrive, const TDesC& aDbName )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   138
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   139
    TInt error( KErrNone );
7feec50967db 201003_02
hgs
parents:
diff changeset
   140
7feec50967db 201003_02
hgs
parents:
diff changeset
   141
#ifdef CONTENT_ARSENAL_STORAGE_UT
7feec50967db 201003_02
hgs
parents:
diff changeset
   142
    TFileName KPathWithoutDrive( KDoubleSlash );
7feec50967db 201003_02
hgs
parents:
diff changeset
   143
#else
7feec50967db 201003_02
hgs
parents:
diff changeset
   144
    TFileName KPathWithoutDrive;
86
hgs
parents: 85
diff changeset
   145
    error = iRfs.PrivatePath( KPathWithoutDrive );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   146
    if( error != KErrNone )
7feec50967db 201003_02
hgs
parents:
diff changeset
   147
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   148
        return error;
7feec50967db 201003_02
hgs
parents:
diff changeset
   149
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   150
#endif
7feec50967db 201003_02
hgs
parents:
diff changeset
   151
7feec50967db 201003_02
hgs
parents:
diff changeset
   152
    aPrivatePath.Copy( aDrive );
7feec50967db 201003_02
hgs
parents:
diff changeset
   153
    aPrivatePath.Append( KPathWithoutDrive );
7feec50967db 201003_02
hgs
parents:
diff changeset
   154
    aPrivatePath.Append( aDbName );
7feec50967db 201003_02
hgs
parents:
diff changeset
   155
7feec50967db 201003_02
hgs
parents:
diff changeset
   156
    return error;
7feec50967db 201003_02
hgs
parents:
diff changeset
   157
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   158
7feec50967db 201003_02
hgs
parents:
diff changeset
   159
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   160
// CCASqLiteStorage::GetListL
7feec50967db 201003_02
hgs
parents:
diff changeset
   161
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   162
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   163
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   164
void CCaSqLiteStorage::GetEntriesL( const CCaInnerQuery* aQuery,
7feec50967db 201003_02
hgs
parents:
diff changeset
   165
        RPointerArray<CCaInnerEntry>& aResultContainer )
7feec50967db 201003_02
hgs
parents:
diff changeset
   166
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   167
    //    Fetch entries from
7feec50967db 201003_02
hgs
parents:
diff changeset
   168
    CCaSqlQuery* sqlGetEntriesQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   169
    CaSqlQueryCreator::CreateGetEntriesQueryL( aQuery, sqlGetEntriesQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   170
    sqlGetEntriesQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   171
    sqlGetEntriesQuery->BindValuesForGetEntriesL( aQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   172
    sqlGetEntriesQuery->ExecuteL( aResultContainer, CCaSqlQuery::EEntry );
7feec50967db 201003_02
hgs
parents:
diff changeset
   173
    CleanupStack::PopAndDestroy( sqlGetEntriesQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   174
7feec50967db 201003_02
hgs
parents:
diff changeset
   175
    //    Populate the entries with their attributes
7feec50967db 201003_02
hgs
parents:
diff changeset
   176
    if( aResultContainer.Count() > 0 )
7feec50967db 201003_02
hgs
parents:
diff changeset
   177
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   178
        CCaSqlQuery* sqlGetAttributesQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   179
        CaSqlQueryCreator::CreateGetAttributesQueryL(
7feec50967db 201003_02
hgs
parents:
diff changeset
   180
                aResultContainer.Count(), sqlGetAttributesQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   181
        sqlGetAttributesQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   182
        sqlGetAttributesQuery->BindEntryIdsL( aResultContainer );
7feec50967db 201003_02
hgs
parents:
diff changeset
   183
        sqlGetAttributesQuery->ExecuteL( aResultContainer,
7feec50967db 201003_02
hgs
parents:
diff changeset
   184
                CCaSqlQuery::EAttribute );
7feec50967db 201003_02
hgs
parents:
diff changeset
   185
        CleanupStack::PopAndDestroy( sqlGetAttributesQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   186
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   187
    //  set entries if proper order if they were fetched by ids
7feec50967db 201003_02
hgs
parents:
diff changeset
   188
    if( aQuery->GetIds().Count() > 0 )
7feec50967db 201003_02
hgs
parents:
diff changeset
   189
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   190
        SetEntriesInProperOrderL( aQuery->GetIds(), aResultContainer );
7feec50967db 201003_02
hgs
parents:
diff changeset
   191
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   192
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   193
7feec50967db 201003_02
hgs
parents:
diff changeset
   194
void CCaSqLiteStorage::LocalizeEntryL( CCaLocalizationEntry& aLocalization )
7feec50967db 201003_02
hgs
parents:
diff changeset
   195
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   196
    CCaSqlQuery* sqlLocalizeEntryQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   197
    CaSqlQueryCreator::CreateLocalizeEntryQueryL( sqlLocalizeEntryQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   198
    sqlLocalizeEntryQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   199
    sqlLocalizeEntryQuery->BindValuesForLocalizeL( aLocalization );
7feec50967db 201003_02
hgs
parents:
diff changeset
   200
    sqlLocalizeEntryQuery->ExecuteL( );
7feec50967db 201003_02
hgs
parents:
diff changeset
   201
    CleanupStack::PopAndDestroy( sqlLocalizeEntryQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   202
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   203
86
hgs
parents: 85
diff changeset
   204
void CCaSqLiteStorage::GetLocalizationsL(
hgs
parents: 85
diff changeset
   205
        RPointerArray<CCaLocalizationEntry>& aResultContainer )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   206
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   207
    CCaSqlQuery* sqlGetLocalizationsQuery = CCaSqlQuery::NewLC( iSqlDb );
86
hgs
parents: 85
diff changeset
   208
    CaSqlQueryCreator::CreateGetLocalizationsQueryL(
hgs
parents: 85
diff changeset
   209
            sqlGetLocalizationsQuery );
hgs
parents: 85
diff changeset
   210
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   211
    sqlGetLocalizationsQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   212
    sqlGetLocalizationsQuery->ExecuteLocalizationsL( aResultContainer );
7feec50967db 201003_02
hgs
parents:
diff changeset
   213
    CleanupStack::PopAndDestroy( sqlGetLocalizationsQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   214
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   215
7feec50967db 201003_02
hgs
parents:
diff changeset
   216
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   217
// CCASqLiteStorage::GetEntriesIdsL
7feec50967db 201003_02
hgs
parents:
diff changeset
   218
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   219
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   220
//
86
hgs
parents: 85
diff changeset
   221
void CCaSqLiteStorage::GetEntriesIdsL( const CCaInnerQuery* aQuery,
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   222
        RArray<TInt>& aResultIdArray )
7feec50967db 201003_02
hgs
parents:
diff changeset
   223
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   224
    CCaSqlQuery* sqlGetEntriesIdsQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   225
    CaSqlQueryCreator::CreateGetEntriesQueryL( aQuery,
7feec50967db 201003_02
hgs
parents:
diff changeset
   226
            sqlGetEntriesIdsQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   227
    sqlGetEntriesIdsQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   228
    sqlGetEntriesIdsQuery->BindValuesForGetEntriesL( aQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   229
    sqlGetEntriesIdsQuery->ExecuteL( aResultIdArray,
7feec50967db 201003_02
hgs
parents:
diff changeset
   230
            CCaSqlQuery::EEntryTable );
7feec50967db 201003_02
hgs
parents:
diff changeset
   231
    CleanupStack::PopAndDestroy( sqlGetEntriesIdsQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   232
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   233
7feec50967db 201003_02
hgs
parents:
diff changeset
   234
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   235
// CCASqLiteStorage::GetEntriesIdsL
7feec50967db 201003_02
hgs
parents:
diff changeset
   236
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   237
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   238
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   239
void CCaSqLiteStorage::GetParentsIdsL( const RArray<TInt>& aEntryIdArray,
7feec50967db 201003_02
hgs
parents:
diff changeset
   240
        RArray<TInt>& aParentIdArray )
7feec50967db 201003_02
hgs
parents:
diff changeset
   241
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   242
    CCaSqlQuery* sqlGetParentIdsQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   243
    CaSqlQueryCreator::CreateGetParentsIdsQueryL( aEntryIdArray,
7feec50967db 201003_02
hgs
parents:
diff changeset
   244
            sqlGetParentIdsQuery, aParentIdArray );
7feec50967db 201003_02
hgs
parents:
diff changeset
   245
    sqlGetParentIdsQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   246
    sqlGetParentIdsQuery->BindIdsL( aEntryIdArray, KSQLGEEntryId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   247
    if( aParentIdArray.Count() > 0 )
7feec50967db 201003_02
hgs
parents:
diff changeset
   248
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   249
        sqlGetParentIdsQuery->BindIdsL( aParentIdArray, KSQLGEIdGroup );
7feec50967db 201003_02
hgs
parents:
diff changeset
   250
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   251
    TInt parentCount = sqlGetParentIdsQuery->ExecuteL( aParentIdArray,
7feec50967db 201003_02
hgs
parents:
diff changeset
   252
            CCaSqlQuery::EGroupTable );
7feec50967db 201003_02
hgs
parents:
diff changeset
   253
    CleanupStack::PopAndDestroy( sqlGetParentIdsQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   254
    if( parentCount > 0 )
7feec50967db 201003_02
hgs
parents:
diff changeset
   255
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   256
        GetParentsIdsL( aParentIdArray, aParentIdArray );
7feec50967db 201003_02
hgs
parents:
diff changeset
   257
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   258
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   259
7feec50967db 201003_02
hgs
parents:
diff changeset
   260
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   261
// CCASqLiteStorage::AddL
7feec50967db 201003_02
hgs
parents:
diff changeset
   262
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   263
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   264
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   265
void CCaSqLiteStorage::AddL( CCaInnerEntry* aEntry, TBool aUpdate)
7feec50967db 201003_02
hgs
parents:
diff changeset
   266
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   267
    RPointerArray<CCaSqlQuery> sqlQueries;
7feec50967db 201003_02
hgs
parents:
diff changeset
   268
    CleanupResetAndDestroyPushL( sqlQueries );
7feec50967db 201003_02
hgs
parents:
diff changeset
   269
7feec50967db 201003_02
hgs
parents:
diff changeset
   270
    CaSqlQueryCreator::CreateAddQueryL( aEntry, sqlQueries, iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   271
7feec50967db 201003_02
hgs
parents:
diff changeset
   272
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   273
    TRAPD( err, ExecuteAddL( aEntry, sqlQueries ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   274
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   275
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   276
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   277
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   278
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   279
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   280
7feec50967db 201003_02
hgs
parents:
diff changeset
   281
    CleanupStack::PopAndDestroy( &sqlQueries );
86
hgs
parents: 85
diff changeset
   282
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   283
    if( aUpdate )
7feec50967db 201003_02
hgs
parents:
diff changeset
   284
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   285
        RemoveFromLocalizationL( aEntry->GetId() );
7feec50967db 201003_02
hgs
parents:
diff changeset
   286
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   287
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   288
7feec50967db 201003_02
hgs
parents:
diff changeset
   289
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   290
// CCASqLiteStorage::RemoveL
7feec50967db 201003_02
hgs
parents:
diff changeset
   291
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   292
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   293
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   294
void CCaSqLiteStorage::RemoveL( const RArray<TInt>& aEntryIds )
7feec50967db 201003_02
hgs
parents:
diff changeset
   295
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   296
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   297
    TRAPD( err, ExecuteRemoveL( aEntryIds ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   298
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   299
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   300
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   301
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   302
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   303
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   304
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   305
7feec50967db 201003_02
hgs
parents:
diff changeset
   306
// ---------------------------------------------------------------------------
86
hgs
parents: 85
diff changeset
   307
// CCASqLiteStorage::OrganizeL( const RArray<TInt>& aEntryIds,
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   308
//        TCaOperationParams aParams )
7feec50967db 201003_02
hgs
parents:
diff changeset
   309
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   310
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   311
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   312
void CCaSqLiteStorage::OrganizeL( const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   313
        TCaOperationParams aParams )
7feec50967db 201003_02
hgs
parents:
diff changeset
   314
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   315
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   316
    TRAPD( err, ExecuteOrganizeL( aEntryIds, aParams ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   317
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   318
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   319
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   320
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   321
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   322
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   323
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   324
7feec50967db 201003_02
hgs
parents:
diff changeset
   325
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   326
// CCASqLiteStorage::TouchL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   327
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   328
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   329
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   330
void CCaSqLiteStorage::TouchL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   331
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   332
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   333
    TRAPD( err, ExecuteTouchL( aEntryId ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   334
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   335
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   336
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   337
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   338
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   339
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   340
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   341
7feec50967db 201003_02
hgs
parents:
diff changeset
   342
// ---------------------------------------------------------------------------
86
hgs
parents: 85
diff changeset
   343
// CCASqLiteStorage::DbPropertyL
hgs
parents: 85
diff changeset
   344
// ( const TDesC& aProperty, TDes& aPropertyValue )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   345
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   346
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   347
void CCaSqLiteStorage::DbPropertyL( const TDesC& aProperty,
7feec50967db 201003_02
hgs
parents:
diff changeset
   348
        TDes& aPropertyValue )
7feec50967db 201003_02
hgs
parents:
diff changeset
   349
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   350
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   351
    TRAPD( err, ExecuteDbPropertyL( aProperty, aPropertyValue ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   352
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   353
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   354
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   355
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   356
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   357
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   358
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   359
7feec50967db 201003_02
hgs
parents:
diff changeset
   360
// ---------------------------------------------------------------------------
86
hgs
parents: 85
diff changeset
   361
// CCASqLiteStorage::SetDBPropertyL
hgs
parents: 85
diff changeset
   362
// ( const TDesC& aProperty, const TDesC& aPropertyValue )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   363
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   364
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   365
void CCaSqLiteStorage::SetDBPropertyL( const TDesC& aProperty,
7feec50967db 201003_02
hgs
parents:
diff changeset
   366
        const TDesC& aPropertyValue )
7feec50967db 201003_02
hgs
parents:
diff changeset
   367
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   368
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   369
    TRAPD( err, ExecuteSetDbPropertyL( aProperty, aPropertyValue ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   370
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   371
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   372
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   373
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   374
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   375
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   376
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   377
7feec50967db 201003_02
hgs
parents:
diff changeset
   378
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   379
// CCaSqLiteStorage::RemoveFromLocalizationL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   380
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   381
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   382
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   383
void CCaSqLiteStorage::RemoveFromLocalizationL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   384
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   385
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   386
    TRAPD( err, ExecuteRemoveFromLocalizationL( aEntryId ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   387
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   388
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   389
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   390
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   391
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   392
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   393
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   394
7feec50967db 201003_02
hgs
parents:
diff changeset
   395
// ---------------------------------------------------------------------------
86
hgs
parents: 85
diff changeset
   396
// CCaSqLiteStorage::CustomSortL
hgs
parents: 85
diff changeset
   397
// ( const RArray<TInt>& aEntryIds, const TInt aGroupId )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   398
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   399
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   400
void CCaSqLiteStorage::CustomSortL( const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   401
        const TInt aGroupId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   402
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   403
    RPointerArray<CCaSqlQuery> sqlQueries;
7feec50967db 201003_02
hgs
parents:
diff changeset
   404
    CleanupResetAndDestroyPushL( sqlQueries );
7feec50967db 201003_02
hgs
parents:
diff changeset
   405
86
hgs
parents: 85
diff changeset
   406
    CaSqlQueryCreator::CreateCustomSortQueryL(
hgs
parents: 85
diff changeset
   407
            aEntryIds, sqlQueries, iSqlDb );
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   408
7feec50967db 201003_02
hgs
parents:
diff changeset
   409
    ExecuteStatementL( KSqlStatementBegin );
7feec50967db 201003_02
hgs
parents:
diff changeset
   410
    TRAPD( err, ExecuteCustomSortL( aEntryIds, aGroupId, sqlQueries ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   411
    if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   412
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   413
        ExecuteStatementL( KSqlStatementRollback );
7feec50967db 201003_02
hgs
parents:
diff changeset
   414
        User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   415
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   416
    ExecuteStatementL( KSqlStatementCommit );
7feec50967db 201003_02
hgs
parents:
diff changeset
   417
7feec50967db 201003_02
hgs
parents:
diff changeset
   418
    CleanupStack::PopAndDestroy( &sqlQueries );
7feec50967db 201003_02
hgs
parents:
diff changeset
   419
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   420
7feec50967db 201003_02
hgs
parents:
diff changeset
   421
// ---------------------------------------------------------------------------
86
hgs
parents: 85
diff changeset
   422
// CCaSqLiteStorage::ExecuteCustomSortL
hgs
parents: 85
diff changeset
   423
// ( const RArray<TInt>& aEntryIds, const TInt aGroupId )
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   424
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   425
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   426
void CCaSqLiteStorage::ExecuteCustomSortL( const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   427
        const TInt aGroupId , RPointerArray<CCaSqlQuery>& aSqlQuery )
7feec50967db 201003_02
hgs
parents:
diff changeset
   428
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   429
    for( TInt i = 0; i < aSqlQuery.Count(); i++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   430
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   431
        TInt newPosition = i + 1;
7feec50967db 201003_02
hgs
parents:
diff changeset
   432
        TInt entryId = aEntryIds[i];
86
hgs
parents: 85
diff changeset
   433
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   434
        aSqlQuery[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   435
        aSqlQuery[i]->BindValuesForCustomSortL( aGroupId, entryId, newPosition );
7feec50967db 201003_02
hgs
parents:
diff changeset
   436
        aSqlQuery[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   437
        aSqlQuery[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   438
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   439
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   440
7feec50967db 201003_02
hgs
parents:
diff changeset
   441
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   442
// CCaSqLiteStorage::ExecuteRemoveFromLocalizationL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   443
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   444
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   445
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   446
void CCaSqLiteStorage::ExecuteRemoveFromLocalizationL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   447
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   448
    CCaSqlQuery* query = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   449
    query->SetQueryL( KSQLDeleteLocalizationTextWhereEntryId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   450
    query->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   451
    query->BindValuesForRemoveFromLocalizationL( aEntryId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   452
    query->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   453
    CleanupStack::PopAndDestroy( query );
7feec50967db 201003_02
hgs
parents:
diff changeset
   454
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   455
7feec50967db 201003_02
hgs
parents:
diff changeset
   456
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   457
// CCASqLiteStorage::ExecuteStatementL( const TDesC& aStatement )
7feec50967db 201003_02
hgs
parents:
diff changeset
   458
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   459
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   460
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   461
void CCaSqLiteStorage::ExecuteStatementL( const TDesC& aStatement )
7feec50967db 201003_02
hgs
parents:
diff changeset
   462
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   463
    CCaSqlQuery* query = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   464
    query->SetQueryL( aStatement );
7feec50967db 201003_02
hgs
parents:
diff changeset
   465
    query->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   466
    query->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   467
    CleanupStack::PopAndDestroy( query );
7feec50967db 201003_02
hgs
parents:
diff changeset
   468
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   469
7feec50967db 201003_02
hgs
parents:
diff changeset
   470
// ---------------------------------------------------------------------------
86
hgs
parents: 85
diff changeset
   471
// CCASqLiteStorage::ExecuteAddL(CCaInnerEntry* aEntry,
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   472
//         RPointerArray<CCASqlQuery>& sqlQuery)
7feec50967db 201003_02
hgs
parents:
diff changeset
   473
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   474
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   475
//
86
hgs
parents: 85
diff changeset
   476
void CCaSqLiteStorage::ExecuteAddL( CCaInnerEntry* aEntry,
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   477
        RPointerArray<CCaSqlQuery>& aSqlQuery )
7feec50967db 201003_02
hgs
parents:
diff changeset
   478
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   479
    TBool isAttributeDeleted( EFalse );
7feec50967db 201003_02
hgs
parents:
diff changeset
   480
    for( TInt i = 0; i < aSqlQuery.Count(); i++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   481
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   482
        if( aSqlQuery[i]->Type() == CCaSqlQuery::EIconTable )
7feec50967db 201003_02
hgs
parents:
diff changeset
   483
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   484
            //check if icon exists - just update
7feec50967db 201003_02
hgs
parents:
diff changeset
   485
            CCaSqlQuery* query = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   486
            query->SetQueryL( KSQLGetIconId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   487
            query->SetTableType( CCaSqlQuery::EIconTable );
7feec50967db 201003_02
hgs
parents:
diff changeset
   488
            query->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   489
            query->BindValuesForGetIconL( aEntry );
7feec50967db 201003_02
hgs
parents:
diff changeset
   490
            CCaInnerEntry::TIconAttributes iconAttributes;
7feec50967db 201003_02
hgs
parents:
diff changeset
   491
            TInt countIcons = query->ExecuteL( iconAttributes );
7feec50967db 201003_02
hgs
parents:
diff changeset
   492
            CleanupStack::PopAndDestroy( query );
86
hgs
parents: 85
diff changeset
   493
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   494
            aSqlQuery[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   495
            aSqlQuery[i]->BindValuesForAddL( aEntry );
7feec50967db 201003_02
hgs
parents:
diff changeset
   496
            TInt tmpId( 0 );
7feec50967db 201003_02
hgs
parents:
diff changeset
   497
            TRAPD( err, tmpId = aSqlQuery[i]->ExecuteL() );
7feec50967db 201003_02
hgs
parents:
diff changeset
   498
            aSqlQuery[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   499
            if( !countIcons && !aEntry->GetIconId() )
7feec50967db 201003_02
hgs
parents:
diff changeset
   500
                { // new icon added
7feec50967db 201003_02
hgs
parents:
diff changeset
   501
                aEntry->SetIconId( tmpId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   502
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   503
7feec50967db 201003_02
hgs
parents:
diff changeset
   504
            if( err == KSqlErrConstraint )
7feec50967db 201003_02
hgs
parents:
diff changeset
   505
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   506
                // ignore, this means that the icon cannot be removed
7feec50967db 201003_02
hgs
parents:
diff changeset
   507
                // because some other entry has the same icon.
7feec50967db 201003_02
hgs
parents:
diff changeset
   508
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   509
            else if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   510
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   511
                User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   512
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   513
7feec50967db 201003_02
hgs
parents:
diff changeset
   514
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   515
        else if( aSqlQuery[i]->Type() == CCaSqlQuery::EEntryTable )
7feec50967db 201003_02
hgs
parents:
diff changeset
   516
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   517
            aSqlQuery[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   518
            aSqlQuery[i]->BindValuesForAddL( aEntry );
7feec50967db 201003_02
hgs
parents:
diff changeset
   519
            TInt tmpId = aSqlQuery[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   520
            aSqlQuery[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   521
            if( !aEntry->GetId() )
7feec50967db 201003_02
hgs
parents:
diff changeset
   522
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   523
                // new entry added
7feec50967db 201003_02
hgs
parents:
diff changeset
   524
                aEntry->SetId( tmpId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   525
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   526
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   527
        else if( !isAttributeDeleted
7feec50967db 201003_02
hgs
parents:
diff changeset
   528
                && aSqlQuery[i]->Type() == CCaSqlQuery::EAttributeTable )
7feec50967db 201003_02
hgs
parents:
diff changeset
   529
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   530
            // delete all entry's attributes, just ones
7feec50967db 201003_02
hgs
parents:
diff changeset
   531
            aSqlQuery[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   532
            aSqlQuery[i]->BindEntryIdL( aEntry->GetId() );
7feec50967db 201003_02
hgs
parents:
diff changeset
   533
            aSqlQuery[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   534
            aSqlQuery[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   535
            isAttributeDeleted = ETrue;
7feec50967db 201003_02
hgs
parents:
diff changeset
   536
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   537
        else if( aSqlQuery[i]->Type()==CCaSqlQuery::EAttributeTable )
7feec50967db 201003_02
hgs
parents:
diff changeset
   538
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   539
            // add new attribute(s) if it's neccesery
7feec50967db 201003_02
hgs
parents:
diff changeset
   540
            aSqlQuery[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   541
            for( TInt k(0); k < aEntry->GetAttributes().Count(); k++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   542
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   543
                // if(id_entry, name) exist it'll replaced by new value
7feec50967db 201003_02
hgs
parents:
diff changeset
   544
                aSqlQuery[i]->BindValuesForAddAttributeL( aEntry,
7feec50967db 201003_02
hgs
parents:
diff changeset
   545
                        aEntry->GetAttributes()[k] );
7feec50967db 201003_02
hgs
parents:
diff changeset
   546
                aSqlQuery[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   547
                aSqlQuery[i]->ResetStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   548
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   549
            aSqlQuery[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   550
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   551
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   552
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   553
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   554
// CCASqLiteStorage::ExecuteRemoveL( const RArray<TInt>& aEntryIds)
7feec50967db 201003_02
hgs
parents:
diff changeset
   555
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   556
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   557
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   558
void CCaSqLiteStorage::ExecuteRemoveL( const RArray<TInt>& aEntryIds )
7feec50967db 201003_02
hgs
parents:
diff changeset
   559
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   560
    for( int i=0; i<aEntryIds.Count(); i++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   561
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   562
        // check if entry exist in database
7feec50967db 201003_02
hgs
parents:
diff changeset
   563
        CCaSqlQuery* queryEntry = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   564
        queryEntry->SetQueryL( KSQLGetEntryIdFromEntryTable );
7feec50967db 201003_02
hgs
parents:
diff changeset
   565
        queryEntry->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   566
        queryEntry->BindEntryIdL( aEntryIds[i] );
7feec50967db 201003_02
hgs
parents:
diff changeset
   567
        TInt entryCount( 0 );
7feec50967db 201003_02
hgs
parents:
diff changeset
   568
        queryEntry->ExecuteL( entryCount );
7feec50967db 201003_02
hgs
parents:
diff changeset
   569
        CleanupStack::PopAndDestroy( queryEntry );
7feec50967db 201003_02
hgs
parents:
diff changeset
   570
        if( !entryCount )
7feec50967db 201003_02
hgs
parents:
diff changeset
   571
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   572
            User::Leave( KErrNotFound );
7feec50967db 201003_02
hgs
parents:
diff changeset
   573
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   574
7feec50967db 201003_02
hgs
parents:
diff changeset
   575
        // SELECT Id_Icon FROM CA_ENTRY WHERE Id = aEntryId;
7feec50967db 201003_02
hgs
parents:
diff changeset
   576
        CCaSqlQuery* queryIconId = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   577
        queryIconId->SetQueryL( KSQLGETIconIdFromEntryTable );
7feec50967db 201003_02
hgs
parents:
diff changeset
   578
        queryIconId->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   579
        queryIconId->BindEntryIdL( aEntryIds[i] );
7feec50967db 201003_02
hgs
parents:
diff changeset
   580
        TInt iconId( 0 );
7feec50967db 201003_02
hgs
parents:
diff changeset
   581
        queryIconId->ExecuteL( iconId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   582
        CleanupStack::PopAndDestroy( queryIconId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   583
7feec50967db 201003_02
hgs
parents:
diff changeset
   584
        RPointerArray<CCaSqlQuery> sqlQuery;
7feec50967db 201003_02
hgs
parents:
diff changeset
   585
        CleanupResetAndDestroyPushL( sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   586
        CaSqlQueryCreator::CreateRemoveQueryL( sqlQuery, iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   587
        for( TInt j = 0; j < sqlQuery.Count(); j++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   588
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   589
            if( !( sqlQuery[j]->Type() == CCaSqlQuery::EIconTable &&
7feec50967db 201003_02
hgs
parents:
diff changeset
   590
                    iconId == 0 ) )
7feec50967db 201003_02
hgs
parents:
diff changeset
   591
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   592
                sqlQuery[j]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   593
                sqlQuery[j]->BindValuesForRemoveL( aEntryIds[i], iconId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   594
                TRAPD( err, sqlQuery[j]->ExecuteL() );
7feec50967db 201003_02
hgs
parents:
diff changeset
   595
                sqlQuery[j]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   596
7feec50967db 201003_02
hgs
parents:
diff changeset
   597
                if( sqlQuery[j]->Type() == CCaSqlQuery::EIconTable &&
7feec50967db 201003_02
hgs
parents:
diff changeset
   598
                        err == KSqlErrConstraint )
7feec50967db 201003_02
hgs
parents:
diff changeset
   599
                    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   600
                    // ignore, this means that the icon cannot be removed
7feec50967db 201003_02
hgs
parents:
diff changeset
   601
                    // because some other entry has the same icon.
7feec50967db 201003_02
hgs
parents:
diff changeset
   602
                    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   603
                else if( err )
7feec50967db 201003_02
hgs
parents:
diff changeset
   604
                    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   605
                    User::Leave( err );
7feec50967db 201003_02
hgs
parents:
diff changeset
   606
                    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   607
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   608
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   609
        CleanupStack::PopAndDestroy( &sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   610
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   611
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   612
7feec50967db 201003_02
hgs
parents:
diff changeset
   613
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   614
// CCASqLiteStorage::ExecuteOrganizeL(const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   615
//      TCaOperationParams aParams)
7feec50967db 201003_02
hgs
parents:
diff changeset
   616
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   617
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   618
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   619
void CCaSqLiteStorage::ExecuteOrganizeL( const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   620
        TCaOperationParams aParams )
7feec50967db 201003_02
hgs
parents:
diff changeset
   621
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   622
    VerifyOrganizeParamsL( aEntryIds, aParams );
7feec50967db 201003_02
hgs
parents:
diff changeset
   623
7feec50967db 201003_02
hgs
parents:
diff changeset
   624
    RPointerArray<CCaSqlQuery> sqlQueries;
7feec50967db 201003_02
hgs
parents:
diff changeset
   625
    CleanupResetAndDestroyPushL( sqlQueries );
7feec50967db 201003_02
hgs
parents:
diff changeset
   626
7feec50967db 201003_02
hgs
parents:
diff changeset
   627
    TBool revereseInsertOrder = CaSqlQueryCreator::CreateOrganizeQueryL(
7feec50967db 201003_02
hgs
parents:
diff changeset
   628
            aEntryIds, aParams, iSqlDb, sqlQueries );
7feec50967db 201003_02
hgs
parents:
diff changeset
   629
7feec50967db 201003_02
hgs
parents:
diff changeset
   630
    for( TInt i = 0; i < sqlQueries.Count(); i++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   631
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   632
        switch( sqlQueries[i]->Type() )
7feec50967db 201003_02
hgs
parents:
diff changeset
   633
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   634
            case CCaSqlQuery::EGroupTableRemove:
7feec50967db 201003_02
hgs
parents:
diff changeset
   635
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   636
                sqlQueries[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   637
                sqlQueries[i]->BindValuesForOrganizeL( aEntryIds, aParams );
7feec50967db 201003_02
hgs
parents:
diff changeset
   638
                sqlQueries[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   639
                sqlQueries[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   640
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   641
                break;
7feec50967db 201003_02
hgs
parents:
diff changeset
   642
7feec50967db 201003_02
hgs
parents:
diff changeset
   643
            case CCaSqlQuery::EGroupTableInsert:
7feec50967db 201003_02
hgs
parents:
diff changeset
   644
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   645
                sqlQueries[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   646
                for( TInt j = 0; j < aEntryIds.Count(); j++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   647
                    {
86
hgs
parents: 85
diff changeset
   648
                    TInt k = (revereseInsertOrder) ?
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   649
                        (aEntryIds.Count() - 1) - j : j;
86
hgs
parents: 85
diff changeset
   650
                    sqlQueries[i]->BindValuesForOrganizeL(
85
7feec50967db 201003_02
hgs
parents:
diff changeset
   651
                            aEntryIds, aParams, aEntryIds[k] );
7feec50967db 201003_02
hgs
parents:
diff changeset
   652
                    sqlQueries[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   653
                    sqlQueries[i]->ResetStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   654
                    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   655
                sqlQueries[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   656
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   657
                break;
7feec50967db 201003_02
hgs
parents:
diff changeset
   658
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   659
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   660
7feec50967db 201003_02
hgs
parents:
diff changeset
   661
    CleanupStack::PopAndDestroy( &sqlQueries );
7feec50967db 201003_02
hgs
parents:
diff changeset
   662
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   663
7feec50967db 201003_02
hgs
parents:
diff changeset
   664
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   665
// CCASqLiteStorage::ExecuteTouchL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   666
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   667
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   668
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   669
void CCaSqLiteStorage::ExecuteTouchL( const TInt aEntryId )
7feec50967db 201003_02
hgs
parents:
diff changeset
   670
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   671
    RPointerArray<CCaSqlQuery> sqlQuery;
7feec50967db 201003_02
hgs
parents:
diff changeset
   672
    CleanupResetAndDestroyPushL( sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   673
7feec50967db 201003_02
hgs
parents:
diff changeset
   674
    CaSqlQueryCreator::CreateTouchQueryL( sqlQuery, iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   675
7feec50967db 201003_02
hgs
parents:
diff changeset
   676
    TTime time;
7feec50967db 201003_02
hgs
parents:
diff changeset
   677
    time.UniversalTime();
7feec50967db 201003_02
hgs
parents:
diff changeset
   678
7feec50967db 201003_02
hgs
parents:
diff changeset
   679
    for( TInt i = 0; i < sqlQuery.Count(); i++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   680
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   681
        sqlQuery[i]->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   682
        sqlQuery[i]->BindValuesForLaunchL( aEntryId, time.Int64() );
7feec50967db 201003_02
hgs
parents:
diff changeset
   683
        sqlQuery[i]->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   684
        sqlQuery[i]->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   685
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   686
7feec50967db 201003_02
hgs
parents:
diff changeset
   687
    CleanupStack::PopAndDestroy( &sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   688
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   689
7feec50967db 201003_02
hgs
parents:
diff changeset
   690
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   691
// ExecuteDbPropertyL( const TDesC& aProperty, TDes& aPropertyValue )
7feec50967db 201003_02
hgs
parents:
diff changeset
   692
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   693
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   694
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   695
void CCaSqLiteStorage::ExecuteDbPropertyL( const TDesC& aProperty,
7feec50967db 201003_02
hgs
parents:
diff changeset
   696
        TDes& aPropertyValue )
7feec50967db 201003_02
hgs
parents:
diff changeset
   697
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   698
    CCaSqlQuery* sqlQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   699
    sqlQuery->SetQueryL( KSQLGetProperty );
7feec50967db 201003_02
hgs
parents:
diff changeset
   700
    sqlQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   701
    sqlQuery->BindValuesForPropertyL( aProperty );
7feec50967db 201003_02
hgs
parents:
diff changeset
   702
    sqlQuery->ExecutePropertyL( aPropertyValue );
7feec50967db 201003_02
hgs
parents:
diff changeset
   703
    sqlQuery->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   704
    CleanupStack::PopAndDestroy( sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   705
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   706
7feec50967db 201003_02
hgs
parents:
diff changeset
   707
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   708
// ExecuteSetDbPropertyL( const TDesC& aProperty, const TDesC& aPropertyValue )
7feec50967db 201003_02
hgs
parents:
diff changeset
   709
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   710
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   711
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   712
void CCaSqLiteStorage::ExecuteSetDbPropertyL( const TDesC& aProperty,
7feec50967db 201003_02
hgs
parents:
diff changeset
   713
        const TDesC& aPropertyValue )
7feec50967db 201003_02
hgs
parents:
diff changeset
   714
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   715
    CCaSqlQuery* sqlQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   716
    sqlQuery->SetQueryL( KSQLUpdateProperty );
7feec50967db 201003_02
hgs
parents:
diff changeset
   717
    sqlQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   718
    sqlQuery->BindValuesForPropertyUpdateL( aProperty, aPropertyValue );
7feec50967db 201003_02
hgs
parents:
diff changeset
   719
    sqlQuery->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   720
    sqlQuery->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   721
    CleanupStack::PopAndDestroy( sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   722
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   723
7feec50967db 201003_02
hgs
parents:
diff changeset
   724
7feec50967db 201003_02
hgs
parents:
diff changeset
   725
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   726
// CCASqLiteStorage::RemoveOldEntriesFromLaunchTableL( TInt aDays )
7feec50967db 201003_02
hgs
parents:
diff changeset
   727
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   728
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   729
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   730
void CCaSqLiteStorage::RemoveOldEntriesFromLaunchTableL( TInt aDays )
7feec50967db 201003_02
hgs
parents:
diff changeset
   731
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   732
    TTime presentTime;
7feec50967db 201003_02
hgs
parents:
diff changeset
   733
    presentTime.UniversalTime();
7feec50967db 201003_02
hgs
parents:
diff changeset
   734
    TTime borderTime = presentTime - ( TTimeIntervalDays( aDays ) );
7feec50967db 201003_02
hgs
parents:
diff changeset
   735
7feec50967db 201003_02
hgs
parents:
diff changeset
   736
    CCaSqlQuery* sqlQuery = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   737
    sqlQuery->SetQueryL( KSQLDeleteOldFromLaunch );
7feec50967db 201003_02
hgs
parents:
diff changeset
   738
    sqlQuery->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   739
    sqlQuery->BindValuesForLaunchL( 0, borderTime.Int64() );
7feec50967db 201003_02
hgs
parents:
diff changeset
   740
    sqlQuery->ExecuteL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   741
7feec50967db 201003_02
hgs
parents:
diff changeset
   742
    CleanupStack::PopAndDestroy( sqlQuery );
7feec50967db 201003_02
hgs
parents:
diff changeset
   743
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   744
7feec50967db 201003_02
hgs
parents:
diff changeset
   745
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   746
// CCASqLiteStorage::VerifyOrganizeParamsL( const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   747
//      TCaOperationParams aParams);
7feec50967db 201003_02
hgs
parents:
diff changeset
   748
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   749
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   750
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   751
void CCaSqLiteStorage::VerifyOrganizeParamsL( const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   752
        TCaOperationParams aParams )
7feec50967db 201003_02
hgs
parents:
diff changeset
   753
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   754
    switch( aParams.iOperationType )
7feec50967db 201003_02
hgs
parents:
diff changeset
   755
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   756
        case TCaOperationParams::ERemove:
7feec50967db 201003_02
hgs
parents:
diff changeset
   757
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   758
            CCaSqlQuery * query = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   759
            CaSqlQueryCreator::PopulateQueryWithIdListL( aEntryIds.Count(),
7feec50967db 201003_02
hgs
parents:
diff changeset
   760
                    query, KSQLOrganizeGetEntryIdCountFromGroup );
7feec50967db 201003_02
hgs
parents:
diff changeset
   761
7feec50967db 201003_02
hgs
parents:
diff changeset
   762
            query->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   763
            query->BindValuesForOrganizeL( aEntryIds, aParams );
7feec50967db 201003_02
hgs
parents:
diff changeset
   764
            TInt dbEntryCount;
7feec50967db 201003_02
hgs
parents:
diff changeset
   765
            query->ExecuteL( dbEntryCount );
7feec50967db 201003_02
hgs
parents:
diff changeset
   766
            query->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   767
            if( dbEntryCount < aEntryIds.Count() )
7feec50967db 201003_02
hgs
parents:
diff changeset
   768
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   769
                User::Leave( KErrArgument );
7feec50967db 201003_02
hgs
parents:
diff changeset
   770
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   771
7feec50967db 201003_02
hgs
parents:
diff changeset
   772
            CleanupStack::PopAndDestroy( query );
7feec50967db 201003_02
hgs
parents:
diff changeset
   773
            break;
7feec50967db 201003_02
hgs
parents:
diff changeset
   774
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   775
        case TCaOperationParams::EInsert:
7feec50967db 201003_02
hgs
parents:
diff changeset
   776
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   777
            CCaSqlQuery * query = CCaSqlQuery::NewLC( iSqlDb );
7feec50967db 201003_02
hgs
parents:
diff changeset
   778
            CaSqlQueryCreator::PopulateQueryWithIdListL( 1, query,
7feec50967db 201003_02
hgs
parents:
diff changeset
   779
                    KSQLOrganizeGetEntryIdCountFromGroup );
7feec50967db 201003_02
hgs
parents:
diff changeset
   780
            RArray<TInt> id;
7feec50967db 201003_02
hgs
parents:
diff changeset
   781
            CleanupClosePushL( id );
7feec50967db 201003_02
hgs
parents:
diff changeset
   782
            id.AppendL( aParams.iBeforeEntryId );
7feec50967db 201003_02
hgs
parents:
diff changeset
   783
7feec50967db 201003_02
hgs
parents:
diff changeset
   784
            query->PrepareL();
7feec50967db 201003_02
hgs
parents:
diff changeset
   785
            query->BindValuesForOrganizeL( id, aParams );
7feec50967db 201003_02
hgs
parents:
diff changeset
   786
            TInt dbEntryCount;
7feec50967db 201003_02
hgs
parents:
diff changeset
   787
            query->ExecuteL( dbEntryCount );
7feec50967db 201003_02
hgs
parents:
diff changeset
   788
            query->CloseStatement();
7feec50967db 201003_02
hgs
parents:
diff changeset
   789
            if( dbEntryCount == 0 )
7feec50967db 201003_02
hgs
parents:
diff changeset
   790
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   791
                User::Leave( KErrArgument );
7feec50967db 201003_02
hgs
parents:
diff changeset
   792
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   793
7feec50967db 201003_02
hgs
parents:
diff changeset
   794
            CleanupStack::PopAndDestroy( &id );
7feec50967db 201003_02
hgs
parents:
diff changeset
   795
            CleanupStack::PopAndDestroy( query );
7feec50967db 201003_02
hgs
parents:
diff changeset
   796
            break;
7feec50967db 201003_02
hgs
parents:
diff changeset
   797
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   798
        case TCaOperationParams::EPrepend:
7feec50967db 201003_02
hgs
parents:
diff changeset
   799
        case TCaOperationParams::EAppend:
7feec50967db 201003_02
hgs
parents:
diff changeset
   800
        default:
7feec50967db 201003_02
hgs
parents:
diff changeset
   801
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   802
            //            TODO: do nothing when default
7feec50967db 201003_02
hgs
parents:
diff changeset
   803
            break;
7feec50967db 201003_02
hgs
parents:
diff changeset
   804
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   805
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   806
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   807
7feec50967db 201003_02
hgs
parents:
diff changeset
   808
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   809
// CCASqLiteStorage::SetEntriesInProperOrderL
7feec50967db 201003_02
hgs
parents:
diff changeset
   810
// ---------------------------------------------------------------------------
7feec50967db 201003_02
hgs
parents:
diff changeset
   811
//
7feec50967db 201003_02
hgs
parents:
diff changeset
   812
void CCaSqLiteStorage::SetEntriesInProperOrderL(
7feec50967db 201003_02
hgs
parents:
diff changeset
   813
        const RArray<TInt>& aEntryIds,
7feec50967db 201003_02
hgs
parents:
diff changeset
   814
        RPointerArray<CCaInnerEntry>& aResultContainer )
7feec50967db 201003_02
hgs
parents:
diff changeset
   815
    {
7feec50967db 201003_02
hgs
parents:
diff changeset
   816
    for( TInt i = 0; i < aEntryIds.Count(); i++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   817
        {
7feec50967db 201003_02
hgs
parents:
diff changeset
   818
        for( TInt j = i + 1; j < aResultContainer.Count(); j++ )
7feec50967db 201003_02
hgs
parents:
diff changeset
   819
            {
7feec50967db 201003_02
hgs
parents:
diff changeset
   820
            if( aEntryIds[i] == aResultContainer[j]->GetId() )
7feec50967db 201003_02
hgs
parents:
diff changeset
   821
                {
7feec50967db 201003_02
hgs
parents:
diff changeset
   822
                CCaInnerEntry* temporary( NULL );
7feec50967db 201003_02
hgs
parents:
diff changeset
   823
                temporary = aResultContainer[i];
7feec50967db 201003_02
hgs
parents:
diff changeset
   824
                aResultContainer[i] = aResultContainer[j];
7feec50967db 201003_02
hgs
parents:
diff changeset
   825
                aResultContainer[j] = temporary;
7feec50967db 201003_02
hgs
parents:
diff changeset
   826
                break;
7feec50967db 201003_02
hgs
parents:
diff changeset
   827
                }
7feec50967db 201003_02
hgs
parents:
diff changeset
   828
            }
7feec50967db 201003_02
hgs
parents:
diff changeset
   829
        }
7feec50967db 201003_02
hgs
parents:
diff changeset
   830
    }
7feec50967db 201003_02
hgs
parents:
diff changeset
   831