1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/usql/UQ_PARSE.CPP Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,807 @@
1.4 +// Copyright (c) 1998-2009 Nokia Corporation and/or its subsidiary(-ies).
1.5 +// All rights reserved.
1.6 +// This component and the accompanying materials are made available
1.7 +// under the terms of "Eclipse Public License v1.0"
1.8 +// which accompanies this distribution, and is available
1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
1.10 +//
1.11 +// Initial Contributors:
1.12 +// Nokia Corporation - initial contribution.
1.13 +//
1.14 +// Contributors:
1.15 +//
1.16 +// Description:
1.17 +// SQL parser
1.18 +//
1.19 +//
1.20 +
1.21 +#include "UQ_STD.H"
1.22 +
1.23 +// class TSqlParser
1.24 +
1.25 +const TInt KSqlError = -1;
1.26 +
1.27 +TSqlParser::TSqlParser(const TDesC& aSql)
1.28 + : iSql(aSql)
1.29 + {
1.30 + NextToken(); // parse the first token
1.31 + }
1.32 +
1.33 +TSqlTokenType TSqlParser::NextToken()
1.34 + {
1.35 + return iSql.NextToken(iToken);
1.36 + }
1.37 +
1.38 +CSqlSearchCondition* TSqlParser::SqlError()
1.39 + {
1.40 + if (!Error())
1.41 + iToken.SetError(KErrArgument);
1.42 + return 0;
1.43 + }
1.44 +
1.45 +TSqlTokenType TSqlParser::SqlErrorL()
1.46 +//
1.47 +// Report a SQL syntax error
1.48 +//
1.49 + {
1.50 + return TSqlTokenType(__LEAVE_IF_ERROR(KErrArgument));
1.51 + }
1.52 +
1.53 +TSqlTokenType TSqlParser::Parse(TSqlKeyword aKeyword)
1.54 +//
1.55 +// look for requested keyword, skip to the next token if found
1.56 +// return the next token if found, else ESqlNoToken (==0)
1.57 +//
1.58 + {
1.59 + return TSqlLexer::IsKeyword(aKeyword,iToken) ? NextToken() : ESqlNoToken;
1.60 + }
1.61 +
1.62 +TSqlTokenType TSqlParser::ParseL(TSqlTokenType aToken)
1.63 +//
1.64 +// parse the desired token
1.65 +//
1.66 + {
1.67 + return iToken!=aToken ? SqlErrorL() : NextToken();
1.68 + }
1.69 +
1.70 +TSqlTokenType TSqlParser::ParseL(TSqlKeyword aKeyword)
1.71 +//
1.72 +// parse the desired keyword
1.73 +//
1.74 + {
1.75 + TSqlTokenType t=Parse(aKeyword);
1.76 + return t==ESqlNoToken ? SqlErrorL() : t;
1.77 + }
1.78 +
1.79 +TSqlKeyword TSqlParser::Keyword()
1.80 +//
1.81 +// parse a keyword
1.82 +//
1.83 + {
1.84 + TSqlKeyword k=TSqlLexer::Keyword(iToken);
1.85 + if (k!=ESqlNotKeyword)
1.86 + NextToken();
1.87 + return k;
1.88 + }
1.89 +
1.90 +TSqlTokenType TSqlParser::RightBracketL()
1.91 +//
1.92 +// parse a right bracket, and fail if not found
1.93 +//
1.94 + {
1.95 + return ParseL(ESqlRightBracket);
1.96 + }
1.97 +
1.98 +void TSqlParser::EndL()
1.99 +//
1.100 +// Check that the SQL has been fully parsed
1.101 +//
1.102 + {
1.103 + if (iToken!=ESqlEos)
1.104 + SqlErrorL();
1.105 + }
1.106 +
1.107 +TSqlTokenType TSqlParser::IdentifierL(TPtrC& aIdentifier)
1.108 +//
1.109 +// parse an identifer, fail if not found
1.110 +//
1.111 + {
1.112 + if (iToken!=ESqlIdentifier)
1.113 + return SqlErrorL();
1.114 + const TText* p=iToken.Literal().Ptr();
1.115 + TInt len=iToken.Literal().End()-p;
1.116 + aIdentifier.Set(p,len);
1.117 + return NextToken();
1.118 + }
1.119 +
1.120 +TPtrC TSqlParser::IdentifierL()
1.121 +//
1.122 +// parse an identifer, fail if not found
1.123 +//
1.124 + {
1.125 + if (iToken!=ESqlIdentifier)
1.126 + SqlErrorL();
1.127 + return iToken.Literal().DesC();
1.128 + }
1.129 +
1.130 +TSqlTokenType TSqlParser::ColumnNameL(RSqlColumnList& aList)
1.131 +//
1.132 +// Parse a column-identifier
1.133 +//
1.134 + {
1.135 + __LEAVE_IF_ERROR(aList.Append(IdentifierL()));
1.136 + return NextToken();
1.137 + }
1.138 +
1.139 +TSqlTokenType TSqlParser::ColumnListL(RSqlColumnList& aList)
1.140 +//
1.141 +// Parse a column-identifier-comma-list
1.142 +//
1.143 + {
1.144 + for (;;)
1.145 + {
1.146 + TSqlTokenType t=ColumnNameL(aList);
1.147 + if (t!=ESqlComma)
1.148 + return t;
1.149 + NextToken();
1.150 + }
1.151 + }
1.152 +
1.153 +TSqlTokenType TSqlParser::AddColumnSpecL(TDbCol& aDef)
1.154 +//
1.155 +// Parse an add-column-spec
1.156 +//
1.157 + {
1.158 + aDef.iAttributes=0;
1.159 + aDef.iName=IdentifierL();
1.160 + NextToken();
1.161 +//
1.162 + TDbColType type;
1.163 + switch (Keyword())
1.164 + {
1.165 + case ESqlKeyword_bit:
1.166 + type=EDbColBit;
1.167 + break;
1.168 + case ESqlKeyword_tinyint:
1.169 + type=EDbColInt8;
1.170 + break;
1.171 + case ESqlKeyword_smallint:
1.172 + type=EDbColInt16;
1.173 + break;
1.174 + case ESqlKeyword_integer:
1.175 + type=EDbColInt32;
1.176 + break;
1.177 + case ESqlKeyword_counter:
1.178 + aDef.iAttributes=aDef.EAutoIncrement;
1.179 + type=EDbColUint32;
1.180 + break;
1.181 + case ESqlKeyword_bigint:
1.182 + type=EDbColInt64;
1.183 + break;
1.184 + case ESqlKeyword_real:
1.185 + type=EDbColReal32;
1.186 + break;
1.187 + case ESqlKeyword_double:
1.188 + //Return value is intentionaly not checked. Parse() checks for
1.189 + //an optional SQL keyword and calls internal checks.
1.190 + //coverity[check_return]
1.191 + //coverity[unchecked_value]
1.192 + Parse(ESqlKeyword_precision);
1.193 + // fall through
1.194 + case ESqlKeyword_float:
1.195 + type=EDbColReal64;
1.196 + break;
1.197 + case ESqlKeyword_date:
1.198 + case ESqlKeyword_time:
1.199 + case ESqlKeyword_timestamp:
1.200 + type=EDbColDateTime;
1.201 + break;
1.202 + case ESqlKeyword_char:
1.203 + case ESqlKeyword_varchar:
1.204 + type=EDbColText;
1.205 + break;
1.206 + case ESqlKeyword_binary:
1.207 + case ESqlKeyword_varbinary:
1.208 + type=EDbColBinary;
1.209 + break;
1.210 + case ESqlKeyword_unsigned: // unsigned tinyint, smallint or integer
1.211 + switch (Keyword())
1.212 + {
1.213 + case ESqlKeyword_tinyint:
1.214 + type=EDbColUint8;
1.215 + break;
1.216 + case ESqlKeyword_smallint:
1.217 + type=EDbColUint16;
1.218 + break;
1.219 + case ESqlKeyword_integer:
1.220 + type=EDbColUint32;
1.221 + break;
1.222 + default:
1.223 + return SqlErrorL();
1.224 + };
1.225 + break;
1.226 + case ESqlKeyword_long: // varchar or varbinary
1.227 + switch (Keyword())
1.228 + {
1.229 + case ESqlKeyword_varchar:
1.230 + type=EDbColLongText;
1.231 + break;
1.232 + case ESqlKeyword_varbinary:
1.233 + type=EDbColLongBinary;
1.234 + break;
1.235 + default:
1.236 + return SqlErrorL();
1.237 + };
1.238 + break;
1.239 + default:
1.240 + return SqlErrorL();
1.241 + }
1.242 + aDef.iType=type;
1.243 +//
1.244 +// get any optional length
1.245 + aDef.iMaxLength=KDbUndefinedLength;
1.246 + TSqlTokenType t=iToken.Type();
1.247 + switch (type)
1.248 + {
1.249 + case EDbColText:
1.250 + case EDbColBinary:
1.251 + if (t==ESqlLeftBracket)
1.252 + {
1.253 + if (NextToken()==ESqlLiteralInt)
1.254 + {
1.255 + iToken.Literal().ToInt32L();
1.256 + aDef.iMaxLength=iToken.Literal().Int32();
1.257 + NextToken();
1.258 + t=RightBracketL();
1.259 + }
1.260 + else
1.261 + return SqlErrorL();
1.262 + }
1.263 + break;
1.264 + default:
1.265 + break;
1.266 + }
1.267 + return t;
1.268 + }
1.269 +
1.270 +CSqlSearchCondition* TSqlParser::SearchCondition(TInt aNot)
1.271 +//
1.272 +// Parse a search-condition
1.273 +//
1.274 + {
1.275 + CSqlSearchCondition* left=BooleanTerm(aNot);
1.276 + if (left==0 || Parse(ESqlKeyword_or)==ESqlNoToken)
1.277 + return left;
1.278 + return CSqlMultiNode::New(aNot ? CSqlMultiNode::EAnd : CSqlMultiNode::EOr,left,SearchCondition(aNot));
1.279 + }
1.280 +
1.281 +CSqlSearchCondition* TSqlParser::BooleanTerm(TInt aNot)
1.282 +//
1.283 +// Parse a boolean-term
1.284 +//
1.285 + {
1.286 + CSqlSearchCondition* left=BooleanFactor(aNot);
1.287 + if (left==0 || Parse(ESqlKeyword_and)==ESqlNoToken)
1.288 + return left;
1.289 + return CSqlMultiNode::New(aNot ? CSqlMultiNode::EOr : CSqlMultiNode::EAnd,left,BooleanTerm(aNot));
1.290 + }
1.291 +
1.292 +CSqlSearchCondition* TSqlParser::BooleanFactor(TInt aNot)
1.293 +//
1.294 +// Parse a boolean-factor
1.295 +//
1.296 + {
1.297 + while (Parse(ESqlKeyword_not))
1.298 + aNot=~aNot;
1.299 + return BooleanPrimary(aNot);
1.300 + }
1.301 +
1.302 +CSqlSearchCondition* TSqlParser::BooleanPrimary(TInt aNot)
1.303 +//
1.304 +// Parse a boolean-factor
1.305 +//
1.306 + {
1.307 + // brackets only allowed in this element, so this ordering is valid
1.308 + if (iToken!=ESqlLeftBracket)
1.309 + return Predicate(aNot);
1.310 + // bracketed search condition
1.311 + NextToken();
1.312 + CSqlSearchCondition* node=SearchCondition(aNot);
1.313 + if (!node)
1.314 + return node;
1.315 + if (iToken==ESqlRightBracket)
1.316 + {
1.317 + NextToken();
1.318 + return node;
1.319 + }
1.320 + delete node;
1.321 + return SqlError();
1.322 + }
1.323 +
1.324 +CSqlSearchCondition* TSqlParser::Predicate(TInt aNot)
1.325 +//
1.326 +// Parse predicate
1.327 +// On null return, error will already be set
1.328 +//
1.329 + {
1.330 + if (iToken!=ESqlIdentifier) // column name
1.331 + return SqlError();
1.332 + TPtrC column(iToken.Literal().DesC());
1.333 + TSqlTokenType t=NextToken();
1.334 + if (t==ESqlIdentifier)
1.335 + { // like-predicate or null-predicate
1.336 + switch (Keyword())
1.337 + {
1.338 + case ESqlKeyword_is: // IS [NOT] NULL
1.339 + if (Parse(ESqlKeyword_not))
1.340 + aNot=~aNot;
1.341 + if (Parse(ESqlKeyword_null)==ESqlNoToken)
1.342 + return SqlError();
1.343 + return new CSqlNullPredicate(aNot ? CSqlNullPredicate::EIsNotNull : CSqlNullPredicate::EIsNull,column);
1.344 + case ESqlKeyword_not: // NOT LIKE
1.345 + if (Parse(ESqlKeyword_like)==ESqlNoToken)
1.346 + return SqlError();
1.347 + aNot=~aNot;
1.348 + // drop through to Like
1.349 + case ESqlKeyword_like: // LIKE
1.350 + {
1.351 + if (iToken!=ESqlLiteralText)
1.352 + return SqlError();
1.353 +
1.354 + //Following code is for the implementation of limited-ESCAPE-clause
1.355 + const TText *next = iSql.Next(); //remember thecurrent position in the SQL statement
1.356 + RSqlLiteral pattern = iToken.Literal(); //this is the LIKE pattern, remember it, because the next keyword might be ESCAPE
1.357 +
1.358 + NextToken(); // Searching for ESCAPE keyword
1.359 +
1.360 + if (Keyword() == ESqlKeyword_escape)
1.361 + {
1.362 + if (pattern.DesC().Length() <= 0 || pattern.DesC().Length() > (KMaxSegmentLength + 2 ))
1.363 + return SqlError();
1.364 + TPtrC escapeChar(iToken.Literal().DesC());
1.365 + if (escapeChar.Length() <= 0)
1.366 + return SqlError();
1.367 + TChar escchar = escapeChar[0];
1.368 + TText newPattern[KMaxSegmentLength + 2]; // '*' can come as first and last char
1.369 + TInt count = PatternFilter(pattern.DesC(),escchar, newPattern);//remove the escape characters from the pattern and store it in "newPattern" variable
1.370 + if (count <=0 )
1.371 + return SqlError();
1.372 + iToken.Literal().SetText(newPattern,(newPattern + count));
1.373 + // copy the text to RSqlLiteral as "newPattern" is stack based variable and will go out of scope
1.374 + if (iToken.Literal().CopyText() != KErrNone)
1.375 + {
1.376 + return SqlError();
1.377 + }
1.378 + CSqlSearchCondition* node = new CSqlLikePredicate(aNot ? CSqlLikePredicate::ENotLike : CSqlLikePredicate::ELike,column,iToken.Literal());
1.379 + //cleanup iToken.Literal(), because if there is another LIKE predicate, the allocated by CopyText() buffer will
1.380 + //be shared between two RSqlLiteral instances and RSqlLiteral::Close() call will crash.
1.381 + //RSqlLiteral::RSqlLiteral() will set the "iBuffer" data member to NULL.
1.382 + iToken.Literal() = RSqlLiteral();
1.383 + if (node)
1.384 + {
1.385 + NextToken();
1.386 + node->iIsEscape = ETrue;
1.387 + }
1.388 + return node;
1.389 + }
1.390 + else
1.391 + {
1.392 + //Set to the previous node
1.393 + iSql.Set(next);
1.394 + CSqlSearchCondition* node = new CSqlLikePredicate(aNot ? CSqlLikePredicate::ENotLike : CSqlLikePredicate::ELike,column,pattern);
1.395 + if(node)
1.396 + NextToken();
1.397 + return node;
1.398 +
1.399 + }
1.400 + }
1.401 + default:
1.402 + return SqlError();
1.403 + }
1.404 + }
1.405 + // Comparison predicate...
1.406 + CSqlSearchCondition::TType op;
1.407 + switch (t)
1.408 + {
1.409 + case ESqlGreaterEqual:
1.410 + aNot=~aNot;
1.411 + // drop through to less
1.412 + case ESqlLess:
1.413 + op=aNot ? CSqlSearchCondition::EGreaterEqual : CSqlSearchCondition::ELess;
1.414 + break;
1.415 + case ESqlGreater:
1.416 + aNot=~aNot;
1.417 + // drop through to less equal
1.418 + case ESqlLessEqual:
1.419 + op=aNot ? CSqlSearchCondition::EGreater: CSqlSearchCondition::ELessEqual;
1.420 + break;
1.421 + case ESqlNotEqual:
1.422 + aNot=~aNot;
1.423 + // drop through to equal
1.424 + case ESqlEqual:
1.425 + op=aNot ? CSqlSearchCondition::ENotEqual : CSqlSearchCondition::EEqual;
1.426 + break;
1.427 + default:
1.428 + return SqlError();
1.429 + }
1.430 + t=NextToken();
1.431 + if (t!=ESqlLiteralInt && t!=ESqlLiteralReal && t!=ESqlLiteralTime && t!=ESqlLiteralText)
1.432 + return SqlError();
1.433 + CSqlSearchCondition* node=new CSqlCompPredicate(op,column,iToken.Literal());
1.434 + if (node)
1.435 + NextToken();
1.436 + return node;
1.437 + }
1.438 +
1.439 +CSqlSearchCondition* TSqlParser::SearchConditionL()
1.440 +//
1.441 +// Parse a search-condition
1.442 +//
1.443 + {
1.444 + CSqlSearchCondition* sc=SearchCondition(0);
1.445 + if (!sc)
1.446 + {
1.447 + __LEAVE_IF_ERROR(Error()); // syntax error
1.448 + User::LeaveNoMemory(); // otherwise a OOM error
1.449 + }
1.450 + return sc;
1.451 + }
1.452 +
1.453 +void TSqlParser::SortSpecificationL(CDbKey& aKey)
1.454 +//
1.455 +// Parse a sort-specification
1.456 +//
1.457 + {
1.458 + for (;;)
1.459 + {
1.460 + TDbKeyCol col(IdentifierL());
1.461 + NextToken();
1.462 + if (Parse(ESqlKeyword_desc))
1.463 + col.iOrder=col.EDesc;
1.464 + else
1.465 + {
1.466 + //Return value is intentionaly not checked. Parse() checks for
1.467 + //an optional SQL keyword and calls internal checks.
1.468 + //coverity[check_return]
1.469 + //coverity[unchecked_value]
1.470 + Parse(ESqlKeyword_asc);
1.471 + col.iOrder=col.EAsc;
1.472 + }
1.473 + aKey.AddL(col);
1.474 + if (iToken!=ESqlComma)
1.475 + break;
1.476 + NextToken();
1.477 + }
1.478 + }
1.479 +
1.480 +CSqlQuery* TSqlParser::QueryLC()
1.481 +//
1.482 +// Generate a CSqlQuery
1.483 +//
1.484 + {
1.485 + CSqlQuery* query=new(ELeave) CSqlQuery;
1.486 + CleanupStack::PushL(query);
1.487 + if (ParseL(ESqlKeyword_select)==ESqlAsterisk)
1.488 + NextToken();
1.489 + else
1.490 + ColumnListL(query->iColumns);
1.491 + ParseL(ESqlKeyword_from);
1.492 + IdentifierL(query->iTable);
1.493 + if (Parse(ESqlKeyword_where))
1.494 + query->iSearchCondition=SearchConditionL();
1.495 + if (Parse(ESqlKeyword_order))
1.496 + {
1.497 + ParseL(ESqlKeyword_by);
1.498 + SortSpecificationL(query->SortSpecificationL());
1.499 + }
1.500 + EndL();
1.501 + return query;
1.502 + }
1.503 +
1.504 +CSqlSearchCondition* TSqlParser::SearchConditionLC()
1.505 +//
1.506 +// Parse a standalone search-condition
1.507 +//
1.508 + {
1.509 + CSqlSearchCondition* sc=SearchConditionL();
1.510 + CleanupStack::PushL(sc);
1.511 + EndL();
1.512 + return sc;
1.513 + }
1.514 +
1.515 +CSqlDDLStatement* TSqlParser::CreateTableLC()
1.516 +//
1.517 +// Parse a CREATE TABLE statement
1.518 +//
1.519 + {
1.520 + CSqlCreateTableStatement* statement=new(ELeave) CSqlCreateTableStatement;
1.521 + CleanupStack::PushL(statement);
1.522 + IdentifierL(statement->iName);
1.523 + ParseL(ESqlLeftBracket);
1.524 + TDbCol def;
1.525 + for (;;)
1.526 + {
1.527 + AddColumnSpecL(def);
1.528 + if (Parse(ESqlKeyword_not))
1.529 + {
1.530 + ParseL(ESqlKeyword_null);
1.531 + def.iAttributes|=TDbCol::ENotNull;
1.532 + }
1.533 + statement->iColumns.AddL(def);
1.534 + if (iToken!=ESqlComma)
1.535 + break;
1.536 + NextToken();
1.537 + }
1.538 + RightBracketL();
1.539 + return statement;
1.540 + }
1.541 +
1.542 +CSqlDDLStatement* TSqlParser::DropTableLC()
1.543 +//
1.544 +// Parse a DROP TABLE statement
1.545 +//
1.546 + {
1.547 + CSqlDropTableStatement* statement=new(ELeave) CSqlDropTableStatement;
1.548 + CleanupStack::PushL(statement);
1.549 + IdentifierL(statement->iName);
1.550 + return statement;
1.551 + }
1.552 +
1.553 +CSqlDDLStatement* TSqlParser::AlterTableLC()
1.554 +//
1.555 +// Parse a CREATE TABLE statement
1.556 +//
1.557 + {
1.558 + CSqlAlterTableStatement* statement=new(ELeave) CSqlAlterTableStatement;
1.559 + CleanupStack::PushL(statement);
1.560 + IdentifierL(statement->iName);
1.561 + TSqlTokenType t=Parse(ESqlKeyword_add);
1.562 + if (t!=ESqlNoToken)
1.563 + {
1.564 + TDbCol def;
1.565 + if (t==ESqlLeftBracket)
1.566 + {
1.567 + NextToken();
1.568 + for (;;)
1.569 + {
1.570 + t=AddColumnSpecL(def);
1.571 + statement->iAdd.AddL(def);
1.572 + if (t!=ESqlComma)
1.573 + break;
1.574 + NextToken();
1.575 + }
1.576 + RightBracketL();
1.577 + }
1.578 + else
1.579 + {
1.580 + AddColumnSpecL(def);
1.581 + statement->iAdd.AddL(def);
1.582 + }
1.583 + }
1.584 + t=Parse(ESqlKeyword_drop);
1.585 + if (t!=ESqlNoToken)
1.586 + {
1.587 + if (t!=ESqlLeftBracket)
1.588 + ColumnNameL(statement->iDrop);
1.589 + else
1.590 + {
1.591 + NextToken();
1.592 + ColumnListL(statement->iDrop);
1.593 + RightBracketL();
1.594 + }
1.595 + }
1.596 + return statement;
1.597 + }
1.598 +
1.599 +CSqlDDLStatement* TSqlParser::CreateIndexLC(TBool aUnique)
1.600 +//
1.601 +// Parse a CREATE INDEX statement
1.602 +//
1.603 + {
1.604 + CSqlCreateIndexStatement* statement=new(ELeave) CSqlCreateIndexStatement;
1.605 + CleanupStack::PushL(statement);
1.606 + if (aUnique)
1.607 + statement->iKey.MakeUnique();
1.608 + IdentifierL(statement->iName);
1.609 + ParseL(ESqlKeyword_on);
1.610 + IdentifierL(statement->iTable);
1.611 + ParseL(ESqlLeftBracket);
1.612 + SortSpecificationL(statement->iKey);
1.613 + RightBracketL();
1.614 + return statement;
1.615 + }
1.616 +
1.617 +CSqlDDLStatement* TSqlParser::DropIndexLC()
1.618 +//
1.619 +// Parse a DROP INDEX statement
1.620 +//
1.621 + {
1.622 + CSqlDropIndexStatement* statement=new(ELeave) CSqlDropIndexStatement;
1.623 + CleanupStack::PushL(statement);
1.624 + IdentifierL(statement->iName);
1.625 + ParseL(ESqlKeyword_from);
1.626 + IdentifierL(statement->iTable);
1.627 + return statement;
1.628 + }
1.629 +
1.630 +CSqlDDLStatement* TSqlParser::DDLStatementLC()
1.631 + {
1.632 + CSqlDDLStatement* statement;
1.633 + if (Parse(ESqlKeyword_create))
1.634 + {
1.635 + if (Parse(ESqlKeyword_table))
1.636 + statement=CreateTableLC();
1.637 + else
1.638 + {
1.639 + TSqlTokenType unique=Parse(ESqlKeyword_unique);
1.640 + ParseL(ESqlKeyword_index);
1.641 + statement=CreateIndexLC(unique);
1.642 + }
1.643 + }
1.644 + else if (Parse(ESqlKeyword_drop))
1.645 + {
1.646 + if (Parse(ESqlKeyword_table))
1.647 + statement=DropTableLC();
1.648 + else
1.649 + {
1.650 + ParseL(ESqlKeyword_index);
1.651 + statement=DropIndexLC();
1.652 + }
1.653 + }
1.654 + else
1.655 + {
1.656 + ParseL(ESqlKeyword_alter);
1.657 + ParseL(ESqlKeyword_table);
1.658 + statement=AlterTableLC();
1.659 + }
1.660 + EndL();
1.661 + return statement;
1.662 + }
1.663 +
1.664 +TSqlTokenType TSqlParser::ColumnValueL(CSqlValues& aValues)
1.665 +//
1.666 +// parse a column-value and add to aValues
1.667 +//
1.668 + {
1.669 + switch (iToken.Type())
1.670 + {
1.671 + case ESqlLiteralInt:
1.672 + case ESqlLiteralReal:
1.673 + case ESqlLiteralTime:
1.674 + case ESqlLiteralText:
1.675 + aValues.AddL(iToken.Literal());
1.676 + return NextToken();
1.677 + case ESqlIdentifier: // NULL
1.678 + {
1.679 + TSqlTokenType t=ParseL(ESqlKeyword_null);
1.680 + aValues.AddL(RSqlLiteral()); // default c'ted RSqlLiteral is null
1.681 + return t;
1.682 + }
1.683 + default: // SQL error
1.684 + return SqlErrorL();
1.685 + }
1.686 + }
1.687 +
1.688 +CSqlDMLStatement* TSqlParser::InsertStatementLC()
1.689 +//
1.690 +// parse an insert-statement
1.691 +//
1.692 + {
1.693 + ParseL(ESqlKeyword_into);
1.694 + CSqlInsertStatement* statement=CSqlInsertStatement::NewLC();
1.695 + if (IdentifierL(statement->iQuery.iTable)==ESqlLeftBracket)
1.696 + {
1.697 + NextToken();
1.698 + ColumnListL(statement->iQuery.iColumns);
1.699 + RightBracketL();
1.700 + }
1.701 + ParseL(ESqlKeyword_values);
1.702 + ParseL(ESqlLeftBracket);
1.703 + CSqlValues& values=statement->ValuesL();
1.704 + while (ColumnValueL(values)==ESqlComma)
1.705 + NextToken();
1.706 + RightBracketL();
1.707 + return statement;
1.708 + }
1.709 +
1.710 +CSqlDMLStatement* TSqlParser::UpdateStatementLC()
1.711 +//
1.712 +// parse an update-statement
1.713 +//
1.714 + {
1.715 + CSqlModifyStatement* statement=CSqlModifyStatement::NewLC();
1.716 + IdentifierL(statement->iQuery.iTable);
1.717 + ParseL(ESqlKeyword_set);
1.718 + CSqlValues& values=statement->ValuesL();
1.719 + for (;;)
1.720 + {
1.721 + ColumnNameL(statement->iQuery.iColumns);
1.722 + ParseL(ESqlEqual);
1.723 + if (ColumnValueL(values)!=ESqlComma)
1.724 + break;
1.725 + NextToken();
1.726 + }
1.727 + if (Parse(ESqlKeyword_where))
1.728 + statement->iQuery.iSearchCondition=SearchConditionL();
1.729 + return statement;
1.730 + }
1.731 +
1.732 +CSqlDMLStatement* TSqlParser::DeleteStatementLC()
1.733 +//
1.734 +// parse a delete-statement
1.735 +//
1.736 + {
1.737 + ParseL(ESqlKeyword_from);
1.738 + CSqlModifyStatement* statement=CSqlModifyStatement::NewLC();
1.739 + IdentifierL(statement->iQuery.iTable);
1.740 + if (Parse(ESqlKeyword_where))
1.741 + statement->iQuery.iSearchCondition=SearchConditionL();
1.742 + return statement;
1.743 + }
1.744 +
1.745 +CSqlDMLStatement* TSqlParser::DMLStatementLC()
1.746 + {
1.747 + CSqlDMLStatement* statement;
1.748 + if (Parse(ESqlKeyword_insert))
1.749 + statement=InsertStatementLC();
1.750 + else if (Parse(ESqlKeyword_update))
1.751 + statement=UpdateStatementLC();
1.752 + else
1.753 + {
1.754 + ParseL(ESqlKeyword_delete);
1.755 + statement=DeleteStatementLC();
1.756 + }
1.757 + EndL();
1.758 + return statement;
1.759 + }
1.760 +
1.761 +Sql::TStatementType TSqlParser::Type()
1.762 + {
1.763 + TSqlKeyword k=TSqlLexer::Keyword(iToken);
1.764 + if (k==ESqlKeyword_create || k==ESqlKeyword_alter || k==ESqlKeyword_drop)
1.765 + return Sql::EDDL;
1.766 + if (k==ESqlKeyword_insert || k==ESqlKeyword_update || k==ESqlKeyword_delete)
1.767 + return Sql::EDML;
1.768 + return Sql::ENone;
1.769 + }
1.770 +
1.771 +TInt TSqlParser::PatternFilter(const TDesC& aPattern,const TChar aEscape,TText *aNewPatternBuffer )
1.772 + {
1.773 + TInt length = aPattern.Length();
1.774 + TInt count =0;
1.775 +
1.776 + // Ensure that the pattern begins and ends with an '*'
1.777 + if ((length < 2) || (aPattern[0] != KMatchAny || aPattern[length-1] != KMatchAny))
1.778 + {
1.779 + return KSqlError;
1.780 + }
1.781 +
1.782 + for (TInt i = 1 ; i< length -1 ;++i)
1.783 + {
1.784 + if (aPattern[i]== (TUint)aEscape)
1.785 + {
1.786 + if ((aPattern[i + 1] == KMatchAny) || (aPattern[i + 1] == KMatchOne) || (aPattern[i + 1] == (TUint)aEscape))
1.787 + {
1.788 + i++;
1.789 + aNewPatternBuffer[count++] = aPattern[i];
1.790 + }
1.791 + else
1.792 + {
1.793 + return KSqlError;
1.794 + }
1.795 + }
1.796 + else
1.797 + {
1.798 + if ((aPattern[i] == KMatchAny || aPattern[i] == KMatchOne) )
1.799 + {
1.800 + return KSqlError;
1.801 + }
1.802 + else
1.803 + {
1.804 + aNewPatternBuffer[count++] = aPattern[i];
1.805 + }
1.806 + }
1.807 + }
1.808 +
1.809 + return count;
1.810 + }