1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/dbms/usql/UQ_COMP.CPP	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,125 @@
     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 Comparison predicate node class
    1.18 +// 
    1.19 +//
    1.20 +
    1.21 +#include "UQ_STD.H"
    1.22 +#include "D32COMP.H"
    1.23 +
    1.24 +// class CSqlCompPredicate
    1.25 +
    1.26 +CSqlCompPredicate::CSqlCompPredicate(TType aType,const TDesC& aColumn,const RSqlLiteral& aLiteral)
    1.27 +	: CSqlLiteralNode(aType,aColumn,aLiteral)
    1.28 +	{
    1.29 +	__ASSERT(aType==ELess||aType==ELessEqual||aType==EEqual||aType==EGreaterEqual||aType==EGreater||aType==ENotEqual);
    1.30 +	}
    1.31 +
    1.32 +TInt CSqlCompPredicate::CompareLongText8L(const TDbBlob& aBlob,const TTextOps& aTextOp) const
    1.33 +	{
    1.34 +	TInt r=Comp::Compare8L(StreamLC(aBlob),aBlob.Size(),Value().Text8(),aTextOp);
    1.35 +	CleanupStack::PopAndDestroy();
    1.36 +	return r;
    1.37 +	}
    1.38 +
    1.39 +TInt CSqlCompPredicate::CompareLongText16L(const TDbBlob& aBlob,const TTextOps& aTextOp) const
    1.40 +	{
    1.41 +	TInt r=Comp::Compare16L(StreamLC(aBlob),aBlob.Size(),Value().Text16(),aTextOp);
    1.42 +	CleanupStack::PopAndDestroy();
    1.43 +	return r;
    1.44 +	}
    1.45 +
    1.46 +TBool CSqlCompPredicate::EvaluateL(const TTextOps& aTextOp) const
    1.47 +//
    1.48 +// Evaluate a comparison between the columns and the data
    1.49 +// NULL numeric data always compares false
    1.50 +//
    1.51 +	{
    1.52 +	TDbColumnC col=Column();
    1.53 +	TDbColType t=ColType();
    1.54 +	if (t<=EDbColDateTime && col.IsNull())
    1.55 +		return EFalse;	// NULL always compares false for non-text columns
    1.56 +	TInt r;
    1.57 +	switch (t)
    1.58 +		{
    1.59 +	default:
    1.60 +		__ASSERT(0);
    1.61 +	case EDbColBit:
    1.62 +	case EDbColUint8:
    1.63 +	case EDbColUint16:
    1.64 +	case EDbColUint32:
    1.65 +		r=Comp::Compare(TInt64(TUint(col.Uint32())),Value().Int64());
    1.66 +		break;
    1.67 +	case EDbColInt8:
    1.68 +	case EDbColInt16:
    1.69 +	case EDbColInt32:
    1.70 +		r=Comp::Compare(TInt64(TInt(col.Int32())),Value().Int64());
    1.71 +		break;
    1.72 +	case EDbColInt64:
    1.73 +		r=Comp::Compare(col.Int64(),Value().Int64());
    1.74 +		break;
    1.75 +	case EDbColReal32:
    1.76 +		r=Comp::Compare(TReal(col.Real32()),Value().Real64());
    1.77 +		break;
    1.78 +	case EDbColReal64:
    1.79 +		r=Comp::Compare(col.Real64(),Value().Real64());
    1.80 +		break;
    1.81 +	case EDbColDateTime:
    1.82 +		r=Comp::Compare(col.Time(),Value().Time());
    1.83 +		break;
    1.84 +	case EDbColText8:
    1.85 +		r=aTextOp.Compare(col.PtrC8(),Value().Text8());
    1.86 +		break;
    1.87 +	case EDbColText16:
    1.88 +		r=aTextOp.Compare(col.PtrC16(),Value().Text16());
    1.89 +		break;
    1.90 +	case EDbColLongText8:
    1.91 +		{
    1.92 +		const TDbBlob& blob=col.Blob();
    1.93 +		if (blob.IsInline())
    1.94 +			r=aTextOp.Compare(blob.PtrC8(),Value().Text8());
    1.95 +		else
    1.96 +			r=CompareLongText8L(blob,aTextOp);
    1.97 +		}
    1.98 +		break;
    1.99 +	case EDbColLongText16:
   1.100 +		{
   1.101 +		const TDbBlob& blob=col.Blob();
   1.102 +		if (blob.IsInline())
   1.103 +			r=aTextOp.Compare(blob.PtrC16(),Value().Text16());
   1.104 +		else
   1.105 +			r=CompareLongText16L(blob,aTextOp);
   1.106 +		}
   1.107 +		break;
   1.108 +		}
   1.109 +	switch (NodeType())
   1.110 +		{
   1.111 +	default:
   1.112 +		__ASSERT(0);
   1.113 +	case EGreater:
   1.114 +		r=-r;
   1.115 +		// drop throught to ELess
   1.116 +	case ELess:
   1.117 +		return r<0;
   1.118 +	case EGreaterEqual:
   1.119 +		r=-r;
   1.120 +		// drop throught to LessEqual
   1.121 +	case ELessEqual:
   1.122 +		return r<=0;
   1.123 +	case EEqual:
   1.124 +		return r==0;
   1.125 +	case ENotEqual:
   1.126 +		return r!=0;
   1.127 +		}
   1.128 +	}