1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dblongcol.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,324 @@
1.4 +// Copyright (c) 2004-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 +//
1.18 +
1.19 +#include <d32dbms.h>
1.20 +#include <s32file.h>
1.21 +#include <e32test.h>
1.22 +
1.23 +static RTest TheTest(_L("t_dblongcol"));
1.24 +static CTrapCleanup* TheTrapCleanup;
1.25 +const TInt KTestCleanupStack=0x40;
1.26 +RFs TheFsSession;
1.27 +
1.28 +_LIT( KTestDir, "c:\\DBMS-TST\\" );
1.29 +_LIT( KSearchTestDbPath, "c:\\DBMS-TST\\eposlmserachtest.ldb" );
1.30 +
1.31 +//Delete "aFullName" file.
1.32 +static void DeleteDataFile(const TDesC& aFullName)
1.33 + {
1.34 + RFs fsSession;
1.35 + TInt err = fsSession.Connect();
1.36 + if(err == KErrNone)
1.37 + {
1.38 + TEntry entry;
1.39 + if(fsSession.Entry(aFullName, entry) == KErrNone)
1.40 + {
1.41 + RDebug::Print(_L("Deleting \"%S\" file.\n"), &aFullName);
1.42 + err = fsSession.SetAtt(aFullName, 0, KEntryAttReadOnly);
1.43 + if(err != KErrNone)
1.44 + {
1.45 + RDebug::Print(_L("Error %d changing \"%S\" file attributes.\n"), err, &aFullName);
1.46 + }
1.47 + err = fsSession.Delete(aFullName);
1.48 + if(err != KErrNone)
1.49 + {
1.50 + RDebug::Print(_L("Error %d deleting \"%S\" file.\n"), err, &aFullName);
1.51 + }
1.52 + }
1.53 + fsSession.Close();
1.54 + }
1.55 + else
1.56 + {
1.57 + RDebug::Print(_L("Error %d connecting file session. File: %S.\n"), err, &aFullName);
1.58 + }
1.59 + }
1.60 +
1.61 +///////////////////////////////////////////////////////////////////////////////////////
1.62 +///////////////////////////////////////////////////////////////////////////////////////
1.63 +//Tests macros and functions.
1.64 +//If (!aValue) then the test will be panicked, the test data files will be deleted.
1.65 +static void Check(TInt aValue, TInt aLine)
1.66 + {
1.67 + if(!aValue)
1.68 + {
1.69 + ::DeleteDataFile(KSearchTestDbPath);
1.70 + TheTest(EFalse, aLine);
1.71 + }
1.72 + }
1.73 +//If (aValue != aExpected) then the test will be panicked, the test data files will be deleted.
1.74 +static void Check(TInt aValue, TInt aExpected, TInt aLine)
1.75 + {
1.76 + if(aValue != aExpected)
1.77 + {
1.78 + RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
1.79 + ::DeleteDataFile(KSearchTestDbPath);
1.80 + TheTest(EFalse, aLine);
1.81 + }
1.82 + }
1.83 +//Use these to test conditions.
1.84 +#define TEST(arg) ::Check((arg), __LINE__)
1.85 +#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
1.86 +
1.87 +///////////////////////////////////////////////////////////////////////////////////////
1.88 +
1.89 +static void LeaveL(TInt aLine, TInt aError)
1.90 + {
1.91 + RDebug::Print(_L("*** Leave. Error: %d, line: %d\r\n"), aError, aLine);
1.92 + User::Leave(aError);
1.93 + }
1.94 +static void LeaveIfErrorL(TInt aLine, TInt aError)
1.95 + {
1.96 + if(aError < KErrNone)
1.97 + {
1.98 + LeaveL(aLine, aError);
1.99 + }
1.100 + }
1.101 +#define __LEAVE(err) LeaveL(__LINE__, err)
1.102 +#define __LEAVE_IF_ERROR(err) LeaveIfErrorL(__LINE__, err)
1.103 +
1.104 +///////////////////////////////////////////////////////////////////////////////////////
1.105 +///////////////////////////////////////////////////////////////////////////////////////
1.106 +
1.107 +//
1.108 +// Prepare the test directory.
1.109 +//
1.110 +static void SetupTestDirectory()
1.111 + {
1.112 + TInt r=TheFsSession.MkDir(KTestDir);
1.113 + TEST(r==KErrNone || r==KErrAlreadyExists);
1.114 + r=TheFsSession.SetSessionPath(KTestDir);
1.115 + TEST2(r,KErrNone);
1.116 + }
1.117 +
1.118 +static TInt SearchForL( const TPtrC& aSearchString, RDbNamedDatabase& aDb )
1.119 + {
1.120 + _LIT( KSQLSearchStatement, "select Notes from CDs where Notes like '%S'" );
1.121 + TBuf<512> query;
1.122 + query.Format( KSQLSearchStatement, &aSearchString );
1.123 +
1.124 + // Display query
1.125 + _LIT( KQueryFormatter, "\r\n %S\r\n" );
1.126 + TBuf<512> msg;
1.127 + msg.Format( KQueryFormatter, &query );
1.128 + TheTest.Printf( msg );
1.129 +
1.130 + // create a view on the database
1.131 + RDbView view;
1.132 + // use EDbCompareCollated in order to search case-insensitive
1.133 + __LEAVE_IF_ERROR( view.Prepare( aDb, TDbQuery( query, EDbCompareCollated ) ) );
1.134 + __LEAVE_IF_ERROR( view.EvaluateAll() );
1.135 +
1.136 + // iterate across the row set
1.137 + TInt noOfMatches = 0;
1.138 + for ( view.FirstL(); view.AtRow(); view.NextL() )
1.139 + {
1.140 + // retrieve the row
1.141 + view.GetL();
1.142 + noOfMatches++;
1.143 + }
1.144 +
1.145 + // Display no of matches
1.146 + _LIT( KNoOfMatchFormatter, " Found %d matches\r\n" );
1.147 + msg.Format( KNoOfMatchFormatter, noOfMatches );
1.148 + TheTest.Printf( msg );
1.149 +
1.150 + // close the view
1.151 + view.Close();
1.152 + return noOfMatches;
1.153 + }
1.154 +
1.155 +/**
1.156 +@SYMTestCaseID SYSLIB-DBMS-CT-0645
1.157 +@SYMTestCaseDesc Searching for data from a database
1.158 +@SYMTestPriority Medium
1.159 +@SYMTestActions Tests for EDbColText,EDbColLongText column type
1.160 +@SYMTestExpectedResults Test must not fail
1.161 +@SYMREQ REQ0000
1.162 +*/
1.163 +static void TestSearchL( TInt aIndex )
1.164 + {
1.165 + // Default database
1.166 + _LIT( KComposer1, "Elgar" );
1.167 + _LIT( KCol1, "Artist" );
1.168 + _LIT( KCol2, "Notes" );
1.169 + _LIT( KTable, "CDs" );
1.170 +
1.171 + TInt err = TheFsSession.Delete( KSearchTestDbPath );
1.172 + if ( ( err != KErrNone ) && ( err != KErrNotFound ) && ( err != KErrPathNotFound ) )
1.173 + {
1.174 + __LEAVE( err );
1.175 + }
1.176 +
1.177 + RDbNamedDatabase db;
1.178 + CleanupClosePushL( db );
1.179 + __LEAVE_IF_ERROR( db.Create( TheFsSession, KSearchTestDbPath ) );
1.180 +
1.181 + //
1.182 + // Create the database table
1.183 + //
1.184 + // Create a table definition
1.185 + CDbColSet* columns = CDbColSet::NewLC();
1.186 + // add the columns
1.187 + columns->AddL( TDbCol( KCol1, EDbColText ) );
1.188 + if ( aIndex == 0 )
1.189 + columns->AddL( TDbCol( KCol2, EDbColText ) );
1.190 + else
1.191 + columns->AddL( TDbCol( KCol2, EDbColLongText ) );
1.192 + // if the column is of type "EDbColText" instead,
1.193 + // all searching is working properly
1.194 + // Create a table
1.195 + __LEAVE_IF_ERROR( db.CreateTable( KTable, *columns ) );
1.196 + // cleanup the column set
1.197 + CleanupStack::PopAndDestroy( columns );
1.198 +
1.199 + //
1.200 + // Add data
1.201 + //
1.202 + // create a view on the database
1.203 + _LIT( KSQLStatement, "select Artist,Notes from CDs order by Artist" );
1.204 + RDbView view;
1.205 + __LEAVE_IF_ERROR( view.Prepare( db, TDbQuery( KSQLStatement, EDbCompareNormal ) ) );
1.206 + __LEAVE_IF_ERROR( view.EvaluateAll() );
1.207 +
1.208 + // Get the structure of rowset
1.209 + CDbColSet* colSet = view.ColSetL();
1.210 + // insert a row
1.211 + view.InsertL();
1.212 + view.SetColL( colSet->ColNo( KCol1 ), KComposer1 ); // Artist
1.213 + // Use the stream
1.214 + // RDbColWriteStream out;
1.215 + // TDbColNo col = colSet->ColNo( KCol2 ); // Ordinal position of long column
1.216 + //
1.217 + // out.OpenLC( view, col );
1.218 + // out.WriteL( _L( "Some additional comment here." ) );
1.219 + // out.Close();
1.220 + //
1.221 + // CleanupStack::PopAndDestroy(); // out
1.222 + view.SetColL( colSet->ColNo( KCol2 ), _L( "Some additional comment here." ) );
1.223 + view.PutL();
1.224 + // close the view
1.225 + view.Close();
1.226 + delete colSet;
1.227 +
1.228 + //
1.229 + // Display the data
1.230 + //
1.231 + _LIT( KRowFormatter, "\r\n Artist: %S \r\n Notes: %S \r\n" );
1.232 + __LEAVE_IF_ERROR( view.Prepare( db, TDbQuery( KSQLStatement, EDbCompareNormal ) ) );
1.233 + __LEAVE_IF_ERROR( view.EvaluateAll() );
1.234 +
1.235 + // Get the structure of the rowset
1.236 + colSet = view.ColSetL();
1.237 + // iterate across the row set
1.238 + for ( view.FirstL(); view.AtRow(); view.NextL() )
1.239 + {
1.240 + // retrieve the row
1.241 + view.GetL();
1.242 + // while the rowset is on this row, can use a TPtrC to
1.243 + // refer to any text columns
1.244 + TPtrC artist = view.ColDes( colSet->ColNo( KCol1 ) );
1.245 + // and a stream for long columns
1.246 + RDbColReadStream in;
1.247 + TDbColNo col = colSet->ColNo( KCol2 ); // Ordinal position of long column
1.248 + TBuf<256> notes; // Buffer for out notes
1.249 + in.OpenLC( view, col );
1.250 + in.ReadL( notes, view.ColLength( col ) );
1.251 + in.Close();
1.252 + CleanupStack::PopAndDestroy(); // in
1.253 + // Display the artist and notes
1.254 + TBuf<512> msg;
1.255 + msg.Format( KRowFormatter, &artist, ¬es );
1.256 + TheTest.Printf( msg );
1.257 + }
1.258 + // close the view
1.259 + view.Close();
1.260 + delete colSet;
1.261 +
1.262 + //
1.263 + // Search for the data
1.264 + //
1.265 + TInt result;
1.266 + result = SearchForL( _L( "Some*" ), db ); // matches
1.267 + TEST(result == 1);
1.268 + result = SearchForL( _L( "some*" ), db ); // defect causes no match, should match
1.269 + TEST(result == 1);
1.270 + result = SearchForL( _L( "*some*" ), db ); // matches
1.271 + TEST(result == 1);
1.272 + result = SearchForL( _L( "s?me*" ), db ); // matches
1.273 + TEST(result == 1);
1.274 + result = SearchForL( _L( "Some additional comment here." ), db ); // matches
1.275 + TEST(result == 1);
1.276 + result = SearchForL( _L( "some additional comment here." ), db ); // defect causes no match, should match
1.277 + TEST(result == 1);
1.278 +
1.279 + CleanupStack::PopAndDestroy( &db );
1.280 + }
1.281 +
1.282 +//
1.283 +// Initialise the cleanup stack.
1.284 +//
1.285 +static void setupCleanup()
1.286 + {
1.287 + TheTrapCleanup=CTrapCleanup::New();
1.288 + TEST(TheTrapCleanup!=NULL);
1.289 + TRAPD(r,\
1.290 + {\
1.291 + for (TInt i=KTestCleanupStack;i>0;i--)\
1.292 + CleanupStack::PushL((TAny*)0);\
1.293 + CleanupStack::Pop(KTestCleanupStack);\
1.294 + });
1.295 + TEST2(r,KErrNone);
1.296 + }
1.297 +
1.298 +//
1.299 +// Test streaming conversions.
1.300 +//
1.301 +GLDEF_C TInt E32Main()
1.302 + {
1.303 + TheTest.Title();
1.304 + setupCleanup();
1.305 + __UHEAP_MARK;
1.306 +
1.307 + TInt err = TheFsSession.Connect();
1.308 + TEST2(err, KErrNone);
1.309 + ::SetupTestDirectory();
1.310 +
1.311 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0645 Testing DBMS - EDbColText "));
1.312 + TRAP(err, TestSearchL( 0 ));
1.313 + TEST2(err,KErrNone);
1.314 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0645 Testing DBMS - EDbColLongText "));
1.315 + TRAP(err, TestSearchL( 1 ));
1.316 + TEST2(err,KErrNone);
1.317 + ::DeleteDataFile(KSearchTestDbPath);
1.318 + TheTest.End();
1.319 +
1.320 + TheFsSession.Close();
1.321 +
1.322 + __UHEAP_MARKEND;
1.323 + delete TheTrapCleanup;
1.324 + TheTest.Close();
1.325 + return 0;
1.326 + }
1.327 +