--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/sql/TEST/t_sqlenvcreate.cpp Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,186 @@
+// 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:
+// SQL security - copying secure test databases to C:
+// Please, ensure that t_sqlenvcreate test is executed before the other sql security tests
+//
+//
+
+#include <e32test.h>
+#include <bautils.h>
+
+RTest TheTest(_L("t_sqlenvcreate - copying secure test databases to C:"));
+
+_LIT(KSqlServerPrivateDirC, "c:\\private\\10281e17\\");
+
+_LIT(KDbZFileName1, "z:\\private\\10281e17\\[21212122]AADb2.db");
+_LIT(KDbZFileName2, "z:\\private\\10281e17\\[21212122]BBDb2.db");
+_LIT(KDbZFileName3, "z:\\private\\10281e17\\[21212125]T_AB.db");
+_LIT(KDbZFileName4, "z:\\private\\10281e17\\[1111CCCC]T_AB.db");
+_LIT(KDbZFileName5, "z:\\private\\10281e17\\[21212125]T_OneDefPolicy.db");
+
+_LIT(KDbCFileName1, "c:\\private\\10281e17\\[21212122]AADb2.db");
+_LIT(KDbCFileName2, "c:\\private\\10281e17\\[21212122]BBDb2.db");
+_LIT(KDbCFileName3, "c:\\private\\10281e17\\[21212125]T_AB.db");
+_LIT(KDbCFileName4, "c:\\private\\10281e17\\[1111CCCC]T_AB.db");
+_LIT(KDbCFileName5, "c:\\private\\10281e17\\[21212125]T_OneDefPolicy.db");
+
+_LIT(KDb1org, "z:\\private\\10281e17\\[98765432]t_nosettings.db");
+_LIT(KDb1, "c:\\private\\10281e17\\[98765432]t_nosettings.db");
+
+_LIT(KDb2org, "z:\\private\\10281e17\\[98765432]t_emptysettings.db");
+_LIT(KDb2, "c:\\private\\10281e17\\[98765432]t_emptysettings.db");
+
+_LIT(KDb3org, "z:\\private\\10281e17\\[98765432]t_invversion.db");
+_LIT(KDb3, "c:\\private\\10281e17\\[98765432]t_invversion.db");
+
+_LIT(KDb4org, "z:\\private\\10281e17\\[98765432]t_nocollation.db");
+_LIT(KDb4, "c:\\private\\10281e17\\[98765432]t_nocollation.db");
+
+_LIT(KDb5org, "z:\\private\\10281e17\\[98765432]t_longcollation.db");
+_LIT(KDb5, "c:\\private\\10281e17\\[98765432]t_longcollation.db");
+
+_LIT(KDb6org, "z:\\private\\10281e17\\[98765432]t_nodefaultpolicy.db");
+_LIT(KDb6, "c:\\private\\10281e17\\[98765432]t_nodefaultpolicy.db");
+
+_LIT(KDb7org, "z:\\private\\10281e17\\[98765432]t_invobject.db");
+_LIT(KDb7, "c:\\private\\10281e17\\[98765432]t_invobject.db");
+
+_LIT(KDb8org, "z:\\private\\10281e17\\[98765432]t_2defaultpolicies.db");
+_LIT(KDb8, "c:\\private\\10281e17\\[98765432]t_2defaultpolicies.db");
+
+///////////////////////////////////////////////////////////////////////////////////////
+///////////////////////////////////////////////////////////////////////////////////////
+//Test macros and functions
+static void Check(TInt aValue, TInt aExpected, TInt aLine)
+ {
+ if(aValue != aExpected)
+ {
+ RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
+ TheTest(EFalse, aLine);
+ }
+ }
+#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+void DoRun()
+ {
+ RFs fs;
+ TInt err = fs.Connect();
+ TEST2(err, KErrNone);
+
+ TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-LEGACY-T_SQLENVCREATE-0001 Copy secure databases from Z: to C: "));
+
+ err = BaflUtils::CopyFile(fs, KDbZFileName1, KDbCFileName1);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDbCFileName1, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDbZFileName2, KDbCFileName2);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDbCFileName2, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDbZFileName3, KDbCFileName3);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDbCFileName3, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDbZFileName4, KDbCFileName4);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDbCFileName4, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDbZFileName5, KDbCFileName5);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDbCFileName5, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb1org, KDb1);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb1, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb2org, KDb2);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb2, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb3org, KDb3);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb3, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb4org, KDb4);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb4, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb5org, KDb5);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb5, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb6org, KDb6);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb6, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb7org, KDb7);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb7, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ err = BaflUtils::CopyFile(fs, KDb8org, KDb8);
+ TEST2(err, KErrNone);
+ err = fs.SetAtt(KDb8, 0, KEntryAttReadOnly);
+ TEST2(err, KErrNone);
+
+ fs.Close();
+ }
+
+void CreateSqlServerPrivateDir()
+ {
+ RFs fs;
+ TInt err = fs.Connect();
+ TEST2(err, KErrNone);
+
+ TRAP(err, BaflUtils::EnsurePathExistsL(fs, KSqlServerPrivateDirC));
+ TEST2(err, KErrNone);
+
+ fs.Close();
+ }
+
+TInt E32Main()
+ {
+ TheTest.Title();
+
+ CTrapCleanup* tc = CTrapCleanup::New();
+
+ __UHEAP_MARK;
+
+ CreateSqlServerPrivateDir();
+
+ DoRun();
+
+ __UHEAP_MARKEND;
+
+ TheTest.End();
+ TheTest.Close();
+
+ delete tc;
+
+ User::Heap().Check();
+ return KErrNone;
+ }