sl@0: // Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies). sl@0: // All rights reserved. sl@0: // This component and the accompanying materials are made available sl@0: // under the terms of "Eclipse Public License v1.0" sl@0: // which accompanies this distribution, and is available sl@0: // at the URL "http://www.eclipse.org/legal/epl-v10.html". sl@0: // sl@0: // Initial Contributors: sl@0: // Nokia Corporation - initial contribution. sl@0: // sl@0: // Contributors: sl@0: // sl@0: // Description: sl@0: // @file sl@0: // sl@0: // sl@0: sl@0: //! @SYMTestSuiteName PDS-TEF-SQL-SUITE sl@0: //! @SYMScriptTestEnvironment TEF sl@0: //! @internalComponent sl@0: //! @test sl@0: sl@0: PRINT Run SQL Tests sl@0: sl@0: LOAD_SUITE te_SQL_Suite sl@0: sl@0: RUN_UTILS MkDir c:\private\ sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1748 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1748 sl@0: //! @SYMTestCaseDesc Dynamically creates a database, adding various data to sl@0: //! a new table. This is done in eight concurrent threads sl@0: //! which are deliberately not synchronized. The data should sl@0: //! successfully write into the table in an undefined order. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! The data should successfully write into the table in sl@0: //! an undefined order. sl@0: //! @SYMREQ REQ5793 sl@0: sl@0: CONCURRENT sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread2 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread3 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread4 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread5 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread6 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread7 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread8 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Thread1 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1748 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1749 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1749 sl@0: //! @SYMTestCaseDesc Now read back the table CONSECUTIVELY to check the sl@0: //! table created above has been written correctly. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! Each step checks the data written by a given thread sl@0: //! in the test above. This is done consecutively in case sl@0: //! the check below (which does the check concurrently) fails. sl@0: //! sl@0: //! @SYMREQ REQ5793 sl@0: sl@0: CONSECUTIVE sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check1 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check2 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check3 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check4 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check5 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check6 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check7 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check8 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1749 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1750 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1750 sl@0: //! @SYMTestCaseDesc Read back the table CONCURRENTLY in sixteen sl@0: //! threads. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! Each step checks the data written by a given thread sl@0: //! in the test above. There are only eight sets of data sl@0: //! to check, but there's no harm in doing this more sl@0: //! than eight times to verify concurrency on read. sl@0: //! sl@0: //! @SYMREQ REQ5793 sl@0: sl@0: CONCURRENT sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check1 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check2 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check3 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check4 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check5 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check6 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check7 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check8 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check1 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check2 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check3 sl@0: RUN_TEST_STEP 1000 te_SQL_Suite CSQLCDT z:\TEF_SQL\Concurrent.ini Check4 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1750 sl@0: sl@0: RUN_UTILS DeleteFile c:\Concurrent.db sl@0: