1172 CloseTestDb(); |
1172 CloseTestDb(); |
1173 } |
1173 } |
1174 |
1174 |
1175 void SelectLikeQueryPerfTest() |
1175 void SelectLikeQueryPerfTest() |
1176 { |
1176 { |
1177 _LIT(KTestDatabase1, "c:\\test\\t_sqldefect_1.db"); |
|
1178 |
|
1179 _LIT8(KServerConfigString1, "encoding = \"UTF-8\""); |
1177 _LIT8(KServerConfigString1, "encoding = \"UTF-8\""); |
1180 //create a sql db file |
1178 //create a sql db file |
1181 (void)RSqlDatabase::Delete(KTestDatabase1); |
1179 (void)RSqlDatabase::Delete(TheNonSecureDbName); |
1182 TInt err = TheDb.Create(KTestDatabase1, &KServerConfigString1); |
1180 TInt err = TheDb.Create(TheNonSecureDbName, &KServerConfigString1); |
1183 TEST2(err, KErrNone); |
1181 TEST2(err, KErrNone); |
1184 |
1182 |
1185 //Create a test table and insert some records |
1183 //Create a test table and insert some records |
1186 err = TheDb.Exec(_L("CREATE TABLE A(Id INTEGER PRIMARY KEY, Name TEXT)")); |
1184 err = TheDb.Exec(_L("CREATE TABLE A(Id INTEGER PRIMARY KEY, Name TEXT)")); |
1187 TEST(err >= 0); |
1185 TEST(err >= 0); |
1188 |
1186 |
1189 //Add 100 records to the table |
1187 //Add 100 records to the table |
1190 for(TInt k=0;k<100;++k) |
1188 for(TInt k=0;k<100;++k) |
1191 { |
1189 { |
1192 TBuf<100> sql; |
1190 TBuf<100> sql; |
1193 sql.Format(_L("INSERT INTO A VALUES(%d, 'Dvorák')"), k + 1); |
1191 sql.Format(_L("INSERT INTO A VALUES(%d, 'Dvorák')"), k + 1); |
1194 err = TheDb.Exec(sql); |
1192 err = TheDb.Exec(sql); |
1195 TEST2(err, 1); |
1193 TEST2(err, 1); |
1196 } |
1194 } |
1197 |
1195 |
1198 //Update one record |
1196 //Update one record |
1199 err = TheDb.Exec(_L("UPDATE A SET Name='dvorak1' WHERE ID = 50")); |
1197 err = TheDb.Exec(_L("UPDATE A SET Name='dvorak1' WHERE ID = 50")); |
1200 TEST2(err, 1); |
1198 TEST2(err, 1); |
1201 |
1199 |
1216 TUint32 end = User::FastCounter(); |
1214 TUint32 end = User::FastCounter(); |
1217 TEST2(err, 1); |
1215 TEST2(err, 1); |
1218 PrintStats(start, end); |
1216 PrintStats(start, end); |
1219 |
1217 |
1220 TheDb.Close(); |
1218 TheDb.Close(); |
1221 (void)RSqlDatabase::Delete(KTestDatabase1); |
1219 (void)RSqlDatabase::Delete(TheNonSecureDbName); |
1222 } |
1220 } |
1223 |
1221 |
1224 /////////////////////////////////////////////////////////////////////////////////// |
1222 /////////////////////////////////////////////////////////////////////////////////// |
1225 /////////////////////////////////////////////////////////////////////////////////// |
1223 /////////////////////////////////////////////////////////////////////////////////// |
1226 |
1224 |