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_cap1 sl@0: LOAD_SUITE te_SQL_Suite_cap2 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 MkDir c:\private\10281e17\ sl@0: sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec1.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec2.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec4.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c8]sec.db sl@0: RUN_UTILS DeleteFile c:\private\102827c7\sec.db sl@0: RUN_UTILS DeleteFile c:\private\102827c8\sec.db sl@0: RUN_UTILS DeleteFile c:\private\102827c8\sec3.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec_copy.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]secpol.db sl@0: sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1839 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1839 sl@0: //! @SYMTestCaseDesc PlatSec tests creating databases 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create1a sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create1b sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini create2 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini create3 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create4 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create5 sl@0: RUN_PANIC_STEP_RESULT 2 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create6 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create7 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create8 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create9 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create10 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap2 CSQLDDT z:\TEF_SQL\security.ini create11 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create12 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini create12a sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap2 CSQLDDT z:\TEF_SQL\security.ini create12b sl@0: END_TESTCASE SYSLIB-SQL-CIT-1839 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1840 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1840 sl@0: //! @SYMTestCaseDesc PlatSec tests reading databases 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini read1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini read2 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini read3 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini read4 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini read4 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1840 sl@0: sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1841 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1841 sl@0: //! @SYMTestCaseDesc PlatSec tests writing to databases 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 REQ5794 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini write1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini write2 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1841 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1842 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1842 sl@0: //! @SYMTestCaseDesc PlatSec tests changing the schema of databases 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini schema1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini schema2 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1842 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1843 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1843 sl@0: //! @SYMTestCaseDesc PlatSec tests checking the enforcement of security during attach operations 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini attach1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini attach2 sl@0: RUN_TEST_STEP -1 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini attach3 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini attach4 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini attach5 sl@0: // RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini attach6 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1843 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1844 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1844 sl@0: //! @SYMTestCaseDesc PlatSec tests checking the DB Copy operations within the security constraints 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy2 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy3 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy4 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy5 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy6 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini copy7 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1844 sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1845 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1845 sl@0: //! @SYMTestCaseDesc PlatSec tests checking that the table level policy has no effect sl@0: //! as it's not supported yet 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLCDT z:\TEF_SQL\security.ini policy1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLCDT z:\TEF_SQL\security.ini policy2 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1845 sl@0: sl@0: RUN_UTILS DeleteFile c:\ext.pol sl@0: sl@0: START_TESTCASE SYSLIB-SQL-CIT-1846 sl@0: //! @SYMTestCaseID SYSLIB-SQL-CIT-1846 sl@0: //! @SYMTestCaseDesc PlatSec tests for RSalSecurity::Externalize and Internalize methods 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 REQ5794 sl@0: sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini External1 sl@0: RUN_TEST_STEP 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini External2 sl@0: RUN_TEST_STEP 100 te_SQL_Suite_cap1 CSQLDDT z:\TEF_SQL\security.ini External3 sl@0: RUN_UTILS MakeReadWrite c:\ext.pol sl@0: RUN_UTILS DeleteFile c:\ext.pol sl@0: RUN_UTILS CopyFile z:\TEF_SQL\TestData\ext.pol c:\ext.pol sl@0: RUN_UTILS MakeReadWrite c:\ext.pol sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]ext.db sl@0: RUN_PANIC_STEP_RESULT 4 SqlDb 100 te_SQL_Suite CSQLDDT z:\TEF_SQL\security.ini External2 sl@0: END_TESTCASE SYSLIB-SQL-CIT-1846 sl@0: sl@0: RUN_UTILS DeleteFile c:\ext.pol sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec1.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec2.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec4.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c8]sec.db sl@0: RUN_UTILS DeleteFile c:\private\102827c7\sec.db sl@0: RUN_UTILS DeleteFile c:\private\102827c8\sec.db sl@0: RUN_UTILS DeleteFile c:\private\102827c8\sec3.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]sec_copy.db sl@0: RUN_UTILS DeleteFile c:\private\10281e17\[102827c7]secpol.db sl@0: sl@0: //cleanup sl@0: RUN_UTILS DeleteDirectory c:\private\102827c7\ sl@0: RUN_UTILS DeleteDirectory c:\private\102827c8\ sl@0: