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