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();
}
}
