static void Main()
{
// Create migration announcer.
var announcer = new TextWriterAnnouncer(Console.WriteLine)
{
ShowSql = true
};
// Create migration context.
var migrationContext = new RunnerContext(announcer);
// Create migration options, factory and runner.
var options = new ProcessorOptions
{
PreviewOnly = false,
Timeout = 60
};
var factory = new SqliteProcessorFactory();
var processor = factory.Create(ConnectionString, announcer, options);
var runner = new MigrationRunner(Assembly.GetExecutingAssembly(), migrationContext, processor);
// Update database.
runner.MigrateUp(long.MaxValue, true);
// Rollback database.
runner.MigrateDown(long.MinValue, true);
}
private void CreateDatabaseSchemaInMemory(string connectionString)
{
if (connectionString == null)
{
throw new ArgumentNullException("connectionString");
}
// Enable testing profile in FluentMigrator.
Environment.SetEnvironmentVariable("TestingProfile", "1", EnvironmentVariableTarget.Process);
// Create migration announcer.
var announcer = new ConsoleAnnouncer();
// Create migration context.
var migrationContext = new RunnerContext(announcer);
// Create migration options, factory and runner.
var options = new ProcessorOptions
{
PreviewOnly = false,
Timeout = 60
};
var factory = new SqliteProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(Assembly.GetAssembly(typeof(MigrationExtensions)), migrationContext, processor);
// Update database.
runner.MigrateUp(long.MaxValue, true);
}
public void MigrateToLatest(string connectionString, MigrationType migrationType)
{
_announcer.Heading("Migrating " + connectionString);
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(_announcer)
{
Namespace = "NzbDrone.Core.Datastore.Migration",
ApplicationContext = new MigrationContext
{
MigrationType = migrationType,
SQLiteAlter = _sqLiteAlter,
MigrationHelper = _migrationHelper,
}
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new SqliteProcessorFactory();
var processor = factory.Create(connectionString, _announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
