public SettingsMigrator(SmartObjectContext ctx)
{
Guard.NotNull(ctx, nameof(ctx));
_ctx = ctx;
_settings = _ctx.Set <Setting>();
}
public ActivityLogTypeMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_activityLogTypeRecords = _ctx.Set<ActivityLogType>();
}
public ActivityLogTypeMigrator(SmartObjectContext ctx)
{
Guard.NotNull(ctx, nameof(ctx));
_ctx = ctx;
_activityLogTypeRecords = _ctx.Set <ActivityLogType>();
}
public void SetUp()
{
var ctx = new SmartObjectContext(GetTestDbName());
Database.SetInitializer(new DropCreateDatabaseAlways <SmartObjectContext>());
ctx.Database.Initialize(true);
}
public virtual void SetUp()
{
context = new SmartObjectContext(GetTestDbName());
context.Database.Delete();
Database.SetInitializer(new TestDatabaseInitializer <SmartObjectContext, MigrationsConfiguration>(GetTestDbName()));
context.Database.Initialize(true);
}
public SettingsMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_settings = _ctx.Set <Setting>();
}
public SettingsMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_settings = _ctx.Set<Setting>();
}
public ActivityLogTypeMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_activityLogTypeRecords = _ctx.Set <ActivityLogType>();
}
public LocaleResourcesMigrator(SmartObjectContext ctx)
{
Guard.NotNull(ctx, nameof(ctx));
_ctx = ctx;
_languages = _ctx.Set <Language>();
_resources = _ctx.Set <LocaleStringResource>();
}
public PermissionMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_permissionRecords = _ctx.Set<PermissionRecord>();
_customerRoles = _ctx.Set<CustomerRole>().Expand(x => x.PermissionRecords);
}
public NewsItemConverter(IDbContext context)
{
_ctx = context as SmartObjectContext;
if (_ctx == null)
{
throw new ArgumentException("Passed context must be an instance of type '{0}'.".FormatInvariant(typeof(SmartObjectContext)), nameof(context));
}
}
public LocaleResourcesMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_languages = _ctx.Set<Language>();
_resources = _ctx.Set<LocaleStringResource>();
}
public LocaleResourcesMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_languages = _ctx.Set <Language>();
_resources = _ctx.Set <LocaleStringResource>();
}
public PermissionMigrator(SmartObjectContext ctx)
{
Guard.ArgumentNotNull(() => ctx);
_ctx = ctx;
_permissionRecords = _ctx.Set <PermissionRecord>();
_customerRoles = _ctx.Set <CustomerRole>().Expand(x => x.PermissionRecords);
}
public void Can_generate_schema()
{
var ctx = new SmartObjectContext("Test");
Database.SetInitializer<SmartObjectContext>(null);
string result = ctx.CreateDatabaseScript();
result.ShouldNotBeNull();
Console.Write(result);
}
public PermissionMigrator(SmartObjectContext ctx)
{
Guard.NotNull(ctx, nameof(ctx));
_ctx = ctx;
_permissionRecords = _ctx.Set <PermissionRecord>();
_customerRoles = _ctx.Set <CustomerRole>().Expand(x => x.PermissionRecords);
}
public void Can_generate_schema()
{
var ctx = new SmartObjectContext("Test");
Database.SetInitializer <SmartObjectContext>(null);
string result = ctx.CreateDatabaseScript();
result.ShouldNotBeNull();
Console.Write(result);
}
public MessageTemplateConverter(IDbContext context)
{
_ctx = context as SmartObjectContext;
if (_ctx == null)
{
throw new ArgumentException("Passed context must be an instance of type '{0}'.".FormatInvariant(typeof(SmartObjectContext)), nameof(context));
}
_defaultEmailAccount = _ctx.Set <EmailAccount>().FirstOrDefault(x => x.Email != null);
}
public void MigrateMediaFiles_Old(SmartObjectContext ctx)
{
var query = ctx.Set <MediaFile>();
//.Where(x => x.Version == 0)
//.Include(x => x.MediaStorage);
var pager = new FastPager <MediaFile>(query, 1000);
using (var scope = new DbContextScope(ctx,
hooksEnabled: false,
autoCommit: false,
proxyCreation: false,
validateOnSave: false,
lazyLoading: false))
{
while (pager.ReadNextPage(out var files))
{
foreach (var file in files)
{
if (file.Version > 0)
{
continue;
}
if (file.Extension.IsEmpty())
{
file.Extension = MimeTypes.MapMimeTypeToExtension(file.MimeType);
}
var name = file.Name;
if (name.IsEmpty())
{
name = file.Id.ToString(System.Globalization.CultureInfo.InvariantCulture);
}
else
{
name = MediaHelper.NormalizeFileName(file.Name.Truncate(292));
}
file.Name = name + "." + file.Extension;
file.CreatedOnUtc = file.UpdatedOnUtc;
file.Version = 1;
ProcessMediaFile(file);
}
// Save to DB
int num = scope.Commit();
// Breathe
ctx.DetachEntities <MediaFile>(deep: true);
}
}
}
public void CreateSettings(SmartObjectContext ctx)
{
var prefix = nameof(MediaSettings) + ".";
ctx.MigrateSettings(x =>
{
x.Add(prefix + nameof(MediaSettings.ImageTypes), string.Join(" ", MediaType.Image.DefaultExtensions));
x.Add(prefix + nameof(MediaSettings.VideoTypes), string.Join(" ", MediaType.Video.DefaultExtensions));
x.Add(prefix + nameof(MediaSettings.AudioTypes), string.Join(" ", MediaType.Audio.DefaultExtensions));
x.Add(prefix + nameof(MediaSettings.DocumentTypes), string.Join(" ", MediaType.Document.DefaultExtensions));
x.Add(prefix + nameof(MediaSettings.TextTypes), string.Join(" ", MediaType.Text.DefaultExtensions));
});
}
public static void MigrateLocaleResources(this SmartObjectContext ctx, Action <LocaleResourcesBuilder> fn, bool updateTouchedResources = false)
{
Guard.NotNull(ctx, nameof(ctx));
Guard.NotNull(fn, nameof(fn));
var builder = new LocaleResourcesBuilder();
fn(builder);
var entries = builder.Build();
var migrator = new LocaleResourcesMigrator(ctx);
migrator.Migrate(entries, updateTouchedResources);
}
public static void ExecutePendingResourceMigrations(string resPath, SmartObjectContext dbContext)
{
Guard.ArgumentNotNull(() => dbContext);
string headPath = Path.Combine(resPath, "head.txt");
if (!File.Exists(headPath))
{
return;
}
string resHead = File.ReadAllText(headPath).Trim();
if (!MigratorUtils.IsValidMigrationId(resHead))
{
return;
}
var migrator = new DbMigrator(new MigrationsConfiguration());
var migrations = GetPendingResourceMigrations(migrator, resHead);
foreach (var id in migrations)
{
if (IsAutomaticMigration(id))
{
continue;
}
if (!IsValidMigrationId(id))
{
continue;
}
// Resolve and instantiate the DbMigration instance from the assembly
var migration = CreateMigrationInstanceByMigrationId(id, migrator.Configuration);
var provider = migration as ILocaleResourcesProvider;
if (provider == null)
{
continue;
}
var builder = new LocaleResourcesBuilder();
provider.MigrateLocaleResources(builder);
var resEntries = builder.Build();
var resMigrator = new LocaleResourcesMigrator(dbContext);
resMigrator.Migrate(resEntries);
}
}
public static void MigrateSettings(this SmartObjectContext ctx, Action <SettingsBuilder> fn)
{
Guard.NotNull(ctx, nameof(ctx));
Guard.NotNull(fn, nameof(fn));
var builder = new SettingsBuilder();
fn(builder);
var entries = builder.Build();
var migrator = new SettingsMigrator(ctx);
migrator.Migrate(entries);
}
public void Add(Country country)
{
using (var ctx = new SmartObjectContext())
{
country.Name = "China";
country.AllowsBilling = true;
country.AllowsShipping = true;
country.LimitedToStores = false;
country.NumericIsoCode = 1;
country.Published = true;
country.ThreeLetterIsoCode = "a";
ctx.Countries.Add(country);
var id = ctx.SaveChanges();
}
}
/// <summary>
/// Persistance test helper
/// </summary>
/// <typeparam name="T">Entity type</typeparam>
/// <param name="entity">Entity</param>
/// <param name="disposeContext">A value indicating whether to dispose context</param>
protected T SaveAndLoadEntity <T>(T entity, bool disposeContext = true) where T : BaseEntity
{
context.Set <T>().Add(entity);
context.SaveChanges();
object id = entity.Id;
if (disposeContext)
{
context.Dispose();
context = new SmartObjectContext(GetTestDbName());
}
var fromDb = context.Set <T>().Find(id);
return(fromDb);
}
private void ReRefMessageTemplateAttachments(
SmartObjectContext ctx,
Dictionary <int, MessageTemplate> messageTemplatesDict,
Dictionary <int, Download> downloads)
{
bool hasChanges = false;
foreach (var kvp in messageTemplatesDict)
{
var downloadId = kvp.Key;
var mt = kvp.Value;
var idxProp = Array.IndexOf(new int?[] { mt.Attachment1FileId, mt.Attachment2FileId, mt.Attachment3FileId }, downloadId) + 1;
if (idxProp > 0)
{
var d = downloads.Get(downloadId);
if (d?.MediaFileId != null)
{
// Change Download.Id ref to MediaFile.Id
if (idxProp == 1)
{
mt.Attachment1FileId = d.MediaFileId;
}
if (idxProp == 2)
{
mt.Attachment2FileId = d.MediaFileId;
}
if (idxProp == 3)
{
mt.Attachment3FileId = d.MediaFileId;
}
// We don't need Download entity anymore
ctx.Set <Download>().Remove(d);
hasChanges = true;
}
}
}
if (hasChanges)
{
ctx.SaveChanges();
}
}
public void MigrateMediaFiles(SmartObjectContext ctx)
{
var query = ctx.Set <MediaFile>()
//.Where(x => x.Version == 0)
.Include(x => x.MediaStorage);
var pager = new FastPager <MediaFile>(query, 1000);
using (var scope = new DbContextScope(ctx,
hooksEnabled: false,
autoCommit: false,
proxyCreation: false,
validateOnSave: false,
lazyLoading: false))
{
while (pager.ReadNextPage(out var files))
{
foreach (var file in files)
{
if (file.Version > 0)
{
continue;
}
if (file.Extension.IsEmpty())
{
file.Extension = MimeTypes.MapMimeTypeToExtension(file.MimeType);
}
file.Name = file.Name + "." + file.Extension;
file.CreatedOnUtc = file.UpdatedOnUtc;
file.Version = 1;
ProcessMediaFile(file);
}
// Save to DB
int num = scope.Commit();
// Breathe
ctx.DetachEntities <MediaFile>(deep: true);
}
}
}
private static IDictionary <int, int> GetPoductPictureMap(SmartObjectContext context, IEnumerable <int> productIds)
{
var map = new Dictionary <int, int>();
var query = from pp in context.Set <ProductPicture>().AsNoTracking()
where productIds.Contains(pp.ProductId)
group pp by pp.ProductId into g
select new
{
ProductId = g.Key,
PictureIds = g.OrderBy(x => x.DisplayOrder)
.Take(1)
.Select(x => x.PictureId)
};
map = query.ToList().ToDictionary(x => x.ProductId, x => x.PictureIds.First());
return(map);
}
/// <remarks>
/// Lazy storing... fired on app shut down. Note that items with CacheItemPriority.NotRemovable are not removed when the cache is emptied.
/// We're beyond infrastructure and cannot use IOC objects here. It would lead to ComponentNotRegisteredException from autofac.
/// </remarks>
private static void OnDataRemoved(string key, object value, CacheItemRemovedReason reason)
{
try
{
if (key == Key)
{
var cacheData = value as List <WebApiUserCacheData>;
if (cacheData != null)
{
var dataToStore = cacheData.Where(x => x.LastRequest.HasValue && x.IsValid);
if (dataToStore.Count() > 0)
{
if (DataSettings.Current.IsValid())
{
var dbContext = new SmartObjectContext(DataSettings.Current.DataConnectionString);
foreach (var user in dataToStore)
{
try
{
dbContext.Execute("Update GenericAttribute Set Value = {1} Where Id = {0}", user.GenericAttributeId, user.ToString());
}
catch (Exception exc)
{
exc.Dump();
}
}
}
}
}
}
}
catch (Exception exc)
{
exc.Dump();
}
}
public void SetUp()
{
var ctx = new SmartObjectContext(GetTestDbName());
Database.SetInitializer(new DropCreateDatabaseAlways<SmartObjectContext>());
ctx.Database.Initialize(true);
}
public void Can_get_customer_content_by_type()
{
var customer = SaveAndLoadEntity <Customer>(GetTestCustomer(), false);
var product = SaveAndLoadEntity <Product>(GetTestProduct(), false);
var productReview = new ProductReview
{
Customer = customer,
Product = product,
Title = "Test",
ReviewText = "A review",
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02),
};
var productReviewHelpfulness = new ProductReviewHelpfulness
{
Customer = customer,
ProductReview = productReview,
WasHelpful = true,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04)
};
var blogComment = new BlogComment
{
Customer = customer,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04),
BlogPost = new BlogPost()
{
Title = "Title 1",
Body = "Body 1",
AllowComments = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
Language = new Language()
{
Name = "English",
LanguageCulture = "en-Us",
}
}
};
context.Set <CustomerContent>().Add(productReview);
context.Set <CustomerContent>().Add(productReviewHelpfulness);
context.Set <CustomerContent>().Add(blogComment);
context.SaveChanges();
context.Dispose();
context = new SmartObjectContext(GetTestDbName());
var query = context.Set <CustomerContent>();
query.ToList().Count.ShouldEqual(3);
var dbReviews = query.OfType <ProductReview>().ToList();
dbReviews.Count().ShouldEqual(1);
dbReviews.First().ReviewText.ShouldEqual("A review");
var dbHelpfulnessRecords = query.OfType <ProductReviewHelpfulness>().ToList();
dbHelpfulnessRecords.Count().ShouldEqual(1);
dbHelpfulnessRecords.First().WasHelpful.ShouldEqual(true);
var dbBlogCommentRecords = query.OfType <BlogComment>().ToList();
dbBlogCommentRecords.Count().ShouldEqual(1);
}
protected void ReloadContext()
{
context.Dispose();
context = new SmartObjectContext(GetTestDbName());
}
public void MigrateUploadedFiles(SmartObjectContext ctx)
{
var fileSet = ctx.Set <MediaFile>();
var folderSet = ctx.Set <MediaFolder>();
using (var scope = new DbContextScope(ctx,
hooksEnabled: false,
autoCommit: false,
validateOnSave: false,
lazyLoading: false,
autoDetectChanges: false))
{
var albumId = _albumRegistry.GetAlbumByName(SystemAlbumProvider.Files)?.Id;
var rootFolder = _mediaFileSystem.GetFolder("Uploaded");
if (!rootFolder.Exists)
{
return;
}
ProcessFolder(rootFolder, albumId.Value);
void ProcessFolder(IFolder folder, int mediaFolderId)
{
var newFiles = new List <FilePair>();
foreach (var uploadedFile in _mediaFileSystem.ListFiles(folder.Path))
{
var file = new MediaFile
{
CreatedOnUtc = uploadedFile.LastUpdated,
UpdatedOnUtc = uploadedFile.LastUpdated,
Extension = uploadedFile.Extension.TrimStart('.'),
Name = uploadedFile.Name,
MimeType = MimeTypes.MapNameToMimeType(uploadedFile.Name),
Size = Convert.ToInt32(uploadedFile.Size),
FolderId = mediaFolderId,
Version = 2
};
ProcessMediaFile(file);
newFiles.Add(new FilePair {
MediaFile = file, UploadedFile = uploadedFile
});
fileSet.Add(file);
}
// Process/save files of current folder
try
{
// Save files to DB
int num = scope.Commit();
// Copy/Move files
foreach (var newFile in newFiles)
{
if (_isFsProvider)
{
var newPath = GetStoragePath(newFile.MediaFile);
if (!_mediaFileSystem.FileExists(newPath))
{
// TODO: (mm) (mc) should we actually MOVE the file?
_mediaFileSystem.CopyFile(newFile.UploadedFile.Path, newPath);
}
}
else
{
_mediaStorageProvider.Save(newFile.MediaFile, MediaStorageItem.FromFile(newFile.UploadedFile));
}
}
if (!_isFsProvider)
{
// MediaFile.MediaStorageId has been updated, we need to save again.
num = scope.Commit();
}
}
catch
{
throw;
}
finally
{
newFiles.Clear();
// Breathe
ctx.DetachEntities <MediaFile>(deep: true);
}
foreach (var uploadedFolder in _mediaFileSystem.ListFolders(folder.Path))
{
var mediaFolder = new MediaFolder
{
Name = uploadedFolder.Name,
ParentId = mediaFolderId
};
// Add folder and save ASAP, we need the folder id
folderSet.Add(mediaFolder);
ctx.SaveChanges();
ProcessFolder(uploadedFolder, mediaFolder.Id);
}
}
}
}
public virtual void SetUp()
{
context = new SmartObjectContext(GetTestDbName());
}
protected virtual InstallationResult InstallCore(ILifetimeScope scope, InstallModel model)
{
UpdateResult(x =>
{
x.ProgressMessage = _locService.GetResource("Progress.CheckingRequirements");
x.Completed = false;
Logger.Info(x.ProgressMessage);
});
if (DataSettings.DatabaseIsInstalled())
{
return(UpdateResult(x =>
{
x.Success = true;
x.RedirectUrl = Url.Action("Index", "Home");
Logger.Info("Application already installed");
}));
}
// set page timeout to 5 minutes
this.Server.ScriptTimeout = 300;
if (model.DatabaseConnectionString != null)
{
model.DatabaseConnectionString = model.DatabaseConnectionString.Trim();
}
// SQL Server
if (model.DataProvider.Equals("sqlserver", StringComparison.InvariantCultureIgnoreCase))
{
if (model.SqlConnectionInfo.Equals("sqlconnectioninfo_raw", StringComparison.InvariantCultureIgnoreCase))
{
// raw connection string
if (string.IsNullOrEmpty(model.DatabaseConnectionString))
{
UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("ConnectionStringRequired"));
Logger.Error(x.Errors.Last());
});
}
try
{
// try to create connection string
new SqlConnectionStringBuilder(model.DatabaseConnectionString);
}
catch (Exception ex)
{
UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("ConnectionStringWrongFormat"));
Logger.Error(ex, x.Errors.Last());
});
}
}
else
{
// values
if (string.IsNullOrEmpty(model.SqlServerName))
{
UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("SqlServerNameRequired"));
Logger.Error(x.Errors.Last());
});
}
if (string.IsNullOrEmpty(model.SqlDatabaseName))
{
UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("DatabaseNameRequired"));
Logger.Error(x.Errors.Last());
});
}
// authentication type
if (model.SqlAuthenticationType.Equals("sqlauthentication", StringComparison.InvariantCultureIgnoreCase))
{
// SQL authentication
if (string.IsNullOrEmpty(model.SqlServerUsername))
{
UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("SqlServerUsernameRequired"));
Logger.Error(x.Errors.Last());
});
}
if (string.IsNullOrEmpty(model.SqlServerPassword))
{
UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("SqlServerPasswordRequired"));
Logger.Error(x.Errors.Last());
});
}
}
}
}
// Consider granting access rights to the resource to the ASP.NET request identity.
// ASP.NET has a base process identity
// (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6 and IIS 7,
// and the configured application pool identity on IIS 7.5) that is used if the application is not impersonating.
// If the application is impersonating via <identity impersonate="true"/>,
// the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
var webHelper = scope.Resolve <IWebHelper>();
// validate permissions
var dirsToCheck = FilePermissionHelper.GetDirectoriesWrite(webHelper);
foreach (string dir in dirsToCheck)
{
if (!FilePermissionHelper.CheckPermissions(dir, false, true, true, false))
{
UpdateResult(x =>
{
x.Errors.Add(string.Format(_locService.GetResource("ConfigureDirectoryPermissions"), WindowsIdentity.GetCurrent().Name, dir));
Logger.Error(x.Errors.Last());
});
}
}
var filesToCheck = FilePermissionHelper.GetFilesWrite(webHelper);
foreach (string file in filesToCheck)
{
if (!FilePermissionHelper.CheckPermissions(file, false, true, true, true))
{
UpdateResult(x =>
{
x.Errors.Add(string.Format(_locService.GetResource("ConfigureFilePermissions"), WindowsIdentity.GetCurrent().Name, file));
Logger.Error(x.Errors.Last());
});
}
}
if (GetInstallResult().HasErrors)
{
return(UpdateResult(x =>
{
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error("Aborting installation.");
}));
}
else
{
SmartObjectContext dbContext = null;
var shouldDeleteDbOnFailure = false;
try
{
string connectionString = null;
if (model.DataProvider.Equals("sqlserver", StringComparison.InvariantCultureIgnoreCase))
{
//SQL Server
if (model.SqlConnectionInfo.Equals("sqlconnectioninfo_raw", StringComparison.InvariantCultureIgnoreCase))
{
//raw connection string
//we know that MARS option is required when using Entity Framework
//let's ensure that it's specified
var sqlCsb = new SqlConnectionStringBuilder(model.DatabaseConnectionString);
sqlCsb.MultipleActiveResultSets = true;
connectionString = sqlCsb.ToString();
}
else
{
// values
connectionString = CreateConnectionString(
model.SqlAuthenticationType == "windowsauthentication",
model.SqlServerName, model.SqlDatabaseName,
model.SqlServerUsername, model.SqlServerPassword);
}
if (model.SqlServerCreateDatabase)
{
if (!SqlServerDatabaseExists(connectionString))
{
//create database
var collation = model.UseCustomCollation ? model.Collation : "";
var errorCreatingDatabase = CreateDatabase(connectionString, collation);
if (errorCreatingDatabase.HasValue())
{
return(UpdateResult(x =>
{
x.Errors.Add(errorCreatingDatabase);
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error(errorCreatingDatabase);
}));
}
else
{
// Database cannot be created sometimes. Weird! Seems to be Entity Framework issue
// that's just wait 3 seconds
Thread.Sleep(3000);
shouldDeleteDbOnFailure = true;
}
}
}
else
{
// check whether database exists
if (!SqlServerDatabaseExists(connectionString))
{
return(UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("DatabaseNotExists"));
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error(x.Errors.Last());
}));
}
}
}
else
{
// SQL CE
string databaseFileName = "SmartStore.Db.sdf";
string databasePath = @"|DataDirectory|\Tenants\{0}\{1}".FormatInvariant(DataSettings.Current.TenantName, databaseFileName);
connectionString = "Data Source=" + databasePath + "; Persist Security Info=False";
// drop database if exists
string databaseFullPath = HostingEnvironment.MapPath(DataSettings.Current.TenantPath.EnsureEndsWith("/")) + databaseFileName;
if (System.IO.File.Exists(databaseFullPath))
{
System.IO.File.Delete(databaseFullPath);
}
shouldDeleteDbOnFailure = true;
}
// save settings
var dataProvider = model.DataProvider;
var settings = DataSettings.Current;
settings.AppVersion = SmartStoreVersion.Version;
settings.DataProvider = dataProvider;
settings.DataConnectionString = connectionString;
settings.Save();
// init data provider
var dataProviderInstance = scope.Resolve <IEfDataProvider>();
// Although obsolete we have no other chance than using this here.
// Delegating this to DbConfiguration is not possible during installation.
#pragma warning disable 618
Database.DefaultConnectionFactory = dataProviderInstance.GetConnectionFactory();
#pragma warning restore 618
// resolve SeedData instance from primary language
var lazyLanguage = _locService.GetAppLanguage(model.PrimaryLanguage);
if (lazyLanguage == null)
{
return(UpdateResult(x =>
{
x.Errors.Add(_locService.GetResource("Install.LanguageNotRegistered").FormatInvariant(model.PrimaryLanguage));
x.Completed = true;
x.Success = false;
x.RedirectUrl = null;
Logger.Error(x.Errors.Last());
}));
}
// create the DataContext
dbContext = new SmartObjectContext();
// AuditableHook must run during install
dbContext.DbHookHandler = new DefaultDbHookHandler(new[]
{
new Lazy <IDbHook, HookMetadata>(() => new AuditableHook(), HookMetadata.Create <AuditableHook>(typeof(IAuditable), true), false)
});
// IMPORTANT: Migration would run way too early otherwise
Database.SetInitializer <SmartObjectContext>(null);
// create Language domain object from lazyLanguage
var languages = dbContext.Set <Language>();
var primaryLanguage = languages.Create(); // create a proxied type, resources cannot be saved otherwise
primaryLanguage.Name = lazyLanguage.Metadata.Name;
primaryLanguage.LanguageCulture = lazyLanguage.Metadata.Culture;
primaryLanguage.UniqueSeoCode = lazyLanguage.Metadata.UniqueSeoCode;
primaryLanguage.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 = _locService.GetResource(msg))
};
var seeder = new InstallDataSeeder(seedConfiguration, Logger);
Database.SetInitializer(new InstallDatabaseInitializer()
{
DataSeeders = new[] { seeder }
});
UpdateResult(x =>
{
x.ProgressMessage = _locService.GetResource("Progress.BuildingDatabase");
Logger.Info(x.ProgressMessage);
});
// ===>>> actually performs the installation by calling "InstallDataSeeder.Seed()" internally.
dbContext.Database.Initialize(true);
// Install plugins.
PluginManager.MarkAllPluginsAsUninstalled();
var pluginFinder = scope.Resolve <IPluginFinder>();
var plugins = pluginFinder.GetPlugins <IPlugin>(false)
//.ToList()
.OrderBy(x => x.PluginDescriptor.Group)
.ThenBy(x => x.PluginDescriptor.DisplayOrder)
.ToList();
var ignoredPluginsSetting = CommonHelper.GetAppSetting <string>("sm:PluginsIgnoredDuringInstallation");
var pluginsIgnoredDuringInstallation = String.IsNullOrEmpty(ignoredPluginsSetting) ?
new List <string>() :
ignoredPluginsSetting
.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)
.Select(x => x.Trim())
.ToList();
if (pluginsIgnoredDuringInstallation.Count > 0)
{
plugins = plugins.Where(x => !pluginsIgnoredDuringInstallation.Contains(x.PluginDescriptor.SystemName, StringComparer.OrdinalIgnoreCase)).ToList();
}
var pluginsCount = plugins.Count;
var idx = 0;
using (var dbScope = new DbContextScope(autoDetectChanges: false, hooksEnabled: false))
{
foreach (var plugin in plugins)
{
try
{
idx++;
UpdateResult(x =>
{
x.ProgressMessage = _locService.GetResource("Progress.InstallingPlugins").FormatInvariant(idx, pluginsCount);
Logger.InfoFormat("Installing plugin '{0}'.", plugin.PluginDescriptor.FriendlyName ?? plugin.PluginDescriptor.SystemName);
});
plugin.Install();
dbScope.Commit();
}
catch (Exception ex)
{
Logger.Error(ex);
if (plugin.PluginDescriptor.Installed)
{
PluginManager.MarkPluginAsUninstalled(plugin.PluginDescriptor.SystemName);
}
}
}
}
// Detect media file tracks (must come after plugins installation)
UpdateResult(x =>
{
x.ProgressMessage = _locService.GetResource("Progress.ProcessingMedia");
Logger.Info(x.ProgressMessage);
});
var mediaTracker = scope.Resolve <IMediaTracker>();
foreach (var album in scope.Resolve <IAlbumRegistry>().GetAlbumNames(true))
{
mediaTracker.DetectAllTracks(album, false);
}
UpdateResult(x =>
{
x.ProgressMessage = _locService.GetResource("Progress.Finalizing");
Logger.Info(x.ProgressMessage);
});
// Do not ignore settings migrated by data seeder (e.g. default media storage provider).
scope.Resolve <ISettingService>().ClearCache();
// SUCCESS: Redirect to home page
return(UpdateResult(x =>
{
x.Completed = true;
x.Success = true;
x.RedirectUrl = Url.Action("Index", "Home");
Logger.Info("Installation completed successfully");
}));
}
catch (Exception ex)
{
Logger.Error(ex);
// Clear provider settings if something got wrong
DataSettings.Delete();
// Delete Db if it was auto generated
if (dbContext != null && shouldDeleteDbOnFailure)
{
try
{
Logger.Debug("Deleting database");
dbContext.Database.Delete();
}
catch { }
}
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(_locService.GetResource("SetupFailed"), msg));
x.Success = false;
x.Completed = true;
x.RedirectUrl = null;
}));
}
finally
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
}
}
public void TearDown()
{
var ctx = new SmartObjectContext(GetTestDbName());
ctx.Database.Delete();
}
public void Can_get_customer_content_by_type()
{
var customer = SaveAndLoadEntity<Customer>(GetTestCustomer(), false);
var product = SaveAndLoadEntity<Product>(GetTestProduct(), false);
var productReview = new ProductReview
{
Customer = customer,
Product = product,
Title = "Test",
ReviewText = "A review",
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
UpdatedOnUtc = new DateTime(2010, 01, 02),
};
var productReviewHelpfulness = new ProductReviewHelpfulness
{
Customer = customer,
ProductReview = productReview,
WasHelpful = true,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04)
};
var blogComment = new BlogComment
{
Customer = customer,
IpAddress = "192.168.1.1",
IsApproved = true,
CreatedOnUtc = new DateTime(2010, 01, 03),
UpdatedOnUtc = new DateTime(2010, 01, 04),
BlogPost = new BlogPost()
{
Title = "Title 1",
Body = "Body 1",
AllowComments = true,
CreatedOnUtc = new DateTime(2010, 01, 01),
Language = new Language()
{
Name = "English",
LanguageCulture = "en-Us",
}
}
};
var table = context.Set<CustomerContent>();
table.RemoveRange(table.ToList());
table.Add(productReview);
table.Add(productReviewHelpfulness);
table.Add(blogComment);
context.SaveChanges();
context.Dispose();
context = new SmartObjectContext(GetTestDbName());
var query = context.Set<CustomerContent>();
query.ToList().Count.ShouldEqual(3);
var dbReviews = query.OfType<ProductReview>().ToList();
dbReviews.Count().ShouldEqual(1);
dbReviews.First().ReviewText.ShouldEqual("A review");
var dbHelpfulnessRecords = query.OfType<ProductReviewHelpfulness>().ToList();
dbHelpfulnessRecords.Count().ShouldEqual(1);
dbHelpfulnessRecords.First().WasHelpful.ShouldEqual(true);
var dbBlogCommentRecords = query.OfType<BlogComment>().ToList();
dbBlogCommentRecords.Count().ShouldEqual(1);
}
public void TearDown()
{
var ctx = new SmartObjectContext(GetTestDbName());
ctx.Database.Delete();
}