os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/scripts/BasicSQL.script
1 // Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).
2 // All rights reserved.
3 // This component and the accompanying materials are made available
4 // under the terms of "Eclipse Public License v1.0"
5 // which accompanies this distribution, and is available
6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".
8 // Initial Contributors:
9 // Nokia Corporation - initial contribution.
18 //! @SYMTestSuiteName PDS-TEF-SQL-SUITE
19 //! @SYMScriptTestEnvironment TEF
20 //! @internalComponent
25 LOAD_SUITE te_SQL_Suite
27 RUN_UTILS MkDir c:\private\10281e17\
28 RUN_UTILS CopyFile z:\TEF_SQL\TestData\test1.db c:\test1.db
29 RUN_UTILS MakeReadWrite c:\test1.db
31 START_TESTCASE SYSLIB-SQL-CIT-1690
32 //! @SYMTestCaseID SYSLIB-SQL-CIT-1690
33 //! @SYMTestCaseDesc Retrieves various information from a pre-existing database
34 //! (300Kb) checking for correct result as it goes.
35 //! @SYMTestPriority High
36 //! @SYMTestActions See description and the config file.
37 //! @SYMTestExpectedResults
38 //! The test looks for errors and content
39 //! within the database. If these are not seen test errors
40 //! will be generated.
44 RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\robust_size.ini LargeSelect
45 END_TESTCASE SYSLIB-SQL-CIT-1690
47 RUN_UTILS DeleteFile c:\test1.db
49 START_TESTCASE SYSLIB-SQL-CIT-1691
50 //! @SYMTestCaseID SYSLIB-SQL-CIT-1691
51 //! @SYMTestCaseDesc Dynamically creates a new db and adds a table. Inserts
52 //! various data into this deliberately violating constraints
53 //! that were set when the table was created. Checks for the
54 //! expected 'KSqlErrConstraint' error when appropriate.
55 //! @SYMTestPriority High
56 //! @SYMTestActions See description and the config file.
57 //! @SYMTestExpectedResults
58 //! This test looks for errors. If these are not seen test
59 //! errors will be generated, none should be seen.
63 RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\constraints.ini constraints
64 END_TESTCASE SYSLIB-SQL-CIT-1691
66 RUN_UTILS DeleteFile c:\test2.db
68 START_TESTCASE SYSLIB-SQL-CIT-1692
69 //! @SYMTestCaseID SYSLIB-SQL-CIT-1692
70 //! @SYMTestCaseDesc Dynamically creates a database, adding various data to
71 //! a new table. Performs an SQL 'create view' operation
72 //! and the retrieves data fromt this view checking for
73 //! expected values and any errors as it goes. Performs
74 //! a second 'create view' operation and again checks for
75 //! correct content in this new view.
76 //! @SYMTestPriority High
77 //! @SYMTestActions See description and the config file.
78 //! @SYMTestExpectedResults
79 //! The test looks for errors and content within views.
80 //! Any unexpected errors or incorrect content will generate
81 //! test errors, none should be seen.
85 RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\views.ini views
86 END_TESTCASE SYSLIB-SQL-CIT-1692
88 RUN_UTILS DeleteFile c:\test3.db