// 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

// 

//

PRINT Run SQL Tests

LOAD_SUITE te_SQL_Suite

RUN_UTILS DeleteFile E:\Robustness*.db

RUN_UTILS DeleteFile T:\Robustness*.db

RUN_UTILS DeleteFile C:\Robustness*.db

RUN_UTILS DeleteFile E:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\Robustness*.db-journal

RUN_UTILS DeleteFile C:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\fillfile.txt

RUN_UTILS DeleteFile T:\fillfile2.txt

RUN_UTILS DeleteFile T:\fillfile4M.txt

RUN_UTILS DeleteFile E:\fillfile.txt

RUN_UTILS DeleteFile E:\fillfile2.txt

RUN_UTILS DeleteFile E:\fillfile4M.txt

START_TESTCASE SYSLIB-SQL-CIT-3348

//! @SYMTestCaseID    SYSLIB-SQL-CIT-3348

//! @SYMTestCaseDesc  Not strictly an SQL test. This step fills the disk to

//!                  within 4M of full an leaves that file lying around. This

//!                  improves the performance of the subsequent OOD tests

//!                  and is required for reliable behaviour within the DABS

//!                  framework (due to possible timeout issues). The large

//!                  file is removed by the script at the end.

//!                  This MUST be the first test to execute in the script.

//!                  Note that this step does nothing at all on emulator -

//!                  that uses the T: drive which is already < 4M.

//! @SYMTestPriority  High

//! @SYMTestActions   See description and the config file, also the code.

//! @SYMTestExpectedResults

//!                  A PASS should be generated.

//! @SYMDEF           DEF095562

  RUN_TEST_STEP 900 te_SQL_Suite CSQLCDT z:\TEF_SQL\Robustness.ini FillDisk4M

END_TESTCASE SYSLIB-SQL-CIT-3348

START_TESTCASE SYSLIB-SQL-CIT-1705

//! @SYMTestCaseID    SYSLIB-SQL-CIT-1705

//! @SYMTestCaseDesc  Adds a few records to a table in a new database. Begins

//!                  a transaction and then fills the disk. When this fails

//!                  with KErrDiskFull, database is closed and re-opened. This

//!                  is all that can be done with disk full unless space has

//!                  been reserved. Free up a bit of disk and then check

//!                  the initial records to validate the db is still usable.

//!                  Further records are then added and checked.

//! @SYMTestPriority  High

//! @SYMTestActions   See description and the config file, also the code.

//! @SYMTestExpectedResults

//!                  A PASS should be generated.

//! @SYMREQ           REQ5792

  PRINT <font size=5 color=AF0000>MMC card on E:\ required on hardware!! </font>

  RUN_TEST_STEP 900 te_SQL_Suite CSQLCDT z:\TEF_SQL\Robustness.ini Top

END_TESTCASE SYSLIB-SQL-CIT-1705

RUN_UTILS DeleteFile E:\Robustness*.db

RUN_UTILS DeleteFile T:\Robustness*.db

RUN_UTILS DeleteFile C:\Robustness*.db

RUN_UTILS DeleteFile E:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\Robustness*.db-journal

RUN_UTILS DeleteFile C:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\fillfile.txt

RUN_UTILS DeleteFile E:\fillfile.txt

RUN_UTILS DeleteFile T:\fillfile2.txt

RUN_UTILS DeleteFile E:\fillfile2.txt

START_TESTCASE SYSLIB-SQL-CIT-1704

//! @SYMTestCaseID    SYSLIB-SQL-CIT-1704

//! @SYMTestCaseDesc  Does an attach of a db on another drive and then fills

//!                  the disk that resides on. Verifies that appropriate

//!                  errors are returned on writing to it. Also check for

//!                  'expired' RSqlStatement after DETACH and verifies that

//!                  the previously attached database can be deleted despite

//!                  having no space.

//! @SYMTestPriority  High

//! @SYMTestActions   See description and the config file, also the code.

//! @SYMTestExpectedResults

//!                  A PASS should be generated.

//! @SYMREQ           REQ5792

    PRINT <font size=5 color=0000AF>INFO: MMC card on E:\ required on hardware!! </font>

    RUN_TEST_STEP 900 te_SQL_Suite CSQLCDT z:\TEF_SQL\Robustness.ini Attach

END_TESTCASE SYSLIB-SQL-CIT-1704

RUN_UTILS DeleteFile E:\Robustness*.db

RUN_UTILS DeleteFile T:\Robustness*.db

RUN_UTILS DeleteFile C:\Robustness*.db

RUN_UTILS DeleteFile E:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\Robustness*.db-journal

RUN_UTILS DeleteFile C:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\fillfile.txt

RUN_UTILS DeleteFile E:\fillfile.txt

RUN_UTILS DeleteFile T:\fillfile2.txt

RUN_UTILS DeleteFile E:\fillfile2.txt

START_TESTCASE SYSLIB-SQL-CIT-1741

//! @SYMTestCaseID    SYSLIB-SQL-CIT-1741

//! @SYMTestCaseDesc  'FillTest' adds some data into its database and checks

//!                  it. It then triggers 'DeleteTest' and waits.

//!                  DeleteTest creates its own, separate database.

//!                  It then reserves space, and then fills the disk

//!                  with writes to a database table. Once it receives

//!                  KErrDiskFull it enables the reserved disk space and

//!                  attempts to add two more records - this should be

//!                  successful. It then signals 'FillTest' back, and waits.

//!                  'FillTest' attempts to add records to its own db. These

//!                  are small, so a number work. It then receives KErrDiskFull.

//!                  DeleteTest is signalled and FillTest waits.

//!                  'DeleteTest' attempts to delete a few records. This should

//!                  be successful - we have reserved space. Reserved space is

//!                  then released by 'DeleteTest', 'FillTest' is signalled

//!                  and 'DeleteTest' waits.

//!                  'FillTest' had no reserved space so just closes it's db,

//!                  deletes it, signals 'DeleteTest' back and dies.

//!                  'DeleteTest' releases reserved space a second time

//!                  (which gives no error) and cleans up.

//!

//! @SYMTestPriority  High

//! @SYMTestActions   See description and the config file, also the code.

//! @SYMTestExpectedResults

//!                  A PASS should be generated.

//! @SYMREQ           REQ5792

//

    PRINT <font size=5 color=AF0000>MMC card on E:\ required on hardware!! </font>

CONCURRENT

// DeleteTest's first action is to wait for a signal from FillTest. It *must*

// be running when FillTest sends it signal, so lets have it first..

    RUN_TEST_STEP 1800 te_SQL_Suite CSQLCDT z:\TEF_SQL\Robustness.ini DeleteTest

    RUN_TEST_STEP 1800 te_SQL_Suite CSQLCDT z:\TEF_SQL\Robustness.ini FillTest

END_TESTCASE SYSLIB-SQL-CIT-1741

RUN_UTILS DeleteFile E:\Robustness*.db

RUN_UTILS DeleteFile T:\Robustness*.db

RUN_UTILS DeleteFile C:\Robustness*.db

RUN_UTILS DeleteFile E:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\Robustness*.db-journal

RUN_UTILS DeleteFile C:\Robustness*.db-journal

RUN_UTILS DeleteFile T:\fillfile.txt

RUN_UTILS DeleteFile E:\fillfile.txt

RUN_UTILS DeleteFile T:\fillfile2.txt

RUN_UTILS DeleteFile E:\fillfile2.txt

RUN_UTILS DeleteFile T:\fillfile4M.txt

RUN_UTILS DeleteFile E:\fillfile4M.txt