upnpharvester/common/dbmanager/src/cmdmsqldbmaintenance.cpp
branchIOP_Improvements
changeset 40 08b5eae9f9ff
parent 39 6369bfd1b60d
child 41 b4d83ea1d6e2
--- 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
-