--- /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;
+    }