public void Migrate()
{
var topics = SourceDbContext.Topics.ToList();
foreach (var oldTopic in topics)
{
var newEntity = new Topic()
{
Id = _topicKeyMapper.MapKey(oldTopic.Id),
PostDate = oldTopic.PostDate,
Subject = oldTopic.Subject,
ForumId = _forumKeyMapper.MapKey(oldTopic.ForumId),
PosterId = _userKeyMapper.MapKey(oldTopic.PosterId)
};
TargetDbContext.Topics.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void MigrateProjections()
{
var forums = SourceDbContext.Forums.ToList();
foreach (var oldForum in forums)
{
var newForum = TargetDbContext.Forums
.First(f => f.Id == _forumKeyMapper.MapKey(oldForum.Id));
newForum.LastPostDate = oldForum.LastPostDate;
newForum.LastPostPosterId = oldForum.LastPostPosterId != null?_userKeyMapper.MapKey((int)oldForum.LastPostPosterId) : (Guid?)null;
newForum.LastPostTopicId = oldForum.LastPostTopicId != null?_topicKeyMapper.MapKey(oldForum.LastPostTopicId) : (Guid?)null;
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var profileSyncs = SourceDbContext.ProfileSyncs.ToList();
foreach (var profileSync in profileSyncs)
{
var newEntity = new ProfileSync()
{
Id = _profileSyncKeyMapper.MapKey(profileSync.Id),
UserId = _userKeyMapper.MapKey(profileSync.AccountId)
};
TargetDbContext.ProfileSyncs.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var forumLastVisits = SourceDbContext.ForumLastVisits.ToList();
foreach (var oldForumLastVisit in forumLastVisits)
{
var newEntity = new ForumLastVisit()
{
Id = _forumLastVisitKeyMapper.MapKey(oldForumLastVisit.Id),
LastVisitDate = oldForumLastVisit.LastVisitDate,
UserId = _userKeyMapper.MapKey(oldForumLastVisit.AccountId)
};
TargetDbContext.ForumLastVisits.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var oldUnreadPosts = SourceDbContext.UnreadPosts.ToList();
foreach (var oldUnreadPost in oldUnreadPosts)
{
var newEntity = new UnreadPost()
{
Id = _unreadPostKeyMapper.MapKey(oldUnreadPost.Id),
PostId = _postKeyMapper.MapKey(oldUnreadPost.PostId),
UserId = _userKeyMapper.MapKey(oldUnreadPost.AccountId)
};
TargetDbContext.UnreadPosts.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var oldSettings = SourceDbContext.Settings.ToList();
foreach (var oldSetting in oldSettings)
{
var newEntity = new Setting()
{
Id = _settingKeyMapper.MapKey(oldSetting.Id),
Name = oldSetting.Name,
Value = oldSetting.Value,
UserId = _userKeyMapper.MapKey(oldSetting.AccountId)
};
TargetDbContext.Settings.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var signUps = SourceDbContext.SignUps.ToList();
foreach (var signUp in signUps)
{
var newEntity = new SignUp()
{
Id = _signUpKeyMapper.MapKey(signUp.Id),
Type = StringToSignUpType.Convert(signUp.Type),
EventId = _eventKeyMapper.MapKey(signUp.EventId),
UserId = _userKeyMapper.MapKey(signUp.AccountId)
};
TargetDbContext.SignUps.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var oldFeatureToggles = SourceDbContext.FeatureToggles.ToList();
foreach (var oldFeatureToggle in oldFeatureToggles)
{
var newEntity = new FeatureToggle()
{
Id = _featureToggleKeyMapper.MapKey(oldFeatureToggle.Id),
Feature = oldFeatureToggle.Feature,
Toggle = oldFeatureToggle.Toggle,
UserId = _userKeyMapper.MapKey(oldFeatureToggle.ToggleForId)
};
TargetDbContext.FeatureToggles.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var accounts = SourceDbContext.Accounts.ToList();
foreach (var account in accounts)
{
var user = new User
{
Id = _userKeyMapper.MapKey(account.Id),
ExternalId = Guid.NewGuid().ToString(),
DisplayName = account.DisplayName,
Email = account.Email
};
TargetDbContext.Users.Add(user);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var oldFeatureUses = SourceDbContext.FeatureUses.ToList();
foreach (var oldFeatureUse in oldFeatureUses)
{
var newEntity = new FeatureUse()
{
Id = _featureUseKeyMapper.MapKey(oldFeatureUse.Id),
UsedOn = oldFeatureUse.UsedOn,
Feature = oldFeatureUse.Feature,
RawData = oldFeatureUse.RawData,
UsedById = oldFeatureUse.UsedById != null?_userKeyMapper.MapKey((int)oldFeatureUse.UsedById) : (Guid?)null
};
TargetDbContext.FeatureUses.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var comments = SourceDbContext.Comments.ToList();
foreach (var comment in comments)
{
var newEntity = new Comment()
{
Id = _commentKeyMapper.MapKey(comment.Id),
PostDate = comment.PostDate,
Content = comment.Message,
GroupId = _commentGroupKeyMapper.MapKey(comment.GroupId),
PosterId = _userKeyMapper.MapKey(comment.PosterId)
};
TargetDbContext.Comments.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var claims = SourceDbContext.CharacterClaims.ToList();
foreach (var claim in claims)
{
var newClaim = new GameCharacterClaim()
{
Id = _gameCharacterClaimKeyMapper.MapKey(claim.Id),
FromTime = claim.FromTime,
EndTime = claim.EndTime,
UserId = _userKeyMapper.MapKey(claim.AccountId),
GameCharacterId = _gameCharacterKeyMapper.MapKey(claim.CharacterId)
};
TargetDbContext.GameCharacterClaims.Add(newClaim);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var posts = SourceDbContext.Posts.ToList();
foreach (var oldPost in posts)
{
var newEntity = new Post()
{
Id = _postKeyMapper.MapKey(oldPost.Id),
PostDate = oldPost.PostDate,
Content = oldPost.Message,
PosterId = _userKeyMapper.MapKey(oldPost.PosterId),
TopicId = _topicKeyMapper.MapKey(oldPost.TopicId)
};
TargetDbContext.Posts.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var oldCalendarExports = SourceDbContext.CalendarExports.ToList();
foreach (var oldCalendarExport in oldCalendarExports)
{
var newEntity = new CalendarExport()
{
Id = _calendarExportKeyMapper.MapKey(oldCalendarExport.Id),
ExportNew = oldCalendarExport.ExportNew,
ExportAbsence = oldCalendarExport.ExportAbsence,
Secret = oldCalendarExport.Secret,
UserId = _userKeyMapper.MapKey(oldCalendarExport.AccountId)
};
TargetDbContext.CalendarExports.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var oldActivityQueueItems = SourceDbContext.ActivityQueueItems.ToList();
foreach (var oldActivityQueueItem in oldActivityQueueItems)
{
var newEntity = new ActivityQueueItem()
{
Id = _activityQueueItemKeyMapper.MapKey(oldActivityQueueItem.Id),
ActivityType = oldActivityQueueItem.ActivityType,
ActivityOn = oldActivityQueueItem.ActivityOn,
RawData = oldActivityQueueItem.RawData,
ProcessedOn = oldActivityQueueItem.ProcessedOn,
ActivityById = oldActivityQueueItem.ActivityById != null?_userKeyMapper.MapKey((int)oldActivityQueueItem.ActivityById) : (Guid?)null
};
TargetDbContext.ActivityQueueItems.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
public void Migrate()
{
var events = SourceDbContext.Events.ToList();
foreach (var oldEvent in events)
{
var newEntity = new Event()
{
Id = _eventKeyMapper.MapKey(oldEvent.Id),
InviteTime = oldEvent.InviteTime,
StartTime = oldEvent.StartTime,
EndTime = oldEvent.EndTime,
Name = oldEvent.Name,
Description = oldEvent.Description,
State = StringToEventState.Convert(oldEvent.State),
CommentGroupId = _commentGroupKeyMapper.MapKey(oldEvent.CommentGroupId),
OrganiserId = _userKeyMapper.MapKey(oldEvent.OrganiserId)
};
TargetDbContext.Events.Add(newEntity);
}
TargetDbContext.SaveChanges();
}
