diff -r 6369bfd1b60d -r 08b5eae9f9ff upnpharvester/common/dbmanager/src/cmdmsqldbmaintenance.cpp --- a/upnpharvester/common/dbmanager/src/cmdmsqldbmaintenance.cpp Mon Nov 01 13:44:24 2010 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,197 +0,0 @@ -/* -* Copyright (c) 2008 Nokia Corporation and/or its subsidiary(-ies). -* All rights reserved. -* This component and the accompanying materials are made available -* under the terms of "Eclipse Public License v1.0" -* which accompanies this distribution, and is available -* at the URL "http://www.eclipse.org/legal/epl-v10.html". -* -* Initial Contributors: -* Nokia Corporation - initial contribution. -* -* Contributors: -* -* Description: SQL database maintenance class -* -*/ - - - - - - -#include "cmdmsqliteconnection.h" -#include "cmdmsqlmaintenanceclauses.h" -#include "cmdmsqldbmaintenance.h" -#include "cmdmsqlclausedef.h" -#include "msdebug.h" - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::NewL -// --------------------------------------------------------------------------- -// -CCmDmSqlDbMaintenance* CCmDmSqlDbMaintenance::NewL() - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::NewL()")); - - CCmDmSqlDbMaintenance* self = CCmDmSqlDbMaintenance::NewLC(); - CleanupStack::Pop( self ); - - return self; - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::NewLC -// --------------------------------------------------------------------------- -// -CCmDmSqlDbMaintenance* CCmDmSqlDbMaintenance::NewLC() - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::NewLC()")); - - CCmDmSqlDbMaintenance* self = new ( ELeave ) CCmDmSqlDbMaintenance(); - CleanupStack::PushL( self ); - self->ConstructL(); - - return self; - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance -// --------------------------------------------------------------------------- -// -CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance() - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance()")); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::InitConnection -// --------------------------------------------------------------------------- -// -TInt CCmDmSqlDbMaintenance::InitConnection( - CCmDmSQLiteConnection& aConnection ) - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::InitConnection()")); - return aConnection.OpenDb( KCmDatabase ); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::CloseConnection -// --------------------------------------------------------------------------- -// -void CCmDmSqlDbMaintenance::CloseConnection( - CCmDmSQLiteConnection& aConnection ) - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CloseConnection()")); - aConnection.CloseDb(); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::CreateDbFile -// --------------------------------------------------------------------------- -// -TInt CCmDmSqlDbMaintenance::CreateDbFile( - CCmDmSQLiteConnection& aConnection ) - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateDbFile()")); - return aConnection.CreateDbFile( KCmDatabase ); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::CreateDb -// --------------------------------------------------------------------------- -// -void CCmDmSqlDbMaintenance::CreateDb( - CCmDmSQLiteConnection& aConnection ) - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateDb()")); - - /// DROP tables - TRAP_IGNORE( aConnection.ExecuteL( KDropFillRuleGroup )); - TRAP_IGNORE( aConnection.ExecuteL( KDropRules )); - TRAP_IGNORE( aConnection.ExecuteL( KDropRuleParams )); - TRAP_IGNORE( aConnection.ExecuteL( KDropRuleGroupServers )); - TRAP_IGNORE( aConnection.ExecuteL( KDropMediaServers )); - TRAP_IGNORE( aConnection.ExecuteL( KDropHashValues )); - TRAP_IGNORE( aConnection.ExecuteL( KDropStored )); - TRAP_IGNORE( aConnection.ExecuteL( KDropFilled )); - TRAP_IGNORE( aConnection.ExecuteL( KDropIDs )); - TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRules )); - TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRuleParams )); - TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRuleServers )); - TRAP_IGNORE( aConnection.ExecuteL( KDropFillFiles )); - TRAP_IGNORE( aConnection.ExecuteL( KDropStoreFiles )); - TRAP_IGNORE( aConnection.ExecuteL( KDropStoreFileServers )); - TRAP_IGNORE( aConnection.ExecuteL( KDropImageShrinkingInfo )); - TRAP_IGNORE( aConnection.ExecuteL( KDropTransferInfo )); - TRAP_IGNORE( aConnection.ExecuteL( KDropSyncTime )); - TRAP_IGNORE( aConnection.ExecuteL( KDropProgressInfo )); - TRAP_IGNORE( aConnection.ExecuteL( KDropDrivesInfo )); - - // Create tables - TRAP_IGNORE( aConnection.ExecuteL( KCreateFillRuleGroup ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateRules ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateRuleParams ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateRuleGroupServers ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateMediaServers ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateHashValues ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStored ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateIDs ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRules ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRuleParams ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRuleServers ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateFillFiles ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreFiles ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreFileServers ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateImageShrinkingInfo ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateTransferInfo ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateSyncTime ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateProgressInfo ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateDrivesInfo )); - - // Init clauses - TRAP_IGNORE( aConnection.ExecuteL( KInitShrinkingTime ) ); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::CreateIndexes -// --------------------------------------------------------------------------- -// -void CCmDmSqlDbMaintenance::CreateIndexes( - CCmDmSQLiteConnection& aConnection ) - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateIndexes()")); - - // Drop indexes - TRAP_IGNORE( aConnection.ExecuteL( KDropFillListIdIndex ) ); - TRAP_IGNORE( aConnection.ExecuteL( KDropFillItemRefIndex ) ); - TRAP_IGNORE( aConnection.ExecuteL( KDropStoreStatusIndex ) ); - TRAP_IGNORE( aConnection.ExecuteL( KDropFillStatusIndex ) ); - - // Create indexes - TRAP_IGNORE( aConnection.ExecuteL( KCreateFillListIdIndex ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateFillItemRefIndex ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreStatusIndex ) ); - TRAP_IGNORE( aConnection.ExecuteL( KCreateFillStatusIndex ) ); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance -// --------------------------------------------------------------------------- -// -CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance() - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance()")); - } - -// --------------------------------------------------------------------------- -// CCmDmSqlDbMaintenance::ConstructL -// --------------------------------------------------------------------------- -// -void CCmDmSqlDbMaintenance::ConstructL() - { - LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::ConstructL()")); - } - -// End of file -