FCL/sf/mw/dlnasrv: upnpharvester/common/cmsqlwrapper/src/cmsqldbmaintenance.cpp@0002d81e447b (annotated)

0 7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	1	/*
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	2	* Copyright (c) 2008 Nokia Corporation and/or its subsidiary(-ies).
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	3	* All rights reserved.
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	4	* This component and the accompanying materials are made available
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	5	* under the terms of "Eclipse Public License v1.0"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	6	* which accompanies this distribution, and is available
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	7	* at the URL "http://www.eclipse.org/legal/epl-v10.html".
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	8	*
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	9	* Initial Contributors:
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	10	* Nokia Corporation - initial contribution.
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	11	*
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	12	* Contributors:
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	13	*
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	14	* Description: SQL database maintenance class
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	15	*
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	16	*/
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	17
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	18
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	19
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	20
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	21
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	22
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	23	#include "cmsqldbmaintenance.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	24	#include "cmsqlconnection.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	25	#include "cmsqlmaintenanceclauses.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	26	#include "msdebug.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	27
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	28	// Constants
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	29	_LIT(KCmSqlDatabase, "C:\\System\\Data\\MediaServant\\cmmetadatacache.sq");
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	30
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	31	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	32	// CCmSqlDbMaintenance::NewL
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	33	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	34	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	35	CCmSqlDbMaintenance* CCmSqlDbMaintenance::NewL()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	36	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	37	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::NewL"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	38
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	39	CCmSqlDbMaintenance* self = CCmSqlDbMaintenance::NewLC();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	40	CleanupStack::Pop( self );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	41	return self;
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	42	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	43
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	44	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	45	// CCmSqlDbMaintenance::NewLC
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	46	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	47	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	48	CCmSqlDbMaintenance* CCmSqlDbMaintenance::NewLC()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	49	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	50	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::NewLC"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	51
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	52	CCmSqlDbMaintenance* self = new ( ELeave ) CCmSqlDbMaintenance();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	53	CleanupStack::PushL( self );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	54	self->ConstructL();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	55	return self;
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	56	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	57
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	58	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	59	// CCmSqlDbMaintenance::~CCmSqlDbMaintenance
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	60	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	61	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	62	CCmSqlDbMaintenance::~CCmSqlDbMaintenance()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	63	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	64	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::~CCmSqlDbMaintenance"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	65	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	66
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	67	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	68	// CCmSqlDbMaintenance::InitConnection
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	69	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	70	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	71	TInt CCmSqlDbMaintenance::InitConnection(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	72	CCmSqlConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	73	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	74	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::InitConnection"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	75
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	76	return aConnection.OpenDb( KCmSqlDatabase );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	77	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	78
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	79	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	80	// CCmSqlDbMaintenance::CloseConnection
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	81	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	82	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	83	void CCmSqlDbMaintenance::CloseConnection(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	84	CCmSqlConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	85	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	86	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CloseConnection"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	87
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	88	aConnection.CloseDb();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	89	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	90
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	91	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	92	// CCmSqlDbMaintenance::CreateDbFile
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	93	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	94	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	95	TInt CCmSqlDbMaintenance::CreateDbFile( CCmSqlConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	96	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	97	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CreateDbFile"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	98
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	99	return aConnection.CreateDbFile( KCmSqlDatabase );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	100	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	101
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	102	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	103	// CCmSqlDbMaintenance::CreateDb
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	104	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	105	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	106	void CCmSqlDbMaintenance::CreateDb(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	107	CCmSqlConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	108	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	109	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CreateDb"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	110	LOG(_L("[SQL wrapper]\t Dropping tables..."));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	111	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropArtists ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	112	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropGenres ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	113	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropAlbums ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	114	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropResolutions ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	115	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropUpnpProfiles ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	116	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropUpnpClasses ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	117	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropResources ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	118	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItems ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	119
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	120	LOG(_L("[SQL wrapper]\t Creating tables..."));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	121	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateArtists ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	122	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateGenres ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	123	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateAlbums ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	124	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateResolutions ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	125	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateUpnpProfiles ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	126	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateUpnpclasses ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	127	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateResources ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	128	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItems ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	129	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	130
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	131	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	132	// CCmSqlDbMaintenance::CreateIndexes
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	133	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	134	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	135	void CCmSqlDbMaintenance::CreateIndexes(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	136	CCmSqlConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	137	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	138	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CreateIndexes"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	139
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	140	LOG(_L("[SQL wrapper]\t Dropping indexes..."));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	141	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemsIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	142	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemTitleIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	143	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemArtistIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	144	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemAlbumIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	145	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemGenreIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	146	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemUpnpclassIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	147	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemResolutionIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	148	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemDateIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	149	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemHarvestDateIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	150	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemUpnpProfileIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	151	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropItemMediatypeIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	152	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropAlbumIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	153	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropArtistIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	154	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlDropGenreIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	155
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	156	LOG(_L("[SQL wrapper]\t Creating indexes..."));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	157	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemsIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	158	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemTitleIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	159	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemArtistIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	160	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemAlbumIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	161	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemGenreIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	162	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemUpnpclassIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	163	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemResolutionIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	164	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemDateIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	165	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemHarvestDateIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	166	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemUpnpProfileIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	167	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateItemMediatypeIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	168	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateAlbumIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	169	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateArtistIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	170	TRAP_IGNORE( aConnection.ExecuteL( KCmSqlCreateGenreIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	171	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	172
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	173	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	174	// CCmSqlDbMaintenance::CCmSqlDbMaintenance
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	175	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	176	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	177	CCmSqlDbMaintenance::CCmSqlDbMaintenance()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	178	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	179	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::CCmSqlDbMaintenance"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	180	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	181
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	182	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	183	// CCmSqlDbMaintenance::ConstructL
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	184	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	185	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	186	void CCmSqlDbMaintenance::ConstructL()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	187	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	188	LOG(_L("[SQL Wrapper]\t CCmSqlDbMaintenance::ConstructL"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	189	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	190
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	191	// End of file
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	192

author	Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
	Fri, 16 Apr 2010 15:14:26 +0300
changeset 13	0002d81e447b
parent 0	7f85d04be362
permissions	-rw-r--r--