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: START_TESTCASE SYSLIB-SQL-CIT-1800 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1800 sl@0: //! @SYMTestCaseDesc Attempt to use an RSqlStatement without an RSqlDatabase. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! The test looks for specific panic codes generated sl@0: //! when the equivalent of programmer errors are executed sl@0: //! on the SQLite system. For example, attempting to use sl@0: //! an RSqlStatement object without an open RSqlDatabase. sl@0: //! @SYMREQ REQ5792 sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-a sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-b sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-c sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-d sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-e sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-f sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-g sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-h sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-i sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini One-j sl@0: END_TESTCASE SYSLIB-SQL-CIT-1800 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1801 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1801 sl@0: //! @SYMTestCaseDesc Attempt to use an RSqlDatabase that isn't open. First sl@0: //! opens a valid database, immediately closes it and then sl@0: //! attempts to use an RSqlDatabase method. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! Panics when an Exec or other RSqlDatabase method is sl@0: //! attempted. sl@0: //! @SYMREQ REQ5792 sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two-b sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two-c sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two-d sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two-e sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two-f sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Two-g sl@0: END_TESTCASE SYSLIB-SQL-CIT-1801 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1802 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1802 sl@0: //! @SYMTestCaseDesc Attempt to use Column* calls following a failed Next. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! The test looks for specific panic codes generated sl@0: //! when Column* methods are called after Next returns sl@0: //! 'KSqlAtEnd'. sl@0: //! @SYMREQ REQ5792 sl@0: RUN_PANIC_STEP_RESULT 130 USER 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-b sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-c sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-d sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-e sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-f sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-g sl@0: RUN_PANIC_STEP_RESULT 11 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-h sl@0: RUN_PANIC_STEP_RESULT 5 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Three-i sl@0: END_TESTCASE SYSLIB-SQL-CIT-1802 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1803 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1803 sl@0: //! @SYMTestCaseDesc Use parameter and column indices which are out of bounds. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! This test looks for specific panic codes generated sl@0: //! when Bind and Column methods are called with Parameter sl@0: //! and Column indices which are out of bounds. sl@0: //! @SYMREQ REQ5792 sl@0: RUN_PANIC_STEP_RESULT 5 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Four sl@0: RUN_PANIC_STEP_RESULT 5 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Four-b sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Four-c sl@0: END_TESTCASE SYSLIB-SQL-CIT-1803 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1804 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1804 sl@0: //! @SYMTestCaseDesc Attempt to read a cell in a table without selecting the sl@0: //! column. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! The test looks for a specific panic code generated sl@0: //! when a Column* method is called on a column that hasn't sl@0: //! been selected. sl@0: //! @SYMREQ REQ5792 sl@0: RUN_PANIC_STEP_RESULT 130 USER 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Five sl@0: END_TESTCASE SYSLIB-SQL-CIT-1804 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1805 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1805 sl@0: //! @SYMTestCaseDesc Attempt to write, using Bind to a non-existent table. sl@0: //! @SYMTestPriority High sl@0: //! @SYMTestActions See description and the config file. sl@0: //! @SYMTestExpectedResults sl@0: //! The test looks for a specific panic code generated sl@0: //! when a Parameter Index call is made following a sl@0: //! prepare on a non-existent table. sl@0: //! @SYMREQ REQ5792 sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\Panics.ini Six sl@0: END_TESTCASE SYSLIB-SQL-CIT-1805 sl@0: sl@0: RUN_UTILS DeleteFile C:\Panics0.db sl@0: