protected override void OnDispose(bool disposing)
{
if (disposing)
{
_db.Dispose();
}
}
public void Dispose()
{
if (_context != null)
{
_context.Dispose();
}
}
public virtual async Task <InstallationResult> InstallAsync(InstallationModel model, ILifetimeScope scope, CancellationToken cancelToken = default)
{
Guard.NotNull(model, nameof(model));
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.CheckingRequirements");
x.Completed = false;
Logger.Info(x.ProgressMessage);
});
if (DataSettings.DatabaseIsInstalled())
{
return(UpdateResult(x =>
{
x.Success = true;
x.RedirectUrl = _urlHelper.Action("Index", "Home");
Logger.Info("Application already installed");
}));
}
DbFactory dbFactory = null;
try
{
dbFactory = DbFactory.Load(model.DataProvider, _appContext.TypeScanner);
}
catch (Exception ex)
{
return(UpdateResult(x =>
{
x.Errors.Add(ex.Message);
Logger.Error(ex);
}));
}
model.DbRawConnectionString = model.DbRawConnectionString?.Trim();
DbConnectionStringBuilder conStringBuilder = null;
try
{
// Try to create connection string
if (model.UseRawConnectionString)
{
conStringBuilder = dbFactory.CreateConnectionStringBuilder(model.DbRawConnectionString);
}
else
{
// Structural connection string
var userId = model.DbUserId;
var password = model.DbPassword;
if (model.DataProvider == "sqlserver" && model.DbAuthType == "windows")
{
userId = null;
password = null;
}
conStringBuilder = dbFactory.CreateConnectionStringBuilder(model.DbServer, model.DbName, userId, password);
}
}
catch (Exception ex)
{
return(UpdateResult(x =>
{
x.Errors.Add(GetResource("ConnectionStringWrongFormat"));
Logger.Error(ex, x.Errors.Last());
}));
}
// Check FS access rights
CheckFileSystemAccessRights(GetInstallResult().Errors);
if (GetInstallResult().HasErrors)
{
return(UpdateResult(x =>
{
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error("Aborting installation.");
}));
}
ILifetimeScope richScope = null;
SmartDbContext dbContext = null;
var shouldDeleteDbOnFailure = false;
try
{
cancelToken.ThrowIfCancellationRequested();
var conString = conStringBuilder.ConnectionString;
var settings = DataSettings.Instance;
settings.AppVersion = SmartstoreVersion.Version;
settings.DbFactory = dbFactory;
settings.ConnectionString = conString;
// So that DataSettings.DatabaseIsInstalled() returns false during installation.
DataSettings.SetTestMode(true);
// Resolve SeedData instance from primary language
var lazyLanguage = GetAppLanguage(model.PrimaryLanguage);
if (lazyLanguage == null)
{
return(UpdateResult(x =>
{
x.Errors.Add(GetResource("Install.LanguageNotRegistered").FormatInvariant(model.PrimaryLanguage));
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error(x.Errors.Last());
}));
}
// Create the DataContext
dbContext = (SmartDbContext)dbFactory.CreateApplicationDbContext(
conString,
_appContext.AppConfiguration.DbMigrationCommandTimeout,
SmartDbContext.MigrationHistoryTableName);
// Delete only on failure if WE created the database.
var canConnectDatabase = await dbContext.Database.CanConnectAsync(cancelToken);
shouldDeleteDbOnFailure = !canConnectDatabase;
cancelToken.ThrowIfCancellationRequested();
// Create Language domain object from lazyLanguage
var languages = dbContext.Languages;
var primaryLanguage = new Language
{
Name = lazyLanguage.Metadata.Name,
LanguageCulture = lazyLanguage.Metadata.Culture,
UniqueSeoCode = lazyLanguage.Metadata.UniqueSeoCode,
FlagImageFileName = lazyLanguage.Metadata.FlagImageFileName
};
// Build the seed configuration model
var seedConfiguration = new SeedDataConfiguration
{
DefaultUserName = model.AdminEmail,
DefaultUserPassword = model.AdminPassword,
SeedSampleData = model.InstallSampleData,
Data = lazyLanguage.Value,
Language = primaryLanguage,
StoreMediaInDB = model.MediaStorage == "db",
ProgressMessageCallback = msg => UpdateResult(x => x.ProgressMessage = GetResource(msg))
};
var seeder = new InstallationDataSeeder(seedConfiguration, Logger, _httpContextAccessor);
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.BuildingDatabase");
Logger.Info(x.ProgressMessage);
});
//// TEST
//return UpdateResult(x =>
//{
// x.Completed = true;
// x.Success = true;
// //x.RedirectUrl = _urlHelper.Action("Index", "Home");
// Logger.Info("Installation completed successfully");
//});
// ===>>> Actually performs database creation.
await dbContext.Database.MigrateAsync(cancelToken);
cancelToken.ThrowIfCancellationRequested();
// ===>>> Seeds data.
await seeder.SeedAsync(dbContext);
cancelToken.ThrowIfCancellationRequested();
// ... Install modules
// Detect media file tracks (must come after plugins installation)
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.ProcessingMedia");
Logger.Info(x.ProgressMessage);
});
richScope = scope.BeginLifetimeScope(c =>
{
// At this stage (after the database has been created and seeded completely) we can create a richer service scope
// to minimize the risk of dependency resolution exceptions during more complex install operations.
c.RegisterInstance(dbContext);
c.Register <IStoreContext>(cc => new StoreContext(cc.Resolve <ICacheFactory>(), null, _httpContextAccessor, cc.Resolve <IActionContextAccessor>()));
c.Register <ISettingFactory>(cc => new SettingFactory(cc.Resolve <ICacheManager>(), null, _httpContextAccessor));
});
var mediaTracker = richScope.Resolve <IMediaTracker>();
foreach (var album in richScope.Resolve <IAlbumRegistry>().GetAlbumNames(true))
{
await mediaTracker.DetectAllTracksAsync(album, cancelToken);
}
cancelToken.ThrowIfCancellationRequested();
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.Finalizing");
Logger.Info(x.ProgressMessage);
});
// Now persist settings
settings.Save();
// SUCCESS: Redirect to home page
return(UpdateResult(x =>
{
x.Completed = true;
x.Success = true;
x.RedirectUrl = _urlHelper.Action("Index", "Home");
Logger.Info("Installation completed successfully");
}));
}
catch (Exception ex)
{
Logger.Error(ex);
// Delete Db if it was auto generated
if (dbContext != null && shouldDeleteDbOnFailure)
{
try
{
Logger.Debug("Deleting database");
await dbContext.Database.EnsureDeletedAsync(cancelToken);
}
catch { }
}
// Clear provider settings if something got wrong
DataSettings.Delete();
var msg = ex.Message;
var realException = ex;
while (realException.InnerException != null)
{
realException = realException.InnerException;
}
if (!object.Equals(ex, realException))
{
msg += " (" + realException.Message + ")";
}
return(UpdateResult(x =>
{
x.Errors.Add(string.Format(GetResource("SetupFailed"), msg));
x.Success = false;
x.Completed = true;
x.RedirectUrl = null;
}));
}
finally
{
if (dbContext != null)
{
dbContext.Dispose();
}
if (richScope != null)
{
richScope.Dispose();
}
}
}
public virtual async Task <InstallationResult> InstallAsync(InstallationModel model, ILifetimeScope scope)
{
// TODO: (core) CancellationToken
Guard.NotNull(model, nameof(model));
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.CheckingRequirements");
x.Completed = false;
Logger.Info(x.ProgressMessage);
});
if (DataSettings.DatabaseIsInstalled())
{
return(UpdateResult(x =>
{
x.Success = true;
x.RedirectUrl = _urlHelper.Action("Index", "Home");
Logger.Info("Application already installed");
}));
}
//// set page timeout to 5 minutes
//this.Server.ScriptTimeout = 300;
DbFactory dbFactory = null;
try
{
dbFactory = DbFactory.Load(model.DataProvider, _appContext.TypeScanner);
}
catch
{
return(UpdateResult(x =>
{
x.Errors.Add(GetResource("ConnectionStringRequired")); // TODO: (core) ErrMessage
Logger.Error(x.Errors.Last());
}));
}
model.DatabaseConnectionString = model.DatabaseConnectionString?.Trim();
DbConnectionStringBuilder conStringBuilder = null;
if (model.SqlConnectionInfo.EqualsNoCase("sqlconnectioninfo_raw"))
{
// Raw connection string
if (string.IsNullOrEmpty(model.DatabaseConnectionString))
{
return(UpdateResult(x =>
{
x.Errors.Add(GetResource("ConnectionStringRequired"));
Logger.Error(x.Errors.Last());
}));
}
try
{
// Try to create connection string
conStringBuilder = dbFactory.CreateConnectionStringBuilder(model.DatabaseConnectionString);
}
catch (Exception ex)
{
return(UpdateResult(x =>
{
x.Errors.Add(GetResource("ConnectionStringWrongFormat"));
Logger.Error(ex, x.Errors.Last());
}));
}
}
else
{
// Structural connection string
// TODO: (core) ...
}
// TODO: (core) Access rights check ...
if (GetInstallResult().HasErrors)
{
return(UpdateResult(x =>
{
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error("Aborting installation.");
}));
}
SmartDbContext dbContext = null;
var shouldDeleteDbOnFailure = false;
try
{
var conString = conStringBuilder.ConnectionString;
var settings = DataSettings.Instance;
settings.AppVersion = SmartstoreVersion.Version;
settings.DbFactory = dbFactory;
settings.ConnectionString = conString;
// So that DataSettings.DatabaseIsInstalled() returns false during installation.
DataSettings.SetTestMode(true);
// resolve SeedData instance from primary language
var lazyLanguage = GetAppLanguage(model.PrimaryLanguage);
if (lazyLanguage == null)
{
return(UpdateResult(x =>
{
x.Errors.Add(GetResource("Install.LanguageNotRegistered").FormatInvariant(model.PrimaryLanguage));
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error(x.Errors.Last());
}));
}
// Create the DataContext
dbContext = (SmartDbContext)dbFactory.CreateApplicationDbContext(
conString,
_appContext.AppConfiguration.DbMigrationCommandTimeout,
HistoryRepository.DefaultTableName + "_Core"); // TODO: (core) Make const for core migration table name
// Delete only on failure if WE created the database.
shouldDeleteDbOnFailure = !await dbContext.Database.CanConnectAsync();
// Create Language domain object from lazyLanguage
var languages = dbContext.Languages;
var primaryLanguage = new Language
{
Name = lazyLanguage.Metadata.Name,
LanguageCulture = lazyLanguage.Metadata.Culture,
UniqueSeoCode = lazyLanguage.Metadata.UniqueSeoCode,
FlagImageFileName = lazyLanguage.Metadata.FlagImageFileName
};
// Build the seed configuration model
var seedConfiguration = new SeedDataConfiguration
{
DefaultUserName = model.AdminEmail,
DefaultUserPassword = model.AdminPassword,
SeedSampleData = model.InstallSampleData,
Data = lazyLanguage.Value,
Language = primaryLanguage,
StoreMediaInDB = model.MediaStorage == "db",
ProgressMessageCallback = msg => UpdateResult(x => x.ProgressMessage = GetResource(msg))
};
var seeder = new InstallationDataSeeder(seedConfiguration, Logger, _httpContextAccessor);
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.BuildingDatabase");
Logger.Info(x.ProgressMessage);
});
// ===>>> Actually performs database creation.
await dbContext.Database.MigrateAsync();
// ===>>> Seeds data.
await seeder.SeedAsync(dbContext);
// ...
// Detect media file tracks (must come after plugins installation)
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.ProcessingMedia");
Logger.Info(x.ProgressMessage);
});
using (var scope2 = scope.BeginLifetimeScope(c =>
{
c.RegisterInstance(dbContext);
c.Register <IStoreContext>(cc => new StoreContext(cc.Resolve <ICacheFactory>(), null, _httpContextAccessor, cc.Resolve <IActionContextAccessor>()));
c.Register <ISettingFactory>(cc => new SettingFactory(cc.Resolve <ICacheManager>(), null, _httpContextAccessor));
}))
{
var mediaTracker = scope2.Resolve <IMediaTracker>();
foreach (var album in scope2.Resolve <IAlbumRegistry>().GetAlbumNames(true))
{
await mediaTracker.DetectAllTracksAsync(album);
}
}
UpdateResult(x =>
{
x.ProgressMessage = GetResource("Progress.Finalizing");
Logger.Info(x.ProgressMessage);
});
// Now persist settings
settings.Save();
// SUCCESS: Redirect to home page
return(UpdateResult(x =>
{
x.Completed = true;
x.Success = true;
x.RedirectUrl = _urlHelper.Action("Index", "Home");
Logger.Info("Installation completed successfully");
}));
}
catch (Exception ex)
{
Logger.Error(ex);
// Delete Db if it was auto generated
if (dbContext != null && shouldDeleteDbOnFailure)
{
try
{
Logger.Debug("Deleting database");
await dbContext.Database.EnsureDeletedAsync();
}
catch { }
}
// Clear provider settings if something got wrong
DataSettings.Delete();
var msg = ex.Message;
var realException = ex;
while (realException.InnerException != null)
{
realException = realException.InnerException;
}
if (!object.Equals(ex, realException))
{
msg += " (" + realException.Message + ")";
}
return(UpdateResult(x =>
{
x.Errors.Add(string.Format(GetResource("SetupFailed"), msg));
x.Success = false;
x.Completed = true;
x.RedirectUrl = null;
}));
}
finally
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
}