--- a/upnpharvester/common/cmsqlwrapper/src/cmsqldbmaintenance.cpp	Mon Nov 01 13:44:24 2010 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,192 +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 "cmsqldbmaintenance.h"
-#include "cmsqlconnection.h"
-#include "cmsqlmaintenanceclauses.h"
-#include "msdebug.h" 
-
-// Constants
-_LIT(KCmSqlDatabase, "C:\\System\\Data\\MediaServant\\cmmetadatacache.sq");
-
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::NewL
-// ---------------------------------------------------------------------------
-//
-CCmSqlDbMaintenance* CCmSqlDbMaintenance::NewL()
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::NewL"));
-        
-    CCmSqlDbMaintenance* self = CCmSqlDbMaintenance::NewLC();
-    CleanupStack::Pop( self );
-    return self;
-    }
- 
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::NewLC
-// ---------------------------------------------------------------------------
-//    
-CCmSqlDbMaintenance* CCmSqlDbMaintenance::NewLC()
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::NewLC"));   
-    
-    CCmSqlDbMaintenance* self = new ( ELeave ) CCmSqlDbMaintenance();
-    CleanupStack::PushL( self );
-    self->ConstructL();
-    return self;  
-    }    
-
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::~CCmSqlDbMaintenance
-// ---------------------------------------------------------------------------
-//
-CCmSqlDbMaintenance::~CCmSqlDbMaintenance()
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::~CCmSqlDbMaintenance"));   
-    }
-    
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::InitConnection
-// ---------------------------------------------------------------------------
-//
-TInt CCmSqlDbMaintenance::InitConnection(
-    CCmSqlConnection& aConnection )
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::InitConnection"));   
-    
-    return aConnection.OpenDb( KCmSqlDatabase );   
-    }    
-
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::CloseConnection
-// ---------------------------------------------------------------------------
-//
-void CCmSqlDbMaintenance::CloseConnection(
-    CCmSqlConnection& aConnection )
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CloseConnection"));   
-    
-    aConnection.CloseDb();        
-    }
-
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::CreateDbFile
-// ---------------------------------------------------------------------------
-//
-TInt CCmSqlDbMaintenance::CreateDbFile( CCmSqlConnection& aConnection )
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CreateDbFile"));   
-    
-    return aConnection.CreateDbFile( KCmSqlDatabase );
-    }
-    
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::CreateDb
-// ---------------------------------------------------------------------------
-//
-void CCmSqlDbMaintenance::CreateDb( 
-    CCmSqlConnection& aConnection )
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CreateDb"));
-    LOG(_L("[SQL wrapper]\t Dropping tables..."));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropArtists ));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropGenres ));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropAlbums ));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropResolutions ));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropUpnpProfiles ));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropUpnpClasses ));  
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropResources ));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItems ));
-           
-    LOG(_L("[SQL wrapper]\t Creating tables..."));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateArtists ) );    
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateGenres ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateAlbums ) );      
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateResolutions ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateUpnpProfiles ) ); 
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateUpnpclasses ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateResources ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItems ) );     
-    }
-
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::CreateIndexes
-// ---------------------------------------------------------------------------
-//
-void CCmSqlDbMaintenance::CreateIndexes( 
-    CCmSqlConnection& aConnection )
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CreateIndexes"));
-    
-    LOG(_L("[SQL wrapper]\t Dropping indexes..."));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemsIdIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemTitleIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemArtistIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemAlbumIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemGenreIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemUpnpclassIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemResolutionIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemDateIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemHarvestDateIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemUpnpProfileIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemMediatypeIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropAlbumIdIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropArtistIdIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropGenreIdIndex ) );
-    
-    LOG(_L("[SQL wrapper]\t Creating indexes..."));
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemsIdIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemTitleIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemArtistIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemAlbumIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemGenreIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemUpnpclassIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemResolutionIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemDateIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemHarvestDateIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemUpnpProfileIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemMediatypeIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateAlbumIdIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateArtistIdIndex ) );
-    TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateGenreIdIndex ) );
-    }
-                
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::CCmSqlDbMaintenance
-// ---------------------------------------------------------------------------
-//    
-CCmSqlDbMaintenance::CCmSqlDbMaintenance()
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CCmSqlDbMaintenance"));
-    }
- 
-// ---------------------------------------------------------------------------
-// CCmSqlDbMaintenance::ConstructL
-// ---------------------------------------------------------------------------
-//   
-void CCmSqlDbMaintenance::ConstructL()
-    {
-    LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::ConstructL"));
-    }    
-
-// End of file
-