MercurialSymaptic / file revision
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | raw | help
os/persistentdata/persistentstorage/dbms/pcdbms/usql/UQ_DDL.CPP
author sl@SLION-WIN7.fritz.box
Fri, 15 Jun 2012 03:10:57 +0200
changeset 0 bde4ae8d615e
permissions -rw-r--r--
First public contribution. 
     1 // Copyright (c) 1998-2009 Nokia Corporation and/or its subsidiary(-ies).

     2 // All rights reserved.

     3 // This component and the accompanying materials are made available

     4 // under the terms of "Eclipse Public License v1.0"

     5 // which accompanies this distribution, and is available

     6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".

     7 //

     8 // Initial Contributors:

     9 // Nokia Corporation - initial contribution.

    10 //

    11 // Contributors:

    12 //

    13 // Description:

    14 // SQL DDL statements

    15 // 

    16 //

    17 

    18 #include "UQ_STD.H"

    19 #include "D32Assert.h"

    20 

    21 // Class CSqlCreateTableStatement

    22 

    23 CDbIncremental* CSqlCreateTableStatement::ExecuteL(CDbDatabase& aDatabase,TDbTextComparison,TInt& aStep)

    24 	{

    25 	aDatabase.CreateTableL(iName,iColumns,0);

    26 	aStep=0;

    27 	return 0;

    28 	}

    29 

    30 // Class CSqlDropTableStatement

    31 

    32 CDbIncremental* CSqlDropTableStatement::ExecuteL(CDbDatabase& aDatabase,TDbTextComparison,TInt& aStep)

    33 	{

    34 	return aDatabase.DropTableL(iName,aStep);

    35 	}

    36 

    37 // Class CSqlAlterTableStatement

    38 

    39 CSqlAlterTableStatement::~CSqlAlterTableStatement()

    40 	{

    41 	iDrop.Close();

    42 	}

    43 

    44 CDbIncremental* CSqlAlterTableStatement::ExecuteL(CDbDatabase& aDatabase,TDbTextComparison,TInt& aStep)

    45 	{

    46 	CDbColSet* set=CDbColSet::NewLC();

    47 	aDatabase.ColumnsL(*set,iName);

    48 	TInt todrop=iDrop.Count();

    49 	for (TDbColSetIter iter(*set);iter;++iter)

    50 		{

    51 		TInt ii=-1;

    52 		for (;;)

    53 			{

    54 			if (++ii==todrop)

    55 				{

    56 				iAdd.AddL(*iter);

    57 				break;

    58 				}

    59 			if (iter->iName.CompareF(iDrop[ii])==0)

    60 				{

    61 				iDrop.Remove(ii);

    62 				--todrop;

    63 				break;

    64 				}

    65 			}

    66 		}

    67 	if (todrop!=0)

    68 		__LEAVE(KErrNotFound);

    69 	CleanupStack::PopAndDestroy();	// set

    70 	return aDatabase.AlterTableL(iName,iAdd,aStep);

    71 	}

    72 

    73 // Class CSqlCreateIndexStatement

    74 

    75 CDbIncremental* CSqlCreateIndexStatement::ExecuteL(CDbDatabase& aDatabase,TDbTextComparison aComparison,TInt& aStep)

    76 	{

    77 	// comparison can now be set from SQL, use aComparison only if existing comparison mode is 

    78 	// EDbCompareNormal

    79 	if ( iKey.Comparison() == EDbCompareNormal && aComparison != EDbCompareNormal )

    80 		{

    81 		iKey.SetComparison(aComparison);

    82 		}

    83 	return aDatabase.CreateIndexL(iName,iTable,iKey,aStep);

    84 	}

    85 

    86 // Class CSqlDropIndexStatement

    87 

    88 CDbIncremental* CSqlDropIndexStatement::ExecuteL(CDbDatabase& aDatabase,TDbTextComparison,TInt& aStep)

    89 	{

    90 	return aDatabase.DropIndexL(iName,iTable,aStep);

    91 	}
Symaptic