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