1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/scripts/BasicSQL.script	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,88 @@
     1.4 +// Copyright (c) 2006-2009 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 +// @file
    1.18 +// 
    1.19 +//
    1.20 +
    1.21 +//! @SYMTestSuiteName PDS-TEF-SQL-SUITE
    1.22 +//! @SYMScriptTestEnvironment TEF
    1.23 +//! @internalComponent
    1.24 +//! @test
    1.25 +
    1.26 +PRINT Run SQL Tests
    1.27 +
    1.28 +LOAD_SUITE te_SQL_Suite
    1.29 +
    1.30 +RUN_UTILS MkDir c:\private\10281e17\
    1.31 +RUN_UTILS CopyFile z:\TEF_SQL\TestData\test1.db c:\test1.db
    1.32 +RUN_UTILS MakeReadWrite c:\test1.db
    1.33 +
    1.34 +START_TESTCASE SYSLIB-SQL-CIT-1690
    1.35 +//! @SYMTestCaseID    SYSLIB-SQL-CIT-1690
    1.36 +//! @SYMTestCaseDesc  Retrieves various information from a pre-existing database
    1.37 +//!                  (300Kb) checking for correct result as it goes.
    1.38 +//! @SYMTestPriority  High
    1.39 +//! @SYMTestActions   See description and the config file.
    1.40 +//! @SYMTestExpectedResults
    1.41 +//!                  The test looks for errors and content
    1.42 +//!                  within the database. If these are not seen test errors
    1.43 +//!                  will be generated.
    1.44 +//!                  
    1.45 +//! @SYMREQ           REQ5792
    1.46 +
    1.47 +	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\robust_size.ini LargeSelect
    1.48 +END_TESTCASE SYSLIB-SQL-CIT-1690
    1.49 +
    1.50 +RUN_UTILS DeleteFile c:\test1.db
    1.51 +
    1.52 +START_TESTCASE SYSLIB-SQL-CIT-1691
    1.53 +//! @SYMTestCaseID    SYSLIB-SQL-CIT-1691
    1.54 +//! @SYMTestCaseDesc  Dynamically creates a new db and adds a table. Inserts
    1.55 +//!                  various data into this deliberately violating constraints
    1.56 +//!                  that were set when the table was created. Checks for the
    1.57 +//!                  expected 'KSqlErrConstraint' error when appropriate.
    1.58 +//! @SYMTestPriority  High
    1.59 +//! @SYMTestActions   See description and the config file.
    1.60 +//! @SYMTestExpectedResults
    1.61 +//!                  This test looks for errors. If these are not seen test
    1.62 +//!                  errors will be generated, none should be seen.
    1.63 +//!                  
    1.64 +//! @SYMREQ           REQ5792
    1.65 +
    1.66 +	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\constraints.ini constraints
    1.67 +END_TESTCASE SYSLIB-SQL-CIT-1691
    1.68 +
    1.69 +RUN_UTILS DeleteFile c:\test2.db
    1.70 +
    1.71 +START_TESTCASE SYSLIB-SQL-CIT-1692
    1.72 +//! @SYMTestCaseID    SYSLIB-SQL-CIT-1692
    1.73 +//! @SYMTestCaseDesc  Dynamically creates a database, adding various data to
    1.74 +//!                  a new table. Performs an SQL 'create view' operation
    1.75 +//!                  and the retrieves data fromt this view checking for
    1.76 +//!                  expected values and any errors as it goes. Performs
    1.77 +//!                  a second 'create view' operation and again checks for
    1.78 +//!                  correct content in this new view.
    1.79 +//! @SYMTestPriority  High
    1.80 +//! @SYMTestActions   See description and the config file.
    1.81 +//! @SYMTestExpectedResults
    1.82 +//!                  The test looks for errors and content within views.
    1.83 +//!                  Any unexpected errors or incorrect content will generate
    1.84 +//!                  test errors, none should be seen.
    1.85 +//!                  
    1.86 +//! @SYMREQ           REQ5792
    1.87 +
    1.88 +	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\views.ini views
    1.89 +END_TESTCASE SYSLIB-SQL-CIT-1692
    1.90 +
    1.91 +RUN_UTILS DeleteFile c:\test3.db