public static void ClassInitialize(TestContext context) { Console.WriteLine("TestContext.DeploymentDirectory={0}", context.DeploymentDirectory); Console.WriteLine("TestContext="); Console.WriteLine(DumpTestContext(context)); Console.WriteLine("Initializing relational databases..."); relationalStorage = RelationalStorageUtilities.CreateDefaultSqlServerStorageInstance(); Console.WriteLine("Dropping and recreating database '{0}' with connectionstring '{1}'", testDatabaseName, relationalStorage.ConnectionString); if (relationalStorage.ExistsDatabaseAsync(testDatabaseName).Result) { relationalStorage.DropDatabaseAsync(testDatabaseName).Wait(); } relationalStorage.CreateDatabaseAsync(testDatabaseName).Wait(); //The old storage instance has the previous connection string, time have a new handle with a new connection string... relationalStorage = relationalStorage.CreateNewStorageInstance(testDatabaseName); Console.WriteLine("Creating database tables..."); var creationScripts = RelationalStorageUtilities.RemoveBatchSeparators(File.ReadAllText("CreateOrleansTables_SqlServer.sql")); foreach (var creationScript in creationScripts) { var res = relationalStorage.ExecuteAsync(creationScript).Result; } //Currently there's only one database under test, SQL Server. So this as the other //setup is hardcoded here: putting the database in simple recovery mode. //This removes the use of recovery log in case of database crashes, which //improves performance to some degree, depending on usage. For non-performance testing only. var simpleModeRes = relationalStorage.ExecuteAsync(string.Format("ALTER DATABASE [{0}] SET RECOVERY SIMPLE;", testDatabaseName)).Result; Console.WriteLine("Initializing relational databases done."); siloOptions.DataConnectionString = relationalStorage.ConnectionString; }
public static void ClassInitialize(TestContext testContext) { TraceLogger.Initialize(new NodeConfiguration()); TraceLogger.AddTraceLevelOverride("SQLMembershipTableTests", Logger.Severity.Verbose3); // Set shorter init timeout for these tests OrleansSiloInstanceManager.initTimeout = TimeSpan.FromSeconds(20); Console.WriteLine("Initializing relational databases..."); relationalStorage = RelationalStorageUtilities.CreateDefaultSqlServerStorageInstance(); Console.WriteLine("Dropping and recreating database '{0}' with connectionstring '{1}'", testDatabaseName, relationalStorage.ConnectionString); if (relationalStorage.ExistsDatabaseAsync(testDatabaseName).Result) { relationalStorage.DropDatabaseAsync(testDatabaseName).Wait(); } relationalStorage.CreateDatabaseAsync(testDatabaseName).Wait(); //The old storage instance has the previous connection string, time have a new handle with a new connection string... relationalStorage = relationalStorage.CreateNewStorageInstance(testDatabaseName); Console.WriteLine("Creating database tables..."); var creationScripts = RelationalStorageUtilities.RemoveBatchSeparators(File.ReadAllText("CreateOrleansTables_SqlServer.sql")); foreach (var creationScript in creationScripts) { var res = relationalStorage.ExecuteAsync(creationScript).Result; } //Currently there's only one database under test, SQL Server. So this as the other //setup is hardcoded here: putting the database in simple recovery mode. //This removes the use of recovery log in case of database crashes, which //improves performance to some degree, depending on usage. For non-performance testing only. var simpleModeRes = relationalStorage.ExecuteAsync(string.Format("ALTER DATABASE [{0}] SET RECOVERY SIMPLE;", testDatabaseName)).Result; Console.WriteLine("Initializing relational databases done."); }
public static void ClassInitialize(TestContext testContext) { TraceLogger.Initialize(new NodeConfiguration()); TraceLogger.AddTraceLevelOverride("SQLMembershipTableTests", Logger.Severity.Verbose3); // Set shorter init timeout for these tests OrleansSiloInstanceManager.initTimeout = TimeSpan.FromSeconds(20); Console.WriteLine("Initializing relational databases..."); relationalStorage = RelationalStorageUtilities.CreateDefaultSqlServerStorageInstance(); Console.WriteLine("Dropping and recreating database '{0}' with connectionstring '{1}'", testDatabaseName, relationalStorage.ConnectionString); if(relationalStorage.ExistsDatabaseAsync(testDatabaseName).Result) { relationalStorage.DropDatabaseAsync(testDatabaseName).Wait(); } relationalStorage.CreateDatabaseAsync(testDatabaseName).Wait(); //The old storage instance has the previous connection string, time have a new handle with a new connection string... relationalStorage = relationalStorage.CreateNewStorageInstance(testDatabaseName); Console.WriteLine("Creating database tables..."); var creationScripts = RelationalStorageUtilities.RemoveBatchSeparators(File.ReadAllText("CreateOrleansTables_SqlServer.sql")); foreach(var creationScript in creationScripts) { var res = relationalStorage.ExecuteAsync(creationScript).Result; } //Currently there's only one database under test, SQL Server. So this as the other //setup is hardcoded here: putting the database in simple recovery mode. //This removes the use of recovery log in case of database crashes, which //improves performance to some degree, depending on usage. For non-performance testing only. var simpleModeRes = relationalStorage.ExecuteAsync(string.Format("ALTER DATABASE [{0}] SET RECOVERY SIMPLE;", testDatabaseName)).Result; Console.WriteLine("Initializing relational databases done."); }
public static void ClassInitialize(TestContext context) { Console.WriteLine("TestContext.DeploymentDirectory={0}", context.DeploymentDirectory); Console.WriteLine("TestContext="); Console.WriteLine(DumpTestContext(context)); Console.WriteLine("Initializing relational databases..."); relationalStorage = RelationalStorageUtilities.CreateDefaultSqlServerStorageInstance(); Console.WriteLine("Dropping and recreating database '{0}' with connectionstring '{1}'", testDatabaseName, relationalStorage.ConnectionString); if(relationalStorage.ExistsDatabaseAsync(testDatabaseName).Result) { relationalStorage.DropDatabaseAsync(testDatabaseName).Wait(); } relationalStorage.CreateDatabaseAsync(testDatabaseName).Wait(); //The old storage instance has the previous connection string, time have a new handle with a new connection string... relationalStorage = relationalStorage.CreateNewStorageInstance(testDatabaseName); Console.WriteLine("Creating database tables..."); var creationScripts = RelationalStorageUtilities.RemoveBatchSeparators(File.ReadAllText("CreateOrleansTables_SqlServer.sql")); foreach(var creationScript in creationScripts) { var res = relationalStorage.ExecuteAsync(creationScript).Result; } //Currently there's only one database under test, SQL Server. So this as the other //setup is hardcoded here: putting the database in simple recovery mode. //This removes the use of recovery log in case of database crashes, which //improves performance to some degree, depending on usage. For non-performance testing only. var simpleModeRes = relationalStorage.ExecuteAsync(string.Format("ALTER DATABASE [{0}] SET RECOVERY SIMPLE;", testDatabaseName)).Result; Console.WriteLine("Initializing relational databases done."); siloOptions.DataConnectionString = relationalStorage.ConnectionString; }