1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/t_sqlconfig.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,720 @@
1.4 +// Copyright (c) 2007-2010 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 <e32test.h>
1.20 +#include <bautils.h>
1.21 +#include <sqldb.h>
1.22 +#include "SqlSrvConfig.h"
1.23 +
1.24 +///////////////////////////////////////////////////////////////////////////////////////
1.25 +
1.26 +RTest TheTest(_L("t_sqlconfig test"));
1.27 +_LIT(KTestDir, "c:\\test\\");
1.28 +_LIT(KTestDbName, "c:\\test\\t_sqlconfig_1.db");
1.29 +_LIT(KTestDbName2, "c:\\test\\t_sqlconfig_2.db");
1.30 +_LIT(KTestDbName3, "c:[1111C1C1]t_sqlconfig_3.db");
1.31 +_LIT(KTestDbName4, "c:\\private\\1111C1C1\\t_sqlconfig_4.db");
1.32 +_LIT(KSqlSrvConfigFile, "c:\\test\\t_sqlserver.cfg");
1.33 +RFs TheFs;
1.34 +RSqlDatabase TheDb;
1.35 +RSqlDatabase TheDb2;
1.36 +
1.37 +enum TConfigParamType {EPrmCacheSize, EPrmPageSize, EPrmDbEncoding};
1.38 +
1.39 +//Default (build-time) configuration parameter values
1.40 +const TInt KDefaultPageSize = 1024;
1.41 +const TInt KDefaultCacheSize = (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / KDefaultPageSize;
1.42 +const TSqlSrvConfigParams::TDbEncoding KDefaultEncoding = TSqlSrvConfigParams::EEncUtf16;
1.43 +
1.44 +///////////////////////////////////////////////////////////////////////////////////////
1.45 +
1.46 +void DestroyTestEnv()
1.47 + {
1.48 + TheDb2.Close();
1.49 + TheDb.Close();
1.50 + (void)RSqlDatabase::Delete(KTestDbName4);
1.51 + (void)RSqlDatabase::Delete(KTestDbName3);
1.52 + (void)RSqlDatabase::Delete(KTestDbName2);
1.53 + (void)RSqlDatabase::Delete(KTestDbName);
1.54 + (void)TheFs.Delete(KSqlSrvConfigFile);
1.55 + TheFs.Close();
1.56 + }
1.57 +
1.58 +///////////////////////////////////////////////////////////////////////////////////////
1.59 +///////////////////////////////////////////////////////////////////////////////////////
1.60 +//Test macros and functions
1.61 +void Check(TInt aValue, TInt aLine)
1.62 + {
1.63 + if(!aValue)
1.64 + {
1.65 + DestroyTestEnv();
1.66 + TheTest(EFalse, aLine);
1.67 + }
1.68 + }
1.69 +void Check(TInt aValue, TInt aExpected, TInt aLine)
1.70 + {
1.71 + if(aValue != aExpected)
1.72 + {
1.73 + DestroyTestEnv();
1.74 + RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
1.75 + TheTest(EFalse, aLine);
1.76 + }
1.77 + }
1.78 +#define TEST(arg) ::Check((arg), __LINE__)
1.79 +#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
1.80 +
1.81 +///////////////////////////////////////////////////////////////////////////////////////
1.82 +
1.83 +void SetupTestEnv()
1.84 + {
1.85 + TInt err = TheFs.Connect();
1.86 + TEST2(err, KErrNone);
1.87 +
1.88 + err = TheFs.MkDir(KTestDir);
1.89 + TEST(err == KErrNone || err == KErrAlreadyExists);
1.90 +
1.91 + err = TheFs.CreatePrivatePath(EDriveC);
1.92 + TEST(err == KErrNone || err == KErrAlreadyExists);
1.93 +
1.94 + (void)RSqlDatabase::Delete(KTestDbName3);
1.95 + (void)RSqlDatabase::Delete(KTestDbName2);
1.96 + (void)RSqlDatabase::Delete(KTestDbName);
1.97 + (void)TheFs.Delete(KSqlSrvConfigFile);//The test does not work if there is a test config file.
1.98 + }
1.99 +
1.100 +TInt DoGetConfigParamValueL(RSqlDatabase& aDb, TConfigParamType aPrmType, const TDesC& aLogicalDbName = KNullDesC)
1.101 + {
1.102 + TBuf<100> sql;
1.103 + sql.Copy(_L("PRAGMA "));
1.104 + if(aLogicalDbName.Length() > 0)
1.105 + {
1.106 + sql.Append(aLogicalDbName);
1.107 + sql.Append(_L("."));
1.108 + }
1.109 +
1.110 + TSqlScalarFullSelectQuery q(aDb);
1.111 + TInt res = 0;
1.112 + switch(aPrmType)
1.113 + {
1.114 + case EPrmCacheSize:
1.115 + sql.Append(_L("cache_size"));
1.116 + res = q.SelectIntL(sql);
1.117 + break;
1.118 + case EPrmPageSize:
1.119 + sql.Append(_L("page_size"));
1.120 + res = q.SelectIntL(sql);
1.121 + break;
1.122 + case EPrmDbEncoding:
1.123 + {
1.124 + sql.Append(_L("encoding"));
1.125 + TBuf<20> dbEncodingText;
1.126 + res = q.SelectTextL(sql, dbEncodingText);
1.127 + TEST2(res, KErrNone);
1.128 + if(dbEncodingText.FindF(_L("UTF-16")) >= 0)
1.129 + {
1.130 + res = TSqlSrvConfigParams::EEncUtf16;
1.131 + }
1.132 + else if(dbEncodingText.FindF(_L("UTF-8")) >= 0)
1.133 + {
1.134 + res = TSqlSrvConfigParams::EEncUtf8;
1.135 + }
1.136 + else
1.137 + {
1.138 + TEST2(0, 1);
1.139 + }
1.140 + }
1.141 + break;
1.142 + default:
1.143 + TEST2(0, 1);
1.144 + break;
1.145 + }
1.146 + return res;
1.147 + }
1.148 +
1.149 +TInt GetConfigParamValue(RSqlDatabase& aDb, TConfigParamType aPrmType, const TDesC& aLogicalDbName = KNullDesC)
1.150 + {
1.151 + TInt res = 0;
1.152 + TRAPD(err, res = DoGetConfigParamValueL(aDb, aPrmType, aLogicalDbName));
1.153 + TEST2(err, KErrNone);
1.154 + return res;
1.155 + }
1.156 +
1.157 +void AssertConfigPrmValues(RSqlDatabase& aDb, TInt aExpectedCacheSize, TInt aExpectedPageSize, TInt aExpectedDbEncoding,
1.158 + const TDesC& aLogicalDbName = KNullDesC)
1.159 + {
1.160 + TInt cacheSize = GetConfigParamValue(aDb, EPrmCacheSize, aLogicalDbName);
1.161 + TInt pageSize = GetConfigParamValue(aDb, EPrmPageSize ,aLogicalDbName);
1.162 + TInt dbEncoding = GetConfigParamValue(aDb, EPrmDbEncoding, aLogicalDbName);
1.163 + TEST2(cacheSize, aExpectedCacheSize);
1.164 + TEST2(pageSize, aExpectedPageSize);
1.165 + TEST2(dbEncoding, aExpectedDbEncoding);
1.166 + }
1.167 +
1.168 +///////////////////////////////////////////////////////////////////////////////////////
1.169 +
1.170 +/**
1.171 +@SYMTestCaseID SYSLIB-SQL-UT-3436
1.172 +@SYMTestCaseDesc Test for DEF105928 "SQL server ignores config string parameters".
1.173 + The test attempts to create/open a database using different cache size/page size/
1.174 + database encoding configurations and then checks that the configuration parameters
1.175 + have been set properly and have the expected values.
1.176 +@SYMTestPriority High
1.177 +@SYMTestActions Test for DEF105928 "SQL server ignores config string parameters".
1.178 +@SYMTestExpectedResults The test must not fail
1.179 +@SYMDEF DEF105928
1.180 +*/
1.181 +void CfgFunctionalTest()
1.182 + {
1.183 + (void)RSqlDatabase::Delete(KTestDbName);
1.184 + //Create a database. No config string. The default config parameters will be used.
1.185 + TInt err = TheDb.Create(KTestDbName);
1.186 + TEST2(err, KErrNone);
1.187 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.188 + TheDb.Close();
1.189 + (void)RSqlDatabase::Delete(KTestDbName);
1.190 + //Create a database. Cache size set.
1.191 + _LIT8(KCfgStr1, "cache_size=32");
1.192 + err = TheDb.Create(KTestDbName, &KCfgStr1);
1.193 + TEST2(err, KErrNone);
1.194 + AssertConfigPrmValues(TheDb, 32, KDefaultPageSize, KDefaultEncoding);
1.195 + TheDb.Close();
1.196 + (void)RSqlDatabase::Delete(KTestDbName);
1.197 + //Create a database. Page size set.
1.198 + _LIT8(KCfgStr2, "page_size=2048");
1.199 + err = TheDb.Create(KTestDbName, &KCfgStr2);
1.200 + TEST2(err, KErrNone);
1.201 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 2048, 2048, KDefaultEncoding);
1.202 + TheDb.Close();
1.203 + (void)RSqlDatabase::Delete(KTestDbName);
1.204 + //Create a database. Cache & Page size set.
1.205 + _LIT8(KCfgStr3, "cache_size=256;page_size=4096");
1.206 + err = TheDb.Create(KTestDbName, &KCfgStr3);
1.207 + TEST2(err, KErrNone);
1.208 + AssertConfigPrmValues(TheDb, 256, 4096, KDefaultEncoding);
1.209 + TheDb.Close();
1.210 + (void)RSqlDatabase::Delete(KTestDbName);
1.211 + //Create a database. Cache size & Page size & db encoding set.
1.212 + _LIT8(KCfgStr4, "cache_size=512;page_size=512;encoding=UTF-8");
1.213 + err = TheDb.Create(KTestDbName, &KCfgStr4);
1.214 + TEST2(err, KErrNone);
1.215 + AssertConfigPrmValues(TheDb, 512, 512, TSqlSrvConfigParams::EEncUtf8);
1.216 + TheDb.Close();
1.217 + (void)RSqlDatabase::Delete(KTestDbName);
1.218 + //Create a database. Cache size & Page size & db encoding set.
1.219 + _LIT8(KCfgStr5, "cache_size=16;page_size=1024;encoding=UTF-16");
1.220 + err = TheDb.Create(KTestDbName, &KCfgStr5);
1.221 + TEST2(err, KErrNone);
1.222 + AssertConfigPrmValues(TheDb, 16, 1024, TSqlSrvConfigParams::EEncUtf16);
1.223 + TheDb.Close();
1.224 + //Open the database. Cache size set. The rest of parameter values must be the same as for KCfgStr5.
1.225 + _LIT8(KCfgStr6, "cache_size=80");
1.226 + err = TheDb.Open(KTestDbName, &KCfgStr6);
1.227 + TEST2(err, KErrNone);
1.228 + AssertConfigPrmValues(TheDb, 80, 1024, TSqlSrvConfigParams::EEncUtf16);
1.229 + TheDb.Close();
1.230 + //Open the database. Attempt to set the page size (impossible when opening a database).
1.231 + _LIT8(KCfgStr7, "page_size=2048");
1.232 + err = TheDb.Open(KTestDbName, &KCfgStr7);
1.233 + TEST2(err, KErrNone);
1.234 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, 1024, TSqlSrvConfigParams::EEncUtf16);
1.235 + TheDb.Close();
1.236 + //Open the database. Attempt to set the encoding (impossible when opening a database).
1.237 + _LIT8(KCfgStr8, "encoding=UTF-8");
1.238 + err = TheDb.Open(KTestDbName, &KCfgStr8);
1.239 + TEST2(err, KErrNone);
1.240 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, 1024, TSqlSrvConfigParams::EEncUtf16);
1.241 + TheDb.Close();
1.242 + (void)RSqlDatabase::Delete(KTestDbName);
1.243 + //Create a database. Empty config string - 1
1.244 + _LIT8(KCfgStr9, "");
1.245 + err = TheDb.Create(KTestDbName, &KCfgStr9);
1.246 + TEST2(err, KErrNone);
1.247 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.248 + TheDb.Close();
1.249 + (void)RSqlDatabase::Delete(KTestDbName);
1.250 + //Create a database. Empty config string - 2
1.251 + _LIT8(KCfgStr10, " ");
1.252 + err = TheDb.Create(KTestDbName, &KCfgStr10);
1.253 + TEST2(err, KErrNone);
1.254 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.255 + TheDb.Close();
1.256 + (void)RSqlDatabase::Delete(KTestDbName);
1.257 + //Create a database. Empty config string - 3
1.258 + _LIT8(KCfgStr11, " ; ; ;; ");
1.259 + err = TheDb.Create(KTestDbName, &KCfgStr11);
1.260 + TEST2(err, KErrNone);
1.261 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.262 + TheDb.Close();
1.263 + (void)RSqlDatabase::Delete(KTestDbName);
1.264 + }
1.265 +
1.266 +/**
1.267 +@SYMTestCaseID SYSLIB-SQL-UT-3437
1.268 +@SYMTestCaseDesc Test for DEF105928 "SQL server ignores config string parameters".
1.269 + The test attempts to create/open a database using invalid configuration strings,
1.270 + too long configuration string, string with missing parameter values, string with
1.271 + invalid database encodings. The test expects the SQL server will report a failure
1.272 + and will refuse to execute the operation.
1.273 +@SYMTestPriority High
1.274 +@SYMTestActions Test for DEF105928 "SQL server ignores config string parameters".
1.275 +@SYMTestExpectedResults The test must not fail
1.276 +@SYMDEF DEF105928
1.277 +*/
1.278 +void CfgNegativeTest()
1.279 + {
1.280 + //Create a database. Spelling problem in the parameter name. This is not reported as an error by the SQL server
1.281 + //(treated as unknown parameter)
1.282 + _LIT8(KCfgStr1, "casche_size = 32");
1.283 + TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
1.284 + TEST2(err, KErrNone);
1.285 + TheDb.Close();
1.286 + (void)RSqlDatabase::Delete(KTestDbName);
1.287 + //Create a database. Spelling problem in the parameter value.
1.288 + _LIT8(KCfgStr2, "encoding = UTF-32");
1.289 + err = TheDb.Create(KTestDbName, &KCfgStr2);
1.290 + TEST2(err, KErrNone);//Invalid encoding: KErrNone, but the encoding will not be used
1.291 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.292 + TheDb.Close();
1.293 + (void)RSqlDatabase::Delete(KTestDbName);
1.294 + //Create a database. Invalid config string.
1.295 + _LIT8(KCfgStr3, "dfgjkdfgkdfk; sfkgjhdfgjkdfk; dfgdfetrwer");
1.296 + err = TheDb.Create(KTestDbName, &KCfgStr3);
1.297 + TEST2(err, KErrArgument);
1.298 + TheDb.Close();
1.299 + (void)RSqlDatabase::Delete(KTestDbName);
1.300 + //Create a database. Too long and invalid config string.
1.301 + _LIT8(KCfgStr4, "A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789");
1.302 + err = TheDb.Create(KTestDbName, &KCfgStr4);
1.303 + TEST2(err, KErrArgument);
1.304 + TheDb.Close();
1.305 + (void)RSqlDatabase::Delete(KTestDbName);
1.306 + //Create a database. No parameter value - 1.
1.307 + _LIT8(KCfgStr5, "page_size=");
1.308 + err = TheDb.Create(KTestDbName, &KCfgStr5);
1.309 + TEST2(err, KErrArgument);
1.310 + TheDb.Close();
1.311 + (void)RSqlDatabase::Delete(KTestDbName);
1.312 + //Create a database. No parameter value - 2.
1.313 + _LIT8(KCfgStr6, "page_size=;");
1.314 + err = TheDb.Create(KTestDbName, &KCfgStr6);
1.315 + TEST2(err, KErrArgument);
1.316 + TheDb.Close();
1.317 + (void)RSqlDatabase::Delete(KTestDbName);
1.318 + //Create a database. Non-number parameter value - 1.
1.319 + _LIT8(KCfgStr7, "page_size=aaa;");
1.320 + err = TheDb.Create(KTestDbName, &KCfgStr7);
1.321 + TEST2(err, KErrArgument);
1.322 + TheDb.Close();
1.323 + (void)RSqlDatabase::Delete(KTestDbName);
1.324 + //Create a database. Non-number parameter value - 2.
1.325 + _LIT8(KCfgStr8, "cache_size=weyu34;");
1.326 + err = TheDb.Create(KTestDbName, &KCfgStr8);
1.327 + TEST2(err, KErrArgument);
1.328 + TheDb.Close();
1.329 + (void)RSqlDatabase::Delete(KTestDbName);
1.330 + //Create a database. "soft_heap_limit_kb" in the config string.
1.331 + _LIT8(KCfgStr9, "soft_heap_limit_kb=512;");
1.332 + err = TheDb.Create(KTestDbName, &KCfgStr9);
1.333 + TEST2(err, KErrArgument);
1.334 + TheDb.Close();
1.335 + (void)RSqlDatabase::Delete(KTestDbName);
1.336 + //Create a database. "free_space_threshold_kb" in the config string.
1.337 + _LIT8(KCfgStr10, "free_space_threshold_kb=256;");
1.338 + err = TheDb.Create(KTestDbName, &KCfgStr10);
1.339 + TEST2(err, KErrArgument);
1.340 + TheDb.Close();
1.341 + (void)RSqlDatabase::Delete(KTestDbName);
1.342 + }
1.343 +
1.344 +/**
1.345 +@SYMTestCaseID SYSLIB-SQL-UT-3438
1.346 +@SYMTestCaseDesc Test for DEF105928 "SQL server ignores config string parameters".
1.347 + The test attempts to create a database with configuration string containing:
1.348 + negative or zero page size and cache size, too small or too big page size,
1.349 + page size, not power of two. The test expects the SQL server will detect those
1.350 + invalid page size and cache size values and will refuse to execute the operation.
1.351 +@SYMTestPriority High
1.352 +@SYMTestActions Test for DEF105928 "SQL server ignores config string parameters".
1.353 +@SYMTestExpectedResults The test must not fail
1.354 +@SYMDEF DEF105928
1.355 +*/
1.356 +void CfgInvalidCacheAndPageSizeTest()
1.357 + {
1.358 + //Create a database. Page size < 512.
1.359 + _LIT8(KCfgStr1, "page_size=128;");
1.360 + TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
1.361 + TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
1.362 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.363 + TheDb.Close();
1.364 + (void)RSqlDatabase::Delete(KTestDbName);
1.365 + //Create a database. Page size > 32768.
1.366 + _LIT8(KCfgStr2, "page_size=65535;");
1.367 + err = TheDb.Create(KTestDbName, &KCfgStr2);
1.368 + TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
1.369 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.370 + TheDb.Close();
1.371 + (void)RSqlDatabase::Delete(KTestDbName);
1.372 + //Create a database. Page size is not power of two.
1.373 + _LIT8(KCfgStr3, "page_size=5000;");
1.374 + err = TheDb.Create(KTestDbName, &KCfgStr3);
1.375 + TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
1.376 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.377 + TheDb.Close();
1.378 + (void)RSqlDatabase::Delete(KTestDbName);
1.379 + //Create a database. Zero cache size.
1.380 + _LIT8(KCfgStr4, "cache_size=0");
1.381 + err = TheDb.Create(KTestDbName, &KCfgStr4);
1.382 + TEST2(err, KErrNone);
1.383 + AssertConfigPrmValues(TheDb, 0, KDefaultPageSize, KDefaultEncoding);
1.384 + TheDb.Close();
1.385 + (void)RSqlDatabase::Delete(KTestDbName);
1.386 + //Create a database. Negative cache size.
1.387 + _LIT8(KCfgStr5, "cache_size=-32");
1.388 + err = TheDb.Create(KTestDbName, &KCfgStr5);
1.389 + TEST2(err, KErrArgument);
1.390 + TheDb.Close();
1.391 + (void)RSqlDatabase::Delete(KTestDbName);
1.392 + //Create a database. Zero page size.
1.393 + _LIT8(KCfgStr6, "page_size=0");
1.394 + err = TheDb.Create(KTestDbName, &KCfgStr6);
1.395 + TEST2(err, KErrNone);//Invalid page size: KErrNone expected, but the page size will not be set
1.396 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.397 + TheDb.Close();
1.398 + (void)RSqlDatabase::Delete(KTestDbName);
1.399 + //Create a database. Negative page size.
1.400 + _LIT8(KCfgStr7, "page_size=-1024");
1.401 + err = TheDb.Create(KTestDbName, &KCfgStr7);
1.402 + TEST2(err, KErrArgument);
1.403 + TheDb.Close();
1.404 + (void)RSqlDatabase::Delete(KTestDbName);
1.405 + }
1.406 +
1.407 +/**
1.408 +@SYMTestCaseID SYSLIB-SQL-UT-3439
1.409 +@SYMTestCaseDesc Test for DEF105928 "SQL server ignores config string parameters".
1.410 + The test creates two databases using configuration strings and checks that database 1
1.411 + configuration has no impact on database 2 configuration.
1.412 +@SYMTestPriority High
1.413 +@SYMTestActions Test for DEF105928 "SQL server ignores config string parameters".
1.414 +@SYMTestExpectedResults The test must not fail
1.415 +@SYMDEF DEF105928
1.416 +*/
1.417 +void CfgCrossConnectionTest()
1.418 + {
1.419 + //Create database 1 with cache size = 40, page size = 2048.
1.420 + _LIT8(KCfgStr1, "cache_size = 40; page_size = 2048");
1.421 + TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
1.422 + TEST2(err, KErrNone);
1.423 + AssertConfigPrmValues(TheDb, 40, 2048, KDefaultEncoding);
1.424 + //Without closing database 1, create database 2 without a configuration string.
1.425 + //Check that database 2 uses the default configuration parameters
1.426 + err = TheDb2.Create(KTestDbName2);
1.427 + TEST2(err, KErrNone);
1.428 + AssertConfigPrmValues(TheDb2, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
1.429 + //Close database 2. Check the configuration parameters of database 1
1.430 + TheDb2.Close();
1.431 + AssertConfigPrmValues(TheDb, 40, 2048, KDefaultEncoding);
1.432 + TheDb.Close();
1.433 + (void)RSqlDatabase::Delete(KTestDbName2);
1.434 + (void)RSqlDatabase::Delete(KTestDbName);
1.435 + //Create 2 databases with different configuration parameters
1.436 + _LIT8(KCfgStr2_1, "cache_size = 50; page_size = 512; encoding = \"UTF-16\"");
1.437 + _LIT8(KCfgStr2_2, "cache_size = 80; page_size = 4096; encoding = \"UTF-8\"");
1.438 + err = TheDb.Create(KTestDbName, &KCfgStr2_1);
1.439 + TEST2(err, KErrNone);
1.440 + err = TheDb2.Create(KTestDbName2, &KCfgStr2_2);
1.441 + TEST2(err, KErrNone);
1.442 + AssertConfigPrmValues(TheDb, 50, 512, TSqlSrvConfigParams::EEncUtf16);
1.443 + AssertConfigPrmValues(TheDb2, 80, 4096, TSqlSrvConfigParams::EEncUtf8);
1.444 + TheDb2.Close();
1.445 + TheDb.Close();
1.446 + //Reopen the databases and check the configuration parameters
1.447 + err = TheDb.Open(KTestDbName);
1.448 + TEST2(err, KErrNone);
1.449 + err = TheDb2.Open(KTestDbName2);
1.450 + TEST2(err, KErrNone);
1.451 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 512, 512, TSqlSrvConfigParams::EEncUtf16);
1.452 + AssertConfigPrmValues(TheDb2, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 4096, 4096, TSqlSrvConfigParams::EEncUtf8);
1.453 + TheDb2.Close();
1.454 + TheDb.Close();
1.455 + (void)RSqlDatabase::Delete(KTestDbName2);
1.456 + (void)RSqlDatabase::Delete(KTestDbName);
1.457 + }
1.458 +
1.459 +/**
1.460 +@SYMTestCaseID SYSLIB-SQL-UT-3440
1.461 +@SYMTestCaseDesc Test for DEF105928 "SQL server ignores config string parameters".
1.462 + The test creates a secure database with a configuration string. The test must not fail.
1.463 +@SYMTestPriority High
1.464 +@SYMTestActions Test for DEF105928 "SQL server ignores config string parameters".
1.465 +@SYMTestExpectedResults The test must not fail
1.466 +@SYMDEF DEF105928
1.467 +*/
1.468 +void CfgSecureDbTest()
1.469 + {
1.470 + //Create
1.471 + TSecurityPolicy policy(TSecurityPolicy::EAlwaysPass);
1.472 + RSqlSecurityPolicy dbPolicy;
1.473 + TInt err = dbPolicy.Create(policy);
1.474 + TEST2(err, KErrNone);
1.475 + _LIT8(KCfgStr1, "cache_size = 80; page_size = 4096; encoding = UTF-8");
1.476 + err = TheDb.Create(KTestDbName3, dbPolicy, &KCfgStr1);
1.477 + TEST2(err, KErrNone);
1.478 + //Since it is a secure database, PRAGMAs cannot be executed (in order to assert the parameter values)
1.479 + //AssertConfigPrmValues(TheDb, 80, 4096, TSqlSrvConfig::EEncUtf8);
1.480 + TheDb.Close();
1.481 + dbPolicy.Close();
1.482 + //Open
1.483 + _LIT8(KCfgStr2, "cache_size = 100");
1.484 + err = TheDb.Open(KTestDbName3, &KCfgStr2);
1.485 + TEST2(err, KErrNone);
1.486 + TheDb.Close();
1.487 + (void)RSqlDatabase::Delete(KTestDbName3);
1.488 + }
1.489 +
1.490 +/**
1.491 +@SYMTestCaseID SYSLIB-SQL-UT-3441
1.492 +@SYMTestCaseDesc Test for DEF105928 "SQL server ignores config string parameters".
1.493 + The test creates a private database with a configuration string. The test must not fail.
1.494 +@SYMTestPriority High
1.495 +@SYMTestActions Test for DEF105928 "SQL server ignores config string parameters".
1.496 +@SYMTestExpectedResults The test must not fail
1.497 +@SYMDEF DEF105928
1.498 +*/
1.499 +void CfgPrivateDbTest()
1.500 + {
1.501 + //Create
1.502 + _LIT8(KCfgStr1, "cache_size = 80; page_size = 4096; encoding = UTF-8");
1.503 + TInt err = TheDb.Create(KTestDbName4, &KCfgStr1);
1.504 + TEST2(err, KErrNone);
1.505 + AssertConfigPrmValues(TheDb, 80, 4096, TSqlSrvConfigParams::EEncUtf8);
1.506 + TheDb.Close();
1.507 + //Open-1. The cache size can be changed.
1.508 + _LIT8(KCfgStr2, "cache_size = 100");
1.509 + err = TheDb.Open(KTestDbName4, &KCfgStr2);
1.510 + TEST2(err, KErrNone);
1.511 + AssertConfigPrmValues(TheDb, 100, 4096, TSqlSrvConfigParams::EEncUtf8);
1.512 + TheDb.Close();
1.513 + //Open-2. The page size cannot be changed if the database does exist already.
1.514 + _LIT8(KCfgStr3, "page_size = 512");
1.515 + err = TheDb.Open(KTestDbName4, &KCfgStr3);
1.516 + TEST2(err, KErrNone);
1.517 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 4096, 4096, TSqlSrvConfigParams::EEncUtf8);
1.518 + TheDb.Close();
1.519 + (void)RSqlDatabase::Delete(KTestDbName4);
1.520 + }
1.521 +
1.522 +/**
1.523 +@SYMTestCaseID SYSLIB-SQL-CT-3480
1.524 +@SYMTestCaseDesc Test for INC106788 - Cannot set SQLite page_size bigger than 4k (4096).
1.525 + The test attempts to create a database with page size 8K, 16K or 32K, which was not
1.526 + possible before (the default page size (1K) has been used).
1.527 +@SYMTestPriority High
1.528 +@SYMTestActions Test for INC106788 - Cannot set SQLite page_size bigger than 4k (4096).
1.529 +@SYMTestExpectedResults The test should not fail or panic.
1.530 +@SYMDEF INC106788
1.531 +*/
1.532 +void INC106788()
1.533 + {
1.534 + //Create a database with page size = 8192.
1.535 + (void)RSqlDatabase::Delete(KTestDbName);
1.536 + _LIT8(KCfgStr1, "page_size = 8192");
1.537 + TInt err = TheDb.Create(KTestDbName, &KCfgStr1);
1.538 + TEST2(err, KErrNone);
1.539 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 8192, 8192, KDefaultEncoding);
1.540 + TheDb.Close();
1.541 +
1.542 + //Create a database with page size = 16384.
1.543 + (void)RSqlDatabase::Delete(KTestDbName);
1.544 + _LIT8(KCfgStr2, "page_size = 16384");
1.545 + err = TheDb.Create(KTestDbName, &KCfgStr2);
1.546 + TEST2(err, KErrNone);
1.547 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 16384, 16384, KDefaultEncoding);
1.548 + TheDb.Close();
1.549 +
1.550 + //Create a database with page size = 32768.
1.551 + (void)RSqlDatabase::Delete(KTestDbName);
1.552 + _LIT8(KCfgStr3, "page_size = 32768");
1.553 + err = TheDb.Create(KTestDbName, &KCfgStr3);
1.554 + TEST2(err, KErrNone);
1.555 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 32768, 32768, KDefaultEncoding);
1.556 + TheDb.Close();
1.557 +
1.558 + (void)RSqlDatabase::Delete(KTestDbName);
1.559 + }
1.560 +
1.561 +/**
1.562 +@SYMTestCaseID SYSLIB-SQL-UT-4049
1.563 +@SYMTestCaseDesc Database configuration string - injection test.
1.564 + The test attempts to create a database using a configuration string
1.565 + and passing a DELETE SQL statement as a compaction mode name.
1.566 + The database should be created successfully, the invalid compaction mode - ignored,
1.567 + the database system tables content shoud not be corrupted by the call.
1.568 +@SYMTestPriority High
1.569 +@SYMTestActions Database configuration string - injection test.
1.570 +@SYMTestExpectedResults Test must not fail
1.571 +@SYMREQ REQ10405
1.572 +*/
1.573 +void InjectionTest()
1.574 + {
1.575 + (void)RSqlDatabase::Delete(KTestDbName);
1.576 + TInt err = TheDb.Create(KTestDbName);
1.577 + TEST2(err, KErrNone);
1.578 + err = TheDb.Exec(_L("CREATE TABLE A(I INTEGER); INSERT INTO A(I) VALUES(1);"));
1.579 + TEST(err > 0);
1.580 + TheDb.Close();
1.581 +
1.582 + _LIT8(KConfig1, "cache_size=128;DELETE FROM A");
1.583 + err = TheDb.Open(KTestDbName, &KConfig1);
1.584 + TEST2(err, KErrArgument);
1.585 + err = TheDb.Open(KTestDbName);
1.586 + TEST2(err, KErrNone);
1.587 + TSqlScalarFullSelectQuery query(TheDb);
1.588 + TInt recCount = 0;
1.589 + TRAP(err, recCount = query.SelectIntL(_L("SELECT COUNT(*) FROM A")));
1.590 + TEST2(err, KErrNone);
1.591 + TEST2(recCount, 1);
1.592 + TheDb.Close();
1.593 +
1.594 + _LIT8(KConfig2, "cache_size=256;compaction=DELETE FROM A;");
1.595 + err = TheDb.Open(KTestDbName, &KConfig2);
1.596 + TEST2(err, KErrNone);
1.597 + query.SetDatabase(TheDb);
1.598 + recCount = 0;
1.599 + TRAP(err, recCount = query.SelectIntL(_L("SELECT COUNT(*) FROM A")));
1.600 + TEST2(err, KErrNone);
1.601 + TEST2(recCount, 1);
1.602 + TheDb.Close();
1.603 + (void)RSqlDatabase::Delete(KTestDbName);
1.604 +
1.605 + _LIT8(KConfig3, "cache_size=256;compaction=DELETE FROM symbian_settings;");
1.606 + err = TheDb.Create(KTestDbName, &KConfig3);
1.607 + TEST2(err, KErrNone);
1.608 + query.SetDatabase(TheDb);
1.609 + recCount = 0;
1.610 + TRAP(err, recCount = query.SelectIntL(_L("SELECT COUNT(*) FROM symbian_settings")));
1.611 + TEST2(err, KErrNone);
1.612 + TEST2(recCount, 1);
1.613 + TheDb.Close();
1.614 + (void)RSqlDatabase::Delete(KTestDbName);
1.615 + }
1.616 +
1.617 +/**
1.618 +@SYMTestCaseID PDS-SQL-UT-4152
1.619 +@SYMTestCaseDesc Test for DEF142305 - RSqlDatabase::Attach does not use cache_size configuration parameters.
1.620 + The test verifies that when a database is attached, the attached database cache size will be set
1.621 + based on the page size, soft heap limit and default cache size.
1.622 +@SYMTestPriority High
1.623 +@SYMTestActions Test for DEF142305 - RSqlDatabase::Attach does not use cache_size configuration parameters.
1.624 +@SYMTestExpectedResults The test must not fail.
1.625 +@SYMDEF INC106788
1.626 +*/
1.627 +void DEF142305()
1.628 + {
1.629 + _LIT8(KConfig, "cache_size=500");
1.630 +
1.631 + //Create main db
1.632 + TInt err = TheDb.Create(KTestDbName, &KConfig);
1.633 + TEST2(err, KErrNone);
1.634 + AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
1.635 + TheDb.Close();
1.636 +
1.637 + //Create non-secure db that will be attached
1.638 + err = TheDb.Create(KTestDbName2, &KConfig);
1.639 + TEST2(err, KErrNone);
1.640 + AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
1.641 + TheDb.Close();
1.642 +
1.643 + //Create private db that will be attached
1.644 + _LIT8(KConfig2, "page_size=2048");
1.645 + err = TheDb.Create(KTestDbName4, &KConfig2);
1.646 + TEST2(err, KErrNone);
1.647 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 2048, 2048, KDefaultEncoding);//2048? - see KConfig2 string
1.648 + TheDb.Close();
1.649 +
1.650 + _LIT(KAttachDbName, "Attached");
1.651 +
1.652 + //Attach non-secure db
1.653 + err = TheDb.Open(KTestDbName, &KConfig);
1.654 + TEST2(err, KErrNone);
1.655 + AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
1.656 + err = TheDb.Attach(KTestDbName2, KAttachDbName);
1.657 + TEST2(err, KErrNone);
1.658 + AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding, KAttachDbName);
1.659 + err = TheDb.Detach(KAttachDbName);
1.660 + TEST2(err, KErrNone);
1.661 + TheDb.Close();
1.662 +
1.663 + //Attach private db
1.664 + err = TheDb.Open(KTestDbName, &KConfig);
1.665 + TEST2(err, KErrNone);
1.666 + AssertConfigPrmValues(TheDb, 500, KDefaultPageSize, KDefaultEncoding);
1.667 + err = TheDb.Attach(KTestDbName4, KAttachDbName);
1.668 + TEST2(err, KErrNone);
1.669 + AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 2048, 2048, KDefaultEncoding, KAttachDbName);//2048? - see KConfig2 string
1.670 + err = TheDb.Detach(KAttachDbName);
1.671 + TEST2(err, KErrNone);
1.672 + TheDb.Close();
1.673 +
1.674 + (void)RSqlDatabase::Delete(KTestDbName4);
1.675 + (void)RSqlDatabase::Delete(KTestDbName2);
1.676 + (void)RSqlDatabase::Delete(KTestDbName);
1.677 + }
1.678 +
1.679 +void DoTests()
1.680 + {
1.681 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3436 Sql config string - functional test "));
1.682 + CfgFunctionalTest();
1.683 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3437 Sql config string - negative test "));
1.684 + CfgNegativeTest();
1.685 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3438 Sql config string - invalid cache size and page size test "));
1.686 + CfgInvalidCacheAndPageSizeTest();
1.687 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3439 Sql config string - cross connection test "));
1.688 + CfgCrossConnectionTest();
1.689 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3440 Sql config string - secure database test "));
1.690 + CfgSecureDbTest();
1.691 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3441 Sql config string - private database test "));
1.692 + CfgPrivateDbTest();
1.693 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-3480 INC106788 - Cannot set SQLite page_size bigger than 4k (4096) "));
1.694 + INC106788();
1.695 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-4049 Config string - injection tests"));
1.696 + InjectionTest();
1.697 + TheTest.Next(_L("@SYMTestCaseID:PDS-SQL-UT-4152: DEF142305 RSqlDatabase::Attach does not use cache_size configuration parameters"));
1.698 + DEF142305();
1.699 + }
1.700 +
1.701 +TInt E32Main()
1.702 + {
1.703 + TheTest.Title();
1.704 +
1.705 + CTrapCleanup* tc = CTrapCleanup::New();
1.706 + TheTest(tc != NULL);
1.707 +
1.708 + __UHEAP_MARK;
1.709 +
1.710 + SetupTestEnv();
1.711 + DoTests();
1.712 + DestroyTestEnv();
1.713 +
1.714 + __UHEAP_MARKEND;
1.715 +
1.716 + TheTest.End();
1.717 + TheTest.Close();
1.718 +
1.719 + delete tc;
1.720 +
1.721 + User::Heap().Check();
1.722 + return KErrNone;
1.723 + }