--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/upnpharvester/common/dbmanager/src/cmdmsqldbmaintenance.cpp	Thu Dec 17 08:52:00 2009 +0200
@@ -0,0 +1,197 @@
+/*
+* 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
+