private void MigrationRunner_Migrated(MigrationRunner sender, Core.Events.MigrationEventArgs e)
{
if (TargetProductNames.Length == 0 || TargetProductNames.Contains(e.ProductName))
{
AfterMigration(sender, e);
}
}
void MigrationRunner_Migrated(MigrationRunner sender, Core.Events.MigrationEventArgs e)
{
var target = new Version(6, 0, 0);
if (e.ConfiguredVersion < target)
{
var sql = new Sql();
sql.Select("*")
.From <DocumentDto>()
.InnerJoin <ContentVersionDto>()
.On <DocumentDto, ContentVersionDto>(left => left.VersionId, right => right.VersionId)
.InnerJoin <ContentDto>()
.On <ContentVersionDto, ContentDto>(left => left.NodeId, right => right.NodeId)
.InnerJoin <NodeDto>()
.On <ContentDto, NodeDto>(left => left.NodeId, right => right.NodeId)
.Where <NodeDto>(x => x.NodeObjectType == new Guid("C66BA18E-EAF3-4CFF-8A22-41B16D66A972"))
.Where <NodeDto>(x => x.Path.StartsWith("-1"));
var uow = PetaPocoUnitOfWorkProvider.CreateUnitOfWork();
var dtos = uow.Database.Fetch <DocumentDto, ContentVersionDto, ContentDto, NodeDto>(sql);
var toUpdate = new List <DocumentDto>();
var versionGroup = dtos.GroupBy(x => x.NodeId);
foreach (var grp in versionGroup)
{
var published = grp.FirstOrDefault(x => x.Published);
var newest = grp.FirstOrDefault(x => x.Newest);
if (newest != null)
{
double timeDiff = new TimeSpan(newest.UpdateDate.Ticks - newest.ContentVersionDto.VersionDate.Ticks).TotalMilliseconds;
var hasPendingChanges = timeDiff > 2000;
if (hasPendingChanges == false && published != null)
{
published.Published = false;
toUpdate.Add(published);
newest.Published = true;
toUpdate.Add(newest);
}
}
}
//Commit the updated entries for the cmsDocument table
using (var transaction = uow.Database.GetTransaction())
{
//Loop through the toUpdate
foreach (var dto in toUpdate)
{
uow.Database.Update(dto);
}
transaction.Complete();
}
}
}
protected abstract void AfterMigration(MigrationRunner sender, Core.Events.MigrationEventArgs e);
private void MigrationRunner_Migrated(MigrationRunner sender, Core.Events.MigrationEventArgs e)
{
AfterMigration(sender, e);
}
