public DbRollbackConsolable(IDatabaseMigrator databaseMigrator)
{
_databaseMigrator = databaseMigrator;
Usage("Rollback to [steps] previous migration").Arguments(m => m.Steps);
Usage("Rollback to the previous migration").Arguments();
}
public App(ILogger <App> log, IConfig config, IDatabaseCreator creator, IDatabaseMigrator migrator)
{
_log = log;
_config = config;
_creator = creator;
_migrator = migrator;
}
public void IntegratedBeforeEachTestFixture()
{
DatabaseCleaner = App.Container.GetInstance <IDatabaseCleaner>();
DatabaseMigrator = App.Container.GetInstance <IDatabaseMigrator>();
App.Log.Info("Running Database Migration");
DatabaseMigrator.UpdateSchema();
}
public void Configure(
IServiceScopeFactory scopeFactory,
IDatabaseMigrator dbMigrator,
IApplicationBuilder app,
ILogger <Startup> log,
IHostingEnvironment env)
{
var version = typeof(Startup).Assembly
.GetCustomAttribute <AssemblyInformationalVersionAttribute>()
.InformationalVersion;
log.LogInformation(Events.Startup, "Starting {ServerVersion}", version);
using (var scope = scopeFactory.CreateScope())
{
dbMigrator.Migrate();
}
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
}
app.UseMiddleware <IpBlockerMiddleware>();
app.UseMiddleware <LoggingMiddleware>();
app.UseMiddleware <CookieAuthenticationMiddleware>();
app.UseAuthentication();
app.UseStaticFiles();
app.UseSpaStaticFiles();
app.UseMiddleware <UserPreloadMiddleware>();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller}/{action=Index}/{id?}");
});
if (!Runtime.IsIntegrationTesting)
{
app.UseSpa(spa =>
{
spa.Options.SourcePath = "ClientApp";
if (env.IsDevelopment())
{
spa.UseAngularCliServer(npmScript: "start");
}
});
}
}
public void SetupDbMigrationTest()
{
DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock();
IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade);
migrator.Migrate(new SqlConnection());
Assert.True(dbAccessFacade.AppliedItems.Count == 5);
}
public DatabaseConnectionFactory(
[NotNull] IContainer container, [NotNull] IConfiguration configuration, [NotNull] ILogger logger, [NotNull] IDatabaseMigrator databaseMigrator,
[NotNull] IDataProtection dataProtection)
{
_Container = container ?? throw new ArgumentNullException(nameof(container));
_Configuration = configuration ?? throw new ArgumentNullException(nameof(configuration));
_Logger = logger ?? throw new ArgumentNullException(nameof(logger));
_DatabaseMigrator = databaseMigrator ?? throw new ArgumentNullException(nameof(databaseMigrator));
_DataProtection = dataProtection ?? throw new ArgumentNullException(nameof(dataProtection));
}
public MainVm(IDatabaseMigrator migrator, ILifetimeScope scope,
INotifsSenderDaemon notificationDaemon)
{
this.migrator = migrator;
this.scope = scope;
this.notificationDaemon = notificationDaemon;
GotoDayCmd = new DelegateCommand <TodoDay>(GoToDay, CanGoToDay);
GotoCalendarCmd = new DelegateCommand <TodoDay>(GoToCalendar, x => true);
GotoItemCmd = new DelegateCommand <TodoItem>(GoToItem, x => true);
}
public UnderlayCacheRepository(
ILogger <UnderlayCacheRepository> logger,
IDatabaseMigrator databaseMigrator)
{
_logger = logger;
_databaseMigrator = databaseMigrator;
_cachePath = PathHelper.CachePath();
if (!Directory.Exists(_cachePath))
{
Directory.CreateDirectory(_cachePath);
}
}
public void ParametersAndFiltersTest()
{
DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock();
config.AddScriptsLocation(Assembly.GetExecutingAssembly(), "TemplateTestScripts");
IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade);
migrator.Migrate(new SqlConnection());
PendingItem script = dbAccessFacade.ClasspathScripts.First(s => s.Version.Equals("201701171635"));
Assert.NotNull(script);
Assert.True(script.Content.ToString().Contains("0x"));
}
public void ParametersTest()
{
DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock();
config.AddParameter("parameters_test_key_1", "col1");
config.AddParameter("parameters_test_key_2", "col2");
IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade);
migrator.Migrate(new SqlConnection());
PendingItem script = dbAccessFacade.ClasspathScripts.First(s => s.Version.Equals("201606201610"));
Assert.NotNull(script);
Assert.True(script.Content.ToString().Contains("[col1]"));
Assert.True(script.Content.ToString().Contains("[col2]"));
Assert.False(script.Content.ToString().Contains("{{parameters_test_key_1}}"));
Assert.False(script.Content.ToString().Contains("{{parameters_test_key_2}}"));
}
public void RepeatableScriptsReapplyTest()
{
DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock();
dbAccessFacade.DbItems.Add(new AppliedItem
{
Id = "201606201701",
Type = ItemType.Repeatable,
Version = "201606201701",
Name = "R2016.06.20_1701_repeatable_test2.sql",
Executed = DateTime.Now,
Checksum = "2e542df38430899677f99ce8be5b97a7"
});
IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade);
migrator.Migrate(new SqlConnection());
Assert.True(dbAccessFacade.DbItems.Count == 1);
Assert.True(dbAccessFacade.AppliedItems.Count == 1);
}
public void RepeatableScriptsNoReapplyTest()
{
DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock();
dbAccessFacade.DbItems.Add(new AppliedItem
{
Id = "201606201701",
Type = ItemType.Repeatable,
Version = "201606201701",
Name = "R2016.06.20_1701_repeatable_test2.sql",
Executed = DateTime.Now,
Checksum = "470f6a50c4fd0323b2dc95be00ab72e1"
});
IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade);
migrator.Migrate(new SqlConnection());
Assert.True(dbAccessFacade.DbItems.Count == 1);
Assert.True(dbAccessFacade.AppliedItems.Count == 0);
}
public void UpdateSchemaTest()
{
DbAccessFacadeMock dbAccessFacade = new DbAccessFacadeMock();
dbAccessFacade.DbItems.Add(new AppliedItem
{
Id = "201606201607",
Type = ItemType.Versioned,
Version = "201606201607",
Name = "V2016.06.20_1607_test1.sql",
Executed = DateTime.Now,
Checksum = "2e542df38430899677f99ce8be5b97a6"
});
IDatabaseMigrator migrator = DatabaseMigratorBuilder.Build(config, dbAccessFacade);
migrator.Migrate(new SqlConnection());
Assert.True(dbAccessFacade.DbItems.Count == 5);
Assert.True(dbAccessFacade.AppliedItems.Count == 4);
}
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IDatabaseMigrator databaseMigrator)
{
Activity.DefaultIdFormat = ActivityIdFormat.W3C;
databaseMigrator.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseConfiguredSwagger();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public CompanyMigrationTest()
{
migrator = SetupTests.Container.Resolve <IDatabaseMigrator>();
repository = SetupTests.Container.Resolve <IRepository <DatabaseVersion> >();
}
public RollbackDatabaseHandler(IDatabaseMigrator migrator)
{
_migrator = migrator;
}
public DbResetConsolable(IDatabaseMigrator databaseMigrator)
{
_databaseMigrator = databaseMigrator;
}
public SqliteWorkQueueRepository([NotNull] IDatabaseConnectionFactory databaseConnectionFactory, [NotNull] IDatabaseMigrator databaseMigrator, [NotNull] IHasher hasher)
{
_DatabaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
_DatabaseMigrator = databaseMigrator ?? throw new ArgumentNullException(nameof(databaseMigrator));
_Hasher = hasher ?? throw new ArgumentNullException(nameof(hasher));
}
public DbMigrateConsolable(IDatabaseMigrator databaseMigrator)
{
_databaseMigrator = databaseMigrator;
}
public MigrationInitializer(IDatabaseMigrator migrator)
{
_migrator = migrator;
}
public ConsolableHandler(IDatabaseMigrator databaseMigrator)
{
_databaseMigrator = databaseMigrator;
}
public MigrationController(IDatabaseMigrator migrator) => _migrator = migrator;
public MigrateDatabaseHandler(IDatabaseMigrator migrator)
{
_migrator = migrator;
}
