public void ConvertExercises_Public()
{
Model.Old.Exercise exercise = new Exercise(Guid.NewGuid());
exercise.Name = "Exercise name";
exercise.ExerciseForceType = ExerciseForceType.Push;
exercise.Description = "desc";
exercise.ExerciseType = ExerciseType.Klatka;
exercise.MechanicsType = MechanicsType.Compound;
exercise.Shortcut = "EX";
exercise.Difficult = ExerciseDifficult.Two;
exercise.Status = PublishStatus.Published;
exercise.Profile = null;
exercise.Url = "Test";
insertToOldDatabase(exercise);
Convert();
var count = SessionNew.QueryOver <Model.Exercise>().RowCount();
Assert.AreEqual(2, count);
var newExercise = SessionNew.Get <Model.Exercise>(exercise.GlobalId);
Assert.AreEqual(exercise.Name, newExercise.Name);
Assert.AreEqual(exercise.Description, newExercise.Description);
Assert.AreEqual(exercise.Url, newExercise.Url);
Assert.AreEqual((int)exercise.ExerciseType, (int)newExercise.ExerciseType);
Assert.AreEqual((int)exercise.MechanicsType, (int)newExercise.MechanicsType);
Assert.AreEqual((int)exercise.ExerciseForceType, (int)newExercise.ExerciseForceType);
Assert.AreEqual((int)exercise.Difficult, (int)newExercise.Difficult);
Assert.IsNull(newExercise.Profile);
Assert.AreEqual(exercise.Shortcut, newExercise.Shortcut);
Assert.AreEqual(exercise.Rating, newExercise.Rating);
}
public void IsMissingExerciseExists()
{
Convert();
var missingExercise = SessionNew.QueryOver <Model.Exercise>().SingleOrDefault();
Assert.IsNotNull(missingExercise);
}
public void ConvertLoginData()
{
var profile = CreateProfile("profile1");
var wp71 = new LoginData();
wp71.ProfileId = profile.Id;
wp71.ApplicationLanguage = "pl";
wp71.ApplicationVersion = "1.0";
wp71.ClientInstanceId = Guid.NewGuid();
wp71.LoginDateTime = DateTime.Now.Date;
wp71.Platform = PlatformType.Linux;
wp71.PlatformVersion = "1.";
insertToOldDatabase(wp71);
Convert();
var dbProfile = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == "profile1").SingleOrDefault();
var newWp71 = SessionNew.QueryOver <Model.LoginData>().SingleOrDefault();
Assert.AreEqual(wp71.ApplicationLanguage, newWp71.ApplicationLanguage);
Assert.AreEqual(wp71.ApplicationVersion, newWp71.ApplicationVersion);
Assert.AreEqual(wp71.ClientInstanceId, newWp71.ClientInstanceId);
Assert.AreEqual(wp71.LoginDateTime, newWp71.LoginDateTime);
Assert.AreEqual((int)wp71.Platform, (int)newWp71.Platform);
Assert.AreEqual(wp71.PlatformVersion, newWp71.PlatformVersion);
Assert.AreEqual(dbProfile.GlobalId, newWp71.ProfileId);
}
public void ConvertProfile_FullVersionUsers()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.Birthday = DateTime.Now.Date;
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.CountryId = 2;
oldProfile.Password = "******";
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
insertToOldDatabase(oldProfile);
var wp71 = new Model.Old.LoginData();
wp71.ProfileId = oldProfile.Id;
wp71.ApplicationLanguage = "pl";
wp71.ApplicationVersion = "Full 2.3.0";
wp71.ClientInstanceId = Guid.NewGuid();
wp71.LoginDateTime = DateTime.Now.Date;
wp71.Platform = Model.Old.PlatformType.WindowsPhone;
wp71.PlatformVersion = "1.";
insertToOldDatabase(wp71);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.AreEqual(AccountType.PremiumUser, dbProfile.Licence.AccountType);
Assert.AreEqual(180, dbProfile.Licence.BAPoints);
Assert.AreEqual(DateTime.UtcNow.Date, dbProfile.Licence.LastPointOperationDate.Date);
}
public void ConvertProfile_Messages_SenderIsDeleted()
{
Model.Old.Profile oldProfile1 = CreateProfile("profile1");
Model.Old.Profile oldProfile2 = CreateProfile("profile2");
oldProfile1.IsDeleted = true;
insertToOldDatabase(oldProfile1);
Model.Old.Message msg = new Model.Old.Message();
msg.Content = "Test";
msg.ContentType = ContentType.Rtf;
msg.MessageType = MessageType.Custom;
msg.Priority = MessagePriority.Hight;
msg.CreatedDate = DateTime.UtcNow.Date;
msg.Sender = oldProfile1;
msg.Receiver = oldProfile2;
msg.Topic = "Topic";
insertToOldDatabase(msg);
Convert();
var newMsg = SessionNew.QueryOver <Model.Message>().Where(x => x.Priority != Model.MessagePriority.System).SingleOrDefault();
Assert.AreEqual(msg.Content, newMsg.Content);
Assert.AreEqual(msg.CreatedDate, newMsg.CreatedDate);
Assert.AreEqual((int)msg.Priority, (int)newMsg.Priority);
Assert.AreEqual(msg.Topic, newMsg.Topic);
Assert.AreEqual("(Deleted)", newMsg.Sender.UserName);
Assert.IsTrue(newMsg.Sender.IsDeleted);
Assert.AreEqual(msg.Receiver.UserName, newMsg.Receiver.UserName);
}
public void ConvertProfile_Friends()
{
Model.Old.Profile oldProfile1 = CreateProfile("profile1");
Model.Old.Profile oldProfile2 = CreateProfile("profile2");
Model.Old.Profile oldProfile3 = CreateProfile("profile3");
Model.Old.Profile oldProfile4 = CreateProfile("profile4");
oldProfile1.Friends.Add(oldProfile2);
oldProfile1.Friends.Add(oldProfile4);
oldProfile2.Friends.Add(oldProfile1);
oldProfile4.Friends.Add(oldProfile1);
insertToOldDatabase(oldProfile1);
insertToOldDatabase(oldProfile2);
insertToOldDatabase(oldProfile4);
Convert();
var list = SessionNew.QueryOver <Profile>().List();
Assert.AreEqual(6, list.Count);
var dbProfile1 = list.Where(x => x.UserName == oldProfile1.UserName).Single();
var dbProfile2 = list.Where(x => x.UserName == oldProfile2.UserName).Single();
var dbProfile3 = list.Where(x => x.UserName == oldProfile3.UserName).Single();
var dbProfile4 = list.Where(x => x.UserName == oldProfile4.UserName).Single();
Assert.AreEqual(2, dbProfile1.Friends.Count);
Assert.AreEqual(1, dbProfile2.Friends.Count);
Assert.AreEqual(0, dbProfile3.Friends.Count);
Assert.AreEqual(1, dbProfile4.Friends.Count);
Assert.IsTrue(dbProfile1.Friends.Contains(dbProfile2));
Assert.IsTrue(dbProfile1.Friends.Contains(dbProfile4));
Assert.IsTrue(dbProfile2.Friends.Contains(dbProfile1));
Assert.IsTrue(dbProfile4.Friends.Contains(dbProfile1));
}
public void ConvertProfile_MainData()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.Birthday = DateTime.Now.Date;
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.CountryId = 2;
oldProfile.Password = "******";
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.IsNotNull(dbProfile);
Assert.IsNotNull(dbProfile.DataInfo);
Assert.AreEqual(oldProfile.Email, dbProfile.Email);
Assert.AreEqual(oldProfile.Birthday, dbProfile.Birthday);
Assert.AreEqual(oldProfile.CreationDate, dbProfile.CreationDate);
Assert.AreEqual(oldProfile.CountryId, dbProfile.CountryId);
Assert.AreEqual(oldProfile.Password, dbProfile.Password);
Assert.AreEqual(AccountType.PremiumUser, dbProfile.Licence.AccountType);
Assert.AreNotEqual(DateTime.MinValue, dbProfile.Licence.LastPointOperationDate);
}
public void CreateExerciseProfileData_TwoExercises()
{
var profile = CreateProfile("profile");
var ex = CreateExercise("test", Guid.NewGuid());
var ex1 = CreateExercise("test1", Guid.NewGuid());
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-5), ex, new Tuple <int?, float?>(10, 30), new Tuple <int?, float?>(5, 50));
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-2), ex1, new Tuple <int?, float?>(10, 20), new Tuple <int?, float?>(4, 70));
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-1), ex, new Tuple <int?, float?>(3, 60), new Tuple <int?, float?>(5, 40));
Convert();
var serie = SessionNew.QueryOver <Model.Serie>().Where(x => x.Weight == 70).SingleOrDefault();
var data = SessionNew.QueryOver <Model.ExerciseProfileData>().List();
Assert.AreEqual(2, data.Count);
var dbData = data.Where(x => x.MaxWeight == 70).Single();
Assert.AreEqual(profile.UserName, dbData.Profile.UserName);
Assert.AreEqual(ex1.GlobalId, dbData.Exercise.GlobalId);
Assert.AreEqual(serie.GlobalId, dbData.Serie.GlobalId);
Assert.AreEqual(70, dbData.MaxWeight);
Assert.AreEqual(4, dbData.Repetitions);
Assert.AreEqual(DateTime.UtcNow.Date.AddDays(-2), dbData.TrainingDate);
dbData = data.Where(x => x.MaxWeight == 60).Single();
serie = SessionNew.QueryOver <Model.Serie>().Where(x => x.Weight == 60).SingleOrDefault();
Assert.AreEqual(profile.UserName, dbData.Profile.UserName);
Assert.AreEqual(ex.GlobalId, dbData.Exercise.GlobalId);
Assert.AreEqual(serie.GlobalId, dbData.Serie.GlobalId);
Assert.AreEqual(60, dbData.MaxWeight);
Assert.AreEqual(3, dbData.Repetitions);
Assert.AreEqual(DateTime.UtcNow.Date.AddDays(-1), dbData.TrainingDate);
}
public void ConvertProfile_Settings()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
oldProfile.Settings.NotificationWorkoutPlanVoted = true;
oldProfile.Settings.NotificationExerciseVoted = true;
oldProfile.Settings.NotificationBlogCommentAdded = false;
oldProfile.Settings.NotificationFriendChangedCalendar = true;
oldProfile.Settings.AutomaticUpdateMeasurements = true;
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.IsNotNull(dbProfile.Settings);
Assert.AreEqual(ProfileNotification.None, dbProfile.Settings.NotificationBlogCommentAdded);
Assert.AreEqual(ProfileNotification.Message, dbProfile.Settings.NotificationFriendChangedCalendar);
Assert.AreEqual(ProfileNotification.Message, dbProfile.Settings.NotificationSocial);
Assert.AreEqual(ProfileNotification.Message, dbProfile.Settings.NotificationVoted);
Assert.IsTrue(dbProfile.Settings.AutomaticUpdateMeasurements);
}
public void ConvertWp7PushNotifications()
{
var profile = CreateProfile("profile1");
Model.Old.WP7PushNotification wp71 = new WP7PushNotification();
wp71.Added = DateTime.UtcNow.Date;
wp71.Counter = 1;
wp71.DeviceID = "Test1";
wp71.LiveTile = true;
wp71.LiveTileFrequency = 3;
wp71.LiveTileLastUpdate = DateTime.UtcNow.Date.AddDays(-2);
wp71.Modified = DateTime.UtcNow.AddDays(-10).Date;
wp71.ProfileId = profile.Id;
wp71.PushNotifications = true;
wp71.URI = "gfdgdfgdfg";
insertToOldDatabase(wp71);
Convert();
var dbProfile = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == "profile1").SingleOrDefault();
var newWp71 = SessionNew.QueryOver <Model.WP7PushNotification>().SingleOrDefault();
Assert.AreEqual(wp71.Added, newWp71.Added);
Assert.AreEqual(wp71.Counter, newWp71.Counter);
Assert.AreEqual(wp71.DeviceID, newWp71.DeviceID);
Assert.AreEqual(wp71.LiveTile, newWp71.LiveTile);
Assert.AreEqual(wp71.LiveTileFrequency, newWp71.LiveTileFrequency);
Assert.AreEqual(wp71.LiveTileLastUpdate, newWp71.LiveTileLastUpdate);
Assert.AreEqual(wp71.Modified, newWp71.Modified);
Assert.AreEqual(dbProfile.GlobalId, newWp71.ProfileId);
Assert.AreEqual(wp71.PushNotifications, newWp71.PushNotifications);
Assert.AreEqual(wp71.URI, newWp71.URI);
}
public void ConvertPlan_WithDeletedExercise()
{
string plan = @"<TrainingPlan>
<Purpose>Mass</Purpose>
<Language>pl</Language>
<Author>jony0008</Author>
<Comment><![CDATA[]]></Comment>
<CreationDate>06/05/2011 21:05:23</CreationDate>
<Difficult>Beginner</Difficult>
<GlobalId>00c7057a-0694-4b2c-96f7-2c8d0e1cf445</GlobalId>
<Name>mój plan FBW</Name>
<RestSeconds>90</RestSeconds>
<TrainingType>FBW</TrainingType>
<Url></Url>
<Days>
<Day>
<GlobalId>4cd10e23-170f-4374-b1ae-06e9774752ce</GlobalId>
<Name>Dzień 1</Name>
<Entries>
<Entry>
<ExerciseId>3e06a130-b811-4e45-9285-f087403615bf</ExerciseId>
<GlobalId>aaae4427-e354-4323-bb0a-08053cacde18</GlobalId>
<RestSeconds>90</RestSeconds>
<Sets>
<Set>
<RepetitionNumberMax>12</RepetitionNumberMax>
<RepetitionNumberMin>12</RepetitionNumberMin>
<RepetitionsType>Normalna</RepetitionsType>
<GlobalId>a6e905c6-a8cc-4840-a8d8-6a25dcafadcb</GlobalId>
<DropSet>None</DropSet>
</Set>
</Sets>
</Entry>
</Entries>
<SuperSets />
</Day>
</Days>
</TrainingPlan>";
Model.Old.Profile oldProfile1 = CreateProfile("profile1");
Model.Old.TrainingPlan oldPlan = new TrainingPlan();
oldPlan.Profile = oldProfile1;
oldPlan.PlanContent = plan;
oldPlan.Purpose = WorkoutPlanPurpose.Strength;
oldPlan.Language = "pl";
oldPlan.Name = "yyyyy";
oldPlan.Author = "Roemk";
oldPlan.CreationDate = DateTime.UtcNow.Date.AddHours(1);
oldPlan.Difficult = TrainingPlanDifficult.Advanced;
oldPlan.TrainingType = TrainingType.HST;
insertToOldDatabase(oldPlan);
Convert();
var newPlan = SessionNew.QueryOver <Model.TrainingPlan>().SingleOrDefault();
var deletedExercise = SessionNew.QueryOver <Model.Exercise>().Where(x => x.IsDeleted).SingleOrDefault();
Assert.AreEqual(deletedExercise.GlobalId, newPlan.Days.ElementAt(0).Entries.ElementAt(0).Exercise.GlobalId);
}
public void ConvertExercises_WithRatings()
{
var profile1 = CreateProfile("profile1");
var profile2 = CreateProfile("profile2");
Model.Old.Exercise exercise = new Exercise(Guid.NewGuid());
exercise.Name = "Exercise name";
exercise.Shortcut = "EX";
insertToOldDatabase(exercise);
RatingUserValue rating = new RatingUserValue();
rating.ProfileId = profile1.Id;
rating.Rating = 3;
rating.RatedObjectId = exercise.GlobalId;
rating.ShortComment = "Comment";
rating.VotedDate = DateTime.Now.Date;
insertToOldDatabase(rating);
rating = new RatingUserValue();
rating.ProfileId = profile2.Id;
rating.Rating = 5;
rating.RatedObjectId = exercise.GlobalId;
rating.ShortComment = "Comment111";
rating.VotedDate = DateTime.Now.Date;
insertToOldDatabase(rating);
Convert();
var newExercise = SessionNew.Get <Model.Exercise>(exercise.GlobalId);
Assert.AreEqual(4, newExercise.Rating);
var ratings = SessionNew.QueryOver <Model.RatingUserValue>().List();
Assert.AreEqual(2, ratings.Count);
var rating1 = ratings.Where(x => x.Rating == 3).Single();
Assert.AreEqual("Comment", rating1.ShortComment);
Assert.AreEqual(DateTime.Now.Date, rating1.VotedDate);
Assert.AreEqual(newExercise.GlobalId, rating1.RatedObjectId);
var newProfile1 = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == "profile1").SingleOrDefault();
Assert.AreEqual(newProfile1.GlobalId, rating1.ProfileId);
var rating2 = ratings.Where(x => x.Rating == 5).Single();
Assert.AreEqual("Comment111", rating2.ShortComment);
Assert.AreEqual(DateTime.Now.Date, rating2.VotedDate);
Assert.AreEqual(newExercise.GlobalId, rating2.RatedObjectId);
var newProfile2 = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == "profile2").SingleOrDefault();
Assert.AreEqual(newProfile2.GlobalId, rating2.ProfileId);
}
public void IsDeleteProfileExists()
{
Convert();
var deletedProfile = SessionNew.QueryOver <Profile>().Where(x => x.IsDeleted).SingleOrDefault();
Assert.IsNotNull(deletedProfile.DataInfo);
Assert.IsNotNull(deletedProfile.Settings);
Assert.IsNull(deletedProfile.Statistics);
Assert.IsNull(deletedProfile.Wymiary);
Assert.IsFalse(deletedProfile.Privacy.Searchable);
}
public void ConvertPlan3_WithSuperSets()
{
var oldExercise1 = CreateExercise("test1", new Guid("7b1982b9-a9ea-4d39-84ff-db6764b66ec0"));
var oldExercise2 = CreateExercise("test2", new Guid("f0ab1656-b94d-4665-9ac9-f02f100f6e8c"));
string plan = @"<TrainingPlan><Purpose>NotSet</Purpose><Language>pl</Language><Author>BodyArchitect</Author><Comment><![CDATA[]]></Comment><CreationDate>12/09/2010 07:01:14</CreationDate><Difficult>Advanced</Difficult><GlobalId>e8ec0028-a9a8-4c9f-a40f-8fb4aea43372</GlobalId><Name>Plan na wytrzymałość</Name><RestSeconds>0</RestSeconds><TrainingType>Split</TrainingType><Url>http://blog.myba.tk/?p=36</Url>
<Days>
<Day><GlobalId>3ed3deaf-ef7b-40f5-9c0e-4e96565306a6</GlobalId><Name>Dzień 1</Name><Entries>
<Entry><Comment><![CDATA[Kąt 45 stopni]]></Comment><ExerciseId>7b1982b9-a9ea-4d39-84ff-db6764b66ec0</ExerciseId><GlobalId>e2a4198f-7cd9-443c-8e44-1605277e1afa</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>67333bfe-771c-452e-8e89-c9ff128712b1</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>2f313788-1126-4621-8081-d2ae52fb6793</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>3ea05350-96a4-4022-9068-440fc327dda2</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>3194c203-4083-462d-b7df-2564c195041f</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><ExerciseId>7b1982b9-a9ea-4d39-84ff-db6764b66ec0</ExerciseId><GlobalId>83ccef8a-6e42-4c74-9b5f-5942c606bfb5</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>972e725c-cee7-4308-bd60-90d3a87a123d</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>e66af240-44fe-4774-9dec-4f65eb853d19</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>9f09f3dc-c2b6-433d-a05d-658b8a81276a</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>d189ff4d-9f09-4b05-8b2b-dae54ecf6acd</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><Comment><![CDATA[Kąt 45 stopni]]></Comment><ExerciseId>7b1982b9-a9ea-4d39-84ff-db6764b66ec0</ExerciseId><GlobalId>48984fa0-aab7-4314-b193-b6158b67e548</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>5ec2ef5f-6fc6-409f-8011-987a63f47667</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>1f9f0114-a4e7-42df-814d-adaebba669e7</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>bf18315d-e0be-4b4d-aa0d-c07ab0604b37</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><ExerciseId>7b1982b9-a9ea-4d39-84ff-db6764b66ec0</ExerciseId><GlobalId>2bfde702-cc44-4c81-9686-9dfe8608eaa8</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>4c4d8820-755f-4e3c-abeb-3434703845df</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>e838b51d-d6d7-47e9-887a-06ba662bf40f</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>dfff566a-cb6c-4e1c-8de5-6fdb5c95b1ed</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><ExerciseId>7b1982b9-a9ea-4d39-84ff-db6764b66ec0</ExerciseId><GlobalId>ea283fb2-b11a-4995-a301-e2fa42752556</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>f133b0b3-ef1c-4c81-ab60-a140b7407e33</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>84581d77-5274-4f3b-99dc-b3b0766d505f</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>f8fd5a6e-d8c1-4148-8e96-7aa17d9b975e</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><ExerciseId>f0ab1656-b94d-4665-9ac9-f02f100f6e8c</ExerciseId><GlobalId>319899bb-0a7e-4783-9074-125e8299c8b9</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>7945faf9-acd2-4266-bd01-8eedae6749f7</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>ff0b56c6-362c-42a4-8b2a-f41cccb7f73a</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>d31ba4a6-d1de-40cc-9b84-5cf678f0eb16</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><ExerciseId>f0ab1656-b94d-4665-9ac9-f02f100f6e8c</ExerciseId><GlobalId>c110f30b-82e6-4ea1-b2f8-1cac3b32bf96</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>f6ea1a8d-c671-4f8c-af6b-ff5d1a9410b7</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>9f01080f-1d67-41e0-821f-c7dd3320eb4d</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>528425be-97bb-4ec9-9609-db04f378eea5</GlobalId><DropSet>None</DropSet></Set></Sets></Entry>
<Entry><ExerciseId>f0ab1656-b94d-4665-9ac9-f02f100f6e8c</ExerciseId><GlobalId>6e2167a7-f41d-4b82-b968-08068d2c70fb</GlobalId><RestSeconds>0</RestSeconds><Sets><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>ee609440-4a69-4562-b05d-cb2a202f35ef</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>99f8a670-f748-430c-b503-c92d6206273d</GlobalId><DropSet>None</DropSet></Set><Set><RepetitionNumberMax>15</RepetitionNumberMax><RepetitionNumberMin>15</RepetitionNumberMin><RepetitionsType>Normalna</RepetitionsType><GlobalId>82dd9dd0-07f5-45b9-bf94-45fcc9ca5ff5</GlobalId><DropSet>None</DropSet></Set></Sets></Entry></Entries>
<SuperSets>
<SuperSet><SuperSetId>ba85dcbd-589e-49cc-94ad-29e4b07db7e3</SuperSetId> <Entries>
<EntryId>ea283fb2-b11a-4995-a301-e2fa42752556</EntryId>
<EntryId>319899bb-0a7e-4783-9074-125e8299c8b9</EntryId></Entries></SuperSet></SuperSets></Day></Days></TrainingPlan>";
Model.Old.Profile oldProfile1 = CreateProfile("profile1");
Model.Old.TrainingPlan oldPlan = new TrainingPlan();
oldPlan.Profile = oldProfile1;
oldPlan.PlanContent = plan;
oldPlan.PublishDate = DateTime.Now.Date;
oldPlan.Language = "pl";
oldPlan.Name = "yyyyy";
oldPlan.Author = "Roemk";
oldPlan.CreationDate = DateTime.UtcNow.Date.AddHours(1);
insertToOldDatabase(oldPlan);
Convert();
var newPlan = SessionNew.QueryOver <Model.TrainingPlan>().SingleOrDefault();
var newProfile = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == "profile1").SingleOrDefault();
Assert.AreEqual(newProfile, newPlan.Profile);
Assert.AreEqual(1, newPlan.Days.Count);
var day = newPlan.Days.ElementAt(0);
Assert.AreEqual(8, day.Entries.Count);
var superSetEntries = newPlan.Days.SelectMany(x => x.Entries).Where(x => !string.IsNullOrEmpty(x.GroupName)).ToList();
Assert.AreEqual(2, superSetEntries.Count);
var firstEntryInSuperSet = day.Entries.Where(x => x.Position == 4).Single();
var secondEntryInSuperSet = day.Entries.Where(x => x.Position == 5).Single();
Assert.AreEqual(firstEntryInSuperSet.GroupName, secondEntryInSuperSet.GroupName);
Assert.IsNotNull(day.Entries.ElementAt(0).Comment);
Assert.IsNotNull(day.Entries.ElementAt(2).Comment);
}
public void CreateExerciseProfileData_ForUserWithoutAnyStrengthTrainingEntries()
{
var profile = CreateProfile("profile");
var ex = CreateExercise("test", Guid.NewGuid());
Convert();
var count = SessionNew.QueryOver <Model.ExerciseProfileData>().RowCount();
Assert.AreEqual(0, count);
}
public void ConvertMyBlogCommentsCount()
{
var profile = CreateProfile("profile");
profile.Statistics.MyBlogCommentsCount = 4;
insertToOldDatabase(profile.Statistics);
Convert();
var dbProfile = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == profile.UserName).SingleOrDefault();
Assert.AreEqual(4, dbProfile.Statistics.MyTrainingDayCommentsCount);
}
public void CreateExerciseProfileData_0Repetitions()
{
var profile = CreateProfile("profile");
var ex = CreateExercise("test", Guid.NewGuid());
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-5), ex, new Tuple <int?, float?>(0, 30));
Convert();
var count = SessionNew.QueryOver <Model.ExerciseProfileData>().RowCount();
Assert.AreEqual(0, count);
}
public void A6WEntries_TrainingNotFullyFinish()
{
var profile = CreateProfile("profile");
MyTraining endedTraining = new MyTraining();
endedTraining.EndDate = DateTime.UtcNow.AddDays(-1).Date;
endedTraining.StartDate = DateTime.UtcNow.AddDays(-3).Date;
endedTraining.TrainingEnd = TrainingEnd.Break;
endedTraining.Name = "TempName";
endedTraining.PercentageCompleted = null;
endedTraining.Profile = profile;
insertToOldDatabase(endedTraining);
var day1 = new TrainingDay(DateTime.UtcNow.AddDays(-10));
day1.Comment = "cmt";
day1.Profile = profile;
var a6w1 = new A6WEntry();
a6w1.Comment = "test";
a6w1.Completed = true;
a6w1.MyTraining = endedTraining;
a6w1.DayNumber = 1;
day1.AddEntry(a6w1);
insertToOldDatabase(day1);
var day2 = new TrainingDay(DateTime.UtcNow.AddDays(-10));
day2.Comment = "cmt";
day2.Profile = profile;
var a6w2 = new A6WEntry();
a6w2.Comment = "test";
a6w2.MyTraining = endedTraining;
a6w2.Completed = false;
a6w2.DayNumber = 2;
a6w2.Set1 = 2;
a6w2.Set2 = 3;
day2.AddEntry(a6w2);
insertToOldDatabase(day2);
Convert();
var dbProfile = SessionNew.QueryOver <Model.Profile>().Where(x => x.UserName == profile.UserName).SingleOrDefault();
var count = SessionNew.QueryOver <Model.A6WEntry>().RowCount();
Assert.AreEqual(count, dbProfile.Statistics.A6WEntriesCount);
}
public void ConvertProfile_Picture()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
oldProfile.Picture = new Picture(Guid.NewGuid(), "test");
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.IsNotNull(dbProfile.Picture);
Assert.AreEqual(oldProfile.Picture.PictureId, dbProfile.Picture.PictureId);
Assert.AreEqual(oldProfile.Picture.Hash, dbProfile.Picture.Hash);
}
public void ConvertProfile_Wymiary()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
oldProfile.Wymiary = new Wymiary();
oldProfile.Wymiary.DateTime = DateTime.Now.Date;
oldProfile.Wymiary.Height = 100;
oldProfile.Wymiary.IsNaCzczo = true;
oldProfile.Wymiary.Klatka = 4;
oldProfile.Wymiary.LeftBiceps = 3;
oldProfile.Wymiary.LeftForearm = 31;
oldProfile.Wymiary.LeftUdo = 44;
oldProfile.Wymiary.Pas = 23;
oldProfile.Wymiary.RightBiceps = 66;
oldProfile.Wymiary.RightForearm = 77;
oldProfile.Wymiary.RightUdo = 21;
oldProfile.Wymiary.Weight = (float)7.77778E+31;
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.IsNotNull(dbProfile.Wymiary);
Assert.AreEqual(oldProfile.Wymiary.DateTime, dbProfile.Wymiary.Time.DateTime);
Assert.AreEqual(TimeType.OnEmptyStomach, dbProfile.Wymiary.Time.TimeType);
Assert.AreEqual(oldProfile.Wymiary.Height, (int)dbProfile.Wymiary.Height);
Assert.AreEqual(oldProfile.Wymiary.LeftBiceps, (float)dbProfile.Wymiary.LeftBiceps);
Assert.AreEqual(oldProfile.Wymiary.LeftForearm, (float)dbProfile.Wymiary.LeftForearm);
Assert.AreEqual(oldProfile.Wymiary.LeftUdo, (float)dbProfile.Wymiary.LeftUdo);
Assert.AreEqual(oldProfile.Wymiary.RightBiceps, (float)dbProfile.Wymiary.RightBiceps);
Assert.AreEqual(oldProfile.Wymiary.RightForearm, (float)dbProfile.Wymiary.RightForearm);
Assert.AreEqual(oldProfile.Wymiary.RightUdo, (float)dbProfile.Wymiary.RightUdo);
Assert.AreEqual(oldProfile.Wymiary.Pas, (float)dbProfile.Wymiary.Pas);
Assert.AreEqual(oldProfile.Wymiary.Klatka, (float)dbProfile.Wymiary.Klatka);
Assert.AreEqual(0, (float)dbProfile.Wymiary.Weight);//here we had overflow (very big value)
}
public void ConvertProfile_DeletedProfile()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.Birthday = DateTime.Now.Date;
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.CountryId = 2;
oldProfile.Password = "******";
oldProfile.IsDeleted = true;
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.IsNull(dbProfile);
}
public void ConvertSupplement_PH()
{
var supplement = new Suplement();
supplement.Name = "supp";
supplement.Comment = "dfgdfgdfg";
supplement.SuplementId = new Guid("D8F8FD0D-31E0-4763-9F1E-ED5AE49DFBD8");
supplement.Url = "test";
insertToOldDatabase(supplement);
Convert();
var newSupplement = SessionNew.Get <Model.Suplement>(supplement.SuplementId);
Assert.AreEqual(supplement.Name, newSupplement.Name);
Assert.AreEqual(supplement.Comment, newSupplement.Comment);
Assert.AreEqual(supplement.Url, newSupplement.Url);
Assert.IsTrue(newSupplement.CanBeIllegal);
Assert.IsFalse(newSupplement.IsProduct);
}
public void ConvertLoginData_FromDeletedProfile()
{
var profile = CreateProfile("profile1", isDeleted: true);
var wp71 = new LoginData();
wp71.ProfileId = profile.Id;
wp71.ApplicationLanguage = "pl";
wp71.ApplicationVersion = "1.0";
wp71.ClientInstanceId = Guid.NewGuid();
wp71.LoginDateTime = DateTime.Now.Date;
wp71.Platform = PlatformType.Linux;
wp71.PlatformVersion = "1.";
insertToOldDatabase(wp71);
Convert();
var count = SessionNew.QueryOver <Model.LoginData>().RowCount();
Assert.AreEqual(0, count);
}
public void ConvertProfile_Privacy()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
oldProfile.Privacy = new ProfilePrivacy();
oldProfile.Privacy.BirthdayDate = Privacy.Private;
oldProfile.Privacy.CalendarView = Privacy.FriendsOnly;
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "test").SingleOrDefault();
Assert.IsNotNull(dbProfile.Privacy);
Assert.AreEqual((int)oldProfile.Privacy.BirthdayDate, (int)dbProfile.Privacy.BirthdayDate);
Assert.AreEqual((int)oldProfile.Privacy.CalendarView, (int)dbProfile.Privacy.CalendarView);
Assert.AreEqual((int)oldProfile.Privacy.Friends, (int)dbProfile.Privacy.Friends);
}
public void CreateExerciseProfileData_NullRepetitions_ForCardio()
{
var profile = CreateProfile("profile");
var ex = CreateExercise("test", Guid.NewGuid(), ExerciseType.Cardio);
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-5), ex, new Tuple <int?, float?>(10, 30), new Tuple <int?, float?>(5, 50));
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-2), ex, new Tuple <int?, float?>(10, 20), new Tuple <int?, float?>(70, null));
addTrainingDaySet(profile, DateTime.UtcNow.Date.AddDays(-1), ex, new Tuple <int?, float?>(3, 60), new Tuple <int?, float?>(5, 40));
Convert();
var count = SessionNew.QueryOver <Model.Serie>().RowCount();
var serie = SessionNew.QueryOver <Model.Serie>().Where(x => x.Weight == 70).SingleOrDefault();
var data = SessionNew.QueryOver <Model.ExerciseProfileData>().SingleOrDefault();
Assert.AreEqual(profile.UserName, data.Profile.UserName);
Assert.AreEqual(ex.GlobalId, data.Exercise.GlobalId);
Assert.AreEqual(serie.GlobalId, data.Serie.GlobalId);
Assert.AreEqual(70, data.MaxWeight);
Assert.AreEqual(null, data.Repetitions);
Assert.AreEqual(DateTime.UtcNow.Date.AddDays(-2), data.TrainingDate);
}
public void ConvertProfile_Admin()
{
Model.Old.Profile oldProfile = new Model.Old.Profile();
oldProfile.UserName = "******";
oldProfile.Email = "*****@*****.**";
oldProfile.Birthday = DateTime.Now.Date;
oldProfile.CreationDate = DateTime.Now.Date.AddDays(-1);
oldProfile.Role = Role.Administrator;
oldProfile.Privacy = new Model.Old.ProfilePrivacy();
oldProfile.Settings = new Model.Old.ProfileSettings();
oldProfile.Privacy.Searchable = false;
insertToOldDatabase(oldProfile);
Convert();
var dbProfile = SessionNew.QueryOver <Profile>().Where(x => x.UserName == "Admin").SingleOrDefault();
Assert.IsNotNull(dbProfile);
Assert.IsNotNull(dbProfile.Licence);
Assert.AreEqual(AccountType.Administrator, dbProfile.Licence.AccountType);
Assert.IsFalse(dbProfile.Privacy.Searchable);
}
public void ConvertProfile_Messages_TrainingDayAdded()
{
Model.Old.Profile oldProfile1 = CreateProfile("profile1");
Model.Old.Profile oldProfile2 = CreateProfile("profile2");
Model.Old.Message msg = new Model.Old.Message();
msg.Content = "Test";
msg.ContentType = ContentType.Rtf;
msg.MessageType = MessageType.TrainingDayAdded;
msg.Priority = MessagePriority.Hight;
msg.CreatedDate = DateTime.UtcNow.Date;
msg.Sender = oldProfile1;
msg.Receiver = oldProfile2;
msg.Topic = "Topic";
insertToOldDatabase(msg);
Convert();
var newMsg = SessionNew.QueryOver <Model.Message>().Where(x => x.Priority != Model.MessagePriority.System).SingleOrDefault();
Assert.IsNull(newMsg);
}
public void ConvertProfile_Invitations()
{
Model.Old.Profile oldProfile1 = CreateProfile("profile1");
Model.Old.Profile oldProfile2 = CreateProfile("profile2");
Model.Old.FriendInvitation invitation = new FriendInvitation();
invitation.Invited = oldProfile1;
invitation.Inviter = oldProfile2;
invitation.CreateDate = DateTime.UtcNow.AddDays(-1).Date;
invitation.InvitationType = FriendInvitationType.RejectFriendship;
invitation.Message = "test";
insertToOldDatabase(invitation);
Convert();
var newInvitation = SessionNew.QueryOver <Model.FriendInvitation>().SingleOrDefault();
Assert.AreEqual(invitation.CreateDate, newInvitation.CreateDate);
Assert.AreEqual((int)invitation.InvitationType, (int)newInvitation.InvitationType);
Assert.AreEqual(invitation.Message, newInvitation.Message);
Assert.AreEqual(invitation.Invited.UserName, newInvitation.Invited.UserName);
Assert.AreEqual(invitation.Inviter.UserName, newInvitation.Inviter.UserName);
}
public void ConvertSupplement()
{
var supplement = new Suplement();
supplement.Name = "supp";
supplement.Comment = "dfgdfgdfg";
supplement.SuplementId = Guid.NewGuid();
supplement.Url = "test";
insertToOldDatabase(supplement);
Convert();
var count = SessionNew.QueryOver <Model.Suplement>().RowCount();
Assert.AreEqual(2, count);
var newSupplement = SessionNew.Get <Model.Suplement>(supplement.SuplementId);
Assert.AreEqual(supplement.Name, newSupplement.Name);
Assert.AreEqual(supplement.Comment, newSupplement.Comment);
Assert.AreEqual(supplement.Url, newSupplement.Url);
Assert.IsFalse(newSupplement.CanBeIllegal);
Assert.IsFalse(newSupplement.IsProduct);
}
public void ConvertWp7PushNotifications_FromDeletedProfile()
{
var profile = CreateProfile("profile1", isDeleted: true);
Model.Old.WP7PushNotification wp71 = new WP7PushNotification();
wp71.Added = DateTime.UtcNow.Date;
wp71.Counter = 1;
wp71.DeviceID = "Test1";
wp71.LiveTile = true;
wp71.LiveTileFrequency = 3;
wp71.LiveTileLastUpdate = DateTime.UtcNow.Date.AddDays(-2);
wp71.Modified = DateTime.UtcNow.AddDays(-10).Date;
wp71.ProfileId = profile.Id;
wp71.PushNotifications = true;
wp71.URI = "gfdgdfgdfg";
insertToOldDatabase(wp71);
Convert();
var count = SessionNew.QueryOver <Model.WP7PushNotification>().RowCount();
Assert.AreEqual(0, count);
}
