--- 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
-