// Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).
// All rights reserved.
// This component and the accompanying materials are made available
// under the terms of "Eclipse Public License v1.0"
// which accompanies this distribution, and is available
// at the URL "http://www.eclipse.org/legal/epl-v10.html".
//
// Initial Contributors:
// Nokia Corporation - initial contribution.
//
// Contributors:
//
// Description:
// @file
// 
//

//! @SYMTestSuiteName PDS-TEF-SQL-SUITE
//! @SYMScriptTestEnvironment TEF
//! @internalComponent
//! @test

PRINT Run SQL Tests

LOAD_SUITE te_SQL_Suite

START_TESTCASE SYSLIB-SQL-CIT-1684
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1684
//! @SYMTestCaseDesc  Perform some basic operations (see the config file for
//!                  full details).
//!                  Runs most of the RSqlDatabase methods, checking for
//!                  expected errors and error messages as it goes. Then
//!                  triggers the 'rsqlstatement' block using the same
//!                  'RSqlDatabase' object and runs most RSqlStatement methods
//!                  again checking for errors and so on. Includes 'Bind' calls
//!                  and retrieval of data with 'ColumnText' etc.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The test looks for specific error codes and content
//!                  within the database. If these are not seen test errors
//!                  will be generated.
//!                  
//! @SYMREQ           REQ5792

	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic.ini Top
END_TESTCASE SYSLIB-SQL-CIT-1684

START_TESTCASE SYSLIB-SQL-CIT-1685
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1685
//! @SYMTestCaseDesc  Perform further basic operations (see the config file for
//!                  full details).
//!                  Add a new field to the table created in the database
//!                  created in the last test. Attempts some exceptions (e.g
//!                  getting a ParameterIndex for a non-existent field),
//!                  checks 'ColumnType' and the output of 'Next' and 'AtRow'.
//!                  Deletes the db on completion.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The test looks for specific error codes and content
//!                  within the database. If these are not seen test errors
//!                  will be generated.
//!                  
//! @SYMREQ           REQ5792

	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic.ini AddtoTable
END_TESTCASE SYSLIB-SQL-CIT-1685

START_TESTCASE SYSLIB-SQL-CIT-1686
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1686
//! @SYMTestCaseDesc  'StreamWrite' bind test. Creates a new db, creates a
//!                  table and writes to a cell in the table using
//!                  the 'BindText' method within 'RSqlParamWriteStream'.
//!                  Retrieve the content from the cell using the various
//!                  'ColumnText' methods of RSqlStatement and also the
//!                  'ColumnText' method of RSqlColumnReadStream and check
//!                  for correct content.
//!                  Now also has an integer field within the table which
//!                  checks the BindInt and ColumnInt methods as well as
//!                  the text methods mentioned above. This change is to
//!                  check for the problem of the first stream write failing
//!                  to store anything if done in conjunction with any other
//!                  bind (which was fixed by cl@764944).
//!                  Deletes the db on completion.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The test looks for specific error codes and content
//!                  within the database. If these are not seen test errors
//!                  will be generated.
//!                  
//! @SYMREQ           REQ5792

	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic.ini SWBindText
END_TESTCASE SYSLIB-SQL-CIT-1686

START_TESTCASE SYSLIB-SQL-CIT-1687
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1687
//! @SYMTestCaseDesc  'StreamWrite' bind test. Creates a new db, creates a
//!                  table and writes to a cell in the table using
//!                  the 'BindBinary' method within 'RSqlParamWriteStream'.
//!                  Retrieve the content from the cell using the various
//!                  'ColumnBinary' methods of RSqlStatement and also the
//!                  'ColumnBinary' method of RSqlColumnReadStream and check
//!                  for correct content.
//!                  Deletes the db on completion.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The test looks for specific error codes and content
//!                  within the database. If these are not seen test errors
//!                  will be generated.
//! @SYMREQ           REQ5792

	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic.ini SWBindBinary
END_TESTCASE SYSLIB-SQL-CIT-1687

START_TESTCASE SYSLIB-SQL-CIT-1699
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1699
//! @SYMTestCaseDesc  Uses the test1.db (in ROM) to test counting of lines,
//!                  calculation of averages and sums in a table and so on.
//!                  This requires that ColumnInt/Real etc access an unnamed
//!                  column (column zero).
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The sums, averages etc are correctly calculated and the
//!                  test reports a PASS.
//! @SYMREQ           REQ5792

	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic.ini Countlines
END_TESTCASE SYSLIB-SQL-CIT-1699

START_TESTCASE SYSLIB-SQL-CIT-1746
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1746
//! @SYMTestCaseDesc  Tests basic transaction behaviour and a simple level
//!                  of concurrency. A single record is added to a table.
//!                  Then, within a transaction three more are added.
//!                  At this point two concurrent threads (one ESerializable,
//!                  one EReadUncommitted) check the content of the table.
//!                  After checking the transaction is rolled back.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The ESerializable thread is unable to read the table
//!                  because it is locked. The EReadUncommitted read it fine.
//! @SYMREQ           REQ5792
//!                  REQ5793

CONCURRENT
	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini Thread2
	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini Thread3
	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini Thread1
END_TESTCASE SYSLIB-SQL-CIT-1746


START_TESTCASE SYSLIB-SQL-CIT-1747
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1747
//! @SYMTestCaseDesc  Verifies the rollback on the last test performed properly.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The table reads without error, it contains 1 record.
//! @SYMREQ           REQ5792

CONSECUTIVE
	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini CheckFollowingRollback
END_TESTCASE SYSLIB-SQL-CIT-1747

START_TESTCASE SYSLIB-SQL-CIT-1745
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1745
//! @SYMTestCaseDesc  Verifies that streams behave - we pass a read stream
//!                  to a write stream.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  Runs without error.
//! @SYMREQ           REQ5792

CONSECUTIVE
	RUN_TEST_STEP 100 te_SQL_Suite CSQLCDT z:\TEF_SQL\APIBasic2.ini CopyCellsWithStreams
END_TESTCASE SYSLIB-SQL-CIT-1745

START_TESTCASE SYSLIB-SQL-CIT-1742
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1742
//! @SYMTestCaseDesc  A simple test of the effect of two binds without an
//!                  exec/reset between them.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  The second data to be bound gets written to the cell,
//!                  a PASS will be reported.
//! @SYMREQ           REQ5792

CONSECUTIVE
	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini DoubleBind
END_TESTCASE SYSLIB-SQL-CIT-1742

START_TESTCASE SYSLIB-SQL-CIT-1798
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1798
//! @SYMTestCaseDesc  A simple test using the OpenL and CreateL methods.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  Checks for appropriate error codes from the APIs called
//!                  and reports a PASS.
//! @SYMREQ           REQ5792

CONSECTUTIVE
	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini LeaveMethods
END_TESTCASE SYSLIB-SQL-CIT-1798

RUN_UTILS DeleteFile C:\Leave1.db
RUN_UTILS DeleteFile C:\MCO1.db
RUN_UTILS DeleteFile C:\MCO2.db
RUN_UTILS DeleteFile C:\MCO3.db
RUN_UTILS DeleteFile C:\MCO4.db
RUN_UTILS DeleteFile C:\MCO5.db

START_TESTCASE SYSLIB-SQL-CIT-1799
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1799
//! @SYMTestCaseDesc  Tests the effect of multiple sequential Creates and Opens.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  Verifies that multiple Creates and Opens with the same
//!                  RSqlDatabase object does not generate an error. You
//!                  might expect a PANIC but you'd be wrong! Note the
//!                  deletes afterwards, these clean up where we can't because
//!                  all of the databases get locked.
//! @SYMREQ           REQ5792

	RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\APIBasic2.ini MultipleCreateOpen
END_TESTCASE SYSLIB-SQL-CIT-1799

RUN_UTILS DeleteFile C:\Leave1.db
RUN_UTILS DeleteFile C:\MCO1.db
RUN_UTILS DeleteFile C:\MCO2.db
RUN_UTILS DeleteFile C:\MCO3.db
RUN_UTILS DeleteFile C:\MCO4.db
RUN_UTILS DeleteFile C:\MCO5.db

START_TESTCASE SYSLIB-SQL-CIT-1830
//! @SYMTestCaseID    SYSLIB-SQL-CIT-1830
//! @SYMTestCaseDesc  Further bind tests.
//! @SYMTestPriority  High
//! @SYMTestActions   See description and the config file.
//! @SYMTestExpectedResults
//!                  A couple of tests that verify that a bind can be used
//!                  in combination with a SELECT to fetch data from a table
//!                  based on parameters in the bind. The first one uses
//!                  integers, the second a binary field (though it's defined
//!                  as text in the 'Create table' line). For no special
//!                  reason we run these concurrently. It isn't really a
//!                  concurrency test, just two tests executing concurrently.
//! @SYMREQ           REQ5792

CONCURRENT
	RUN_TEST_STEP 100 te_SQL_Suite CSQLCDT z:\TEF_SQL\APIBasic2.ini ExtraBindTest
	RUN_TEST_STEP 100 te_SQL_Suite CSQLCDT z:\TEF_SQL\APIBasic2.ini ExtraBindTest2
END_TESTCASE SYSLIB-SQL-CIT-1830