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\10281e17\
sl@0: RUN_UTILS CopyFile z:\TEF_SQL\TestData\test1.db c:\test1.db
sl@0: RUN_UTILS MakeReadWrite c:\test1.db
sl@0: 
sl@0: START_TESTCASE SYSLIB-SQL-CIT-1690
sl@0: //! @SYMTestCaseID    SYSLIB-SQL-CIT-1690
sl@0: //! @SYMTestCaseDesc  Retrieves various information from a pre-existing database
sl@0: //!                  (300Kb) checking for correct result as it goes.
sl@0: //! @SYMTestPriority  High
sl@0: //! @SYMTestActions   See description and the config file.
sl@0: //! @SYMTestExpectedResults
sl@0: //!                  The test looks for errors and content
sl@0: //!                  within the database. If these are not seen test errors
sl@0: //!                  will be generated.
sl@0: //!                  
sl@0: //! @SYMREQ           REQ5792
sl@0: 
sl@0: 	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\robust_size.ini LargeSelect
sl@0: END_TESTCASE SYSLIB-SQL-CIT-1690
sl@0: 
sl@0: RUN_UTILS DeleteFile c:\test1.db
sl@0: 
sl@0: START_TESTCASE SYSLIB-SQL-CIT-1691
sl@0: //! @SYMTestCaseID    SYSLIB-SQL-CIT-1691
sl@0: //! @SYMTestCaseDesc  Dynamically creates a new db and adds a table. Inserts
sl@0: //!                  various data into this deliberately violating constraints
sl@0: //!                  that were set when the table was created. Checks for the
sl@0: //!                  expected 'KSqlErrConstraint' error when appropriate.
sl@0: //! @SYMTestPriority  High
sl@0: //! @SYMTestActions   See description and the config file.
sl@0: //! @SYMTestExpectedResults
sl@0: //!                  This test looks for errors. If these are not seen test
sl@0: //!                  errors will be generated, none should be seen.
sl@0: //!                  
sl@0: //! @SYMREQ           REQ5792
sl@0: 
sl@0: 	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\constraints.ini constraints
sl@0: END_TESTCASE SYSLIB-SQL-CIT-1691
sl@0: 
sl@0: RUN_UTILS DeleteFile c:\test2.db
sl@0: 
sl@0: START_TESTCASE SYSLIB-SQL-CIT-1692
sl@0: //! @SYMTestCaseID    SYSLIB-SQL-CIT-1692
sl@0: //! @SYMTestCaseDesc  Dynamically creates a database, adding various data to
sl@0: //!                  a new table. Performs an SQL 'create view' operation
sl@0: //!                  and the retrieves data fromt this view checking for
sl@0: //!                  expected values and any errors as it goes. Performs
sl@0: //!                  a second 'create view' operation and again checks for
sl@0: //!                  correct content in this new view.
sl@0: //! @SYMTestPriority  High
sl@0: //! @SYMTestActions   See description and the config file.
sl@0: //! @SYMTestExpectedResults
sl@0: //!                  The test looks for errors and content within views.
sl@0: //!                  Any unexpected errors or incorrect content will generate
sl@0: //!                  test errors, none should be seen.
sl@0: //!                  
sl@0: //! @SYMREQ           REQ5792
sl@0: 
sl@0: 	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\views.ini views
sl@0: END_TESTCASE SYSLIB-SQL-CIT-1692
sl@0: 
sl@0: RUN_UTILS DeleteFile c:\test3.db