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: LOAD_SUITE te_SQL_Suite_cap2 sl@0: LOAD_SUITE BURTestServer sl@0: sl@0: RUN_UTILS MkDir c:\private\ sl@0: RUN_UTILS MkDir c:\private\102827c7\ sl@0: RUN_UTILS MkDir c:\private\102827c8\ sl@0: RUN_UTILS CopyFile z:\TEF_SQL\TestData\backup_registration.xml c:\private\102827c7\backup_registration.xml sl@0: RUN_UTILS CopyFile z:\TEF_SQL\TestData\backup_registration.xml c:\private\102827c8\backup_registration.xml sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c8]bur.db sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1834 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1834 sl@0: //! @SYMTestCaseDesc Backup and restore with no change 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 REQ5906 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check sl@0: END_TESTCASE SYSLIB-SQL-CIT-1834 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive\ sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1835 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1835 sl@0: //! @SYMTestCaseDesc Backup and restore with database file deleted 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 REQ5906 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check sl@0: END_TESTCASE SYSLIB-SQL-CIT-1835 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive\ sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1836 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1836 sl@0: //! @SYMTestCaseDesc Backup and restore with database file modified 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 REQ5906 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini modify sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check sl@0: END_TESTCASE SYSLIB-SQL-CIT-1836 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive\ sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1837 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1837 sl@0: //! @SYMTestCaseDesc Backup and restore with database file corrupted 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 REQ5906 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS CopyFile z:\TEF_SQL\TestData\[102827c7]corrupt.db c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS MakeReadWrite c:\private\10281e17\[102827c7]bur.db sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check sl@0: END_TESTCASE SYSLIB-SQL-CIT-1837 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive\ sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1838 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1838 sl@0: //! @SYMTestCaseDesc Backup and restore with database file from 2 data owners 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 REQ5906 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap2 CSQLDDT z:\TEF_SQL\BUR.ini setup2 sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur2 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c8]bur.db sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur2 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap2 CSQLDDT z:\TEF_SQL\BUR.ini check2 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1838 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c8]bur.db sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive\ sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1839-0001 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1839-0001 sl@0: //! @SYMTestCaseDesc Backup and restore with 3 database files 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 REQ5906 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup3 sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur1.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur2.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur3.db sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check3 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1839-0001 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur1.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur2.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur3.db sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-4026 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-4026 sl@0: //! @SYMTestCaseDesc Backup and restore a database file (with no extension) 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: //! @SYMDEF INC118192 sl@0: //! PDEF118675 sl@0: //! PDEF118676 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini setup4 sl@0: RUN_TEST_STEP -1 BURTestServer TestBackup z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]118192 sl@0: RUN_TEST_STEP -1 BURTestServer TestRestore z:\TEF_SQL\BUR.ini bur sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini wait sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\BUR.ini check4 sl@0: END_TESTCASE SYSLIB-SQL-CIT-4026 sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]118192 sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive sl@0: sl@0: //cleanup sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]bur.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c8]bur.db sl@0: RUN_UTILS MakeReadWrite c:\private\102827c7\backup_registration.xml sl@0: RUN_UTILS MakeReadWrite c:\private\102827c8\backup_registration.xml sl@0: RUN_UTILS DeleteFile c:\private\102827c7\backup_registration.xml sl@0: RUN_UTILS DeleteFile c:\private\102827c8\backup_registration.xml sl@0: RUN_UTILS DeleteDirectory c:\BackupArchive\ sl@0: RUN_UTILS DeleteDirectory c:\private\102827c7\ sl@0: RUN_UTILS DeleteDirectory c:\private\102827c8\ sl@0: sl@0: