private static void RunDatabaseInstaller()
{
var configBuilder = new ConfigurationBuilder();
configBuilder.AddUserSecrets("aspnet-DatabaseInstallerSampleApp-20160525082933");
var config = configBuilder.Build();
var serviceCollection = new ServiceCollection();
serviceCollection.AddDatabaseInstaller(config["Data:DefaultConnection:ConnectionString"]);
serviceCollection.AddLogging();
var serviceProvider = serviceCollection.BuildServiceProvider();
var loggerFactory = serviceProvider.GetRequiredService<ILoggerFactory>();
loggerFactory.AddConsole();
loggerFactory.WithFilter(new FilterLoggerSettings
{
{ "Rinsen", LogLevel.Debug }
});
var installer = serviceProvider.GetRequiredService<Installer>();
var info = installer.GetVersionInformation();
// Install installer and first version
var versionList = new List<DatabaseVersion>();
versionList.Add(new FirstTableVersion());
installer.Run(versionList);
// Install failing script and se that the rollback is working
var secondTable = new SecondTableVersion();
var exceptionFound = false;
try
{
versionList.Add(secondTable);
installer.Run(versionList);
}
catch (CommandFailedToExecuteException)
{
exceptionFound = true;
var installedVersion = installer.GetVersionInformation().Single(m => m.InstallationName == secondTable.InstallationName);
if (installedVersion.InstalledVersion != 1 || installedVersion.InstalledVersion != installedVersion.StartedInstallingVersion)
{
throw new Exception("This should not happen");
}
}
if (!exceptionFound)
{
throw new Exception("This should not happen number two");
}
// Install alteration only, clear out failing script
versionList.Clear();
versionList.Add(new CorrectSecondVersion());
installer.Run(versionList);
// Run with installation list containing previous version
versionList.Add(new ThirdVersion());
installer.Run(versionList);
}
