public void AirPressureLookup_FindClosest_Returns_Correct_AirPressure_Record()
{
var worksheet = new ExcelWorksheetData(TestContext);
for (var i = 1; i <= 3; ++i)
{
var latitudeColumn = String.Format("Lat{0}", i);
var longitudeColumn = String.Format("Lng{0}", i);
if (worksheet.String(latitudeColumn) != null)
{
_AirPressures.Add(new AirPressure()
{
Latitude = worksheet.Float(latitudeColumn),
Longitude = worksheet.Float(longitudeColumn),
AgeSeconds = (short)i,
});
}
}
_Lookup.LoadAirPressures(_AirPressures, _Now);
var expected = worksheet.Int("Closest");
var actual = _Lookup.FindClosest(worksheet.Float("Lat"), worksheet.Float("Lng"));
Assert.AreEqual(expected, actual.AgeSeconds);
}
public void Aircraft_UpdateCoordinates_Resets_Coordinates_If_Aircraft_Looks_To_Be_Moving_Impossibly_Quickly()
{
// Some aircraft's transponders report the wrong position. Further, some radios misinterpret position updates at
// extreme ranges. We can guess the position is wrong if the position and timing of two updates would require the
// aircraft to be moving at incredibly high speeds. When this is detected we should reset the trails, otherwise the
// user sees long lines drawn across the map, or a scribble effect if the transponder is just reporting nonsense.
var worksheet = new ExcelWorksheetData(TestContext);
var time = DateTime.UtcNow;
var shortSeconds = 24 * 60 * 60; // seconds in a day
_Aircraft.DataVersion = time.Ticks;
_Aircraft.Latitude = worksheet.Float("Lat1");
_Aircraft.Longitude = worksheet.Float("Lng1");
_Aircraft.Track = 1;
_Aircraft.UpdateCoordinates(time, shortSeconds);
int milliseconds = worksheet.Int("Milliseconds");
time = time.AddMilliseconds(milliseconds);
_Aircraft.DataVersion = time.Ticks;
_Aircraft.Latitude = worksheet.Float("Lat2");
_Aircraft.Longitude = worksheet.Float("Lng2");
_Aircraft.Track = 2;
_Aircraft.UpdateCoordinates(time, shortSeconds);
if (!worksheet.Bool("ResetTrail"))
{
if (milliseconds >= 1000)
{
Assert.AreEqual(2, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(2, _Aircraft.ShortCoordinates.Count);
}
else
{
Assert.AreEqual(1, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(1, _Aircraft.ShortCoordinates.Count);
Assert.AreEqual(1, _Aircraft.FullCoordinates[0].Heading);
Assert.AreEqual(1, _Aircraft.ShortCoordinates[0].Heading);
}
}
else
{
if (milliseconds < 1000)
{
Assert.AreEqual(0, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(0, _Aircraft.ShortCoordinates.Count);
}
else
{
Assert.AreEqual(1, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(1, _Aircraft.ShortCoordinates.Count);
Assert.AreEqual(2, _Aircraft.FullCoordinates[0].Heading);
Assert.AreEqual(2, _Aircraft.ShortCoordinates[0].Heading);
}
}
}
public void Aircraft_UpdateCoordinates_Replaces_Last_Full_Coordinate_If_Track_Hardly_Changes()
{
// If an update changes the position but the aircraft remains on the same ground track as the previous position
// then there's no need to keep the previous position, it can be replaced with the current one.
var worksheet = new ExcelWorksheetData(TestContext);
var time = DateTime.Now;
var expected = new List <Coordinate>();
for (int i = 1; i <= 4; ++i)
{
var latInColumn = String.Format("Lat{0}", i);
var lngInColumn = String.Format("Lng{0}", i);
var trkInColumn = String.Format("Trk{0}", i);
var latOutColumn = String.Format("CLat{0}", i);
var lngOutColumn = String.Format("CLng{0}", i);
var trkOutColumn = String.Format("CTrk{0}", i);
if (worksheet.String(latInColumn) != null)
{
time = time.AddHours(1);
_Aircraft.DataVersion = time.Ticks;
_Aircraft.Latitude = worksheet.Float(latInColumn);
_Aircraft.Longitude = worksheet.Float(lngInColumn);
_Aircraft.Track = worksheet.NFloat(trkInColumn);
_Aircraft.UpdateCoordinates(time, 300 * 60 * 60);
Assert.AreEqual(i, _Aircraft.ShortCoordinates.Count);
}
if (worksheet.String(latOutColumn) != null)
{
expected.Add(new Coordinate(0, 0, worksheet.Float(latOutColumn), worksheet.Float(lngOutColumn), worksheet.NFloat(trkOutColumn)));
}
}
Assert.AreEqual(expected.Count, _Aircraft.FullCoordinates.Count);
for (int i = 0; i < expected.Count; ++i)
{
var expCoordinate = expected[i];
var fullCoordinate = _Aircraft.FullCoordinates[i];
Assert.AreEqual(expCoordinate, fullCoordinate, i.ToString());
Assert.AreEqual(expCoordinate.Heading, fullCoordinate.Heading, i.ToString());
}
}
public void JsonSerialiser_WriteObject_Writes_ValueTypes_Correctly_For_Non_UK_Cultures()
{
var worksheet = new ExcelWorksheetData(TestContext);
foreach (var culture in new string[] { "en-US", "de-DE", "fr-FR", "ru-RU" })
{
using (var cultureSwitcher = new CultureSwitcher(culture)) {
TestCleanup();
TestInitialise();
var obj = new ValueTypes()
{
BoolValue = worksheet.Bool("BoolValue"),
UnusedBool = worksheet.Bool("UnusedBool"),
NullableBool = worksheet.NBool("NullableBool"),
Int = worksheet.Int("Int"),
NullableInt = worksheet.NInt("NullableInt"),
Long = worksheet.Long("Long"),
NullableLong = worksheet.NLong("NullableLong"),
Float = worksheet.Float("Float"),
NullableFloat = worksheet.NFloat("NullableFloat"),
Double = worksheet.Double("Double"),
NullableDouble = worksheet.NDouble("NullableDouble"),
DateTime = worksheet.DateTime("DateTime"),
NullableDateTime = worksheet.NDateTime("NullableDateTime"),
};
_JsonSerialiser.Initialise(typeof(ValueTypes));
_JsonSerialiser.WriteObject(_Stream, obj);
var message = String.Format("when culture is {0}", culture);
Assert.AreEqual(worksheet.EString("Json"), GetJson(), message);
}
}
}
public void JsonSerialiser_WriteObject_Writes_ValueTypes_Correctly()
{
var worksheet = new ExcelWorksheetData(TestContext);
var obj = new ValueTypes()
{
BoolValue = worksheet.Bool("BoolValue"),
UnusedBool = worksheet.Bool("UnusedBool"),
NullableBool = worksheet.NBool("NullableBool"),
Int = worksheet.Int("Int"),
NullableInt = worksheet.NInt("NullableInt"),
Long = worksheet.Long("Long"),
NullableLong = worksheet.NLong("NullableLong"),
Float = worksheet.Float("Float"),
NullableFloat = worksheet.NFloat("NullableFloat"),
Double = worksheet.Double("Double"),
NullableDouble = worksheet.NDouble("NullableDouble"),
DateTime = worksheet.DateTime("DateTime"),
NullableDateTime = worksheet.NDateTime("NullableDateTime"),
};
_JsonSerialiser.Initialise(typeof(ValueTypes));
_JsonSerialiser.WriteObject(_Stream, obj);
Assert.AreEqual(worksheet.EString("Json"), GetJson());
}
public void Aircraft_UpdateCoordinates_Resets_Coordinates_If_Aircraft_Looks_To_Be_Moving_Impossibly_Quickly()
{
// Some aircraft's transponders report the wrong position. Further, some radios misinterpret position updates at
// extreme ranges. We can guess the position is wrong if the position and timing of two updates would require the
// aircraft to be moving at incredibly high speeds. When this is detected we should reset the trails, otherwise the
// user sees long lines drawn across the map, or a scribble effect if the transponder is just reporting nonsense.
var worksheet = new ExcelWorksheetData(TestContext);
var time = DateTime.UtcNow;
var shortSeconds = 24 * 60 * 60; // seconds in a day
_Aircraft.DataVersion = time.Ticks;
_Aircraft.Latitude = worksheet.Float("Lat1");
_Aircraft.Longitude = worksheet.Float("Lng1");
_Aircraft.Track = 1;
_Aircraft.UpdateCoordinates(time, shortSeconds);
int milliseconds = worksheet.Int("Milliseconds");
time = time.AddMilliseconds(milliseconds);
_Aircraft.DataVersion = time.Ticks;
_Aircraft.Latitude = worksheet.Float("Lat2");
_Aircraft.Longitude = worksheet.Float("Lng2");
_Aircraft.Track = 2;
_Aircraft.UpdateCoordinates(time, shortSeconds);
if(!worksheet.Bool("ResetTrail")) {
if(milliseconds >= 1000) {
Assert.AreEqual(2, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(2, _Aircraft.ShortCoordinates.Count);
} else {
Assert.AreEqual(1, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(1, _Aircraft.ShortCoordinates.Count);
Assert.AreEqual(1, _Aircraft.FullCoordinates[0].Heading);
Assert.AreEqual(1, _Aircraft.ShortCoordinates[0].Heading);
}
} else {
if(milliseconds < 1000) {
Assert.AreEqual(0, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(0, _Aircraft.ShortCoordinates.Count);
} else {
Assert.AreEqual(1, _Aircraft.FullCoordinates.Count);
Assert.AreEqual(1, _Aircraft.ShortCoordinates.Count);
Assert.AreEqual(2, _Aircraft.FullCoordinates[0].Heading);
Assert.AreEqual(2, _Aircraft.ShortCoordinates[0].Heading);
}
}
}
public void Aircraft_UpdateCoordinates_Replaces_Last_Full_Coordinate_If_Track_Hardly_Changes()
{
// If an update changes the position but the aircraft remains on the same ground track as the previous position
// then there's no need to keep the previous position, it can be replaced with the current one.
var worksheet = new ExcelWorksheetData(TestContext);
var time = DateTime.Now;
var expected = new List<Coordinate>();
for(int i = 1;i <= 4;++i) {
var latInColumn = String.Format("Lat{0}", i);
var lngInColumn = String.Format("Lng{0}", i);
var trkInColumn = String.Format("Trk{0}", i);
var latOutColumn = String.Format("CLat{0}", i);
var lngOutColumn = String.Format("CLng{0}", i);
var trkOutColumn = String.Format("CTrk{0}", i);
if(worksheet.String(latInColumn) != null) {
time = time.AddHours(1);
_Aircraft.DataVersion = time.Ticks;
_Aircraft.Latitude = worksheet.Float(latInColumn);
_Aircraft.Longitude = worksheet.Float(lngInColumn);
_Aircraft.Track = worksheet.NFloat(trkInColumn);
_Aircraft.UpdateCoordinates(time, 300 * 60 * 60);
Assert.AreEqual(i, _Aircraft.ShortCoordinates.Count);
}
if(worksheet.String(latOutColumn) != null) {
expected.Add(new Coordinate(0, 0, worksheet.Float(latOutColumn), worksheet.Float(lngOutColumn), worksheet.NFloat(trkOutColumn)));
}
}
Assert.AreEqual(expected.Count, _Aircraft.FullCoordinates.Count);
for(int i = 0;i < expected.Count;++i) {
var expCoordinate = expected[i];
var fullCoordinate = _Aircraft.FullCoordinates[i];
Assert.AreEqual(expCoordinate, fullCoordinate, i.ToString());
Assert.AreEqual(expCoordinate.Heading, fullCoordinate.Heading, i.ToString());
}
}
/// <summary>
/// Returns a mock flight record with values filled from a spreadsheet row, starting from the column number passed across.
/// </summary>
/// <param name="expected"></param>
/// <param name="firstOrdinal"></param>
/// <returns></returns>
/// <remarks>
/// The columns are read in the following order:
/// AircraftID, Callsign, EndTime, FirstAltitude, FirstGroundSpeed, FirstIsOnGround, FirstLat, FirstLon, FirstSquawk, FirstTrack, FirstVerticalRate, HadAlert,
/// HadEmergency, HadSpi, LastAltitude, LastGroundSpeed, LastIsOnGround, LastLat, LastLon, LastSquawk, LastTrack, LastVerticalRate, NumADSBMsgRec, NumModeSMsgRec,
/// NumIDMsgRec, NumSurPosMsgRec, NumAirPosMsgRec, NumAirVelMsgRec, NumSurAltMsgRec, NumSurIDMsgRec, NumAirToAirMsgRec, NumAirCallRepMsgRec, NumPosMsgRec
/// and StartTime
/// </remarks>
private BaseStationFlight LoadFlightFromSpreadsheet(ExcelWorksheetData worksheet, int firstOrdinal = 0, BaseStationFlight copyIntoFlight = null)
{
int ordinal = firstOrdinal;
var aircraft = CreateAircraft();
aircraft.AircraftID = worksheet.Int(ordinal++);
var result = copyIntoFlight == null ? CreateFlight(aircraft) : copyIntoFlight;
result.AircraftID = aircraft.AircraftID;
result.Callsign = worksheet.EString(ordinal++);
result.EndTime = worksheet.DateTime(ordinal++);
result.FirstAltitude = worksheet.Int(ordinal++);
result.FirstGroundSpeed = worksheet.Float(ordinal++);
result.FirstIsOnGround = worksheet.Bool(ordinal++);
result.FirstLat = worksheet.Float(ordinal++);
result.FirstLon = worksheet.Float(ordinal++);
result.FirstSquawk = worksheet.Int(ordinal++);
result.FirstTrack = worksheet.Float(ordinal++);
result.FirstVerticalRate = worksheet.Int(ordinal++);
result.HadAlert = worksheet.Bool(ordinal++);
result.HadEmergency = worksheet.Bool(ordinal++);
result.HadSpi = worksheet.Bool(ordinal++);
result.LastAltitude = worksheet.Int(ordinal++);
result.LastGroundSpeed = worksheet.Float(ordinal++);
result.LastIsOnGround = worksheet.Bool(ordinal++);
result.LastLat = worksheet.Float(ordinal++);
result.LastLon = worksheet.Float(ordinal++);
result.LastSquawk = worksheet.Int(ordinal++);
result.LastTrack = worksheet.Float(ordinal++);
result.LastVerticalRate = worksheet.Int(ordinal++);
result.NumADSBMsgRec = worksheet.Int(ordinal++);
result.NumModeSMsgRec = worksheet.Int(ordinal++);
result.NumIDMsgRec = worksheet.Int(ordinal++);
result.NumSurPosMsgRec = worksheet.Int(ordinal++);
result.NumAirPosMsgRec = worksheet.Int(ordinal++);
result.NumAirVelMsgRec = worksheet.Int(ordinal++);
result.NumSurAltMsgRec = worksheet.Int(ordinal++);
result.NumSurIDMsgRec = worksheet.Int(ordinal++);
result.NumAirToAirMsgRec = worksheet.Int(ordinal++);
result.NumAirCallRepMsgRec = worksheet.Int(ordinal++);
result.NumPosMsgRec = worksheet.Int(ordinal++);
result.StartTime = worksheet.DateTime(ordinal++);
return result;
}
public void WebSite_BaseStationAircraftList_Builds_Arrays_Of_Trail_Coordinates_Correctly()
{
var worksheet = new ExcelWorksheetData(TestContext);
AddBlankAircraft(1);
var aircraft = _BaseStationAircraft[0];
Mock<IAircraft> mockAircraft = Mock.Get(aircraft);
aircraft.Latitude = worksheet.NFloat("ACLat");
aircraft.Longitude = worksheet.NFloat("ACLng");
aircraft.Track = worksheet.NFloat("ACTrk");
aircraft.FirstCoordinateChanged = worksheet.Long("ACFirstCoCh");
aircraft.LastCoordinateChanged = worksheet.Long("ACLastCoCh");
aircraft.PositionTime = new DateTime(1970, 1, 1, 0, 0, 0, worksheet.Int("ACPosTimeCh"));
mockAircraft.Setup(m => m.PositionTimeChanged).Returns(worksheet.Long("ACPosTimeCh"));
for(int i = 1;i <= 2;++i) {
var dataVersion = String.Format("Coord{0}DV", i);
var tick = String.Format("Coord{0}Tick", i);
var latitude = String.Format("Coord{0}Lat", i);
var longitude = String.Format("Coord{0}Lng", i);
var track = String.Format("Coord{0}Trk", i);
if(worksheet.String(dataVersion) != null) {
DateTime dotNetDate = new DateTime(1970, 1, 1, 0, 0, 0, worksheet.Int(tick));
var coordinate = new Coordinate(worksheet.Long(dataVersion), dotNetDate.Ticks, worksheet.Float(latitude), worksheet.Float(longitude), worksheet.NFloat(track));
aircraft.FullCoordinates.Add(coordinate);
aircraft.ShortCoordinates.Add(coordinate);
}
}
_AircraftListAddress.PreviousDataVersion = worksheet.Long("ArgsPrevDV");
if(worksheet.Bool("ArgsIsPrevAC")) _AircraftListAddress.PreviousAircraft.Add(0);
_AircraftListAddress.ShowShortTrail = worksheet.Bool("ArgsShort");
_AircraftListAddress.ResendTrails = worksheet.Bool("ArgsResend");
var aircraftJson = SendJsonRequest<AircraftListJson>(_AircraftListAddress.Address).Aircraft[0];
var count = worksheet.Int("Count");
if(count == 0) {
Assert.IsNull(aircraftJson.ShortCoordinates);
Assert.IsNull(aircraftJson.FullCoordinates);
} else {
var list = worksheet.Bool("IsShort") ? aircraftJson.ShortCoordinates : aircraftJson.FullCoordinates;
Assert.AreEqual(count, list.Count);
for(int i = 0;i < count;++i) {
var column = String.Format("R{0}", i);
Assert.AreEqual(worksheet.NDouble(column), list[i], "Element {0}", i);
}
}
Assert.AreEqual(worksheet.Bool("ResetTrail"), aircraftJson.ResetTrail);
}
public void WebSite_BaseStationAircraftList_AircraftListFilter_PositionWithin_Works_Correctly()
{
var worksheet = new ExcelWorksheetData(TestContext);
_AircraftListAddress.Filter = _AircraftListFilter;
AddBlankAircraft(1);
_BaseStationAircraft[0].Latitude = worksheet.NFloat("Latitude");
_BaseStationAircraft[0].Longitude = worksheet.NFloat("Longitude");
_AircraftListFilter.PositionWithin = new Pair<Coordinate>(
new Coordinate(worksheet.Float("Top"), worksheet.Float("Left")),
new Coordinate(worksheet.Float("Bottom"), worksheet.Float("Right"))
);
var list = SendJsonRequest<AircraftListJson>(_AircraftListAddress.Address);
Assert.AreEqual(worksheet.Bool("IsInBounds") ? 1 : 0, list.Aircraft.Count);
}
public void WebSite_BaseStationAircraftList_AircraftListFilter_Distance_AircraftListFiltered_Correctly()
{
var worksheet = new ExcelWorksheetData(TestContext);
_AircraftListAddress.Filter = _AircraftListFilter;
_AircraftListAddress.BrowserLatitude = worksheet.Float("BrowserLatitude");
_AircraftListAddress.BrowserLongitude = worksheet.Float("BrowserLongitude");
AddBlankAircraft(1);
_BaseStationAircraft[0].Latitude = worksheet.NFloat("AircraftLatitude");
_BaseStationAircraft[0].Longitude = worksheet.NFloat("AircraftLongitude");
_AircraftListFilter.DistanceLower = worksheet.NDouble("DistanceLower");
_AircraftListFilter.DistanceUpper = worksheet.NDouble("DistanceUpper");
bool passed = SendJsonRequest<AircraftListJson>(_AircraftListAddress.Address).Aircraft.Count == 1;
Assert.AreEqual(worksheet.Bool("Passes"), passed);
}
public void JsonSerialiser_WriteObject_Writes_ValueTypes_Correctly_For_Non_UK_Cultures()
{
var worksheet = new ExcelWorksheetData(TestContext);
foreach(var culture in new string[] { "en-US", "de-DE", "fr-FR", "ru-RU" }) {
using(var cultureSwitcher = new CultureSwitcher(culture)) {
TestCleanup();
TestInitialise();
var obj = new ValueTypes() {
BoolValue = worksheet.Bool("BoolValue"),
UnusedBool = worksheet.Bool("UnusedBool"),
NullableBool = worksheet.NBool("NullableBool"),
Int = worksheet.Int("Int"),
NullableInt = worksheet.NInt("NullableInt"),
Long = worksheet.Long("Long"),
NullableLong = worksheet.NLong("NullableLong"),
Float = worksheet.Float("Float"),
NullableFloat = worksheet.NFloat("NullableFloat"),
Double = worksheet.Double("Double"),
NullableDouble = worksheet.NDouble("NullableDouble"),
DateTime = worksheet.DateTime("DateTime"),
NullableDateTime = worksheet.NDateTime("NullableDateTime"),
};
_JsonSerialiser.Initialise(typeof(ValueTypes));
_JsonSerialiser.WriteObject(_Stream, obj);
var message = String.Format("when culture is {0}", culture);
Assert.AreEqual(worksheet.EString("Json"), GetJson(), message);
}
}
}
public void JsonSerialiser_WriteObject_Writes_ValueTypes_Correctly()
{
var worksheet = new ExcelWorksheetData(TestContext);
var obj = new ValueTypes() {
BoolValue = worksheet.Bool("BoolValue"),
UnusedBool = worksheet.Bool("UnusedBool"),
NullableBool = worksheet.NBool("NullableBool"),
Int = worksheet.Int("Int"),
NullableInt = worksheet.NInt("NullableInt"),
Long = worksheet.Long("Long"),
NullableLong = worksheet.NLong("NullableLong"),
Float = worksheet.Float("Float"),
NullableFloat = worksheet.NFloat("NullableFloat"),
Double = worksheet.Double("Double"),
NullableDouble = worksheet.NDouble("NullableDouble"),
DateTime = worksheet.DateTime("DateTime"),
NullableDateTime = worksheet.NDateTime("NullableDateTime"),
};
_JsonSerialiser.Initialise(typeof(ValueTypes));
_JsonSerialiser.WriteObject(_Stream, obj);
Assert.AreEqual(worksheet.EString("Json"), GetJson());
}