public void DatabaseTestCanInsertCaptureBatchDataAndRetrieve() { // Arrange string expectedFileName = "CaptureFileTest2u.pcap"; // Act using (var context = new PacketsTestEntities()) { var captureBatch = new CaptureBatch() { FileName = expectedFileName, Marked = false, Mean = 0M, TrimmedMean = 0M, Parsed = false, SingleStatistics = false, CumulativeStatistics = false }; context.CaptureBatches.Add(captureBatch); context.SaveChanges(); } // Assert using (var context = new PacketsTestEntities()) { var actualFileName = (from c in context.CaptureBatches where c.CaptureBatchId == 2 select c.FileName).FirstOrDefault(); Assert.AreEqual(expectedFileName, actualFileName); } }
public void SeedTestDatabase(PacketsTestEntities context) { var captureBatch = new CaptureBatch { FileName = "CaptureFileTest1d.pcap", Marked = true, Mean = 0M, TrimmedMean = 0M, Parsed = false, SingleStatistics = false, CumulativeStatistics = false }; context.CaptureBatches.Add(captureBatch); int msec = 067; for (int i = 0; i < 10; i++) { var capturePacket = new CapturePacket { PacketNumber = i, CaptureBatchId = 1, TimeStamp = Convert.ToDateTime(string.Format("2016-01-31 12:13:58." + msec++)), Marked = true }; context.CapturePackets.Add(capturePacket); } context.SaveChanges(); /* Test Data CapturePacketId CaptureBatchId PacketNumber TimeStamp Marked 1 1 0 2016-01-31 12:13:58.067 1 2 1 1 2016-01-31 12:13:58.067 1 3 1 2 2016-01-31 12:13:58.067 1 4 1 3 2016-01-31 12:13:58.070 1 5 1 4 2016-01-31 12:13:58.070 1 6 1 5 2016-01-31 12:13:58.070 1 7 1 6 2016-01-31 12:13:58.073 1 8 1 7 2016-01-31 12:13:58.073 1 CaptureBatchId FileName Marked Mean TrimmedMean Parsed SingleStatistics CumulativeStatistics 1 CaptureFile635898392258793796d.pcap 1 105.5416666667 115.0454545455 1 1 1 2 CaptureFile635898392480034634u.pcap 0 9.8230616302 125.6944444444 1 1 1 3 CaptureFile635898392680134473d.pcap 1 7.7898989899 132.3846153846 1 1 1 4 CaptureFile635898392880258123u.pcap 0 9.6271844660 106.0930232558 1 1 1 5 CaptureFile635898393080301245d.pcap 1 9.7991967871 110.2682926829 1 1 1 6 CaptureFile635898393280407635u.pcap 0 9.5570866142 120.8648648649 1 1 1 7 CaptureFile635898393480605337d.pcap 1 9.1496062992 109.3076923077 1 1 1 8 CaptureFile635898393680732945u.pcap 0 10.3278008299 131.9714285714 1 1 1 */ }
public void DatabaseTestCanDeleteCapturePacketData() { // Arrange int expectedRecordCount = 9; int actualRecordCount = 0; // Act using (var context = new PacketsTestEntities()) { var record = context.CapturePackets.Where(c => c.CapturePacketId == 9).FirstOrDefault(); context.CapturePackets.Remove(record); context.SaveChanges(); var count = context.CapturePackets.Count(); actualRecordCount = Convert.ToInt32(count); } // Assert Assert.AreEqual(expectedRecordCount, actualRecordCount); }
public void DatabaseTestCanRetrieveCapturePacketData() { // Arrange int expectedRecordCount = 10; int actualRecordCount = 0; // Act using (var context = new PacketsTestEntities()) { var count = context.CapturePackets.Count(); actualRecordCount = Convert.ToInt32(count); } // Assert Assert.AreEqual(expectedRecordCount, actualRecordCount); }
public void TruncateAllTablesPacketsTestDatabaseForTesting() { using (var context = new PacketsTestEntities()) { try { context.TruncateAllTables(); } catch (Exception ex) { throw ex; } } }
public void ReSeedDataPacketsTestDatabaseForTesting() { DatabaseSeedingInitializer dsi = new DatabaseSeedingInitializer(); using (var context = new PacketsTestEntities()) { dsi.SeedTestDatabase(context); } }
public void DatabaseTestCanUpdateCaptureBatchData() { // Arrange bool expectedParsedValue = true; bool actualParsedValue = false; // Act using (var context = new PacketsTestEntities()) { var record0 = context.CaptureBatches.Where(c => c.CaptureBatchId == 1).FirstOrDefault(); record0.Parsed = true; context.SaveChanges(); var record1 = context.CaptureBatches.Where(c => c.CaptureBatchId == 1).FirstOrDefault(); actualParsedValue = record1.Parsed; } // Assert Assert.AreEqual(expectedParsedValue, actualParsedValue); }