public void TryFindDeviceVersionId()
{
int goodDeviceId = 1;
int badDeviceId = int.MaxValue;
SemanticVersion inside1stBlockVersion = SemanticVersion.Parse("3.0.0");
SemanticVersion inside2ndBlockVersion = SemanticVersion.Parse("100.43.0");
SemanticVersion outsideAllVersion = SemanticVersion.Parse("10.43.0");
using (var context = new DeviceDatabaseContext(this.database))
{
DeviceVersion foundDeviceVersion = null;
Assert.IsTrue(context.TryFindDeviceVersionId(goodDeviceId, inside1stBlockVersion, out foundDeviceVersion), $"Cannot find 'good' device-version ID for device '{goodDeviceId}', inside-block-1 version {inside1stBlockVersion}");
Assert.AreEqual(1, foundDeviceVersion, $"Wrong device-version ID found for 'good' device ID '{goodDeviceId}', inside-block-1 version {inside1stBlockVersion}");
Assert.IsTrue(context.TryFindDeviceVersionId(goodDeviceId, inside2ndBlockVersion, out foundDeviceVersion), $"Cannot find 'good' device-version ID for device '{goodDeviceId}', inside-block-2 version {inside2ndBlockVersion}");
Assert.AreEqual(2, foundDeviceVersion, $"Wrong device-version ID found for 'good' device ID '{goodDeviceId}', inside-block-2 version {inside2ndBlockVersion}");
Assert.IsFalse(context.TryFindDeviceVersionId(goodDeviceId, outsideAllVersion, out foundDeviceVersion), $"Found 'good' device-version ID for device '{goodDeviceId}' using version outside all blocks.");
Assert.IsTrue(context.TryFindDeviceVersionId(goodDeviceId, null, out foundDeviceVersion), $"Cannot find 'good' device-version ID for device '{goodDeviceId}', null version (i.e. highest available minimum version)");
Assert.AreEqual(2, foundDeviceVersion, $"Wrong device-version ID found for 'good' device ID '{goodDeviceId}', null version (i.e. highest available minimum version)");
Assert.IsFalse(context.TryFindDeviceVersionId(badDeviceId, null, out foundDeviceVersion), $"Found 'bad' device ID '{badDeviceId}'");
}
}
public void DbConsistencyCheckTest()
{
using (var context = new DeviceDatabaseContext(this.database))
{
Assert.IsTrue(context.DataTypeConsistencyCheck(), "DataTypeConsistencyCheck failure");
Assert.IsTrue(context.RetrievableValueConsistencyCheck(), "RetrievableValueConsistencyCheck failure");
}
}
public void TryFindDeviceIdTest()
{
string goodDeviceName = "UnitTestDevice";
string badDeviceName = "wrzlbrmft";
using (var context = new DeviceDatabaseContext(this.database))
{
int foundDeviceId = int.MinValue;
Assert.IsTrue(context.TryFindDeviceId(goodDeviceName, out foundDeviceId), $"Cannot find 'good' device '{goodDeviceName}'");
Assert.AreEqual(1, foundDeviceId, $"Wrong device ID found for 'good' device '{goodDeviceName}'");
Assert.IsFalse(context.TryFindDeviceId(badDeviceName, out foundDeviceId), $"Found 'bad' device '{badDeviceName}'");
}
}
public void DbContextTest()
{
using (var context = new DeviceDatabaseContext(this.database))
{
Assert.NotNull(context, "The database context is null");
var result = context.DeviceSpecificOids
.Where(d => (d.RetrievableValue == RetrievableValuesEnum.Model))
.Include(d => d.RetrievableValue)
.Include(d => d.DataType)
.ToList();
Assert.AreEqual(1, result.Count(), "Returned result does not have exactly one row");
}
}
public void TryFindOids()
{
int goodOidLookupId = 1;
int badOidLookupId = int.MaxValue;
using (var context = new DeviceDatabaseContext(this.database))
{
IDeviceSpecificOidLookup foundLookup = null;
Assert.IsTrue(context.TryFindDeviceSpecificOidLookup(goodOidLookupId, SnmpSharpNet.SnmpVersion.Ver1, out foundLookup), $"Cannot find OID lookup ID for 'good' lookup ID '{goodOidLookupId}'");
Assert.GreaterOrEqual(foundLookup.Count, 1, $"Empty lookup for for 'good' lookup ID '{goodOidLookupId}'");
Assert.IsFalse(context.TryFindDeviceSpecificOidLookup(badOidLookupId, SnmpSharpNet.SnmpVersion.Ver1, out foundLookup), $"Found lookup for 'bad' lookup ID '{badOidLookupId}'");
}
}
public void TryFindOidMappingId()
{
int goodDeviceVersionId = 2;
int badDeviceVersionId = int.MaxValue;
using (var context = new DeviceDatabaseContext(this.database))
{
string foundOidMappingIds = string.Empty;
Assert.IsTrue(context.TryFindOidLookupId(goodDeviceVersionId, out foundOidMappingIds), $"Cannot find OID mapping ID for 'good' device-version ID '{goodDeviceVersionId}'");
Assert.AreEqual("2,1", foundOidMappingIds, $"Wrong OID mapping ID found for 'good' device-version ID '{goodDeviceVersionId}'");
Assert.IsFalse(context.TryFindOidLookupId(badDeviceVersionId, out foundOidMappingIds), $"Found OID mapping ID for 'bad' device-version ID '{badDeviceVersionId}'");
}
}
