public void TestSaveContexts_New()
{
DefinedContexts dc = null;
DefinedContexts dcNew = null;
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
dc = sqlite.LoadContexts();
}
dc.Add(new Context("b19bce30-96fe-46dc-b408-891a12a3a933", "Weekly Team Meeting"));
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
sqlite.SaveContexts(dc);
}
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
dcNew = sqlite.LoadContexts();
Assert.AreEqual(7, dcNew.Count);
Assert.AreEqual("2ad57821-dad5-4e0a-abb4-47d99b314f21", dcNew.FindIdByDescr("Home").ID);
Assert.AreEqual("be17f3e2-764b-43b5-b943-63faf6223863", dcNew.FindIdByDescr("Office").ID);
Assert.AreEqual("f89d513b-c24d-468e-99f3-b841e5ceca6f", dcNew.FindIdByDescr("Computer").ID);
Assert.AreEqual("ae7491da-4a83-4cc6-ad26-cd090e81417b", dcNew.FindIdByDescr("Errands").ID);
Assert.AreEqual("c50d02de-d22c-475b-9fef-6e24c05f966b", dcNew.FindIdByDescr("Phone").ID);
Assert.AreEqual("1b9c460b-0287-4011-87fc-0ae0c5f7b81c", dcNew.FindIdByDescr("Manager").ID);
Assert.AreEqual("b19bce30-96fe-46dc-b408-891a12a3a933", dcNew.FindIdByDescr("Weekly Team Meeting").ID);
}
Assert.IsFalse(DefinedContexts.AreDifferences(dc, dcNew));
}
public void TestSaveProject_AddProject_WithTasks()
{
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
Collection <Project> prjList = sqlite.LoadProjects();
DefinedContexts dc = sqlite.LoadContexts();
var removedProjectID = prjList[0].UniqueID;
var newProject = new Project("New Test Project");
var newTask = new Task("New Task")
{
ContextID = dc.FindIdByDescr("Home").ID
};
newProject.AddTask(newTask);
prjList.Add(newProject);
sqlite.SaveProjects(prjList);
Collection <Project> prjListNew = sqlite.LoadProjects();
Assert.IsTrue(ProjectComparer.AreListsEquivalent(prjList, prjListNew,
out List <Project> chgList, out List <Project> addList, out List <Project> delList,
out List <Project> chgTaskList));
Assert.IsTrue(prjListNew[10].TaskList.Select(t => t.UniqueID == newTask.UniqueID).First());
}
}
public void TestLoadContexts()
{
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
DefinedContexts dc = sqlite.LoadContexts();
Assert.AreEqual(6, dc.Count);
Assert.AreEqual("2ad57821-dad5-4e0a-abb4-47d99b314f21", dc.FindIdByDescr("Home").ID);
Assert.AreEqual("be17f3e2-764b-43b5-b943-63faf6223863", dc.FindIdByDescr("Office").ID);
Assert.AreEqual("f89d513b-c24d-468e-99f3-b841e5ceca6f", dc.FindIdByDescr("Computer").ID);
Assert.AreEqual("ae7491da-4a83-4cc6-ad26-cd090e81417b", dc.FindIdByDescr("Errands").ID);
Assert.AreEqual("c50d02de-d22c-475b-9fef-6e24c05f966b", dc.FindIdByDescr("Phone").ID);
Assert.AreEqual("1b9c460b-0287-4011-87fc-0ae0c5f7b81c", dc.FindIdByDescr("Manager").ID);
}
}
public void TestSaveProject_DeleteExistingTask()
{
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
Collection <Project> prjList = sqlite.LoadProjects();
DefinedContexts dc = sqlite.LoadContexts();
var deletedTask = prjList[3].TaskList[1].UniqueID;
prjList[3].TaskList.RemoveAt(1);
sqlite.SaveProjects(prjList);
Collection <Project> prjListNew = sqlite.LoadProjects();
Assert.IsTrue(ProjectComparer.AreListsEquivalent(prjList, prjListNew,
out List <Project> chgList, out List <Project> addList, out List <Project> delList,
out List <Project> chgTaskList));
Assert.AreEqual(0, prjListNew[3].TaskList.Where(t => t.UniqueID == deletedTask).Count());
}
}
public void TestSaveProject_ChangeExistingTask()
{
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
Collection <Project> prjList = sqlite.LoadProjects();
DefinedContexts dc = sqlite.LoadContexts();
var changedTask = prjList[2].TaskList[4].UniqueID;
prjList[2].TaskList[4].Details = "New details";
sqlite.SaveProjects(prjList);
Collection <Project> prjListNew = sqlite.LoadProjects();
Assert.IsTrue(ProjectComparer.AreListsEquivalent(prjList, prjListNew,
out List <Project> chgList, out List <Project> addList, out List <Project> delList,
out List <Project> chgTaskList));
Assert.AreEqual("New details", prjListNew[2].TaskList.Where(t => t.UniqueID == changedTask).First().Details);
}
}
public void TestSaveContexts_NoChanges()
{
DefinedContexts dc = null;
DefinedContexts dcNew = null;
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
dc = sqlite.LoadContexts();
}
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
sqlite.SaveContexts(dc);
}
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
dcNew = sqlite.LoadContexts();
}
Assert.IsFalse(DefinedContexts.AreDifferences(dc, dcNew));
}
public void TestSaveProject_AddTaskToExistingProject()
{
using (SQLitePersistence sqlite = new SQLitePersistence(new SQLitePersistenceConfig(GetTestDBLocation())))
{
Collection <Project> prjList = sqlite.LoadProjects();
DefinedContexts dc = sqlite.LoadContexts();
var prjIDWithNewTask = prjList[0].UniqueID;
var newTask = new Task("New Task")
{
ContextID = dc.FindIdByDescr("Home").ID
};
prjList[0].AddTask(newTask);
sqlite.SaveProjects(prjList);
Collection <Project> prjListNew = sqlite.LoadProjects();
Assert.IsTrue(ProjectComparer.AreListsEquivalent(prjList, prjListNew,
out List <Project> chgList, out List <Project> addList, out List <Project> delList,
out List <Project> chgTaskList));
Assert.IsNotNull(prjListNew[0].TaskList.Where(t => t.UniqueID == newTask.UniqueID).First());
}
}
