|
sl@0
|
1 |
// Copyright (c) 2008-2010 Nokia Corporation and/or its subsidiary(-ies).
|
|
sl@0
|
2 |
// All rights reserved.
|
|
sl@0
|
3 |
// This component and the accompanying materials are made available
|
|
sl@0
|
4 |
// under the terms of "Eclipse Public License v1.0"
|
|
sl@0
|
5 |
// which accompanies this distribution, and is available
|
|
sl@0
|
6 |
// at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
sl@0
|
7 |
//
|
|
sl@0
|
8 |
// Initial Contributors:
|
|
sl@0
|
9 |
// Nokia Corporation - initial contribution.
|
|
sl@0
|
10 |
//
|
|
sl@0
|
11 |
// Contributors:
|
|
sl@0
|
12 |
//
|
|
sl@0
|
13 |
// Description:
|
|
sl@0
|
14 |
//
|
|
sl@0
|
15 |
|
|
sl@0
|
16 |
#include <e32test.h>
|
|
sl@0
|
17 |
#include <bautils.h>
|
|
sl@0
|
18 |
#include <sqldb.h>
|
|
sl@0
|
19 |
#include "t_sqlcmdlineutil.h"
|
|
sl@0
|
20 |
|
|
sl@0
|
21 |
///////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
22 |
|
|
sl@0
|
23 |
RTest TheTest(_L("t_sqlperformance2 test"));
|
|
sl@0
|
24 |
RSqlDatabase TheDb;
|
|
sl@0
|
25 |
TFileName TheDbFileName;
|
|
sl@0
|
26 |
RFs TheFs;
|
|
sl@0
|
27 |
|
|
sl@0
|
28 |
TBuf<200> TheTestTitle;
|
|
sl@0
|
29 |
TCmdLineParams TheCmdLineParams;
|
|
sl@0
|
30 |
TBuf8<200> TheSqlConfigString;
|
|
sl@0
|
31 |
|
|
sl@0
|
32 |
_LIT(KUtf8, "UTF8 ");
|
|
sl@0
|
33 |
_LIT(KUtf16, "UTF16");
|
|
sl@0
|
34 |
|
|
sl@0
|
35 |
TInt TheBlobSize = 1024 * 256;
|
|
sl@0
|
36 |
|
|
sl@0
|
37 |
///////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
38 |
|
|
sl@0
|
39 |
void TestEnvDestroy()
|
|
sl@0
|
40 |
{
|
|
sl@0
|
41 |
TheDb.Close();
|
|
sl@0
|
42 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
43 |
TheFs.Close();
|
|
sl@0
|
44 |
}
|
|
sl@0
|
45 |
|
|
sl@0
|
46 |
///////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
47 |
///////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
48 |
//Test macros and functions
|
|
sl@0
|
49 |
void Check1(TInt aValue, TInt aLine)
|
|
sl@0
|
50 |
{
|
|
sl@0
|
51 |
if(!aValue)
|
|
sl@0
|
52 |
{
|
|
sl@0
|
53 |
TestEnvDestroy();
|
|
sl@0
|
54 |
TheTest.Printf(_L("*** Line %d\r\n"), aLine);
|
|
sl@0
|
55 |
TheTest(EFalse, aLine);
|
|
sl@0
|
56 |
}
|
|
sl@0
|
57 |
}
|
|
sl@0
|
58 |
void Check2(TInt aValue, TInt aExpected, TInt aLine)
|
|
sl@0
|
59 |
{
|
|
sl@0
|
60 |
if(aValue != aExpected)
|
|
sl@0
|
61 |
{
|
|
sl@0
|
62 |
TestEnvDestroy();
|
|
sl@0
|
63 |
TheTest.Printf(_L("*** Line %d, Expected error: %d, got: %d\r\n"), aLine, aExpected, aValue);
|
|
sl@0
|
64 |
TheTest(EFalse, aLine);
|
|
sl@0
|
65 |
}
|
|
sl@0
|
66 |
}
|
|
sl@0
|
67 |
#define TEST(arg) ::Check1((arg), __LINE__)
|
|
sl@0
|
68 |
#define TEST2(aValue, aExpected) ::Check2(aValue, aExpected, __LINE__)
|
|
sl@0
|
69 |
|
|
sl@0
|
70 |
///////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
71 |
|
|
sl@0
|
72 |
void TestEnvInit()
|
|
sl@0
|
73 |
{
|
|
sl@0
|
74 |
TInt err = TheFs.Connect();
|
|
sl@0
|
75 |
TEST2(err, KErrNone);
|
|
sl@0
|
76 |
//
|
|
sl@0
|
77 |
TInt driveNumber = -1;
|
|
sl@0
|
78 |
err = RFs::CharToDrive(TheCmdLineParams.iDriveName[0], driveNumber);
|
|
sl@0
|
79 |
TEST2(err, KErrNone);
|
|
sl@0
|
80 |
TDriveNumber driveNo = static_cast <TDriveNumber> (driveNumber);
|
|
sl@0
|
81 |
TDriveInfo driveInfo;
|
|
sl@0
|
82 |
err = TheFs.Drive(driveInfo, driveNo);
|
|
sl@0
|
83 |
TEST2(err, KErrNone);
|
|
sl@0
|
84 |
//Create the test directory
|
|
sl@0
|
85 |
err = TheFs.MkDirAll(TheDbFileName);
|
|
sl@0
|
86 |
TEST(err == KErrNone || err == KErrAlreadyExists);
|
|
sl@0
|
87 |
//Print drive info and the database name
|
|
sl@0
|
88 |
_LIT(KType1, "Not present");
|
|
sl@0
|
89 |
_LIT(KType2, "Unknown");
|
|
sl@0
|
90 |
_LIT(KType3, "Floppy");
|
|
sl@0
|
91 |
_LIT(KType4, "Hard disk");
|
|
sl@0
|
92 |
_LIT(KType5, "CD ROM");
|
|
sl@0
|
93 |
_LIT(KType6, "RAM disk");
|
|
sl@0
|
94 |
_LIT(KType7, "Flash");
|
|
sl@0
|
95 |
_LIT(KType8, "ROM drive");
|
|
sl@0
|
96 |
_LIT(KType9, "Remote drive");
|
|
sl@0
|
97 |
_LIT(KType10,"NAND flash");
|
|
sl@0
|
98 |
_LIT(KType11,"Rotating media");
|
|
sl@0
|
99 |
TPtrC KMediaTypeNames[] = {KType1(), KType2(), KType3(), KType4(), KType5(), KType6(), KType7(), KType8(), KType9(), KType10(), KType11()};
|
|
sl@0
|
100 |
TheTest.Printf(_L("Drive %C: %S. File: \"%S\"\r\n"), 'A' + driveNo, &KMediaTypeNames[driveInfo.iType], &TheDbFileName);
|
|
sl@0
|
101 |
}
|
|
sl@0
|
102 |
|
|
sl@0
|
103 |
void PrintWriteTime(TTimeIntervalMicroSeconds aTime, TTimeIntervalMicroSeconds aWriteTime, TTimeIntervalMicroSeconds aCommitTime)
|
|
sl@0
|
104 |
{
|
|
sl@0
|
105 |
TheTest.Printf(_L("####Execution time: %d ms, Write: %d ms, Commit: %d ms\r\n"),
|
|
sl@0
|
106 |
(TInt)(aTime.Int64() / 1000), (TInt)(aWriteTime.Int64() / 1000), (TInt)(aCommitTime.Int64() / 1000));
|
|
sl@0
|
107 |
}
|
|
sl@0
|
108 |
|
|
sl@0
|
109 |
void PrintReadTime(TTimeIntervalMicroSeconds aPrepareTime, TTimeIntervalMicroSeconds aNextTime, TTimeIntervalMicroSeconds aReadTime)
|
|
sl@0
|
110 |
{
|
|
sl@0
|
111 |
TInt executionTime = (TInt)(aPrepareTime.Int64() / 1000) + (TInt)(aNextTime.Int64() / 1000) + (TInt)(aReadTime.Int64() / 1000);
|
|
sl@0
|
112 |
TheTest.Printf(_L("####Execution time: %d ms, Prepare: %d ms, Next: %d ms, Read: %d ms\r\n"),
|
|
sl@0
|
113 |
executionTime, (TInt)(aPrepareTime.Int64() / 1000), (TInt)(aNextTime.Int64() / 1000), (TInt)(aReadTime.Int64() / 1000));
|
|
sl@0
|
114 |
}
|
|
sl@0
|
115 |
|
|
sl@0
|
116 |
void PrintReadTime(TTimeIntervalMicroSeconds aOpenTime, TTimeIntervalMicroSeconds aReadTime)
|
|
sl@0
|
117 |
{
|
|
sl@0
|
118 |
TInt executionTime = (TInt)(aOpenTime.Int64() / 1000) + (TInt)(aReadTime.Int64() / 1000);
|
|
sl@0
|
119 |
TheTest.Printf(_L("####Execution time: %d ms, Open: %d ms, Read: %d ms\r\n"),
|
|
sl@0
|
120 |
executionTime, (TInt)(aOpenTime.Int64() / 1000), (TInt)(aReadTime.Int64() / 1000));
|
|
sl@0
|
121 |
}
|
|
sl@0
|
122 |
|
|
sl@0
|
123 |
void PrintFileSize(RSqlDatabase& aDb)
|
|
sl@0
|
124 |
{
|
|
sl@0
|
125 |
TheTest.Printf(_L("####FileSize: %d\r\n"), aDb.Size());
|
|
sl@0
|
126 |
}
|
|
sl@0
|
127 |
|
|
sl@0
|
128 |
///////////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
129 |
|
|
sl@0
|
130 |
void CreateTestDb()
|
|
sl@0
|
131 |
{
|
|
sl@0
|
132 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
133 |
TInt err = TheDb.Create(TheDbFileName, &TheSqlConfigString);
|
|
sl@0
|
134 |
TEST2(err, KErrNone);
|
|
sl@0
|
135 |
err = TheDb.Exec(_L8("CREATE TABLE A(B BLOB)"));
|
|
sl@0
|
136 |
TEST2(err, 1);
|
|
sl@0
|
137 |
}
|
|
sl@0
|
138 |
|
|
sl@0
|
139 |
void DoWriteBlobIncrL(const TDesC8& aData,
|
|
sl@0
|
140 |
TTime& aT1,
|
|
sl@0
|
141 |
TTime& aT2,
|
|
sl@0
|
142 |
TTime& aT3,
|
|
sl@0
|
143 |
TTime& aT4)
|
|
sl@0
|
144 |
{
|
|
sl@0
|
145 |
|
|
sl@0
|
146 |
RSqlBlobWriteStream strm;
|
|
sl@0
|
147 |
CleanupClosePushL(strm);
|
|
sl@0
|
148 |
|
|
sl@0
|
149 |
aT1.HomeTime();
|
|
sl@0
|
150 |
strm.OpenL(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
151 |
strm.WriteL(aData);
|
|
sl@0
|
152 |
aT2.HomeTime();
|
|
sl@0
|
153 |
|
|
sl@0
|
154 |
aT3.HomeTime();
|
|
sl@0
|
155 |
strm.CommitL();
|
|
sl@0
|
156 |
aT4.HomeTime();
|
|
sl@0
|
157 |
|
|
sl@0
|
158 |
CleanupStack::PopAndDestroy(&strm);
|
|
sl@0
|
159 |
}
|
|
sl@0
|
160 |
|
|
sl@0
|
161 |
void InsertZeroBlob(TBool aDoPrintTime = EFalse)
|
|
sl@0
|
162 |
{
|
|
sl@0
|
163 |
TBuf<100> sql;
|
|
sl@0
|
164 |
sql.Format(_L("INSERT INTO A VALUES(zeroblob(%d))"), TheBlobSize);
|
|
sl@0
|
165 |
|
|
sl@0
|
166 |
TTime t1, t2;
|
|
sl@0
|
167 |
t1.HomeTime();
|
|
sl@0
|
168 |
TInt err = TheDb.Exec(sql);
|
|
sl@0
|
169 |
t2.HomeTime();
|
|
sl@0
|
170 |
TEST2(err, 1);
|
|
sl@0
|
171 |
TTimeIntervalMicroSeconds insertTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
172 |
|
|
sl@0
|
173 |
if(aDoPrintTime)
|
|
sl@0
|
174 |
{
|
|
sl@0
|
175 |
PrintWriteTime(insertTime, TTimeIntervalMicroSeconds(0), TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
176 |
}
|
|
sl@0
|
177 |
}
|
|
sl@0
|
178 |
|
|
sl@0
|
179 |
void InsertRealBlob()
|
|
sl@0
|
180 |
{
|
|
sl@0
|
181 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
182 |
TEST(data != NULL);
|
|
sl@0
|
183 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
184 |
dataptr.SetLength(TheBlobSize);
|
|
sl@0
|
185 |
dataptr.Fill(TChar('A'));
|
|
sl@0
|
186 |
|
|
sl@0
|
187 |
RSqlStatement stmt;
|
|
sl@0
|
188 |
TInt err = stmt.Prepare(TheDb, _L8("INSERT INTO A VALUES(:Prm)"));
|
|
sl@0
|
189 |
TEST2(err, KErrNone);
|
|
sl@0
|
190 |
|
|
sl@0
|
191 |
RSqlParamWriteStream strm;
|
|
sl@0
|
192 |
err = strm.BindBinary(stmt, 0);
|
|
sl@0
|
193 |
TEST2(err, KErrNone);
|
|
sl@0
|
194 |
|
|
sl@0
|
195 |
TRAP(err, strm.WriteL(dataptr));
|
|
sl@0
|
196 |
TEST2(err, KErrNone);
|
|
sl@0
|
197 |
TRAP(err, strm.CommitL());
|
|
sl@0
|
198 |
TEST2(err, KErrNone);
|
|
sl@0
|
199 |
strm.Close();
|
|
sl@0
|
200 |
|
|
sl@0
|
201 |
err = stmt.Exec();
|
|
sl@0
|
202 |
TEST2(err, 1);
|
|
sl@0
|
203 |
stmt.Close();
|
|
sl@0
|
204 |
|
|
sl@0
|
205 |
delete data;
|
|
sl@0
|
206 |
}
|
|
sl@0
|
207 |
|
|
sl@0
|
208 |
void InsertBlobIncr()
|
|
sl@0
|
209 |
{
|
|
sl@0
|
210 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
211 |
TEST(data != NULL);
|
|
sl@0
|
212 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
213 |
dataptr.SetLength(TheBlobSize);
|
|
sl@0
|
214 |
dataptr.Fill(TChar('B'));
|
|
sl@0
|
215 |
|
|
sl@0
|
216 |
TTimeIntervalMicroSeconds totalTime, writeTime, commitTime;
|
|
sl@0
|
217 |
|
|
sl@0
|
218 |
TBuf<100> sql;
|
|
sl@0
|
219 |
sql.Format(_L("INSERT INTO A VALUES(zeroblob(%d))"), TheBlobSize);
|
|
sl@0
|
220 |
|
|
sl@0
|
221 |
TTime t1, t2, subt1, subt2, subt3, subt4;
|
|
sl@0
|
222 |
t1.HomeTime();
|
|
sl@0
|
223 |
|
|
sl@0
|
224 |
TInt err = TheDb.Exec(_L8("BEGIN"));
|
|
sl@0
|
225 |
TEST(err >= 0);
|
|
sl@0
|
226 |
|
|
sl@0
|
227 |
err = TheDb.Exec(sql);
|
|
sl@0
|
228 |
TEST2(err, 1);
|
|
sl@0
|
229 |
|
|
sl@0
|
230 |
TRAP(err, DoWriteBlobIncrL(dataptr, subt1, subt2, subt3, subt4));
|
|
sl@0
|
231 |
TEST2(err, KErrNone);
|
|
sl@0
|
232 |
|
|
sl@0
|
233 |
err = TheDb.Exec(_L8("COMMIT"));
|
|
sl@0
|
234 |
TEST(err >= 0);
|
|
sl@0
|
235 |
|
|
sl@0
|
236 |
t2.HomeTime();
|
|
sl@0
|
237 |
totalTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
238 |
|
|
sl@0
|
239 |
writeTime = subt2.MicroSecondsFrom(subt1);
|
|
sl@0
|
240 |
commitTime = subt4.MicroSecondsFrom(subt3);
|
|
sl@0
|
241 |
|
|
sl@0
|
242 |
PrintWriteTime(totalTime, writeTime, commitTime);
|
|
sl@0
|
243 |
|
|
sl@0
|
244 |
delete data;
|
|
sl@0
|
245 |
}
|
|
sl@0
|
246 |
|
|
sl@0
|
247 |
void InsertBlobExec()
|
|
sl@0
|
248 |
{
|
|
sl@0
|
249 |
HBufC8* buf = HBufC8::New(TheBlobSize * 2 + 100);
|
|
sl@0
|
250 |
TEST(buf != NULL);
|
|
sl@0
|
251 |
TPtr8 sql = buf->Des();
|
|
sl@0
|
252 |
_LIT8(KStr, "INSERT INTO A VALUES(x'");
|
|
sl@0
|
253 |
sql.SetLength(TheBlobSize * 2 + KStr().Length());
|
|
sl@0
|
254 |
sql.Fill(TChar('A'));
|
|
sl@0
|
255 |
sql.Replace(0, KStr().Length(), KStr);
|
|
sl@0
|
256 |
sql.Append(_L8("')"));
|
|
sl@0
|
257 |
|
|
sl@0
|
258 |
TTime t1, t2;
|
|
sl@0
|
259 |
|
|
sl@0
|
260 |
t1.HomeTime();
|
|
sl@0
|
261 |
TInt err = TheDb.Exec(sql);
|
|
sl@0
|
262 |
t2.HomeTime();
|
|
sl@0
|
263 |
TEST2(err, 1);
|
|
sl@0
|
264 |
|
|
sl@0
|
265 |
TTimeIntervalMicroSeconds totalTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
266 |
|
|
sl@0
|
267 |
PrintWriteTime(totalTime, TTimeIntervalMicroSeconds(0), TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
268 |
|
|
sl@0
|
269 |
delete buf;
|
|
sl@0
|
270 |
}
|
|
sl@0
|
271 |
|
|
sl@0
|
272 |
void InsertBlobBindStreamPrm()
|
|
sl@0
|
273 |
{
|
|
sl@0
|
274 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
275 |
TEST(data != NULL);
|
|
sl@0
|
276 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
277 |
dataptr.SetLength(TheBlobSize);
|
|
sl@0
|
278 |
dataptr.Fill(TChar('A'));
|
|
sl@0
|
279 |
|
|
sl@0
|
280 |
TTimeIntervalMicroSeconds totalTime, writeTime, commitTime;
|
|
sl@0
|
281 |
|
|
sl@0
|
282 |
TTime t1, t2, t3, t4, t5, t6;
|
|
sl@0
|
283 |
t1.HomeTime();
|
|
sl@0
|
284 |
|
|
sl@0
|
285 |
RSqlStatement stmt;
|
|
sl@0
|
286 |
TInt err = stmt.Prepare(TheDb, _L8("INSERT INTO A VALUES(:Prm)"));
|
|
sl@0
|
287 |
TEST2(err, KErrNone);
|
|
sl@0
|
288 |
|
|
sl@0
|
289 |
RSqlParamWriteStream strm;
|
|
sl@0
|
290 |
err = strm.BindBinary(stmt, 0);
|
|
sl@0
|
291 |
TEST2(err, KErrNone);
|
|
sl@0
|
292 |
|
|
sl@0
|
293 |
t3.HomeTime();
|
|
sl@0
|
294 |
TRAP(err, strm.WriteL(dataptr));
|
|
sl@0
|
295 |
t4.HomeTime();
|
|
sl@0
|
296 |
TEST2(err, KErrNone);
|
|
sl@0
|
297 |
|
|
sl@0
|
298 |
t5.HomeTime();
|
|
sl@0
|
299 |
TRAP(err, strm.CommitL());
|
|
sl@0
|
300 |
t6.HomeTime();
|
|
sl@0
|
301 |
TEST2(err, KErrNone);
|
|
sl@0
|
302 |
|
|
sl@0
|
303 |
err = stmt.Exec();
|
|
sl@0
|
304 |
|
|
sl@0
|
305 |
strm.Close();
|
|
sl@0
|
306 |
stmt.Close();
|
|
sl@0
|
307 |
|
|
sl@0
|
308 |
t2.HomeTime();
|
|
sl@0
|
309 |
TEST2(err, 1);
|
|
sl@0
|
310 |
|
|
sl@0
|
311 |
totalTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
312 |
|
|
sl@0
|
313 |
writeTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
314 |
commitTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
315 |
|
|
sl@0
|
316 |
PrintWriteTime(totalTime, writeTime, commitTime);
|
|
sl@0
|
317 |
|
|
sl@0
|
318 |
delete data;
|
|
sl@0
|
319 |
}
|
|
sl@0
|
320 |
|
|
sl@0
|
321 |
void UpdateBlobIncr()
|
|
sl@0
|
322 |
{
|
|
sl@0
|
323 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
324 |
TEST(data != NULL);
|
|
sl@0
|
325 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
326 |
dataptr.SetLength(TheBlobSize);
|
|
sl@0
|
327 |
dataptr.Fill(TChar('A'));
|
|
sl@0
|
328 |
|
|
sl@0
|
329 |
TTimeIntervalMicroSeconds totalTime, writeTime, commitTime;
|
|
sl@0
|
330 |
|
|
sl@0
|
331 |
TTime t1, t2, subt1, subt2, subt3, subt4;
|
|
sl@0
|
332 |
t1.HomeTime();
|
|
sl@0
|
333 |
|
|
sl@0
|
334 |
TInt err = TheDb.Exec(_L8("BEGIN"));
|
|
sl@0
|
335 |
TEST(err >= 0);
|
|
sl@0
|
336 |
|
|
sl@0
|
337 |
TRAP(err, DoWriteBlobIncrL(dataptr, subt1, subt2, subt3, subt4));
|
|
sl@0
|
338 |
TEST2(err, KErrNone);
|
|
sl@0
|
339 |
|
|
sl@0
|
340 |
err = TheDb.Exec(_L8("COMMIT"));
|
|
sl@0
|
341 |
TEST(err >= 0);
|
|
sl@0
|
342 |
|
|
sl@0
|
343 |
t2.HomeTime();
|
|
sl@0
|
344 |
totalTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
345 |
|
|
sl@0
|
346 |
writeTime = subt2.MicroSecondsFrom(subt1);
|
|
sl@0
|
347 |
commitTime = subt4.MicroSecondsFrom(subt3);
|
|
sl@0
|
348 |
|
|
sl@0
|
349 |
PrintWriteTime(totalTime, writeTime, commitTime);
|
|
sl@0
|
350 |
|
|
sl@0
|
351 |
delete data;
|
|
sl@0
|
352 |
}
|
|
sl@0
|
353 |
|
|
sl@0
|
354 |
void UpdateBlobExec()
|
|
sl@0
|
355 |
{
|
|
sl@0
|
356 |
HBufC8* buf = HBufC8::New(TheBlobSize * 2 + 100);
|
|
sl@0
|
357 |
TEST(buf != NULL);
|
|
sl@0
|
358 |
TPtr8 sql = buf->Des();
|
|
sl@0
|
359 |
_LIT8(KStr, "UPDATE A SET B=x'");
|
|
sl@0
|
360 |
sql.SetLength(TheBlobSize * 2 + KStr().Length());
|
|
sl@0
|
361 |
sql.Fill(TChar('B'));
|
|
sl@0
|
362 |
sql.Replace(0, KStr().Length(), KStr);
|
|
sl@0
|
363 |
sql.Append(_L8("'"));
|
|
sl@0
|
364 |
|
|
sl@0
|
365 |
TTime t1, t2;
|
|
sl@0
|
366 |
t1.HomeTime();
|
|
sl@0
|
367 |
TInt err = TheDb.Exec(sql);
|
|
sl@0
|
368 |
t2.HomeTime();
|
|
sl@0
|
369 |
TEST2(err, 1);
|
|
sl@0
|
370 |
|
|
sl@0
|
371 |
TTimeIntervalMicroSeconds totalTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
372 |
|
|
sl@0
|
373 |
PrintWriteTime(totalTime, TTimeIntervalMicroSeconds(0), TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
374 |
|
|
sl@0
|
375 |
delete buf;
|
|
sl@0
|
376 |
}
|
|
sl@0
|
377 |
|
|
sl@0
|
378 |
void UpdateBlobBindStreamPrm()
|
|
sl@0
|
379 |
{
|
|
sl@0
|
380 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
381 |
TEST(data != NULL);
|
|
sl@0
|
382 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
383 |
dataptr.SetLength(TheBlobSize);
|
|
sl@0
|
384 |
dataptr.Fill(TChar('B'));
|
|
sl@0
|
385 |
|
|
sl@0
|
386 |
TTimeIntervalMicroSeconds totalTime, writeTime, commitTime;
|
|
sl@0
|
387 |
|
|
sl@0
|
388 |
TTime t1, t2, t3, t4, t5, t6;
|
|
sl@0
|
389 |
t1.HomeTime();
|
|
sl@0
|
390 |
|
|
sl@0
|
391 |
RSqlStatement stmt;
|
|
sl@0
|
392 |
TInt err = stmt.Prepare(TheDb, _L8("UPDATE A SET B=(:Prm)"));
|
|
sl@0
|
393 |
TEST2(err, KErrNone);
|
|
sl@0
|
394 |
|
|
sl@0
|
395 |
RSqlParamWriteStream strm;
|
|
sl@0
|
396 |
err = strm.BindBinary(stmt, 0);
|
|
sl@0
|
397 |
TEST2(err, KErrNone);
|
|
sl@0
|
398 |
|
|
sl@0
|
399 |
t3.HomeTime();;
|
|
sl@0
|
400 |
TRAP(err, strm.WriteL(dataptr));
|
|
sl@0
|
401 |
t4.HomeTime();
|
|
sl@0
|
402 |
TEST2(err, KErrNone);
|
|
sl@0
|
403 |
|
|
sl@0
|
404 |
t5.HomeTime();
|
|
sl@0
|
405 |
TRAP(err, strm.CommitL());
|
|
sl@0
|
406 |
t6.HomeTime();
|
|
sl@0
|
407 |
TEST2(err, KErrNone);
|
|
sl@0
|
408 |
|
|
sl@0
|
409 |
err = stmt.Exec();
|
|
sl@0
|
410 |
|
|
sl@0
|
411 |
strm.Close();
|
|
sl@0
|
412 |
stmt.Close();
|
|
sl@0
|
413 |
|
|
sl@0
|
414 |
t2.HomeTime();
|
|
sl@0
|
415 |
TEST2(err, 1);
|
|
sl@0
|
416 |
|
|
sl@0
|
417 |
totalTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
418 |
|
|
sl@0
|
419 |
writeTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
420 |
commitTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
421 |
|
|
sl@0
|
422 |
PrintWriteTime(totalTime, writeTime, commitTime);
|
|
sl@0
|
423 |
|
|
sl@0
|
424 |
delete data;
|
|
sl@0
|
425 |
}
|
|
sl@0
|
426 |
|
|
sl@0
|
427 |
/**
|
|
sl@0
|
428 |
@SYMTestCaseID SYSLIB-SQL-UT-4084
|
|
sl@0
|
429 |
@SYMTestCaseDesc SQL, BLOB write, performance tests.
|
|
sl@0
|
430 |
Tests insertion and updates of BLOBs using the old
|
|
sl@0
|
431 |
APIs and the new RSqlBlobWriteStream APIs.
|
|
sl@0
|
432 |
@SYMTestPriority Medium
|
|
sl@0
|
433 |
@SYMTestActions Insertion and updates of blobs using the old and new APIs.
|
|
sl@0
|
434 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
435 |
@SYMREQ REQ5912
|
|
sl@0
|
436 |
*/
|
|
sl@0
|
437 |
void BlobWriteTest()
|
|
sl@0
|
438 |
{
|
|
sl@0
|
439 |
TheTest.Printf(_L("Blob size=%d Kb\r\n"), TheBlobSize / 1024);
|
|
sl@0
|
440 |
|
|
sl@0
|
441 |
//Insert a blob
|
|
sl@0
|
442 |
TheTest.Printf(_L("==================================================================\r\n"));
|
|
sl@0
|
443 |
|
|
sl@0
|
444 |
CreateTestDb();
|
|
sl@0
|
445 |
TheTest.Printf(_L("INSERT zeroblob - RSqlDatabase::Exec()\r\n"));
|
|
sl@0
|
446 |
PrintFileSize(TheDb);
|
|
sl@0
|
447 |
InsertZeroBlob(ETrue);
|
|
sl@0
|
448 |
PrintFileSize(TheDb);
|
|
sl@0
|
449 |
TheDb.Close();
|
|
sl@0
|
450 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
451 |
|
|
sl@0
|
452 |
CreateTestDb();
|
|
sl@0
|
453 |
TheTest.Printf(_L("INSERT blob - RSqlParamWriteStream\r\n"));
|
|
sl@0
|
454 |
PrintFileSize(TheDb);
|
|
sl@0
|
455 |
InsertBlobBindStreamPrm();
|
|
sl@0
|
456 |
PrintFileSize(TheDb);
|
|
sl@0
|
457 |
TheDb.Close();
|
|
sl@0
|
458 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
459 |
|
|
sl@0
|
460 |
CreateTestDb();
|
|
sl@0
|
461 |
TheTest.Printf(_L("INSERT blob - RSqlDatabase::Exec()\r\n"));
|
|
sl@0
|
462 |
PrintFileSize(TheDb);
|
|
sl@0
|
463 |
InsertBlobExec();
|
|
sl@0
|
464 |
PrintFileSize(TheDb);
|
|
sl@0
|
465 |
TheDb.Close();
|
|
sl@0
|
466 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
467 |
|
|
sl@0
|
468 |
CreateTestDb();
|
|
sl@0
|
469 |
TheTest.Printf(_L("INSERT blob - RSqlBlobWriteStream + transaction\r\n"));
|
|
sl@0
|
470 |
PrintFileSize(TheDb);
|
|
sl@0
|
471 |
InsertBlobIncr();
|
|
sl@0
|
472 |
PrintFileSize(TheDb);
|
|
sl@0
|
473 |
TheDb.Close();
|
|
sl@0
|
474 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
475 |
|
|
sl@0
|
476 |
// Update a blob
|
|
sl@0
|
477 |
TheTest.Printf(_L("==================================================================\r\n"));
|
|
sl@0
|
478 |
|
|
sl@0
|
479 |
CreateTestDb();
|
|
sl@0
|
480 |
TheTest.Printf(_L("UPDATE zeroblob - RSqlParamWriteStream\r\n"));
|
|
sl@0
|
481 |
PrintFileSize(TheDb);
|
|
sl@0
|
482 |
InsertZeroBlob();
|
|
sl@0
|
483 |
UpdateBlobBindStreamPrm();
|
|
sl@0
|
484 |
PrintFileSize(TheDb);
|
|
sl@0
|
485 |
TheDb.Close();
|
|
sl@0
|
486 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
487 |
|
|
sl@0
|
488 |
CreateTestDb();
|
|
sl@0
|
489 |
TheTest.Printf(_L("UPDATE blob - RSqlParamWriteStream\r\n"));
|
|
sl@0
|
490 |
PrintFileSize(TheDb);
|
|
sl@0
|
491 |
InsertRealBlob();
|
|
sl@0
|
492 |
UpdateBlobBindStreamPrm();
|
|
sl@0
|
493 |
PrintFileSize(TheDb);
|
|
sl@0
|
494 |
TheDb.Close();
|
|
sl@0
|
495 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
496 |
|
|
sl@0
|
497 |
CreateTestDb();
|
|
sl@0
|
498 |
TheTest.Printf(_L("UPDATE zeroblob - RSqlDatabase::Exec()\r\n"));
|
|
sl@0
|
499 |
PrintFileSize(TheDb);
|
|
sl@0
|
500 |
InsertZeroBlob();
|
|
sl@0
|
501 |
UpdateBlobExec();
|
|
sl@0
|
502 |
PrintFileSize(TheDb);
|
|
sl@0
|
503 |
TheDb.Close();
|
|
sl@0
|
504 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
505 |
|
|
sl@0
|
506 |
CreateTestDb();
|
|
sl@0
|
507 |
TheTest.Printf(_L("UPDATE blob - RSqlDatabase::Exec()\r\n"));
|
|
sl@0
|
508 |
PrintFileSize(TheDb);
|
|
sl@0
|
509 |
InsertRealBlob();
|
|
sl@0
|
510 |
UpdateBlobExec();
|
|
sl@0
|
511 |
PrintFileSize(TheDb);
|
|
sl@0
|
512 |
TheDb.Close();
|
|
sl@0
|
513 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
514 |
|
|
sl@0
|
515 |
CreateTestDb();
|
|
sl@0
|
516 |
TheTest.Printf(_L("UPDATE zeroblob - RSqlBlobWriteStream + transaction\r\n"));
|
|
sl@0
|
517 |
PrintFileSize(TheDb);
|
|
sl@0
|
518 |
InsertZeroBlob();
|
|
sl@0
|
519 |
UpdateBlobIncr();
|
|
sl@0
|
520 |
PrintFileSize(TheDb);
|
|
sl@0
|
521 |
TheDb.Close();
|
|
sl@0
|
522 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
523 |
|
|
sl@0
|
524 |
CreateTestDb();
|
|
sl@0
|
525 |
TheTest.Printf(_L("UPDATE blob - RSqlBlobWriteStream + transaction\r\n"));
|
|
sl@0
|
526 |
PrintFileSize(TheDb);
|
|
sl@0
|
527 |
InsertRealBlob();
|
|
sl@0
|
528 |
UpdateBlobIncr();
|
|
sl@0
|
529 |
PrintFileSize(TheDb);
|
|
sl@0
|
530 |
TheDb.Close();
|
|
sl@0
|
531 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
532 |
}
|
|
sl@0
|
533 |
|
|
sl@0
|
534 |
void DoReadBlobIncrL(TDes8& aDes, TInt aMaxLength)
|
|
sl@0
|
535 |
{
|
|
sl@0
|
536 |
TTime t1, t2, t3, t4;
|
|
sl@0
|
537 |
|
|
sl@0
|
538 |
TTimeIntervalMicroSeconds openTime, readTime;
|
|
sl@0
|
539 |
|
|
sl@0
|
540 |
RSqlBlobReadStream strm;
|
|
sl@0
|
541 |
CleanupClosePushL(strm);
|
|
sl@0
|
542 |
|
|
sl@0
|
543 |
t1.HomeTime();
|
|
sl@0
|
544 |
strm.OpenL(TheDb, _L("A"), _L("B"), 1);
|
|
sl@0
|
545 |
t2.HomeTime();
|
|
sl@0
|
546 |
|
|
sl@0
|
547 |
openTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
548 |
|
|
sl@0
|
549 |
t3.HomeTime();
|
|
sl@0
|
550 |
strm.ReadL(aDes, aMaxLength);
|
|
sl@0
|
551 |
t4.HomeTime();
|
|
sl@0
|
552 |
|
|
sl@0
|
553 |
readTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
554 |
|
|
sl@0
|
555 |
PrintReadTime(openTime, readTime);
|
|
sl@0
|
556 |
|
|
sl@0
|
557 |
CleanupStack::PopAndDestroy(&strm);
|
|
sl@0
|
558 |
}
|
|
sl@0
|
559 |
|
|
sl@0
|
560 |
void ReadBlobIncr()
|
|
sl@0
|
561 |
{
|
|
sl@0
|
562 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
563 |
TEST(data != NULL);
|
|
sl@0
|
564 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
565 |
|
|
sl@0
|
566 |
TRAPD(err, DoReadBlobIncrL(dataptr, TheBlobSize));
|
|
sl@0
|
567 |
TEST2(err, KErrNone);
|
|
sl@0
|
568 |
TEST2(dataptr.Length(), TheBlobSize);
|
|
sl@0
|
569 |
|
|
sl@0
|
570 |
delete data;
|
|
sl@0
|
571 |
}
|
|
sl@0
|
572 |
|
|
sl@0
|
573 |
void ReadBlobColDes()
|
|
sl@0
|
574 |
{
|
|
sl@0
|
575 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
576 |
TEST(data != NULL);
|
|
sl@0
|
577 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
578 |
|
|
sl@0
|
579 |
TTime t1, t2, t3, t4, t5, t6;
|
|
sl@0
|
580 |
TTimeIntervalMicroSeconds prepareTime, nextTime, readTime;
|
|
sl@0
|
581 |
|
|
sl@0
|
582 |
RSqlStatement stmt;
|
|
sl@0
|
583 |
t1.HomeTime();
|
|
sl@0
|
584 |
TInt err = stmt.Prepare(TheDb, _L8("SELECT B FROM A WHERE ROWID=1"));
|
|
sl@0
|
585 |
t2.HomeTime();
|
|
sl@0
|
586 |
TEST2(err, KErrNone);
|
|
sl@0
|
587 |
prepareTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
588 |
|
|
sl@0
|
589 |
t3.HomeTime();
|
|
sl@0
|
590 |
err = stmt.Next();
|
|
sl@0
|
591 |
t4.HomeTime();
|
|
sl@0
|
592 |
TEST2(err, KSqlAtRow);
|
|
sl@0
|
593 |
nextTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
594 |
|
|
sl@0
|
595 |
t5.HomeTime();
|
|
sl@0
|
596 |
err = stmt.ColumnBinary(0, dataptr);
|
|
sl@0
|
597 |
t6.HomeTime();
|
|
sl@0
|
598 |
TEST2(err, KErrNone);
|
|
sl@0
|
599 |
TEST2(dataptr.Length(), TheBlobSize);
|
|
sl@0
|
600 |
readTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
601 |
|
|
sl@0
|
602 |
PrintReadTime(prepareTime, nextTime, readTime);
|
|
sl@0
|
603 |
stmt.Close();
|
|
sl@0
|
604 |
|
|
sl@0
|
605 |
delete data;
|
|
sl@0
|
606 |
}
|
|
sl@0
|
607 |
|
|
sl@0
|
608 |
void ReadBlobColPtr()
|
|
sl@0
|
609 |
{
|
|
sl@0
|
610 |
TTime t1, t2, t3, t4, t5, t6;
|
|
sl@0
|
611 |
TTimeIntervalMicroSeconds prepareTime, nextTime, readTime;
|
|
sl@0
|
612 |
|
|
sl@0
|
613 |
RSqlStatement stmt;
|
|
sl@0
|
614 |
t1.HomeTime();
|
|
sl@0
|
615 |
TInt err = stmt.Prepare(TheDb, _L8("SELECT B FROM A WHERE ROWID=1"));
|
|
sl@0
|
616 |
t2.HomeTime();
|
|
sl@0
|
617 |
TEST2(err, KErrNone);
|
|
sl@0
|
618 |
prepareTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
619 |
|
|
sl@0
|
620 |
t3.HomeTime();
|
|
sl@0
|
621 |
err = stmt.Next();
|
|
sl@0
|
622 |
t4.HomeTime();
|
|
sl@0
|
623 |
TEST2(err, KSqlAtRow);
|
|
sl@0
|
624 |
nextTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
625 |
|
|
sl@0
|
626 |
TPtrC8 data;
|
|
sl@0
|
627 |
t5.HomeTime();
|
|
sl@0
|
628 |
err = stmt.ColumnBinary(0, data);
|
|
sl@0
|
629 |
t6.HomeTime();
|
|
sl@0
|
630 |
TEST2(err, KErrNone);
|
|
sl@0
|
631 |
TEST2(data.Length(), TheBlobSize);
|
|
sl@0
|
632 |
readTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
633 |
|
|
sl@0
|
634 |
PrintReadTime(prepareTime, nextTime, readTime);
|
|
sl@0
|
635 |
stmt.Close();
|
|
sl@0
|
636 |
}
|
|
sl@0
|
637 |
|
|
sl@0
|
638 |
void ReadBlobStreamCol()
|
|
sl@0
|
639 |
{
|
|
sl@0
|
640 |
HBufC8* data = HBufC8::New(TheBlobSize);
|
|
sl@0
|
641 |
TEST(data != NULL);
|
|
sl@0
|
642 |
TPtr8 dataptr = data->Des();
|
|
sl@0
|
643 |
|
|
sl@0
|
644 |
TTime t1, t2, t3, t4, t5, t6;
|
|
sl@0
|
645 |
TTimeIntervalMicroSeconds prepareTime, nextTime, readTime;
|
|
sl@0
|
646 |
|
|
sl@0
|
647 |
RSqlStatement stmt;
|
|
sl@0
|
648 |
t1.HomeTime();
|
|
sl@0
|
649 |
TInt err = stmt.Prepare(TheDb, _L8("SELECT B FROM A WHERE ROWID=1"));
|
|
sl@0
|
650 |
t2.HomeTime();
|
|
sl@0
|
651 |
TEST2(err, KErrNone);
|
|
sl@0
|
652 |
prepareTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
653 |
|
|
sl@0
|
654 |
t3.HomeTime();
|
|
sl@0
|
655 |
err = stmt.Next();
|
|
sl@0
|
656 |
t4.HomeTime();
|
|
sl@0
|
657 |
TEST2(err, KSqlAtRow);
|
|
sl@0
|
658 |
nextTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
659 |
|
|
sl@0
|
660 |
RSqlColumnReadStream strm;
|
|
sl@0
|
661 |
t5.HomeTime();
|
|
sl@0
|
662 |
err = strm.ColumnBinary(stmt, 0);
|
|
sl@0
|
663 |
TEST2(err, KErrNone);
|
|
sl@0
|
664 |
TRAP(err, strm.ReadL(dataptr, TheBlobSize));
|
|
sl@0
|
665 |
t6.HomeTime();
|
|
sl@0
|
666 |
TEST2(err, KErrNone);
|
|
sl@0
|
667 |
TEST2(dataptr.Length(), TheBlobSize);
|
|
sl@0
|
668 |
readTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
669 |
|
|
sl@0
|
670 |
strm.Close();
|
|
sl@0
|
671 |
stmt.Close();
|
|
sl@0
|
672 |
|
|
sl@0
|
673 |
PrintReadTime(prepareTime, nextTime, readTime);
|
|
sl@0
|
674 |
|
|
sl@0
|
675 |
delete data;
|
|
sl@0
|
676 |
}
|
|
sl@0
|
677 |
|
|
sl@0
|
678 |
/**
|
|
sl@0
|
679 |
@SYMTestCaseID SYSLIB-SQL-UT-4085
|
|
sl@0
|
680 |
@SYMTestCaseDesc SQL, BLOB read, performance tests.
|
|
sl@0
|
681 |
Tests retrieval of BLOBs using the old
|
|
sl@0
|
682 |
APIs and the new RSqlBlobReadStream APIs.
|
|
sl@0
|
683 |
@SYMTestPriority Medium
|
|
sl@0
|
684 |
@SYMTestActions Retrieval of blobs using the old and new APIs.
|
|
sl@0
|
685 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
686 |
@SYMREQ REQ5912
|
|
sl@0
|
687 |
*/
|
|
sl@0
|
688 |
void BlobReadTest()
|
|
sl@0
|
689 |
{
|
|
sl@0
|
690 |
TheTest.Printf(_L("Blob size=%d Kb\r\n"), TheBlobSize / 1024);
|
|
sl@0
|
691 |
|
|
sl@0
|
692 |
// Insert a blob
|
|
sl@0
|
693 |
TheTest.Printf(_L("==================================================================\r\n"));
|
|
sl@0
|
694 |
TheTest.Printf(_L("Insert blob\r\n"));
|
|
sl@0
|
695 |
|
|
sl@0
|
696 |
CreateTestDb();
|
|
sl@0
|
697 |
PrintFileSize(TheDb);
|
|
sl@0
|
698 |
InsertBlobExec();
|
|
sl@0
|
699 |
PrintFileSize(TheDb);
|
|
sl@0
|
700 |
TheDb.Close();
|
|
sl@0
|
701 |
|
|
sl@0
|
702 |
// Read the blob
|
|
sl@0
|
703 |
TheTest.Printf(_L("==================================================================\r\n"));
|
|
sl@0
|
704 |
|
|
sl@0
|
705 |
TheTest.Printf(_L("Read blob - RSqlBlobReadStream\r\n"));
|
|
sl@0
|
706 |
TInt err = TheDb.Open(TheDbFileName);
|
|
sl@0
|
707 |
TEST2(err, KErrNone);
|
|
sl@0
|
708 |
ReadBlobIncr();
|
|
sl@0
|
709 |
TheDb.Close();
|
|
sl@0
|
710 |
|
|
sl@0
|
711 |
TheTest.Printf(_L("Read blob - RSqlStatement::ColumnBinary(TInt, TDes8&)\r\n"));
|
|
sl@0
|
712 |
err = TheDb.Open(TheDbFileName);
|
|
sl@0
|
713 |
TEST2(err, KErrNone);
|
|
sl@0
|
714 |
ReadBlobColDes();
|
|
sl@0
|
715 |
TheDb.Close();
|
|
sl@0
|
716 |
|
|
sl@0
|
717 |
TheTest.Printf(_L("Read blob - RSqlStatement::ColumnBinary(TInt, TPtrC8&)\r\n"));
|
|
sl@0
|
718 |
err = TheDb.Open(TheDbFileName);
|
|
sl@0
|
719 |
TEST2(err, KErrNone);
|
|
sl@0
|
720 |
ReadBlobColPtr();
|
|
sl@0
|
721 |
TheDb.Close();
|
|
sl@0
|
722 |
|
|
sl@0
|
723 |
TheTest.Printf(_L("Read blob - RSqlColumnReadStream\r\n"));
|
|
sl@0
|
724 |
err = TheDb.Open(TheDbFileName);
|
|
sl@0
|
725 |
TEST2(err, KErrNone);
|
|
sl@0
|
726 |
ReadBlobStreamCol();
|
|
sl@0
|
727 |
TheDb.Close();
|
|
sl@0
|
728 |
|
|
sl@0
|
729 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
730 |
}
|
|
sl@0
|
731 |
|
|
sl@0
|
732 |
/**
|
|
sl@0
|
733 |
@SYMTestCaseID SYSLIB-SQL-UT-4115
|
|
sl@0
|
734 |
@SYMTestCaseDesc SQL, sequential BLOB writes, performance tests.
|
|
sl@0
|
735 |
Tests sequentially writing 32Kb blocks to a 1.125Mb blob
|
|
sl@0
|
736 |
using the new RSqlBlobWriteStream APIs to examine
|
|
sl@0
|
737 |
the write performance at different stages in the
|
|
sl@0
|
738 |
sequence.
|
|
sl@0
|
739 |
@SYMTestPriority Medium
|
|
sl@0
|
740 |
@SYMTestActions Sequential writing of a blob using the new RSqlBlobWriteStream APIs.
|
|
sl@0
|
741 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
742 |
@SYMREQ REQ5912
|
|
sl@0
|
743 |
*/
|
|
sl@0
|
744 |
void SequentialWriteTestL()
|
|
sl@0
|
745 |
{
|
|
sl@0
|
746 |
const TInt KBufLen = 32768; // 32Kb
|
|
sl@0
|
747 |
HBufC8* buf = HBufC8::NewL(KBufLen);
|
|
sl@0
|
748 |
TPtr8 dataPtr = buf->Des();
|
|
sl@0
|
749 |
dataPtr.SetLength(KBufLen);
|
|
sl@0
|
750 |
dataPtr.Fill('A', KBufLen);
|
|
sl@0
|
751 |
|
|
sl@0
|
752 |
CreateTestDb();
|
|
sl@0
|
753 |
InsertZeroBlob(); // insert zeroblob of "TheBlobSize" size
|
|
sl@0
|
754 |
|
|
sl@0
|
755 |
RSqlBlobWriteStream strm;
|
|
sl@0
|
756 |
strm.OpenL(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
757 |
|
|
sl@0
|
758 |
// Sequentially write 32Kb blocks of data to the
|
|
sl@0
|
759 |
// blob until the 1Mb cache is full and writes to the disk begin.
|
|
sl@0
|
760 |
// 32 * 32Kb = 1Mb = soft heap limit
|
|
sl@0
|
761 |
const TInt KItCount = TheBlobSize / KBufLen - 1;
|
|
sl@0
|
762 |
for(TInt i = 1; i <= KItCount; ++i)
|
|
sl@0
|
763 |
{
|
|
sl@0
|
764 |
TheTest.Printf(_L("***Iteration %d\r\n"), i);
|
|
sl@0
|
765 |
|
|
sl@0
|
766 |
PrintFileSize(TheDb);
|
|
sl@0
|
767 |
|
|
sl@0
|
768 |
TTimeIntervalMicroSeconds writeTime;
|
|
sl@0
|
769 |
TTime t1, t2;
|
|
sl@0
|
770 |
|
|
sl@0
|
771 |
t1.HomeTime();
|
|
sl@0
|
772 |
strm.WriteL(dataPtr);
|
|
sl@0
|
773 |
t2.HomeTime();
|
|
sl@0
|
774 |
|
|
sl@0
|
775 |
writeTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
776 |
|
|
sl@0
|
777 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), writeTime, TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
778 |
PrintFileSize(TheDb);
|
|
sl@0
|
779 |
}
|
|
sl@0
|
780 |
|
|
sl@0
|
781 |
TTimeIntervalMicroSeconds commitTime;
|
|
sl@0
|
782 |
TTime t3, t4;
|
|
sl@0
|
783 |
t3.HomeTime();
|
|
sl@0
|
784 |
strm.CommitL();
|
|
sl@0
|
785 |
t4.HomeTime();
|
|
sl@0
|
786 |
commitTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
787 |
|
|
sl@0
|
788 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), TTimeIntervalMicroSeconds(0), commitTime);
|
|
sl@0
|
789 |
PrintFileSize(TheDb);
|
|
sl@0
|
790 |
|
|
sl@0
|
791 |
strm.Close();
|
|
sl@0
|
792 |
TheDb.Close();
|
|
sl@0
|
793 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
794 |
|
|
sl@0
|
795 |
delete buf;
|
|
sl@0
|
796 |
}
|
|
sl@0
|
797 |
|
|
sl@0
|
798 |
/**
|
|
sl@0
|
799 |
@SYMTestCaseID SYSLIB-SQL-UT-4116
|
|
sl@0
|
800 |
@SYMTestCaseDesc SQL, transaction sequential BLOB writes, performance tests.
|
|
sl@0
|
801 |
Tests sequentially writing 32Kb blocks to a 1.125Mb blob
|
|
sl@0
|
802 |
within a transaction, using the new RSqlBlobWriteStream APIs,
|
|
sl@0
|
803 |
to examine the write performance at different stages in the
|
|
sl@0
|
804 |
sequence.
|
|
sl@0
|
805 |
@SYMTestPriority Medium
|
|
sl@0
|
806 |
@SYMTestActions Sequential writing of a blob within a transactions, using the
|
|
sl@0
|
807 |
new RSqlBlobWriteStream APIs.
|
|
sl@0
|
808 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
809 |
@SYMREQ REQ5912
|
|
sl@0
|
810 |
*/
|
|
sl@0
|
811 |
void TransSequentialWriteTestL()
|
|
sl@0
|
812 |
{
|
|
sl@0
|
813 |
const TInt KBufLen = 32768; // 32Kb
|
|
sl@0
|
814 |
HBufC8* buf = HBufC8::NewL(KBufLen);
|
|
sl@0
|
815 |
TPtr8 dataPtr = buf->Des();
|
|
sl@0
|
816 |
dataPtr.SetLength(KBufLen);
|
|
sl@0
|
817 |
dataPtr.Fill('A', KBufLen);
|
|
sl@0
|
818 |
|
|
sl@0
|
819 |
CreateTestDb();
|
|
sl@0
|
820 |
InsertZeroBlob(); // insert zeroblob of "TheBlobSize" size
|
|
sl@0
|
821 |
|
|
sl@0
|
822 |
RSqlBlobWriteStream strm;
|
|
sl@0
|
823 |
strm.OpenL(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
824 |
|
|
sl@0
|
825 |
TInt err = TheDb.Exec(_L8("BEGIN"));
|
|
sl@0
|
826 |
TEST(err >= 0);
|
|
sl@0
|
827 |
|
|
sl@0
|
828 |
// Sequentially write 32Kb blocks of data to the
|
|
sl@0
|
829 |
// blob until the 1Mb cache is full and writes to the disk begin.
|
|
sl@0
|
830 |
// 32 * 32Kb = 1Mb = soft heap limit
|
|
sl@0
|
831 |
const TInt KItCount = TheBlobSize / KBufLen - 1;
|
|
sl@0
|
832 |
for(TInt i = 1; i <= KItCount; ++i)
|
|
sl@0
|
833 |
{
|
|
sl@0
|
834 |
TheTest.Printf(_L("***Iteration %d\r\n"), i);
|
|
sl@0
|
835 |
|
|
sl@0
|
836 |
PrintFileSize(TheDb);
|
|
sl@0
|
837 |
|
|
sl@0
|
838 |
TTimeIntervalMicroSeconds writeTime;
|
|
sl@0
|
839 |
TTime t1, t2;
|
|
sl@0
|
840 |
|
|
sl@0
|
841 |
t1.HomeTime();
|
|
sl@0
|
842 |
strm.WriteL(dataPtr);
|
|
sl@0
|
843 |
t2.HomeTime();
|
|
sl@0
|
844 |
|
|
sl@0
|
845 |
writeTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
846 |
|
|
sl@0
|
847 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), writeTime, TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
848 |
PrintFileSize(TheDb);
|
|
sl@0
|
849 |
}
|
|
sl@0
|
850 |
|
|
sl@0
|
851 |
TTimeIntervalMicroSeconds commitTime;
|
|
sl@0
|
852 |
TTime t3, t4;
|
|
sl@0
|
853 |
|
|
sl@0
|
854 |
t3.HomeTime();
|
|
sl@0
|
855 |
strm.CommitL();
|
|
sl@0
|
856 |
t4.HomeTime();
|
|
sl@0
|
857 |
commitTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
858 |
|
|
sl@0
|
859 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), TTimeIntervalMicroSeconds(0), commitTime);
|
|
sl@0
|
860 |
PrintFileSize(TheDb);
|
|
sl@0
|
861 |
|
|
sl@0
|
862 |
TTime t5, t6;
|
|
sl@0
|
863 |
t5.HomeTime();
|
|
sl@0
|
864 |
err = TheDb.Exec(_L8("COMMIT"));
|
|
sl@0
|
865 |
t6.HomeTime();
|
|
sl@0
|
866 |
TEST(err >= 0);
|
|
sl@0
|
867 |
|
|
sl@0
|
868 |
TTimeIntervalMicroSeconds transCommitTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
869 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), TTimeIntervalMicroSeconds(0), transCommitTime);
|
|
sl@0
|
870 |
PrintFileSize(TheDb);
|
|
sl@0
|
871 |
|
|
sl@0
|
872 |
strm.Close();
|
|
sl@0
|
873 |
TheDb.Close();
|
|
sl@0
|
874 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
875 |
|
|
sl@0
|
876 |
delete buf;
|
|
sl@0
|
877 |
}
|
|
sl@0
|
878 |
|
|
sl@0
|
879 |
/**
|
|
sl@0
|
880 |
@SYMTestCaseID SYSLIB-SQL-UT-4117
|
|
sl@0
|
881 |
@SYMTestCaseDesc SQL, whole BLOB write, performance tests.
|
|
sl@0
|
882 |
Tests writing a 256Kb data block to a 256Kb blob to examine the
|
|
sl@0
|
883 |
relative performance of the TSqlBlob and RSqlBlobWriteStream APIs.
|
|
sl@0
|
884 |
@SYMTestPriority Medium
|
|
sl@0
|
885 |
@SYMTestActions Whole update of a blob using the new TSqlBlob and RSqlBlobWriteStream APIs.
|
|
sl@0
|
886 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
887 |
@SYMREQ REQ5912
|
|
sl@0
|
888 |
*/
|
|
sl@0
|
889 |
void WholeWriteTestL()
|
|
sl@0
|
890 |
{
|
|
sl@0
|
891 |
TInt bufLen = TheBlobSize;
|
|
sl@0
|
892 |
HBufC8* buf = HBufC8::NewL(bufLen);
|
|
sl@0
|
893 |
TPtr8 dataPtr = buf->Des();
|
|
sl@0
|
894 |
dataPtr.SetLength(bufLen);
|
|
sl@0
|
895 |
dataPtr.Fill('Z', bufLen);
|
|
sl@0
|
896 |
|
|
sl@0
|
897 |
CreateTestDb();
|
|
sl@0
|
898 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
899 |
|
|
sl@0
|
900 |
TheTest.Printf(_L("***WholeWriteTestL - %dKb blob \r\n"), TheBlobSize / 1024);
|
|
sl@0
|
901 |
PrintFileSize(TheDb);
|
|
sl@0
|
902 |
|
|
sl@0
|
903 |
// TSqlBlob::Set
|
|
sl@0
|
904 |
TTimeIntervalMicroSeconds writeTime;
|
|
sl@0
|
905 |
TTime t1, t2, t3, t4;
|
|
sl@0
|
906 |
|
|
sl@0
|
907 |
t1.HomeTime();
|
|
sl@0
|
908 |
TSqlBlob::SetL(TheDb, _L("A"), _L("B"), dataPtr);
|
|
sl@0
|
909 |
t2.HomeTime();
|
|
sl@0
|
910 |
|
|
sl@0
|
911 |
writeTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
912 |
|
|
sl@0
|
913 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), writeTime, TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
914 |
PrintFileSize(TheDb);
|
|
sl@0
|
915 |
|
|
sl@0
|
916 |
// to avoid caching issues, close and re-create the database for the next part
|
|
sl@0
|
917 |
TheDb.Close();
|
|
sl@0
|
918 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
919 |
CreateTestDb();
|
|
sl@0
|
920 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
921 |
PrintFileSize(TheDb);
|
|
sl@0
|
922 |
|
|
sl@0
|
923 |
// RSqlBlobWriteStream::WriteL
|
|
sl@0
|
924 |
t3.HomeTime();
|
|
sl@0
|
925 |
RSqlBlobWriteStream strm;
|
|
sl@0
|
926 |
CleanupClosePushL(strm);
|
|
sl@0
|
927 |
strm.OpenL(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
928 |
strm.WriteL(dataPtr);
|
|
sl@0
|
929 |
CleanupStack::PopAndDestroy(&strm);
|
|
sl@0
|
930 |
t4.HomeTime();
|
|
sl@0
|
931 |
|
|
sl@0
|
932 |
writeTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
933 |
|
|
sl@0
|
934 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), writeTime, TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
935 |
PrintFileSize(TheDb);
|
|
sl@0
|
936 |
|
|
sl@0
|
937 |
TheDb.Close();
|
|
sl@0
|
938 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
939 |
|
|
sl@0
|
940 |
delete buf;
|
|
sl@0
|
941 |
}
|
|
sl@0
|
942 |
|
|
sl@0
|
943 |
/**
|
|
sl@0
|
944 |
@SYMTestCaseID SYSLIB-SQL-UT-4118
|
|
sl@0
|
945 |
@SYMTestCaseDesc SQL, transaction whole BLOB write, performance tests.
|
|
sl@0
|
946 |
Tests writing a 256Kb data block to a 256Kb blob, within a transaction,
|
|
sl@0
|
947 |
to examine the relative performance of the TSqlBlob and RSqlBlobWriteStream APIs.
|
|
sl@0
|
948 |
@SYMTestPriority Medium
|
|
sl@0
|
949 |
@SYMTestActions Whole update of a blob, within a transaction, using the new TSqlBlob and
|
|
sl@0
|
950 |
RSqlBlobWriteStream APIs.
|
|
sl@0
|
951 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
952 |
@SYMREQ REQ5912
|
|
sl@0
|
953 |
*/
|
|
sl@0
|
954 |
void TransWholeWriteTestL()
|
|
sl@0
|
955 |
{
|
|
sl@0
|
956 |
TInt bufLen = TheBlobSize;
|
|
sl@0
|
957 |
HBufC8* buf = HBufC8::NewL(bufLen);
|
|
sl@0
|
958 |
TPtr8 dataPtr = buf->Des();
|
|
sl@0
|
959 |
dataPtr.SetLength(bufLen);
|
|
sl@0
|
960 |
dataPtr.Fill('Z', bufLen);
|
|
sl@0
|
961 |
|
|
sl@0
|
962 |
CreateTestDb();
|
|
sl@0
|
963 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
964 |
|
|
sl@0
|
965 |
TheTest.Printf(_L("***TransWholeWriteTestL - %dKb blob\r\n"), TheBlobSize / 1024);
|
|
sl@0
|
966 |
PrintFileSize(TheDb);
|
|
sl@0
|
967 |
|
|
sl@0
|
968 |
// TSqlBlob::Set
|
|
sl@0
|
969 |
TTimeIntervalMicroSeconds writeTime;
|
|
sl@0
|
970 |
TTime t1, t2, t3, t4;
|
|
sl@0
|
971 |
|
|
sl@0
|
972 |
t1.HomeTime();
|
|
sl@0
|
973 |
TInt err = TheDb.Exec(_L8("BEGIN"));
|
|
sl@0
|
974 |
TEST(err >= 0);
|
|
sl@0
|
975 |
TSqlBlob::SetL(TheDb, _L("A"), _L("B"), dataPtr);
|
|
sl@0
|
976 |
err = TheDb.Exec(_L8("COMMIT"));
|
|
sl@0
|
977 |
t2.HomeTime();
|
|
sl@0
|
978 |
TEST(err >= 0);
|
|
sl@0
|
979 |
|
|
sl@0
|
980 |
writeTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
981 |
|
|
sl@0
|
982 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), writeTime, TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
983 |
PrintFileSize(TheDb);
|
|
sl@0
|
984 |
|
|
sl@0
|
985 |
// to avoid caching issues, close and re-create the database for the next part
|
|
sl@0
|
986 |
TheDb.Close();
|
|
sl@0
|
987 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
988 |
CreateTestDb();
|
|
sl@0
|
989 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
990 |
PrintFileSize(TheDb);
|
|
sl@0
|
991 |
|
|
sl@0
|
992 |
// RSqlBlobWriteStream::WriteL
|
|
sl@0
|
993 |
t3.HomeTime();
|
|
sl@0
|
994 |
err = TheDb.Exec(_L8("BEGIN"));
|
|
sl@0
|
995 |
TEST(err >= 0);
|
|
sl@0
|
996 |
RSqlBlobWriteStream strm;
|
|
sl@0
|
997 |
CleanupClosePushL(strm);
|
|
sl@0
|
998 |
strm.OpenL(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
999 |
strm.WriteL(dataPtr);
|
|
sl@0
|
1000 |
CleanupStack::PopAndDestroy(&strm);
|
|
sl@0
|
1001 |
err = TheDb.Exec(_L8("COMMIT"));
|
|
sl@0
|
1002 |
t4.HomeTime();
|
|
sl@0
|
1003 |
TEST(err >= 0);
|
|
sl@0
|
1004 |
|
|
sl@0
|
1005 |
writeTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
1006 |
|
|
sl@0
|
1007 |
PrintWriteTime(TTimeIntervalMicroSeconds(0), writeTime, TTimeIntervalMicroSeconds(0));
|
|
sl@0
|
1008 |
PrintFileSize(TheDb);
|
|
sl@0
|
1009 |
|
|
sl@0
|
1010 |
TheDb.Close();
|
|
sl@0
|
1011 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
1012 |
|
|
sl@0
|
1013 |
delete buf;
|
|
sl@0
|
1014 |
}
|
|
sl@0
|
1015 |
|
|
sl@0
|
1016 |
/**
|
|
sl@0
|
1017 |
@SYMTestCaseID SYSLIB-SQL-UT-4119
|
|
sl@0
|
1018 |
@SYMTestCaseDesc SQL, whole BLOB read, performance tests.
|
|
sl@0
|
1019 |
Tests reading a 256Kb blob in one block to examine the
|
|
sl@0
|
1020 |
relative performance of the TSqlBlob and RSqlBlobReadStream APIs.
|
|
sl@0
|
1021 |
@SYMTestPriority Medium
|
|
sl@0
|
1022 |
@SYMTestActions Whole retrieval of a blob using the new TSqlBlob and RSqlBlobReadStream APIs.
|
|
sl@0
|
1023 |
@SYMTestExpectedResults Test must not fail
|
|
sl@0
|
1024 |
@SYMREQ REQ5912
|
|
sl@0
|
1025 |
*/
|
|
sl@0
|
1026 |
void WholeReadTestL()
|
|
sl@0
|
1027 |
{
|
|
sl@0
|
1028 |
TInt bufLen = TheBlobSize;
|
|
sl@0
|
1029 |
HBufC8* buf = HBufC8::NewL(bufLen);
|
|
sl@0
|
1030 |
TPtr8 dataPtr = buf->Des();
|
|
sl@0
|
1031 |
dataPtr.SetLength(bufLen);
|
|
sl@0
|
1032 |
dataPtr.Fill('A', bufLen);
|
|
sl@0
|
1033 |
|
|
sl@0
|
1034 |
CreateTestDb();
|
|
sl@0
|
1035 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
1036 |
|
|
sl@0
|
1037 |
TheTest.Printf(_L("***WholeReadTestL - %dKb blob \r\n"), TheBlobSize / 1024);
|
|
sl@0
|
1038 |
PrintFileSize(TheDb);
|
|
sl@0
|
1039 |
|
|
sl@0
|
1040 |
// TSqlBlob::GetLC
|
|
sl@0
|
1041 |
TTimeIntervalMicroSeconds readTime;
|
|
sl@0
|
1042 |
TTime t1, t2, t3, t4, t5, t6;
|
|
sl@0
|
1043 |
|
|
sl@0
|
1044 |
t1.HomeTime();
|
|
sl@0
|
1045 |
HBufC8* readBuf = TSqlBlob::GetLC(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
1046 |
t2.HomeTime();
|
|
sl@0
|
1047 |
TEST(readBuf->Des().Compare(buf->Des()) == 0);
|
|
sl@0
|
1048 |
|
|
sl@0
|
1049 |
readTime = t2.MicroSecondsFrom(t1);
|
|
sl@0
|
1050 |
|
|
sl@0
|
1051 |
PrintReadTime(TTimeIntervalMicroSeconds(0), readTime);
|
|
sl@0
|
1052 |
PrintFileSize(TheDb);
|
|
sl@0
|
1053 |
CleanupStack::PopAndDestroy(readBuf);
|
|
sl@0
|
1054 |
|
|
sl@0
|
1055 |
// to avoid caching issues, close and re-create the database for the next part
|
|
sl@0
|
1056 |
TheDb.Close();
|
|
sl@0
|
1057 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
1058 |
CreateTestDb();
|
|
sl@0
|
1059 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
1060 |
PrintFileSize(TheDb);
|
|
sl@0
|
1061 |
|
|
sl@0
|
1062 |
// TSqlBlob::Get
|
|
sl@0
|
1063 |
HBufC8* preBuf = HBufC8::NewLC(bufLen);
|
|
sl@0
|
1064 |
TPtr8 preBufPtr(preBuf->Des());
|
|
sl@0
|
1065 |
t3.HomeTime();
|
|
sl@0
|
1066 |
TInt err = TSqlBlob::Get(TheDb, _L("A"), _L("B"), preBufPtr);
|
|
sl@0
|
1067 |
t4.HomeTime();
|
|
sl@0
|
1068 |
TEST2(err, KErrNone);
|
|
sl@0
|
1069 |
TEST(preBufPtr.Compare(buf->Des()) == 0);
|
|
sl@0
|
1070 |
|
|
sl@0
|
1071 |
readTime = t4.MicroSecondsFrom(t3);
|
|
sl@0
|
1072 |
|
|
sl@0
|
1073 |
PrintReadTime(TTimeIntervalMicroSeconds(0), readTime);
|
|
sl@0
|
1074 |
PrintFileSize(TheDb);
|
|
sl@0
|
1075 |
CleanupStack::PopAndDestroy(preBuf);
|
|
sl@0
|
1076 |
|
|
sl@0
|
1077 |
// to avoid caching issues, close and re-create the database for the next part
|
|
sl@0
|
1078 |
TheDb.Close();
|
|
sl@0
|
1079 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
1080 |
CreateTestDb();
|
|
sl@0
|
1081 |
InsertRealBlob(); // insert blob of "TheBlobSize" size
|
|
sl@0
|
1082 |
PrintFileSize(TheDb);
|
|
sl@0
|
1083 |
|
|
sl@0
|
1084 |
// RSqlBlobReadStream::ReadL
|
|
sl@0
|
1085 |
preBuf = HBufC8::NewLC(bufLen);
|
|
sl@0
|
1086 |
TPtr8 preBufP(preBuf->Des());
|
|
sl@0
|
1087 |
t5.HomeTime();
|
|
sl@0
|
1088 |
RSqlBlobReadStream strm;
|
|
sl@0
|
1089 |
CleanupClosePushL(strm);
|
|
sl@0
|
1090 |
strm.OpenL(TheDb, _L("A"), _L("B"));
|
|
sl@0
|
1091 |
strm.ReadL(preBufP, bufLen);
|
|
sl@0
|
1092 |
CleanupStack::PopAndDestroy(&strm);
|
|
sl@0
|
1093 |
t6.HomeTime();
|
|
sl@0
|
1094 |
TEST(preBufP.Compare(buf->Des()) == 0);
|
|
sl@0
|
1095 |
|
|
sl@0
|
1096 |
readTime = t6.MicroSecondsFrom(t5);
|
|
sl@0
|
1097 |
|
|
sl@0
|
1098 |
PrintReadTime(TTimeIntervalMicroSeconds(0), readTime);
|
|
sl@0
|
1099 |
PrintFileSize(TheDb);
|
|
sl@0
|
1100 |
CleanupStack::PopAndDestroy(preBuf);
|
|
sl@0
|
1101 |
|
|
sl@0
|
1102 |
TheDb.Close();
|
|
sl@0
|
1103 |
(void)RSqlDatabase::Delete(TheDbFileName);
|
|
sl@0
|
1104 |
|
|
sl@0
|
1105 |
delete buf;
|
|
sl@0
|
1106 |
}
|
|
sl@0
|
1107 |
///////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
1108 |
///////////////////////////////////////////////////////////////////////////////////
|
|
sl@0
|
1109 |
|
|
sl@0
|
1110 |
void DoTests()
|
|
sl@0
|
1111 |
{
|
|
sl@0
|
1112 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4084 SQL, BLOB write, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1113 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1114 |
TheTest.Start(TheTestTitle);
|
|
sl@0
|
1115 |
BlobWriteTest();
|
|
sl@0
|
1116 |
|
|
sl@0
|
1117 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4085 SQL, BLOB read, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1118 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1119 |
TheTest.Next(TheTestTitle);
|
|
sl@0
|
1120 |
BlobReadTest();
|
|
sl@0
|
1121 |
|
|
sl@0
|
1122 |
TheTest.Printf(_L("==================================================================\r\n"));
|
|
sl@0
|
1123 |
|
|
sl@0
|
1124 |
// Bigger blob tests - only on hardware, release mode
|
|
sl@0
|
1125 |
#if !defined __WINS__ && !defined __WINSCW__ && !defined _DEBUG
|
|
sl@0
|
1126 |
|
|
sl@0
|
1127 |
TheBlobSize = 1024 * 1024 + 128 * 1024;//1.125Mb
|
|
sl@0
|
1128 |
|
|
sl@0
|
1129 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4115 SQL, sequential BLOB writes, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1130 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1131 |
TheTest.Next(TheTestTitle);
|
|
sl@0
|
1132 |
TRAPD(err, SequentialWriteTestL());
|
|
sl@0
|
1133 |
TEST2(err, KErrNone);
|
|
sl@0
|
1134 |
|
|
sl@0
|
1135 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4116 SQL, transaction sequential BLOB writes, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1136 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1137 |
TheTest.Next(TheTestTitle);
|
|
sl@0
|
1138 |
TRAP(err, TransSequentialWriteTestL());
|
|
sl@0
|
1139 |
TEST2(err, KErrNone);
|
|
sl@0
|
1140 |
|
|
sl@0
|
1141 |
TheBlobSize = 256 * 1024 ; // 256Kb
|
|
sl@0
|
1142 |
|
|
sl@0
|
1143 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4117 SQL, whole BLOB write, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1144 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1145 |
TheTest.Next(TheTestTitle);
|
|
sl@0
|
1146 |
TRAP(err, WholeWriteTestL());
|
|
sl@0
|
1147 |
TEST2(err, KErrNone);
|
|
sl@0
|
1148 |
|
|
sl@0
|
1149 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4118 SQL, transaction whole BLOB write, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1150 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1151 |
TheTest.Next(TheTestTitle);
|
|
sl@0
|
1152 |
TRAP(err, TransWholeWriteTestL());
|
|
sl@0
|
1153 |
TEST2(err, KErrNone);
|
|
sl@0
|
1154 |
|
|
sl@0
|
1155 |
TheTestTitle.Format(_L("@SYMTestCaseID:SYSLIB-SQL-UT-4119 SQL, whole BLOB read, performance tests, encoding: \"%S\", page size: %d\r\n"),
|
|
sl@0
|
1156 |
TheCmdLineParams.iDbEncoding == TCmdLineParams::EDbUtf16 ? &KUtf16 : &KUtf8, TheCmdLineParams.iPageSize);
|
|
sl@0
|
1157 |
TheTest.Next(TheTestTitle);
|
|
sl@0
|
1158 |
TRAP(err, WholeReadTestL());
|
|
sl@0
|
1159 |
TEST2(err, KErrNone);
|
|
sl@0
|
1160 |
|
|
sl@0
|
1161 |
#endif//!defined __WINS__ && !defined __WINSCW__ && !defined _DEBUG
|
|
sl@0
|
1162 |
}
|
|
sl@0
|
1163 |
|
|
sl@0
|
1164 |
TInt E32Main()
|
|
sl@0
|
1165 |
{
|
|
sl@0
|
1166 |
TheTest.Title();
|
|
sl@0
|
1167 |
|
|
sl@0
|
1168 |
CTrapCleanup* tc = CTrapCleanup::New();
|
|
sl@0
|
1169 |
TheTest(tc != NULL);
|
|
sl@0
|
1170 |
|
|
sl@0
|
1171 |
__UHEAP_MARK;
|
|
sl@0
|
1172 |
|
|
sl@0
|
1173 |
GetCmdLineParamsAndSqlConfigString(TheTest, _L("t_sqlperformance2"), TheCmdLineParams, TheSqlConfigString);
|
|
sl@0
|
1174 |
_LIT(KDbName, "c:\\test\\t_sqlperformance2.db");
|
|
sl@0
|
1175 |
PrepareDbName(KDbName, TheCmdLineParams.iDriveName, TheDbFileName);
|
|
sl@0
|
1176 |
|
|
sl@0
|
1177 |
TheTest.Printf(_L("==Databases: %S\r\n"), &TheDbFileName);
|
|
sl@0
|
1178 |
|
|
sl@0
|
1179 |
TestEnvInit();
|
|
sl@0
|
1180 |
DoTests();
|
|
sl@0
|
1181 |
TestEnvDestroy();
|
|
sl@0
|
1182 |
|
|
sl@0
|
1183 |
__UHEAP_MARKEND;
|
|
sl@0
|
1184 |
|
|
sl@0
|
1185 |
TheTest.End();
|
|
sl@0
|
1186 |
TheTest.Close();
|
|
sl@0
|
1187 |
|
|
sl@0
|
1188 |
delete tc;
|
|
sl@0
|
1189 |
|
|
sl@0
|
1190 |
User::Heap().Check();
|
|
sl@0
|
1191 |
return KErrNone;
|
|
sl@0
|
1192 |
}
|
|
sl@0
|
1193 |
|
|
sl@0
|
1194 |
|