sl@0: // Copyright (c) 1998-2009 Nokia Corporation and/or its subsidiary(-ies).
sl@0: // All rights reserved.
sl@0: // This component and the accompanying materials are made available
sl@0: // under the terms of "Eclipse Public License v1.0"
sl@0: // which accompanies this distribution, and is available
sl@0: // at the URL "http://www.eclipse.org/legal/epl-v10.html".
sl@0: //
sl@0: // Initial Contributors:
sl@0: // Nokia Corporation - initial contribution.
sl@0: //
sl@0: // Contributors:
sl@0: //
sl@0: // Description:
sl@0: // SQL Literal value and node classes
sl@0: // 
sl@0: //
sl@0: 
sl@0: #include "UQ_STD.H"
sl@0: 
sl@0: // internalising literal strings, overload selectors
sl@0: 
sl@0: inline HBufC8* Alloc8L(const TDesC8& aDes)
sl@0: 	{return aDes.AllocL();}
sl@0: inline HBufC8* Alloc8L(const TDesC16& aDes)
sl@0: 	{HBufC8* cell=HBufC8::NewL(aDes.Length());cell->Des().Copy(aDes);return cell;}
sl@0: inline HBufC16* Alloc16L(const TDesC16& aDes)
sl@0: 	{return aDes.AllocL();}
sl@0: inline HBufC16* Alloc16L(const TDesC8& aDes)
sl@0: 	{HBufC16* cell=HBufC16::NewL(aDes.Length());cell->Des().Copy(aDes);return cell;}
sl@0: 
sl@0: template <class B,class T>
sl@0: inline B* DoInternString(B* aBuf,T*)
sl@0: 	{
sl@0: 	const T* base=aBuf->Ptr();
sl@0: 	const T* from=base;
sl@0: 	const T* end=base+aBuf->Length();
sl@0: 	for (;;)
sl@0: 		{
sl@0: 		if (from==end)
sl@0: 			return aBuf;
sl@0: 		if (*from++=='\'')
sl@0: 			break;
sl@0: 		}
sl@0: 	T* to=(T*)from;
sl@0: 	++from;
sl@0: 	while (from<end)
sl@0: 		{
sl@0: 		T c=*from++;
sl@0: 		if (c=='\'')
sl@0: 			++from;
sl@0: 		*to++=c;
sl@0: 		}
sl@0: 	aBuf->Des().SetLength(to-base);
sl@0: 	return aBuf;
sl@0: 	}
sl@0: 
sl@0: template <class B>
sl@0: inline B* InternString(B* aBuf)
sl@0: 	{return DoInternString(aBuf,PtrType(*aBuf));}
sl@0: 
sl@0: // Class RSqlLiteral
sl@0: 
sl@0: void RSqlLiteral::Close()
sl@0: //
sl@0: // Free any allocated cell
sl@0: //
sl@0: 	{
sl@0: 	if(iBuffer)
sl@0: 		delete iBuffer;
sl@0: 	if (IsAlloc())
sl@0: 		User::Free(iVal.iAlloc);
sl@0: 
sl@0: 		
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToInt32L()
sl@0: //
sl@0: // Convert a numeric type to Int32
sl@0: //
sl@0: 	{
sl@0: 	ToInt64L();
sl@0: 	const TInt64& v=iVal.iInt64;
sl@0: 	TInt32 l = I64LOW(v);
sl@0: 	TInt32 h = I64HIGH(v);
sl@0: 	if (h==(l>>31))	// domain check, in signed 32-bit range
sl@0: 		{
sl@0: 		iVal.iInt32=l;
sl@0: 		iType=EInt32;
sl@0: 		}
sl@0: 	else
sl@0: 		__LEAVE(KErrOverflow);	// cannot convert
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToUint32L()
sl@0: //
sl@0: // Convert a numeric type to Uint32
sl@0: //
sl@0: 	{
sl@0: 	ToInt64L();
sl@0: 	const TInt64& v=iVal.iInt64;
sl@0: 	if (I64HIGH(v)==0)		// domain check, in unsigned 32-bit range
sl@0: 		{
sl@0: 		iVal.iUint32 = I64LOW(v);
sl@0: 		iType=EUint32;
sl@0: 		}
sl@0: 	else
sl@0: 		__LEAVE(KErrOverflow);	// cannot convert
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToInt64L()
sl@0: //
sl@0: // Convert a numeric type to int64
sl@0: //
sl@0: 	{
sl@0: 	__ASSERT(IsBasic());	// only apply conversions once
sl@0: 	TType t=iType;
sl@0: 	if (t==EReal64)
sl@0: 		{
sl@0: 		iVal.iInt64() = static_cast<TInt64>(Real64());
sl@0: 		iType=EInt64;
sl@0: 		}
sl@0: 	else if (t!=EInt64)
sl@0: 		__LEAVE(KErrGeneral);
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToReal64L()
sl@0: //
sl@0: // Convert a numeric type to real64
sl@0: //
sl@0: 	{
sl@0: 	__ASSERT(IsBasic());	// only apply conversions once
sl@0: 	TType t=iType;
sl@0: 	if (t==EInt64)
sl@0: 		{
sl@0: 		iVal.iReal64=I64REAL(Int64());
sl@0: 		iType=EReal64;
sl@0: 		}
sl@0: 	else if (t!=EReal64)
sl@0: 		__LEAVE(KErrGeneral);
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToReal32L()
sl@0: //
sl@0: // Convert a numeric type to real32
sl@0: //
sl@0: 	{
sl@0: 	ToReal64L();
sl@0: 	__LEAVE_IF_ERROR(TRealX(iVal.iReal64).GetTReal(iVal.iReal32));
sl@0: 	iType=EReal32;
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToTimeL()
sl@0: //
sl@0: // Ensure we are a time
sl@0: //
sl@0: 	{
sl@0: 	__ASSERT(IsBasic());	// only apply conversions once
sl@0: 	if (iType!=ETime)
sl@0: 		__LEAVE(KErrGeneral);	// type mismatch
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToText8L()
sl@0: //
sl@0: // Convert a ptr to a text8
sl@0: //
sl@0: 	{
sl@0: 	__ASSERT(IsBasic());	// only apply conversions once
sl@0: 	if (iType==EPtr)
sl@0: 		{
sl@0: 		iVal.iAlloc=InternString(Alloc8L(DesC()));
sl@0: 		iType=EBuf8;
sl@0: 		}
sl@0: 	else
sl@0: 		__LEAVE(KErrGeneral);	// type mismatch
sl@0: 	}
sl@0: 
sl@0: void RSqlLiteral::ToText16L()
sl@0: //
sl@0: // Convert a ptr to a text8
sl@0: //
sl@0: 	{
sl@0: 	__ASSERT(IsBasic());	// only apply conversions once
sl@0: 	if (iType==EPtr)
sl@0: 		{
sl@0: 		iVal.iAlloc=InternString(Alloc16L(DesC()));
sl@0: 		iType=EBuf16;
sl@0: 		}
sl@0: 	else
sl@0: 		__LEAVE(KErrGeneral);	// type mismatch
sl@0: 	}
sl@0: 
sl@0: 
sl@0: 
sl@0: // class CSqlLiteralNode
sl@0: 
sl@0: CSqlLiteralNode::CSqlLiteralNode(TType aType,const TDesC& aColumn,const RSqlLiteral& aLiteral)
sl@0: 	:CSqlBoundNode(aType,aColumn),iLiteral(aLiteral)
sl@0: 	{}
sl@0: 
sl@0: CSqlLiteralNode::~CSqlLiteralNode()
sl@0: 	{
sl@0: 	iLiteral.Close();
sl@0: 	}
sl@0: 
sl@0: void CSqlLiteralNode::BindL(const RDbTableRow& aSource)
sl@0: 	{
sl@0: 	CSqlBoundNode::BindL(aSource);
sl@0: 	switch (ColType())
sl@0: 		{
sl@0: 	default:	// type not allowed in evaluation expressions
sl@0: 		__LEAVE(KErrGeneral);
sl@0: 		break;
sl@0: 	case EDbColBit:
sl@0: 	case EDbColInt8:
sl@0: 	case EDbColUint8:
sl@0: 	case EDbColInt16:
sl@0: 	case EDbColUint16:
sl@0: 	case EDbColInt32:
sl@0: 	case EDbColUint32:
sl@0: 	case EDbColInt64:
sl@0: 		iLiteral.ToInt64L();
sl@0: 		break;
sl@0: 	case EDbColReal32:
sl@0: 	case EDbColReal64:
sl@0: 		iLiteral.ToReal64L();
sl@0: 		break;
sl@0: 	case EDbColDateTime:
sl@0: 		iLiteral.ToTimeL();
sl@0: 		break;
sl@0: 	case EDbColText8:
sl@0: 	case EDbColLongText8:
sl@0: 		iLiteral.ToText8L();
sl@0: 		break;
sl@0: 	case EDbColText16:
sl@0: 	case EDbColLongText16:
sl@0: 		iLiteral.ToText16L();
sl@0: 		break;
sl@0: 		}
sl@0: 	}
sl@0: // copy text to buffer for LIKE Escape support
sl@0: TInt RSqlLiteral::CopyText()
sl@0: 	{
sl@0: 	if (iType==EPtr)
sl@0: 		{
sl@0: 		TInt length = iVal.iPtr.iEnd - iVal.iPtr.iPtr;
sl@0: 		if(iBuffer)
sl@0: 			delete iBuffer;
sl@0: 		if((iBuffer=HBufC::New(length+1)) == NULL)
sl@0: 	        	{
sl@0: 			return KErrNoMemory;
sl@0: 			}
sl@0: 		iBuffer->Des().Copy(iVal.iPtr.iPtr,length);
sl@0: 		iVal.iPtr.iPtr= &iBuffer->Des()[0];
sl@0: 		iBuffer->Des().Append(iVal.iPtr.iEnd,1);
sl@0: 		iVal.iPtr.iEnd=&iBuffer->Des()[length]; 
sl@0: 		}
sl@0: 	else
sl@0: 		return KErrGeneral;	// type mismatch
sl@0: 	return KErrNone;
sl@0: 	}
sl@0: