protected override void ApplicationStartup(TinyIoCContainer container, IPipelines pipelines)
{
base.ApplicationStartup(container, pipelines);
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Server.Migrations"
};
var options = new MigrationOptions();
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2008ProcessorFactory();
var processor = factory.Create(
ConfigurationManager.ConnectionStrings["Simple.Data.Properties.Settings.DefaultConnectionString"].ConnectionString,
announcer,
options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
pipelines.EnableBasicAuthentication(new BasicAuthenticationConfiguration(new UserValidator(), "CPNRealm"));
JsonSettings.RetainCasing = true;
StaticConfiguration.DisableErrorTraces = false;
}
// Runs all migrations in the assembly of specified type
public static void RunMigrations(string connectionString, MigrationsAssembly migrationsAssembly, MigrationProcessorFactory factory = null)
{
try
{
var announcer = new NullAnnouncer();
//var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var assembly = migrationsAssembly.Assembly;
var migrationContext = new RunnerContext(announcer);
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var processor = (factory ?? new SqlServerProcessorFactory()).Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(useAutomaticTransactionManagement: true);
processor.Dispose();
}
catch (Exception ex)
{
var message = string.Format("Failed to run migrations for {0}", connectionString);
throw new Exception(message, ex);
}
}
public void MigrateToLatest()
{
try
{
var connectionString = _settingsService.ConnectionString(DatabaseContext.DefaultConnectionString);
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
NestedNamespaces = true,
Namespace = "Database.Migrations",
Connection = connectionString
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory();
using (var processor = factory.Create(connectionString, announcer, options))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
}
catch (Exception e)
{
}
}
public IMigrationProcessor GetMigrationProcessor(DatabaseType databaseType, string connectionString, RunnerContext context)
{
var announcer = new NullAnnouncer();
var options = new MigrationProcessorOptions(context);
var factory = GetProcessorFactory(databaseType);
var processor = factory.Create(connectionString, announcer, options);
return(processor);
}
private MigrationRunner GetRunner(Assembly assembly)
{
var factory = new SQLiteProcessorFactory();
var announcer = new NullAnnouncer();
var processor = factory.Create(connection, announcer, new MigrationOptions()
{
PreviewOnly = false, Timeout = 0
});
return(new MigrationRunner(assembly, new RunnerContext(announcer), processor));
}
public RunnerContext GetRunnerContext(string profile, IEnumerable <string> tags, bool previewOnly)
{
var announcer = new NullAnnouncer();
var context = new RunnerContext(announcer)
{
PreviewOnly = previewOnly,
Profile = profile,
Tags = tags
};
return(context);
}
public void MigrateToLatest()
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer);
var options = new ProcessorOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2008ProcessorFactory();
var processor = factory.Create(_settings.ConnectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
private MigrationRunner GetMigrator()
{
var announcer = new NullAnnouncer();
var migrationContext = new RunnerContext(announcer);
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.Oracle.OracleProcessorFactory();
var processor = factory.Create(this.connectionString, announcer, options);
var runner = new MigrationRunner(migrationsAssembly, migrationContext, processor);
return(runner);
}
private IAnnouncer GetAnnouncer()
{
IAnnouncer retVal = null;
if (Environment.UserInteractive)
{
retVal = new TextWriterAnnouncer(s => Debug.WriteLine(s));
}
else
{
retVal = new NullAnnouncer();
}
return(retVal);
}
private static MigrationRunner GetRunner(string connectionString, IMigrationProcessorFactory factory)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Migrations"
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var processor = factory.Create(connectionString, announcer, options);
return(new MigrationRunner(assembly, migrationContext, processor));
}
private void MigrateTo(long targetVersion)
{
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var announcer = new NullAnnouncer();
var processor = new SqlServer2012ProcessorFactory().Create(connectionString, announcer, options);
var migrationContext = new RunnerContext(announcer)
{
Namespace = "DDDEastAnglia.DatabaseMigrations.Migrations"
};
var runner = new MigrationRunner(GetType().Assembly, migrationContext, processor);
runner.MigrateUp(targetVersion, true);
}
protected virtual MigrationRunner GetRunner()
{
string connString = string.Format("Data Source={0}", DatabaseFile);
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 0
};
//var factory = new FluentMigrator.Runner.Processors.SQLite.SQLiteProcessorFactory();
var factory = new MonoSQLiteProcessorFactory();
var assembly = Assembly.GetExecutingAssembly();
var announcer = new NullAnnouncer();
var migrationContext = new RunnerContext(announcer);
var processor = factory.Create(connString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
return(runner);
}
public static void MigrateToLatest(string connectionString)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Bloqs.Logging.Data.Migrations"
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
/// <summary>
/// Migrate the database to the latest version.
/// </summary>
/// <param name="connectionStringName">The name of the connection string.</param>
public static void MigrateToLatest(string connectionStringName)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetAssembly(typeof(CreateCountriesTable));
var migrationContext = new RunnerContext(announcer)
{
Namespace = "ExampleApplication.Database.Migrations"
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory();
using (var processor = factory.Create(connectionStringName, announcer, options))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
}
