FCL/sf/mw/dlnasrv: upnpharvester/common/dbmanager/src/cmdmsqldbmaintenance.cpp@6bd7e2973eb9 (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 "cmdmsqliteconnection.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	24	#include "cmdmsqlmaintenanceclauses.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	25	#include "cmdmsqldbmaintenance.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	26	#include "cmdmsqlclausedef.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	27	#include "msdebug.h"
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	28
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	29	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	30	// CCmDmSqlDbMaintenance::NewL
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	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	33	CCmDmSqlDbMaintenance* CCmDmSqlDbMaintenance::NewL()
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	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::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	CCmDmSqlDbMaintenance* self = CCmDmSqlDbMaintenance::NewLC();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	38	CleanupStack::Pop( self );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	39
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	40	return self;
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	41	}
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	// CCmDmSqlDbMaintenance::NewLC
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	45	// ---------------------------------------------------------------------------
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	CCmDmSqlDbMaintenance* CCmDmSqlDbMaintenance::NewLC()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	48	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	49	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::NewLC()"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	50
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	51	CCmDmSqlDbMaintenance* self = new ( ELeave ) CCmDmSqlDbMaintenance();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	52	CleanupStack::PushL( self );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	53	self->ConstructL();
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	54
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	// CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance
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	CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance()
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( "[DB MNGR]\t CCmDmSqlDbMaintenance::~CCmDmSqlDbMaintenance()"));
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	// CCmDmSqlDbMaintenance::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 CCmDmSqlDbMaintenance::InitConnection(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	72	CCmDmSQLiteConnection& 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( "[DB MNGR]\t CCmDmSqlDbMaintenance::InitConnection()"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	75	return aConnection.OpenDb( KCmDatabase );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	76	}
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	// CCmDmSqlDbMaintenance::CloseConnection
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	80	// ---------------------------------------------------------------------------
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	void CCmDmSqlDbMaintenance::CloseConnection(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	83	CCmDmSQLiteConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	84	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	85	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CloseConnection()"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	86	aConnection.CloseDb();
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
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	// CCmDmSqlDbMaintenance::CreateDbFile
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	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	93	TInt CCmDmSqlDbMaintenance::CreateDbFile(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	94	CCmDmSQLiteConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	95	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	96	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateDbFile()"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	97	return aConnection.CreateDbFile( KCmDatabase );
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
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	// CCmDmSqlDbMaintenance::CreateDb
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	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	104	void CCmDmSqlDbMaintenance::CreateDb(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	105	CCmDmSQLiteConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	106	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	107	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateDb()"));
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	/// DROP tables
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	110	TRAP_IGNORE( aConnection.ExecuteL( KDropFillRuleGroup ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	111	TRAP_IGNORE( aConnection.ExecuteL( KDropRules ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	112	TRAP_IGNORE( aConnection.ExecuteL( KDropRuleParams ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	113	TRAP_IGNORE( aConnection.ExecuteL( KDropRuleGroupServers ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	114	TRAP_IGNORE( aConnection.ExecuteL( KDropMediaServers ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	115	TRAP_IGNORE( aConnection.ExecuteL( KDropHashValues ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	116	TRAP_IGNORE( aConnection.ExecuteL( KDropStored ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	117	TRAP_IGNORE( aConnection.ExecuteL( KDropFilled ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	118	TRAP_IGNORE( aConnection.ExecuteL( KDropIDs ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	119	TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRules ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	120	TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRuleParams ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	121	TRAP_IGNORE( aConnection.ExecuteL( KDropStoreRuleServers ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	122	TRAP_IGNORE( aConnection.ExecuteL( KDropFillFiles ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	123	TRAP_IGNORE( aConnection.ExecuteL( KDropStoreFiles ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	124	TRAP_IGNORE( aConnection.ExecuteL( KDropStoreFileServers ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	125	TRAP_IGNORE( aConnection.ExecuteL( KDropImageShrinkingInfo ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	126	TRAP_IGNORE( aConnection.ExecuteL( KDropTransferInfo ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	127	TRAP_IGNORE( aConnection.ExecuteL( KDropSyncTime ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	128	TRAP_IGNORE( aConnection.ExecuteL( KDropProgressInfo ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	129	TRAP_IGNORE( aConnection.ExecuteL( KDropDrivesInfo ));
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	// Create tables
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	132	TRAP_IGNORE( aConnection.ExecuteL( KCreateFillRuleGroup ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	133	TRAP_IGNORE( aConnection.ExecuteL( KCreateRules ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	134	TRAP_IGNORE( aConnection.ExecuteL( KCreateRuleParams ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	135	TRAP_IGNORE( aConnection.ExecuteL( KCreateRuleGroupServers ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	136	TRAP_IGNORE( aConnection.ExecuteL( KCreateMediaServers ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	137	TRAP_IGNORE( aConnection.ExecuteL( KCreateHashValues ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	138	TRAP_IGNORE( aConnection.ExecuteL( KCreateStored ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	139	TRAP_IGNORE( aConnection.ExecuteL( KCreateIDs ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	140	TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRules ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	141	TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRuleParams ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	142	TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreRuleServers ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	143	TRAP_IGNORE( aConnection.ExecuteL( KCreateFillFiles ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	144	TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreFiles ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	145	TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreFileServers ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	146	TRAP_IGNORE( aConnection.ExecuteL( KCreateImageShrinkingInfo ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	147	TRAP_IGNORE( aConnection.ExecuteL( KCreateTransferInfo ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	148	TRAP_IGNORE( aConnection.ExecuteL( KCreateSyncTime ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	149	TRAP_IGNORE( aConnection.ExecuteL( KCreateProgressInfo ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	150	TRAP_IGNORE( aConnection.ExecuteL( KCreateDrivesInfo ));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	151
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	152	// Init clauses
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	153	TRAP_IGNORE( aConnection.ExecuteL( KInitShrinkingTime ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	154	}
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	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	157	// CCmDmSqlDbMaintenance::CreateIndexes
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	158	// ---------------------------------------------------------------------------
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	159	//
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	160	void CCmDmSqlDbMaintenance::CreateIndexes(
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	161	CCmDmSQLiteConnection& aConnection )
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	162	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	163	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CreateIndexes()"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	164
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	165	// Drop indexes
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	166	TRAP_IGNORE( aConnection.ExecuteL( KDropFillListIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	167	TRAP_IGNORE( aConnection.ExecuteL( KDropFillItemRefIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	168	TRAP_IGNORE( aConnection.ExecuteL( KDropStoreStatusIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	169	TRAP_IGNORE( aConnection.ExecuteL( KDropFillStatusIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	170
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	171	// Create indexes
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	172	TRAP_IGNORE( aConnection.ExecuteL( KCreateFillListIdIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	173	TRAP_IGNORE( aConnection.ExecuteL( KCreateFillItemRefIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	174	TRAP_IGNORE( aConnection.ExecuteL( KCreateStoreStatusIndex ) );
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	175	TRAP_IGNORE( aConnection.ExecuteL( KCreateFillStatusIndex ) );
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
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	// CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance
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	CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	183	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	184	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::CCmDmSqlDbMaintenance()"));
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
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	// CCmDmSqlDbMaintenance::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	void CCmDmSqlDbMaintenance::ConstructL()
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	192	{
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	193	LOG( _L( "[DB MNGR]\t CCmDmSqlDbMaintenance::ConstructL()"));
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	194	}
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	195
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	196	// End of file
7f85d04be362 Revision: 200947 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	197

author	hgs
	Thu, 15 Apr 2010 15:32:09 +0300
changeset 20	6bd7e2973eb9
parent 0	7f85d04be362
permissions	-rw-r--r--