public void HandleRecordInsertNewRecordToDBTest()
{
PTRecord record = new PTRecord("name", DateTime.Today, new TimeSpan(0, 10, 0));
PTDatabase.HandleRecord(record);
PTDate expectedDate = new PTDate(1, DateTime.Today);
PTProcessInfo expectedInfo = new PTProcessInfo(1, "name", new TimeSpan(0, 10, 0));
PTDate actualDate = PTDatabase.GetDateForDateTime(DateTime.Today);
PTProcessInfo actaulInfo = PTDatabase.GetInfoForProcessOnDate(record.name, actualDate);
Assert.AreEqual(expectedDate, actualDate);
Assert.AreEqual(expectedInfo, actaulInfo);
}
public void GetInfoForProcessOnDateTest()
{
string processName = "name";
PTDate date = new PTDate(1, DateTime.Today);
string otherProcessName = "otherName";
PTProcessInfo expected = new PTProcessInfo(1, processName, new TimeSpan(0, 10, 0));
PTProcessInfo otherInfo = new PTProcessInfo(2, otherProcessName, new TimeSpan(0, 10, 0));
PTDatabase.InsertDate(date);
PTDatabase.InsertProcessInfo(expected, date);
PTDatabase.InsertProcessInfo(otherInfo, date);
PTProcessInfo actual = PTDatabase.GetInfoForProcessOnDate(processName, date);
Assert.AreEqual(expected, actual);
}
public void HandleRecordInsertsSeparateRecordforDifferentProcessInDBTest()
{
PTRecord record1 = new PTRecord("name1", DateTime.Today, new TimeSpan(0, 10, 0));
PTRecord record2 = new PTRecord("name2", DateTime.Today, new TimeSpan(0, 20, 0));
PTDate expectedDate = new PTDate(1, DateTime.Today);
PTProcessInfo expectedInfo1 = new PTProcessInfo(1, record1.name, new TimeSpan(0, 10, 0));
PTProcessInfo expectedInfo2 = new PTProcessInfo(2, record2.name, new TimeSpan(0, 20, 0));
PTDatabase.HandleRecord(record1);
PTDate actualDate = PTDatabase.GetDateForDateTime(DateTime.Today);
PTProcessInfo actaulInfo1 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate);
Assert.AreEqual(expectedDate, actualDate);
Assert.AreEqual(expectedInfo1, actaulInfo1);
PTDatabase.HandleRecord(record2);
PTProcessInfo actaulInfo2 = PTDatabase.GetInfoForProcessOnDate(record2.name, actualDate);
Assert.AreEqual(expectedInfo2, actaulInfo2);
}
public void HandleRecordUpdatesExistingEntryInDBTest()
{
PTRecord record1 = new PTRecord("name", DateTime.Today, new TimeSpan(0, 10, 0));
PTRecord record2 = new PTRecord("name", DateTime.Today, new TimeSpan(0, 20, 0));
PTDate expectedDate = new PTDate(1, DateTime.Today);
PTProcessInfo expectedInfo1 = new PTProcessInfo(1, "name", new TimeSpan(0, 10, 0));
PTProcessInfo expectedInfo2 = new PTProcessInfo(1, "name", new TimeSpan(0, 30, 0));
PTDatabase.HandleRecord(record1);
PTDate actualDate = PTDatabase.GetDateForDateTime(DateTime.Today);
PTProcessInfo actaulInfo1 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate);
Assert.AreEqual(expectedDate, actualDate);
Assert.AreEqual(expectedInfo1, actaulInfo1);
PTDatabase.HandleRecord(record2);
PTProcessInfo actaulInfo2 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate);
Assert.AreEqual(expectedInfo2, actaulInfo2);
}
public void processInfoForDateTest()
{
PTDate date = new PTDate(1, DateTime.Now.Date);
PTDate otherDate = new PTDate(2, DateTime.Today + new TimeSpan(1, 0, 0, 0));
List <PTProcessInfo> expected = new List <PTProcessInfo>()
{
new PTProcessInfo(1, "name1", new TimeSpan(0, 5, 0)),
new PTProcessInfo(2, "name2", new TimeSpan(0, 75, 0)),
new PTProcessInfo(3, "name3", new TimeSpan(1, 5, 0))
};
PTProcessInfo otherInfo = new PTProcessInfo(4, "name4", new TimeSpan(1, 25, 0));
PTDatabase.InsertProcessInfo(expected[0], date);
PTDatabase.InsertProcessInfo(expected[1], date);
PTDatabase.InsertProcessInfo(expected[2], date);
PTDatabase.InsertProcessInfo(otherInfo, otherDate);
List <PTProcessInfo> actual = PTDatabase.ProcessInfoForDate(date);
CollectionAssert.AreEqual(expected, actual);
}
public void HandleRecordInsertsNewEntryForTheSameProcessIfTheDateIsDifferentDBTest()
{
PTRecord record1 = new PTRecord("name", DateTime.Today - new TimeSpan(1, 0, 0, 0), new TimeSpan(0, 10, 0));
PTRecord record2 = new PTRecord("name", DateTime.Today, new TimeSpan(0, 20, 0));
PTDate expectedDate1 = new PTDate(1, record1.datetime);
PTDate expectedDate2 = new PTDate(2, record2.datetime);
PTProcessInfo expectedInfo1 = new PTProcessInfo(1, "name", new TimeSpan(0, 10, 0));
PTProcessInfo expectedInfo2 = new PTProcessInfo(2, "name", new TimeSpan(0, 20, 0));
PTDatabase.HandleRecord(record1);
PTDate actualDate1 = PTDatabase.GetDateForDateTime(DateTime.Today - new TimeSpan(1, 0, 0, 0));
PTDate actualDate2 = PTDatabase.GetDateForDateTime(DateTime.Today);
PTProcessInfo actaulInfo1 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate1);
Assert.AreEqual(expectedDate1, actualDate1);
Assert.AreEqual(expectedInfo1, actaulInfo1);
PTDatabase.HandleRecord(record2);
PTProcessInfo actaulInfo2 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate2);
Assert.AreEqual(expectedDate2, actualDate2);
Assert.AreEqual(expectedInfo2, actaulInfo2);
}
