private static void RunMigrations() { var defaultConnection = SqlConnections.GetConnectionString("Default"); // safety check to ensure that we are not modifying another database if (defaultConnection.ConnectionString.IndexOf(typeof(SiteInitialization).Namespace + @"_Default_v1") < 0) return; using (var sw = new StringWriter()) { var announcer = new TextWriterWithGoAnnouncer(sw) { ShowSql = true }; var runner = new RunnerContext(announcer) { Database = "SqlServer", Connection = defaultConnection.ConnectionString, Targets = new string[] { typeof(SiteInitialization).Assembly.Location }, Task = "migrate:up", WorkingDirectory = Path.GetDirectoryName(typeof(SiteInitialization).Assembly.Location), Namespace = "MovieTutorial.Migrations.DefaultDB" }; new TaskExecutor(runner).Execute(); } }
public void TestSetup() { _stringWriter = new StringWriter(); announcer = new TextWriterWithGoAnnouncer(_stringWriter) { ShowElapsedTime = true, ShowSql = true }; }
private static void RunMigrations(string databaseKey) { var cs = SqlConnections.GetConnectionString(databaseKey); var connection = cs.ConnectionString; // safety check to ensure that we are not modifying an arbitrary database. // remove these two lines if you want Serene1 migrations to run on your DB. if (cs.ConnectionString.IndexOf(typeof(SiteInitialization).Namespace + @"_" + databaseKey + "_v1", StringComparison.OrdinalIgnoreCase) < 0) { SkippedMigrations = true; return; } string databaseType = "SqlServer"; if (String.Equals(cs.ProviderName, "npgsql", StringComparison.OrdinalIgnoreCase)) databaseType = "Postgres"; else if (String.Equals(cs.ProviderName, "MySql.Data.MySqlClient", StringComparison.OrdinalIgnoreCase)) databaseType = "MySql"; using (var sw = new StringWriter()) { var announcer = new TextWriterWithGoAnnouncer(sw) { }; var runner = new RunnerContext(announcer) { Database = databaseType, Connection = cs.ConnectionString, Targets = new string[] { typeof(SiteInitialization).Assembly.Location }, Task = "migrate:up", WorkingDirectory = Path.GetDirectoryName(typeof(SiteInitialization).Assembly.Location), Namespace = "Serene1.Migrations." + databaseKey + "DB" }; new TaskExecutor(runner).Execute(); } }
private static void RunMigrations(string databaseKey) { var connectionString = SqlConnections.GetConnectionString(databaseKey); // safety check to ensure that we are not modifying an arbitrary database. // remove these two lines if you want Serene migrations to run on your DB. if (connectionString.ConnectionString.IndexOf(typeof(SiteInitialization).Namespace + @"_" + databaseKey + "_v1") < 0) return; using (var sw = new StringWriter()) { var announcer = new TextWriterWithGoAnnouncer(sw) { ShowSql = true }; var runner = new RunnerContext(announcer) { Database = "SqlServer", Connection = connectionString.ConnectionString, Targets = new string[] { typeof(SiteInitialization).Assembly.Location }, Task = "migrate:up", WorkingDirectory = Path.GetDirectoryName(typeof(SiteInitialization).Assembly.Location), Namespace = "Serene.Migrations." + databaseKey + "DB" }; new TaskExecutor(runner).Execute(); } }